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
  • 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?

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.
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
cloning computer 13 65
Office 365 & Microsoft Azure 8 56
who removed AD Domain ID 9 25
need help with active directory 4 26
In this article, we will see the basic design consideration while designing a Multi-tenant web application in a simple manner. Though, many frameworks are available in the market to develop a multi - tenant application, but do they provide data, cod…
On some Windows 7 (SP1) computers, Windows Update becomes super slow even the computer is reasonably fast.  There's one solution that seemed to have worked well for me (after trying a few other suggested solutions).
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
This Micro Tutorial will give you a basic overview of Windows Live Photo Gallery and show you various editing filters and touches to photos you can apply. This will be demonstrated using Windows Live Photo Gallery on Windows 7 operating system.

911 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now