How to Find Users and thier AD groups in SQL Server - SQL Server DBA Tutorial

This video illustrates Following:

1- How to find members of an Active Directory group using SQL Server Management studio (SSMS)
2- How to find members of an Active directory group using T-SQL Script
3- How to find which Active directory group a particular user belong to using T-SQL

Script that you can use to find out the Users and their AD Groups in SSMS

--Finding out members of Active Directory Group that is already in SQL Server
master.dbo.xp_logininfo 'TECHBROTHERS\SQLDBReader', 'members' 

--Finding out Active directory group that below user belong to?
Exec master.dbo.xp_logininfo 'TECHBROTHERS\gbailey'


How to Get Users and thier AD groups in SQL Server - SQL Server DBA Tutorial

1 comment:

  1. and more importantly, your personal experienceMindfully using our emotions as data about our inner state and knowing when it’s better to de-escalate by taking a time out are great tools. Appreciate you reading and sharing your story, since I can certainly relate and I think others can too

    https://vidmate.onl/download/

    ReplyDelete