Spotlight reports are designed in SQL Server Report Definition files (RDL) and stored in the local installation folder of Spotlight client application making them accessible to Spotlight users. By default this path in Spotlight 11.7.0+ versions is C:\Program Files (x86)\Quest Software\Spotlight on SQL Server\Plug-ins\Trending\SSRS. Not only Spotlight provides users with the raw RDL files but also provides the pre-built Visual Studio Project file that includes are report files. This allows to load the project file including all Spotlight reports in VS at one time.
Below I’m outlining the steps on how to use Spotlight VS Project file to deploy, schedule and customize existing reports, and add new reports.
A few requirements before we begin:
Deploy Spotlight Reports to SQL Server Reporting Services:
To confirm the URL string of server check Reporting Services Configuration Manager:
8. View Spotlight reports in Report Manager URL:
Customize the default Reports:
For example, I’ve renamed the ‘All SQL Agent Jobs Report’ and customized the report to show top 8 jobs instead of the default 6:
Result of the default report:
Result of the customized report:
Create new reports:
Users can add new reports to the project SoSSE Reports.rptproj and then deploy those reports to SQL Server Reporting Services.
Explore Spotlight reports and drop us a note on Twitter.
Download the latest version of Spotlight from here.