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
