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