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 


   3:   CS.Name0,


   5:   CS.UserName0


   7: from 


   9:   dbo.v_R_User U


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


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


  15: Where


  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