Need Help: Need to build a collection of just my Domain controllers

[CrashRider]

I've been trying to figure this out all morning. I need a query that will pull in only domain controllers.

I did look at the domain role section but the atributes 0-5 seemed to be fore the Operation Roles.

Thank you for any help,

Crash

 

[CrashRider]

I got it!

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 inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Roles like "%Domain_Controller%