SCCM 2007: How to Tell Which Machine is Running a Particular Executable

As the title of this question states, I'm trying to search the computers on my domain for a particular .exe file via SCCM 2007.  Does anyone know the options that I'd need to select to do this?  Any help with this is greatly appreciated.  Thank you.
itsmevicAsked:
Who is Participating?
 
Joseph DalyCommented:
When you go into sccm and right click to make a new collection. There will be an option for a query based membership. On that page you can enter the code I pasted above.

Also if you dont want to paste the code above you can go through the new query collection wizard. Those are the set of screenshots I posted.
0
 
Joseph DalyCommented:
In SCCM you can search for machines that have a particular exe present. However I dont think there is a query that will tell if it is running that exe.
0
 
Joseph DalyCommented:
The below query will create a collection of computers with a certain EXE file present. Replace filename.exe with the actual exe name.

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client 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 = "filename.exe"

Open in new window

0
Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

 
Joseph DalyCommented:
And if you wan to use the collection wizard to make the collection here is an example.

SCCM
0
 
itsmevicAuthor Commented:
totally crazy question here  xxdcmast, but where would i need paste that query into?  SCCM? It looks like a SQL statement.
0
 
itsmevicAuthor Commented:
Unfortunately, I do not have access to SCCM server to make these adjustments and can only view the optioins via browser.  There are a ton of choices, I just don't know which one to select in order to search for a particular executable on any of my machines under the domain.  I can do a wildcard searches i.e. %someexecutable% but don't know the option I'd need to select in order to properly search my entire domain.  I'll figure it out eventually.  Thank you anyway xxdcmast.  I hate to bother you anymore with this.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.