Managing Reports › Key Performance Indicators › Stored Query KPIs

Stored Query KPIs

With Stored Query KPIs you can generate reports based on count metrics retrieved from the CA SDM database.

CA SDM provides a set of predefined stored queries. Many of them are useful just as they are. You can also customize them to meet your needs, or use them as models for writing your own queries.

All Stored Query KPIs have a Count metric type.

Note: You can use stored queries to produce counter fields for your web interface Scoreboard, or KPI metrics, or both. To use a stored query in a KPI definition, the query must be enabled for KPI usage. For more information, see Stored Query Setup.

Stored Query KPI Examples

• This example produces a count of the open change orders at the assignee's location:

  @cnt.location.name Changes
  

• This example produces a count of the workflow tasks that will violate an SLA before midnight of the current day:

  Issue Workflow Tasks that will Violate an SLA today