Systems Management

Hi,

Hope you’re all well. I was wondering if someone can help me find Video, Pics, Music files installed on our network PC’s.

Currently I have a report and a collection setup and only works to search for an specific software i.e. to search for PC’s that have Live Messenger the report and collection will use the Specific .exe file (msnmsgr.exe).

My question is that I would like to search for generic file .wav or .jpeg. How can I amend the report statement to search for this.

See example below that works.

SELECT SYS.Netbios_Name0, NETW.IPAddress0, NETW.MACAddress0, SYS.User_Name0, FilePath, SF.FileName, FileVersion
FROM v_GS_SoftwareFile SF
JOIN v_R_System SYS ON SYS.ResourceID = SF.ResourceID
JOIN v_GS_NETWORK_ADAPTER_CONFIGUR NETW ON NETW.ResourceID = Sys.ResourceID
WHERE SF.FileName LIKE 'msnmsgr.exe' AND FilePath LIKE 'C:\Program Files\MSN Messenger\' AND NETW.IPAddress0 LIKE '172.25.%'ORDER BY SYS.Netbios_Name0

Please advice or if above not clear then please do let me know.

Thanks in advance.
Prav