SQL Queries - CAST Central Base - SQL Queries on Transactions - How to retrieve the list of Transactions per snapshot


Purpose of Query

 The query retrieves the list of Transactions per snapshot

Applicable CAST Version
Release
Yes/No
8.3.x  (tick)
8.2.x  (tick)
8.1.x  (tick)
8.0.x  (tick)
Applicable RDBMS

 

RDBMS
Yes/No
Oracle Server  (tick)
Microsoft SQL Server  (tick)
CSS2  (tick)


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