Doh.. I just realised I got Lenovo confused with HP.. sorry bout that.
Obviously you need to customise it for your own environment, this one is from our Dell environment.
Here is my query anyway
SELECT vComputer.Name AS 'WorkStation', vUser.[Display Name] AS 'User', vUser.[Job Title], vUser.[Department], t1.[description], t1.[Size (MB)], t1.[Drive Letters] FROM vComputer JOIN Inv_AeX_HW_Physical_Disk t1 ON t1._ResourceGuid = vComputer.Guid JOIN vUser ON vUser.Name = vComputer.[User]
WHERE (t1.[description] != 'HDS728040PLA320') AND
(t1.[description] != '\\.\PHYSICALDRIVE0') AND
(t1.[description] != 'DELL PERC 5/i SCSI Disk Device') AND
(t1.[description] != 'DELL PERC 5/i SCSI Disk Device') AND
(t1.[description] != 'DELL VIRTUAL DISK IM SCSI Disk Device') AND
(t1.[description] != 'HDS728040PLA320') AND
(t1.[description] != 'Hitachi HTS541040G9AT00') AND
(t1.[description] != 'WDC WD800JD-75MSA3') AND
(t1.[description] != 'ST380815AS') AND
(t1.[description] != 'ST340212AS') AND
(t1.[description] != 'WDC WD400BD-75MRA1') AND
(t1.[description] != 'HDS728040PLA320') AND
(t1.[description] != 'WDC WD400BD-75MRA3') AND
(t1.[description] != 'PERC LD 0 PERCRAID SCSI Disk Device') AND
(t1.[description] != 'SAMSUNG HD040GJ') AND
(t1.[description] != 'ST3402111AS') AND
(t1.[description] != 'ST340014A') AND
(t1.[description] != 'VMware Virtual disk SCSI Disk Device') AND
(t1.[description] NOT LIKE 'WDC WD%') AND
(t1.[description] NOT LIKE 'ST%') AND
(t1.[description] NOT LIKE 'VMWare%') AND
(t1.[description] != 'ST340014AS') AND
(t1.[description] != 'Hitachi HDS721680PLA380') AND
(t1.[description] != 'IronKey Secure Drive USB Device') AND
(t1.[description] != 'ST3500641AS')
ORDER BY vUser.[Department] ASC