Solved

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

Posted on 2014-10-28
8
3,150 Views
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)
0
Comment
Question by:rdefino
  • 4
  • 2
  • 2
8 Comments
 
LVL 50

Expert Comment

by:jcimarron
ID: 40409554
rdefino--
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
http://www.voidtools.com/
0
 

Author Comment

by:rdefino
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.
0
 
LVL 50

Expert Comment

by:jcimarron
ID: 40409643
rdefino--
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?
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

Author Comment

by:rdefino
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.
0
 
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.
0
 

Author Comment

by:rdefino
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"
0
 
LVL 22

Accepted Solution

by:
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.
0
 

Author Closing Comment

by:rdefino
ID: 40411084
Thanks
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

When you try to extract and to view the contents of a Microsoft Update Standalone Package (MSU) for Windows Vista, you cannot extract the files from the MSU. Here we are going to explain how to extract those hotfix details without using any third pa…
When you try to share a printer , you may receive one of the following error messages. Error message when you use the Add Printer Wizard to share a printer: Windows could not share your printer. Operation could not be completed (Error 0x000006…
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum editing capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

733 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