SQL Query to Enumerate USB drives by Domain
--Enumerate USB Drives--
select sys.Name0 [System Name],
sys.Resource_Domain_or_Workgr0 [Domain],
sys.Operating_System_Name_and0 [O/S],
disk.Description0 [Description],
disk.InterfaceType0 [Bus Type],
disk.Model0 [Model],
disk.Name0 [USB Drive Name],
disk.Size0 [Size],
disk.DeviceID0 [DeviceID]
from
v_R_System sys
join v_GS_DISK disk
on sys.ResourceID = disk.ResourceID
where InterfaceType0 = 'USB' and Resource_Domain_or_Workgr0 IN ('@Domain')
order by Resource_Domain_or_Workgr0,sys.Operating_System_Name_and0,sys.Name0