Sccm Query Domain Ou

Here are some useful queries for system center configuration manager that you can use to create collections.

Sccm query domain ou. All queries tested in sccm current branch 1902. To create sccm collections based on active directory ou refer this post. Sccm query collection list. The customer told us to create sccm collections based on the active directory ou.

First of all to manage domain controllers using sccm you must first install the configmgr client agents on domain controllers. After this complete you should see the sms table system system ou name arr table in the sccm database will populate with data in the system ou name0 column of the database. Select s netbios name0 ip ip addresses0 s distinguished name0 s operatingsystem0 s operating system name and0 from v ra system ipaddresses as ip inner join v r system as s on ip resourceid s resourceid. And to find out the sccm queries for mobile devices read this post.

Select from sms r system where lower sms r system systemouname domain local ou ou. However you can achieve this task using powershell as well. In this post i will cover the steps to create device collections based on ad ou. Sccm clients collections clients not approved.

Highly accomplished information technology professional with extensive knowledge in system center configuration manager windows server sharepoint and office 365. Replace domain local ou ou with your own domain name and ou that you need a collection of. This query will create an sccm device collection from computers in an ad organizational unit. Share to twitter share to facebook share to pinterest.

This is an sccm device collection query to pull in computers of a specific model. A simple sql query that will get you the hostname ip address ou location and operating system details from your sccm database. Replace domain local ou ou with your own domain name and ou that you need a collection of. Highly accomplished information technology professional with extensive knowledge in system center configuration manager windows server sharepoint and office 365.

Simply copy and paste these into the sccm query statement of the query rule. To create sccm collections you require a query. Sccm device collection query domain ou membership select sms r system resourceid sms r system resourcetype. The ou s will now populate for the containers or domain you specified in the ad system group discovery ldap queries.

These collections demonstrate different queries. This is an sccm device collection query to pull in computers of a specific model.