SQL Queries - Common SQL Queries - Queries on Metrics - How to get ids of metrics given part of the name of the metric

This query provides the metric ids for metrics given part of a metrics name. This can be run on a local or central database.

You can substitute other phrases or words below in the metric description search. Please remember to use lower case in the description search.

SELECT METRIC_ID,
       METRIC_DESCRIPTION
FROM   DSS_METRIC_DESCRIPTIONS
WHERE  language              = 'ENGLISH'
AND    lower(METRIC_DESCRIPTION) LIKE '%avoid using%';