Customize/Filter "Disk Capacity Forecasts" Report

buceyes

I was curious if there is a way to filter the Disk Capacity Forecasts report to only show Fixed Disks and limit the nodes to only virtual machines.

The current report include Physical and Virtual Memory

Going to the "Edit Resource" section of the report is see there is a Filter field but I'm not sure what the filter would be (if there is one) for only Fixed Disks.

The second priority would be to limit this to only virtual host machines.

Maybe its easier to create the report from scratch using SQL but I am not familiar with the data tables to know where to pull the required data from.

Thanks

buceyes

So after looking through some of the database tables I found something I could filter on to get the physical disks (sort of). I used the filter: ForecastCapacity.InstanceCaption LIKE '*E:*' or ForecastCapacity.InstanceCaption LIKE '*F:*'

I could have also added ....Like "*C:*" to get the system drives but I was really only concerned with Data drives and in our environment most have drive letters E or F. I could not find anything in the fields to use "Physical Disk" which would be preferable to catch anything not E or F etc...

Still nothing to limit the collection to virtual systems only but still working on that.....