This query on the central base determines if a metric has been calculated for a given snapshot.
Release | Yes/No |
---|---|
8.3.x | |
8.2.x |
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS |
SELECT * FROM dss_metric_results WHERE metric_id = <metric_id> AND METRIC_VALUE_INDEX = 2
2230;54;2;237;"NULL";0;1;0
2230;54;2;237;"NULL";0;10;0
2230;54;2;237;"NULL";0;11;0
2230;54;2;237;"NULL";0;12;0
If the metric has not been calculated, the query returns no row. If the metric has been calculated, the query returns one row per OBJECT_ID, where OBJECT_ID represents the associated module.
In the results above, the metric_id is 2230, the object_id is 54, and the snapshot_ids are 1, 10, 11, and 12, so that this metric was calculated in these snapshots.
If the results desired are to just check the results above for a particular snapshot, then you can add the clause 'AND snapshot_id= <snapshot_id>' with the appropriate snapshot_id to the query above
Enter the SQL query
Enter the SQL query