Share via

SQL Server : Disk Space report using SSRS Custom Report

  • Article

Building and using SSRS Custom Report for Disk Space Check

I have created a SSRS Custom Report to Check allocated and available space on the server, Hope this helps many people to check availability od space using SSMS instead of RDP or using some jobs to generate the report.

We can use this custom report file as normal Disk usage Report,

By default it get the local host Disk space report , you can also provide server name as a parameter to get the Disk space report  of particular server.

Pre-requisites :

SSMS

Access to Xp_cmshell and Powershell to access the WMI data.

Download the file  here.

https://gallery.technet.microsoft.com/SQL-Server-Disk-Space-d9eab1ad