SMS SW inventory and usb memory sticks ?

[Mirdus0001]

Hi All,

is there a way to persuade SMS Sw. Inventory to collect information about files stored on usb memory sticks ??

For instance if I set the *.exe in the path like E:\ which is one of frequent letters used for mem sticks it doesn't work.

Thanks for any tip or advice.
Mirdus

 

[dgreensl]

Paste the following into a new SMS 2003 report:

SELECT
D.SystemName0,
D.Index0,
D.Manufacturer0,
D.MediaType0,
D.PNPDeviceID0,
D.Size0
FROM V_GS_Disk D
Where interfacetype0 = 'USB'