• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1283
  • Last Modified:

SMS Query any computer with a specific file

I need to perform a search to find if any computers have a specific file.  How do I make a query to search all computers for a file name that doesn't exist in the software inventory?
0
cavalierlan
Asked:
cavalierlan
  • 3
  • 3
1 Solution
 
NJComputerNetworksCommented:
Natively only exe. files are recorded in Software Inventory... you will have to turn on searching for this new file type that you are looking for...

(I'm assuming that its not an exe. file)

So, you have to turn on your site settings to query for more then just exe. file typses... you can specify the file name in the screen shot window... once this is configured, you can then query for computer with this file (and make a collection from it if you want)
1-8-2010-12-02-58-PM.png
0
 
cavalierlanAuthor Commented:
can you not make a one time query that doesnt add anything to the inventory?  Our site doesn't have privledges to get the properties of client agents.
0
 
NJComputerNetworksCommented:
I thought you said that the file can not been seen in the database today?

What is the file name that you are looking for?

If the extention for the file is not .EXE, then you will have some trouble because Software Inventory agent by default does not search for anything but exe files.

I guess another way would be to create a custom SMS package (using WISE or VB script, batch file, etc) to search for this file.  Then based on whether it finds the file or not, it will generate a MIF status (normal process of deployment packages to SMS clients).  Advertise this new package to all of your clients on a schedule.  You can then view the mif status report to see if the file was found.
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
cavalierlanAuthor Commented:
can you not create a query that queries all machines for the file instead of SMS just searching its software inventory database?  You can run a report for "All computers with a specific file" that is what it sounds like you want me to do.  That just queries the database.  I want to make a new query.
one of the files is thumb.dd
0
 
NJComputerNetworksCommented:
thumb.dd or *.dd files are not INVENTORIED by SMS/SCCM by default.  Therefore, you can not use the web report or a query yet.  You first have to enable Software Inventory agent on the clients to inventory thumb.dd or just *.dd files.  

Once you do this, the clients will report if they have a thumb.dd or *.dd files somewhere on the client.

(Note: only EXE files are inventoried by SMS by default - get it?  this means only files with the exe extention will be seen in your SMS database.  You have to first tell the SMS agent to look for something more then just EXE files.  After all, it is inventoried ALL files by default, your database would be HUGE!  It only inventories EXE file by default.  It only inventories EXE file by default.  It only inventories EXE file by default. It only inventories EXE file by default. It only inventories EXE file by default. It only inventories EXE file by default. It only inventories EXE file by default. It only inventories EXE file by default. It only inventories EXE file by default. It only inventories EXE file by default. It only inventories EXE file by default. It only inventories EXE file by default. It only inventories EXE file by default. It only inventories EXE file by default. It only inventories EXE file by default. It only inventories EXE file by default. It only inventories EXE file by default. It only inventories EXE file by default. It only inventories EXE file by default. It only inventories EXE file by default. It only inventories EXE file by default. It only inventories EXE file by default. It only inventories EXE file by default. It only inventories EXE file by default. It only inventories EXE file by default. It only inventories EXE file by default. It only inventories EXE file by default.)
0
 
cavalierlanAuthor Commented:
Ahole
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.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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