Share This Post

List of computers from an AD User Security Group

Use this query to get a list of PCs by user’s security group. For full details see the forum post:

  dbo.v_R_User U
  join dbo.v_RA_User_UserGroupName UGN on U.ResourceID = UGN.ResourceID
  join dbo.v_GS_COMPUTER_SYSTEM CS on CS.UserName0 = U.Unique_User_Name0
  UGN.User_Group_Name0 = 'GARTEK\Domain Users'

Share This Post

Enhansoft specializes in providing software solutions, custom reports, and consulting services for retrieving your IT asset inventory. This is done within the system management area focusing on Microsoft System Center Configuration Manager (SCCM) by extending its asset information and reporting capabilities. Enhansoft is a Bronze sponsor of

Leave a Reply