I was asked recently to create a report for all disks that require a defrag. The most recent version of the Windows MP includes a monitor that checks fragmentation levels, which is great, but we switched off the alerting for this monitor, as we can typically only run defrags once a month, so I needed a way to generate a report without relying on the alerts.
I played around a little bit, and found I could pull the information from the state of the disk, and the result was a rather nifty little report that looks a bit like this:
(server names blurred out to protect the innocent)
The RDL file is available for download here. Create a data source that points to your OperationsManager database (not the DW), and update the report to use this data source and off you go. The report is set to, by default, run for the past week, but you can also select your start and end dates to select a different time period.