Release : 12.1
Component : CA OUTPUT MANAGEMENT WEB VIEWER FOR ALL PLATFORMS
WBVLUW
MSSQL
MS SQL Server
DB2
Here is SQL, specifically for Windows MSSQL, please modify for your specific database. Please be aware that if you are actually running with the internal Derby database that is included with your Tomcat server, there is no way to run outside queries against that.
This will provide you a count of the total number of favorites, both for reports and for saved filters that can be defined:
SELECT COUNT(*) FROM favorieObj
Or you can drill down for specifics like a specific Repository Definition in the Administration->Repositories, or a particular User with: (ignoring <,>)
SELECT COUNT(*) FROM favorieObj WHERE REPOSITORYNAME = '<defined name>'
SELECT COUNT(*) FROM favorieObj WHERE USERID = '<user id>'