To configure the dashboard on SQL Server CMSs, run a database statement to change parameters to new values. Then run a second statement to go live with these new values.
In SQL Server Enterprise Manager Studio, run the following database statements.
EXEC rut_dlp_set_aggregation_values @<parameter>[,@<parameter>]
Where @<parameter> defines the new parameter value.
Each query can include multiple parameter definitions, separated by commas. If a parameter is not explicitly specified it retains its current value. Available parameters are described in the following sections.
After running the previous statement, the Output pane displays confirmation details of the new parameters plus the following 'go live' statement:
EXEC rut_dlp_set_new_values_live <n>
Where <n> uniquely identifies the new set of job parameters. This number is not specified here because it varies.
Now run this go live statement (we recommend you simply copy it from the Output pane into the query pane). Running the go live statement ensures that the next time the data warehousing job runs, it uses the new parameter values.
The following example specifies a 3 month dashboard snapshot period. Snapshots refer to total incident counts for the whole snapshot period. Snapshots are calculated for the following metrics: Reviewed Events, New Events, and Escalated Events:
EXEC rut_dlp_set_aggregation_values @history=3
|
Copyright © 2012 CA.
All rights reserved.
|
|