Community

How to get the AD groups of a login with sys.login_token

(Jack Vamvas) Question: I’d like to get the list of AD groups of a login currently logged into a SQL Server. I’ve read your post on xp_logininfo limitations – and one of the issues I’m experiencing is that xp_logininfo only returns details from AD global groups not universal groups.