[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 985
  • Last Modified:

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.
0
itsmevic
Asked:
itsmevic
  • 4
  • 2
1 Solution
 
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
 
Joseph DalyCommented:
And if you wan to use the collection wizard to make the collection here is an example.

SCCM
0
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
itsmevicAuthor Commented:
totally crazy question here  xxdcmast, but where would i need paste that query into?  SCCM? It looks like a SQL statement.
0
 
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
 
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

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now