/build/static/layout/Breadcrumb_cap_w.png

Systems Management Question


Search for Video, Pics, Music Files on SCCM via Reporting

07/23/2009 5577 views
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
0 Comments   [ + ] Show comments

Comments


Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

All Answers

0
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
6th Degree Black Belt

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

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ