SQL KPIs provide more flexibility than Stored Query KPIs. With SQL KPIs you can write your own queries to the CA SDM database to produce the following types of metrics:
Note: Your SQL code must comply with SQL92 syntax.
The following considerations apply to SQL KPIs:
Note: For instructions, see the Online Help.
SELECT * FROM cr WHERE assignee_last_name = "Smith"
For this example, you could use a predefined attribute alias. The Attribute Alias Detail page appears as follows:
" Object Name = cr
" Alias Name = assignee_last_name
" Status = Active
" Alias Value = assignee.last_name
Examples: SQL Query KPI
Est Cost Sum of Pending Change Workflow Tasks
Count of Reopened Change Orders
Copyright © 2012 CA. All rights reserved. | Tell Technical Publications how we can improve this information |