SCCM SQL Query for Dummies



Meta Stack Overflow your communities Sign on or log in to personalize your checklist. much more stack exchange communities organization website

From your properties website page, you are able to decide on the Object Form that the query will run from and decide on no matter whether to Restrict the query against a particular selection employing the gathering Restricting grouping.

In my passed lifetime, I need to acknowledge, I actually did like queries. They can be this kind of a strong Device to populate your collections. I generally was looking for methods to pimp

During this put up we will likely be looking at employing SCCM dynamic queries to populate collections within our deployments. Being a SCCM administrator, you most probably had to strategy out mass deployments to all of your servers or workstations and even both equally.

Stack Trade network is made of 176 Q&A communities together with Stack Overflow, the most important, most reliable on line community for builders to master, share their information, and Establish their Professions. Take a look at Stack Trade

The next SMS WQL query will Track down end users in your SMS web-sites which have prohibited or unneeded application set up on their equipment.

Linux / Unix shoppers are very easy to query as they have got SMS_R_System.ClientEdition residence set to thirteen in the database. This can be hos a collection query for linux / unix pcs appear like in SCCM.

This is the truly basic query and they might get a great deal far more advanced. If you control to seek out the effects you want in a straightforward query or Source a more complicated a single the point is that you have The end result you'd like.

Furnished Here's SQL queries that will enable you to locate shopper resources from the specified subnet. The primary instance specifies (=) a subnet, the 2nd SCCM Add Remove Programs query just one employs a wildcard (Like) and finally the 3rd allows you to specify multiple subnets.

This SQL Query will checklist the entire collections on the website server from which the query is executed on and can generate the gathering ID, Collection Title and the time stamp for when the gathering was very last up-to-date.

Not long ago we had the necessity to get an index of all software program installed on a group of systems in a group in ConfigMgr. There was an existing report which furnished this for just one Laptop or computer but we needed to set it with each other for a group of computers (not dependent on precisely what is in add/remove programs). The outcome were being our query beneath: (swap with your actual assortment identify)

Now it's essential to make an SQL query from this 1 to create a report With all the list of personal computers and people. It is sort of sophisticated to transform this query into SQL. (Of course, You should use SQL Server Report Builder to construct the query code, but there is an easier way to get it done.

Then wrap that query in a SCCM Query very NOT IN: [aformentioned query]. This will then exhibit outcomes of devices that aren't in the original query, that's what you need.

Desire me luck, I'm almost to install Home windows 8 on this laptop computer! Who know After i is going to be back on the internet!

Leave a Reply

Your email address will not be published. Required fields are marked *