The purpose of this query is to calculate the number of bookmarks for a given snapshot for each object and for each metric_id.
Release | Yes/No |
---|---|
8.3.x | |
8.2.x | |
8.1.x | |
8.0.x |
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS2 |
Note that snapshot_id has to be provided in the query below. It can be found using this page: SQL Queries - CAST Central Base - Queries on snapshots - How to get the ID and name of a snapshot for a given application
SELECT dos.object_id , dos.object_full_Name, dmr.metric_id , CASE WHEN dmr.position_id=0 THEN 1 ELSE COUNT(DISTINCT dcb.local_position_id) END AS "bookmark count" FROM dss_objects dos , dss_metric_results dmr, dss_code_bookmarks dcb WHERE dos.object_id =dmr.object_id AND dcb.object_id =dos.object_id AND dmr.snapshot_id=<snapshot_id> AND ( dcb.position_id=dmr.position_id OR dmr.position_id=0 ) GROUP BY dos.object_id , dos.object_full_Name, dmr.position_id , dmr.metric_id
916;"org.owasp.webgoat.session.CreateDB.createTransactionTable";8105;1
916;"org.owasp.webgoat.session.CreateDB.createTransactionTable";8113;3
The result will provide the object_Id followed by the object full name and then the metric_id and the count of bookmarks.
In the above example this will indicate that for the createTransactionTable object there is one bookmark or there is no bookmark for the metric_id 8105 and three bookmarks for the metric_id 8113.
Enter the SQL query
Enter the SQL query