Get the Advanced Reports Report ID

  1. In SQL Server Management Studio, select the ION_Network database.
  2. 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.