Get the Advanced Reports Report ID
- In SQL Server Management Studio, select the ION_Network database.
- Create and run the following query:
SELECT TOP 1000
[ReportID], [DisplayName], [SubFolder], [Name]
FROM [ION_Network].[dbo].[RPT_Report]
This SQL script displays the names and IDs of all the reports that have been configured and saved.
NOTE: It is possible to have two reports with the same name, but the [SubFolder] designation will make them unique.