All the report files are accessible directly or indirectly from the primary report “SQLOpDB Dashboard.” I would recommend after deployment to hide all the reports and folders not needed to make it easier for your team to focus.
To deploy the report open the solution file from the deployment location, “C:\SQLOpsDB\Traditional SSRS\SQLOpDBReports.sln.”
In Visual Studio, first double click on dsMain.rds (Connection String) and update the Data Source and the Initial Catalog settings.
Next update the deployment location. Right click on the project “SQLOpDBReports” and go to the Properties. Update all the highlighted values below.
The main value to adjust is the TargetSeverURL.
After updating the settings, right click on the project and deploy. You will get lots of warnings. Ignore. I did not design reports for exportability. If needed let me know, will look at adjusting.
After deployment, as recommend before, hide all the reports not needed. Especially the drill through reports. Following reports can be accessed stand alone can be be left visible.
- SQLOpDB Dashboard
- SQLOpDB Logs
- SQLOpDB STB Deleted Overview
- SQL Infrastructure Overview
- Servers
- Volumes
- SQL License Overview
- SQL Instance by Support Life Cycle
- SQL Instances
- Databases
- Applications
- Security – User Lookup
After hiding reports (you will have to hide each item), it deployment should look like below.
There are lots of reports, I will explain the intent of each report in future posts.
SQL Canada (SQLCAN) 