Want to create a SQL query that will list report names that are defined in the iDash Database.
Release : 12.1
Report definitions are stored in the idash_config table. Most object definitions are stored in this table. Depending on what they want to see, they can modify the query in multiple ways.
SELECT * from idash_config where type like '%report%'
This query will show the full definition for all reports.
SELECT * from idash_config where type like '%report%' and tag like '%name' and deleted = 0
This query will show only the report name row for current reports.