Hello
I'm trying to find the local windows group membership on the local machine through a tsql script. I have a query which I want to run for a bunch of users and I want to include in this script the users local windows group member ship. I tried using xp_commandShell with the 'net user' command but it doesn't have an option for this
eg. exec xp_cmdshell "net user username /domain"
Any help would be appreciated
Regards
Matt