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

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)
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
rdefinoAuthor Commented:
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.
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?
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

rdefinoAuthor Commented:
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.
Adam LeinssServer SpecialistCommented:
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.
rdefinoAuthor Commented:
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"
Adam LeinssServer SpecialistCommented:
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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rdefinoAuthor Commented:
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Server Apps

From novice to tech pro — start learning today.