I’ve had the following request for information on our SQL VMs’ backup drives
‘Please provide a report on X:\ Drive usage for SQL VMs across the entire infrastructure.
The report needs to display VM Name, X:\ Drive Capacity (Provisioned & Usage)
Then an entire capacity for the environment.’
Any ideas how I could achieve this? The matrix tile with custom columns or something? Especially how do I get a total provisioned and then used capacity of all ‘X:’ drives?
Matrix tile is probably your best bet.
You can use the performance counters and properties from the disks themselves.
Coffee Break – Deep dive Matrix Tile
Support article for Matrix tile: