Updated on: Relevant to: SCCM 2007, SCCM 2012 (including R2 and R3 versions) Probably the thing that gives SCCM most of its power (IMO) is the ability to target programs at machines with very specific properties, by using query based collections – however this is also something that we get constant emails about from our support customers. Query based collections allow an administrator to provide any criteria that the SCCM database may hold about systems, and automatically make those systems a member of that collection. For example, you may want to update to Acrobat Reader 9.3 on all your machines, however out in the field at the moment you have a mix of Acrobat Reader 7, 8.1, 9.2 etc.

Jan 27, 2014 Premier Field Engineer for System Center Configuration Manager. Useful ConfigMgr Collection Queries. To pull the device which has a specific file and. Get an introduction to software inventory in System Center Configuration Manager. Software inventory is collected when you. Create query-based. Aug 06, 2007 SMS/SCCM, Beyond Application. Query computers to find a specific file. This query can now be used to form a collection or exported to Excel.

And the install methods for each of these is different ( this is NOT the case, I’m just trying to present a hypothetical example!) Within your package, you would create an upgrade program for each possible situation, and then advertise each of those programs to a different collections – each of which we will plug in a query to in order to identify the correct clients.

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. Autoturn 8.1 Keygen. 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 3:37:36 PM 6368 (0x18E0) Query parsed successfully.

Ready to scan for files. FileSystemFile 3:37:36 PM 6368 (0x18E0) Folders to skip: c: system volume information. FileSystemFile 3:37:36 PM 6368 (0x18E0) Scanning input path c: program files (x86) mcafee FileSystemFile 3:37:36 PM 6368 (0x18E0) File scan completed; 1 instances reported.

FileSystemFile 3:37:45 PM 6368 (0x18E0) File System File: Query completed successfully. FileSystemFile 3:37:45 PM 6368 (0x18E0) ************* End of File System Query. ************* FileSystemFile 3:37:45 PM 6368 (0x18E0).