Purpose of Query
The query retrieves the list of Transactions per snapshot
Applicable CAST Version
Release | Yes/No |
---|---|
8.3.x | |
8.2.x | |
8.1.x | |
8.0.x |
Applicable RDBMS
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS2 |
Query for CSS
SELECT R.snapshot_id, S.snapshot_name, R.object_id, O.object_name FROM dss_objects O, dss_object_info OI, dss_metric_results R, dss_snapshots S WHERE R.snapshot_id = S.snapshot_id AND R.metric_id IN ( 10322, 10204 ) AND R.metric_value_index = 1 AND R.object_id = O.object_id AND O.object_type_id = 30002 AND R.object_id = OI.object_id AND R.snapshot_id = OI.snapshot_id ORDER BY 1, 2
Query result example
1;920028;
"doKfn"
2;920028;
"doKfn"
Query result interpretation
The query returns the snapshot id, Transaction is and Transaction name
Query for Oracle
SELECT R.snapshot_id, R.object_id, O.object_name, FROM dss_objects O, dss_object_info OI, dss_metric_results R, dss_snapshots S WHERE S.application_id = 3 AND R.snapshot_id = S.snapshot_id AND R.metric_id IN ( 10322, 10204 ) AND R.metric_value_index = 1 AND R.object_id = O.object_id AND O.object_type_id = 30002 AND R.object_id = OI.object_id AND R.snapshot_id = OI.snapshot_id ORDER BY 1, 2
Query result example
1;920028;
"doKfn"
2;920028;
"doKfn"
Query result interpretation
The query returns the snapshot id, Transaction is and Transaction name
Query for SQL server
SELECT R.snapshot_id, R.object_id, O.object_name, FROM dss_objects O, dss_object_info OI, dss_metric_results R, dss_snapshots S WHERE S.application_id = 3 AND R.snapshot_id = S.snapshot_id AND R.metric_id IN ( 10322, 10204 ) AND R.metric_value_index = 1 AND R.object_id = O.object_id AND O.object_type_id = 30002 AND R.object_id = OI.object_id AND R.snapshot_id = OI.snapshot_id ORDER BY 1, 2
Query result example
1;920028;
"doKfn"
2;920028;
"doKfn"
Query result interpretation
The query returns the snapshot id, Transaction is and Transaction name
Notes/comments
Related Pages