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
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.
0 Comments   [ - ] Hide Comments


Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.
Answer this question or Comment on this question for clarity


You need to enable software inventory for those file types. You'd then have to choose between reporting all the files of that type for one machine, or reporting one specific file on many machines.
Answered 07/23/2009 by: turbokitty
Sixth Degree Black Belt

Please log in to comment
you should add the extensions of all these files in the software inventory...
Answered 07/27/2009 by: daya.neel
Yellow Belt

Please log in to comment