sccm 2012 "Computers with a specific file" not finding files

Posted on 2014-10-28
Last Modified: 2014-10-29
I have set the software inventory t find the file "mcconsol.exe". When checking the logs on a client I see that it has found the file. But when running the report and entering the file that I searching for, it never finds a system with the file on it. Even though the logs show it's been found.

Query = SELECT __class, __path, __relpath, lastwritedate, name, path, size   FROM FileSystemFile WHERE name ="mcconsol.exe" and path ="c:\\program files (x86)\\mcafee\\*"  and iscompressed =false and isencrypted =false; Timeout = 7200 secs; ScanInterval = 2 msecs; SkipFile = skpswi.dat      FileSystemFile      10/28/2014 3:37:36 PM      6368 (0x18E0)
Query parsed successfully... ready to scan for files.      FileSystemFile      10/28/2014 3:37:36 PM      6368 (0x18E0)
Folders to skip: c:\system volume information.      FileSystemFile      10/28/2014 3:37:36 PM      6368 (0x18E0)
Scanning input path c:\program files (x86)\mcafee\      FileSystemFile      10/28/2014 3:37:36 PM      6368 (0x18E0)
File scan completed; 1 instances reported.      FileSystemFile      10/28/2014 3:37:45 PM      6368 (0x18E0)
File System File: Query completed successfully.      FileSystemFile      10/28/2014 3:37:45 PM      6368 (0x18E0)
 ************* End of File System Query. *************      FileSystemFile      10/28/2014 3:37:45 PM      6368 (0x18E0)
Question by:rdefino
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
  • 2
LVL 50

Expert Comment

ID: 40409554
Could it be a hidden file?
To  show all hidden folders and files
1) In Explorer, click Organize in ToolBar|click "Folder and Search Options"|View|uncheck "Hide protected operating system files"|Yes|Apply|OK.  
2) And if not already done, under "Hidden Files and Folders", check "Show hidden files, folders,..." and uncheck "Don't show hidden files, folders...".

Or you could try Everything

Author Comment

ID: 40409563
It's not a hidden file. I see it in the folder and sccm shows in the log on the client that it finds the file when preforming a software inventory scan.
LVL 50

Expert Comment

ID: 40409643
I guess I do not understand "it never finds a system with the file on it."  Do you mean  your Search engine is not working.  Have you Indexed appropriately?
Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.


Author Comment

ID: 40409647
When I run the report "Computers with a specific file" and I list the file that the software inventory is collecting. The report always comes back empty.
LVL 22

Expert Comment

by:Adam Leinss
ID: 40410769
Under Software Inventory in Client settings, you are inventorying all *.exe files under Set Types?

What is the software inventory cycle set to?  I think the default is 7 days.  If that's the case, you won't get results back for 7 days if this is a new install.  Mine is set to 1 day.

Author Comment

ID: 40410829
Under "Inventory these files types"  I have nothing set.

But under Collect files" I have mcconsol.exe  set to be found.

I also set the scan to run every 2hrs while I working to figure this out.

Do I need to set "exe.*" under "Inventory these files types"
LVL 22

Accepted Solution

Adam Leinss earned 500 total points
ID: 40410847
I don't think you really want collect files turned on.  That literally copies the file up to the server for every client and it becomes apart of the client record in SCCM.  I would disable the collect files rule and turn on *.exe under Set Types in software inventory.

Author Closing Comment

ID: 40411084

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Auditing domain password hashes is a commonly overlooked but critical requirement to ensuring secure passwords practices are followed. Methods exist to extract hashes directly for a live domain however this article describes a process to extract u…
After seeing many questions for JRNL_WRAP_ERROR for replication failure, I thought it would be useful to write this article.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question