Display AD Users information using TSQL

xp_logininfo returns information about windows users and windows groups.



EXEC xp_logininfo 'Group_Name', 'members'

EXEC xp_logininfo 'Login_Name', 'all'


EXEC xp_logininfo 'BUILTIN\Administrators' , 'members'

EXEC xp_logininfo 'Domain\ADGroup', 'members'

EXEC xp_logininfo 'kalyan','all'