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
Count(D.ResourceID) as 'Disk Count'
join v_gs_disk D on RV.ResourceID = D.ResourceID
From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On
Behalf Of Stuart Watret
Sent: Thursday, December 1, 2016 6:56 AM
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.