What nodes don't have their disk volumes monitored?

Question

Re-asking this question from over 5 years ago since it did not flill my need 
 
 "A disk on one of my servers ran out of disk and no alert triggered for it. I went to the node and clicked on List Resources where I saw that the volumes were not selected. Which leads me to my question. 
 Is there a query I could run to list all nodes where disk volumes are not selected? I'll poke around in the database to try and figure it out but I'm hoping someone can save me some time. Thanks!" 
 
 I have no idea how many Windows Fixed Disks were added and how long ago. It seems if the GUI is able to display a Windows Fixed Disks that are unchecked. a query or report should be able to do the same. I cannot manually check multi hundreds of servers. Is there such a SQL or SWQL query or report to accomplish this?

adam.beedell · Answer

With Russ/' solution, i'd try and add a section using/referencing discovery results in the #Simulate manual check section If you've got the virtualization layer for your stuff consistently you can pull the VirtualMachineVolumes section, which means unmonitored volumes could just be an OUTER JOIN on that table, maybe. 
 
 In pratice probably a few methods 
 Auto-scans-auto-adds usually the way to go eventually

sharath_kb · Answer

simpler way to reduce your burden to check manually is to run a discovery of the IPs, & schedule it weekly/monthly/etc, the job will take care of adding any/all new drives that were not selected in past.
You would also need to use a query to check WMI failures separately, so you need to fix those first & wait for next discovery schedule to run and pick the missing drives on these nodes as well.

What nodes don't have their disk volumes monitored?

Top Replies