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

ReleaseYes/No
8.3.x✅
8.2.x✅
8.1.x✅
8.0.x✅

Applicable RDBMS

RDBMSYes/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