The child pages listed here all contain useful queries....
xp_logininfo (Transact-SQL) | Microsoft Docs - useful extended stored procedure for Windows user/group info, does not work with Azure, can be used to find members of a Windows group: xp_logininfo 'windows group name','members'
.