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.
Select
RV.Netbios_name0,
Count(D.ResourceID) as 'Disk Count'
from
v_r_system_valid RV
join v_gs_disk D on RV.ResourceID = D.ResourceID
Group by
RV.Netbios_name0
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.
Cheers
Stuart Watret
