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?

Peter Aston selected answer