NEW Get query for AD group in sccm

[Sridharrandy]

Hi All.

I am created 10 device collection and the same we have also AD group for all the collection..

I need query for how many collection is linked with single AD group ..

I want to fetch those information through query based rule.

Please provide me query for the above..

Your quick response is very much appreciated..

 

[Youssef Saad]

First, you need to enable Active Directory Group Discovery method.

Try with this query to create your device collection:

select
SMS_R_SYSTEM.ResourceID,
SMS_R_SYSTEM.ResourceType,
SMS_R_SYSTEM.Name,
SMS_R_SYSTEM.SMSUniqueIdentifier,
SMS_R_SYSTEM.ResourceDomainORWorkgroup,
SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.SecurityGroupName = "Contoso\\Test_Security_Group"

 

[Sridharrandy]

How to enable Active Directory group discovery?

 

[Youssef Saad]

Refer to this.

 

[Sridharrandy]

Thanks a lot youssef..