SCCM report to inventory file types like. Now you are ready to create SMS/SCCM report to list the file information. With no query rules defined (collection. 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. I need to use a single collection to target both win7(x86) and win7(x64) builds to check if Outlook.exe is installed under program files, but the problem is under. Examples of common SCCM collection queries. Digger Simulator S. 7 thoughts on “ SCCM Collections – The basics ”. SCCM Log files; SCCM OSD Task Sequence Variables. Enl832-tx-en Driver Windows 7.

The following queries are for use in creating collections within Microsoft System Center Configuration Manager (SCCM). I’ve posted them here in an effort to assist new SCCM Admins in getting things up and running as quickly as possible. If you notice anything out of whack, or just plain incorrect, please let me know. I will also be the first to admit that I’m no SQL guru by any means, and as time (and experience) allows I try to go back through my queries and tighten them up. OU-Based If you wish to target specific sections of your Active Directory infrastructure, then you may wish to utilize collections based on computer account object OUs; making sure to watch out for oddities if using subOU levels. Select * from SMS_R_System where SMS_R_System.SystemOUName = ' MyDomain.com/OU/SubOU ' Limit to collection: (your collection of healthy clients) Notes: Remember, currently SCCM is Active Directory (AD) aware, not AD-integrated. This means there is still a lag in time between what’s happening in AD and what the SCCM service knows.

If you require a more immediate result, you may want to look into using scripts instead of the normal consoles. Healthy Clients (3 queries) Now, I’m a big believer that every collection query should be limited. Evertz Mvp Desktop Control Manual. What this does is ensures that your query is running against the desired pool of clients; which hopefully means that you won’t get unexpected results. If you’re new to SCCM (and maybe even if you aren’t), I’d strongly recommend first coming up with a strategy on weeding out your inactive/unhealthy clients from your healthy ones.