ConfigMgr Collection Query for all systems with a specific .exe file
Home  » Config Manager  » ConfigMgr Collection Query for all systems with a specific .exe file

ConfigMgr Collection Query for all systems with a specific .exe file
Posted: Sun, Sep 13, 2009 6:46 PM :: Rank: 69
Author
Points: 47503
Level: System Center Expert

I've searched the net for an answer and must not be  using the correct terms. I am trying to create a collection query for all systems that have a specific .exe file. This is a file that would not appear in Add/Remove programs.

I do not want to retrieve the file, just document the fact that it is present and then populate a query-based collection. Can you all help me understand how i would I go about doing this?

   Report Abuse
Re: ConfigMgr Collection Query for all systems with a specific .exe file
Posted: Mon, Sep 14, 2009 2:37 AM :: Rank: 99
Author
Points: 2360
Level: System Center Specialist
Hi Tommy,



This query will find all computers with the file bison.exe. In order to colleciton information about the file you need to have configured software inventory.



select * from SMS_R_System inner join SMS_G_System_SoftwareFile on SMS_G_System_SoftwareFile.ResourceId = SMS_R_System.ResourceId where SMS_G_System_SoftwareFile.FileName = "bison.exe"
   Report Abuse
RE: ConfigMgr Collection Query for all systems with a specific .exe file
Posted: Mon, Sep 14, 2009 8:16 AM :: Rank: 83
Author
Points: 47503
Level: System Center Expert

Software Inventory will have a list of files, even if not in Add/Remove Programs? Just want to be sure I understand correctly.

   Report Abuse
Re: ConfigMgr Collection Query for all systems with a specific .exe file
Posted: Mon, Sep 14, 2009 9:54 AM :: Rank: 76
Author
Points: 40804
Level: System Center Expert
Have a look as this Tommy



http://www.systemcentercentral.com/BlogDetails/tabid/143/IndexID/22345/Default.aspx

   Report Abuse
Re: ConfigMgr Collection Query for all systems with a specific .exe file
Posted: Mon, Sep 14, 2009 6:08 PM :: Rank: 73
Author
Points: 2360
Level: System Center Specialist
Yes, that's correct. Software inventory is not related to the list of applications found in add/remove programs. Files from software inventory is based on the rules you configured in the Software Inventory agent. It's just a simple scan for a specific set of files.
   Report Abuse
RE: ConfigMgr Collection Query for all systems with a specific .exe file
Posted: Tue, Sep 15, 2009 11:55 AM :: Rank: 99
Author
Points: 47503
Level: System Center Expert

 Kent and Simon, this is just what I needed, thanks!

 

   Report Abuse

Home  » Config Manager  » ConfigMgr Collection Query for all systems with a specific .exe file
Top Contributors
Featured Members
Pete Zerger
Points: 72684
Level: System Center Expert
Tommy Gunn
Points: 47503
Level: System Center Expert
Simon Skinner
Points: 40804
Level: System Center Expert
Andreas Zuckerhut
Points: 30700
Level: System Center Expert
Stefan Koell
Points: 30179
Level: System Center Expert