You import reports into the Notification Server (NS) console and notice that some of the reports appear do have a duplicate entry with the duplicate having the '- Query' suffix appended to the report's name.
8.1 and earlier
Reports that are based on raw SQL queries normally have a hidden item in the console containing just the SQL query with an association to the report proper. In some instances this hidden atttribute is switched to 'normal', causing both the main report and the query portion of the report to be visible.
Export the report with the -Query name
Edit the xml of the report using Notepad or suitable xml editor
Locate the <ItemAttributes> element and change the Normal value to Hidden
Save and reimport the report
You'll see that the orginial report still runs, but the -Query report is no longer visible in the console
Subscribing will provide email updates when this Article is updated. Login is required.