Find AD Users In a Specific Group

Active Directory is used in almost all organizations to organize and manage both devices and users. Lansweeper can scan users directly from active directory along with a wide range of active directory attributes like the status of AD users.

This report provides a detailed list of Active Directory users and their group memberships, focusing on a specific group defined by you. It includes user display names, office locations, and associated Active Directory group names. The report helps IT administrators manage and audit user access, ensuring proper group assignments and organizational alignment. Results are sorted alphabetically by user name for easy navigation and analysis.

Run the Active Directory Users In Specific Group Audit

Select Top 1000000 tblADusers.DisplayName,
tblADusers.Displayname,
tblADusers.Office,
tblADGroups.Name As 'Active Directory Group Name'
From tblADusers
Left Join tblADMembership On tblADMembership.ChildAdObjectID =
tblADusers.ADObjectID
Left Join tblADGroups On tblADMembership.ParentAdObjectID =
tblADGroups.ADObjectID
Where tblADGroups.Name Like 'Domain Users'
Order By tblADusers.Name