Showing posts with label groupthanksjohn. Show all posts
Showing posts with label groupthanksjohn. Show all posts

Monday, March 19, 2012

List Users in Windows Group

What is the SQL Server command that will list out the
users within a Windows Group?
Thanks!!!
John E.
I don't think there is one.
If you want to know the users in a _SQL group_, you could use
sp_helpgroup
HTH
Rick Sawtell
MCT, MCSD, MCDBA
"John E." <anonymous@.discussions.microsoft.com> wrote in message
news:d39601c48ab6$d747e2b0$a601280a@.phx.gbl...
> What is the SQL Server command that will list out the
> users within a Windows Group?
> Thanks!!!
> John E.
|||Hi,
You have to execute the below command from command prompt:-
master..xp_cmdshell 'NET GROUP groupname /DOMAIN'
if it is a local group use the below command
master..xp_cmdshell 'NET LOCALGROUP administrators'
Thanks
Hari
MCDBA
"John E." <anonymous@.discussions.microsoft.com> wrote in message
news:d39601c48ab6$d747e2b0$a601280a@.phx.gbl...
> What is the SQL Server command that will list out the
> users within a Windows Group?
> Thanks!!!
> John E.

List Users in Windows Group

What is the SQL Server command that will list out the
users within a Windows Group?
Thanks!!!
John E.I don't think there is one.
If you want to know the users in a _SQL group_, you could use
sp_helpgroup
HTH
Rick Sawtell
MCT, MCSD, MCDBA
"John E." <anonymous@.discussions.microsoft.com> wrote in message
news:d39601c48ab6$d747e2b0$a601280a@.phx.gbl...
> What is the SQL Server command that will list out the
> users within a Windows Group?
> Thanks!!!
> John E.|||Hi,
You have to execute the below command from command prompt:-
master..xp_cmdshell 'NET GROUP groupname /DOMAIN'
if it is a local group use the below command
master..xp_cmdshell 'NET LOCALGROUP administrators'
Thanks
Hari
MCDBA
"John E." <anonymous@.discussions.microsoft.com> wrote in message
news:d39601c48ab6$d747e2b0$a601280a@.phx.gbl...
> What is the SQL Server command that will list out the
> users within a Windows Group?
> Thanks!!!
> John E.