Your company's ad could live here and reach over 50,000 people a month!

Share This Post

List of Computers from an Active Directory User Security Group

Posted in CM2012ConfigMgrQueriesReportingSCCMSQL

Garth Jones (fellow ConfigMgr MVP) blogged a really great query for get a list o PC’s by using a user security group.

Read his original blog post here.

   1: select 

   2:  

   3:   CS.Name0,

   4:  

   5:   CS.UserName0

   6:  

   7: from 

   8:  

   9:   dbo.v_R_User U

  10:  

  11:   join dbo.v_RA_User_UserGroupName UGN on U.ResourceID = UGN.ResourceID

  12:  

  13:   join dbo.v_GS_COMPUTER_SYSTEM CS on CS.UserName0 = U.Unique_User_Name0

  14:  

  15: Where

  16:  

  17:   UGN.User_Group_Name0 = 'GARTEK\Domain Users'

Share This Post

I am a Microsoft MVP for System Center Configuration Manager and owner of Nackers Consulting Services, LLC. I focus primarily on System Center Configuration Manager and the Microsoft Deployment Toolkit. In addition to helping clients leverage the technologies they use, I enjoy spending a lot of time on the forums and email lists helping answer questions and just seeing what people are doing with the deployment technologies available to them. I have spoken at Microsoft Management Summit on ConfigMgr/MDT integration and I have spoken at user groups around the country. If you have any questions, please feel free to contact me, I am always willing to help.

Leave a Reply