Hi Stuart,

This will be a hard question to answer as if any of the systems have HW RAID 
then the OS will see that as one physical disk. The only way to see each disk 
within a HW Raid is for you to install  the WMI provider (if one exists) for 
the HW RAID controller then inventory the data listed within its WMI classes.

If you are just looking for the number of disks the OS sees then this query can 
help you.

       Count(D.ResourceID) as 'Disk Count'
       v_r_system_valid RV
       join v_gs_disk D on RV.ResourceID = D.ResourceID
Group by

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Stuart Watret
Sent: Thursday, December 1, 2016 6:56 AM
To: mssms@lists.myitforum.com
Subject: [mssms] Count physical disks

Anyone share a bit of query magic I can utilise to count disks in machines, 
that’s all I need.


Stuart Watret

Reply via email to