SQL query to list all defined iDash reports

Products

• iDash Workload Automation

Issue/Introduction

Want to create a SQL query that will list report names that are defined in the iDash Database. 

Environment

Release : 12.1

Resolution

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.