There is no direct link /information on how many times a scoreboard query was used and when it was used for the last time. However, you may be benefited by querying which user is linked to a specific scoreboard.
How many users have a particular query on their scoreboards?
CA Service Desk Manager 14.1CA Service Desk Manager 17.x
The below queries will fetch you the list of users/roles that are linked to the selected stored query.
pdm_extract -f "select bj_persid from User_Query where query='LOGININ'"
For list of queries assigned to different roles the query should be for a specific role in the where clause
pdm_extract -f "select query from User_Query where obj_persid='role:10002'"
Note: You may want to try other values to suit your requirement as we have used place holders for the where clause to complete the query