A Secret Weapon For sccm collection query based on compliance
But equivalent, Otherwise equivalent, details is collected as a result of diverse processes by the client, leading to the SCCM primary site server perhaps getting incomplete aspects of a device. This is especially evident when searching for aspects a couple of workstation computer shortly right after it has accomplished an OSD task sequence.
Nevertheless, for those who given that the very first A part of the machine name is frequent and equals to PROSERV, the following query ought to operate: pick * from SMS_R_System wherever Name like "PROSERVS%"
As I mentioned before, the aim of the submit is just not always to replace your deployment techniques. It’s basically to provide you with an alternate means of deploying software with your objects and viewing in authentic time the achievements in the deployment. Because the count goes down, you already know which machines received it productively and which didn’t.
To unravel this you may likely require sub-pick out queries to find all computer with the version that is increased You'll be able to find Every person without that version.
Another thing to note is that you’re click here incorporating systems by name whenever you do it in a very query, rather than as direct provides. This may or may not be your desired condition, just something to keep in mind.
by Ben Whitmore
This query is often created extra typical by using the LIKE operator after which you can wrapping the lookup term in p.c symbols: %Windows 10 Organization%.
Schedule a complete update on this collection: Schedule an everyday comprehensive evaluation in the collection membership.
Hello, wonderful write-up, but does it maintain sccm and Advertisement in sync? If I remove computers from Advert OU's, then I manually must remove them from SCCM collection? Do I would like some added quarys to remove?
You could possibly use this customized collection list to deploy an update or software offer only if they already have An additional application installed. For instance, deploy a Java update provided that a version of Acrobat Reader 9.x is now installed.
Use the next query to return the NetBIOS name and operating system version of all computers that run Windows 7.
Enter an correct name with the query and limit to the workstation collection (if needed – but NOT suggested for your Apple Mac Systems query!)
4) Individuals exact same computers now get that very same offer... and given that regkey exists once more. Which can yet again be inventoried or dcm checked to exist all over again.
Your logic is audio, you'd probably undoubtedly have to create a brand new collection with a query rule that looks for the chassis type.