Members of windows group

Question

Members of windows group

Yogeshwar Phull

Default port

Points: 1434
More actions
March 12, 2014 at 9:10 pm

#284579

Comments posted to this topic are about the item Members of windows group

Viewing 15 posts - 1 through 15 (of 18 total)

You must be logged in to reply to this topic. Login to reply

free_mascot One Orange Chip Points: 27169 More actions · Answer 1

Easy one, thanks.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

paul s-306273 SSChampion Points: 10727 More actions · Answer 2

paul s-306273

SSChampion

Points: 10727

March 13, 2014 at 2:28 am

#1696671

free_mascot (3/12/2014)
Easy one, thanks.

+1

Ed Wagner SSC Guru Points: 287024 More actions · Answer 3

Nice...thanks.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

david.gugg SSCertifiable Points: 6032 More actions · Answer 4

Wow, I never knew this existed. This is very helpful.

[font="Tahoma"]Personal blog relating fishing to database administration:[/font]
[font="Comic Sans MS"]https://davegugg.wordpress.com[/url]/[/font]

Mike Hays SSCommitted Points: 1871 More actions · Answer 5

Mike Hays

SSCommitted

Points: 1871

March 13, 2014 at 6:59 am

#1696749

Good Question, I did not know about this one...

Andy sql SSCrazy Eights Points: 9481 More actions · Answer 6

Likewise, I did not know about this option. I was surprised it works! But good to know. Thanks for the question.

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 7

Nice question, had me to do some research.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

dfortier SSC-Addicted Points: 411 More actions · Answer 8

dfortier

SSC-Addicted

Points: 411

March 13, 2014 at 8:02 am

#1696794

You made my day, thanks!

SQLRNNR SSC Guru Points: 281334 More actions · Answer 9

Based on the wording of the question, I have to throw this out there too!

xp_cmdshell 'net localgroup administrators'

GO

xp_cmdshell 'WMIC USERACCOUNT LIST BRIEF'

GO

xp_cmdshell 'WMIC USERACCOUNT LIST FULL'

GO

Which extended stored procedure can be used to find members of a Windows group?

By that wording alone, we have multiple correct answers.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Anoo S Pillai Mr or Mrs. 500 Points: 547 More actions · Answer 10

SQLRNNR (3/13/2014)
Based on the wording of the question, I have to throw this out there too!
xp_cmdshell 'net localgroup administrators'
GO
xp_cmdshell 'WMIC USERACCOUNT LIST BRIEF'
GO
xp_cmdshell 'WMIC USERACCOUNT LIST FULL'
GO
Which extended stored procedure can be used to find members of a Windows group?
By that wording alone, we have multiple correct answers.

I got it right, but xp_cmdshell too can be a right answer. 😉

TomThomson SSC Guru Points: 104773 More actions · Answer 11

The call in the explanation doesn't give all memers of the group - members of a group G1 which is itself a member of a group G are automatically members of G, but will not be listed by calling xp_login 'G', 'members'. So one has to recurse down the tree to get all members of G. There was a connect item about this a while back, closed as "won't fix".

The AD Users and Computers tool has the same problem - it doesn't recurse.

So in effect there isn't any means of getting all the members of a group by a simple xp call, you have to provide the recursion yourself.. Unfortunately I misunderstood the question as asking for that, so I got it wrong.

Tom

Thomas Abraham SSChampion Points: 10761 More actions · Answer 12

TomThomson (3/13/2014)
The call in the explanation doesn't give all memers of the group - members of a group G1 which is itself a member of a group G are automatically members of G, but will not be listed by calling xp_login 'G', 'members'. So one has to recurse down the tree to get all members of G. There was a connect item about this a while back, closed as "won't fix".
The AD Users and Computers tool has the same problem - it doesn't recurse.
So in effect there isn't any means of getting all the members of a group by a simple xp call, you have to provide the recursion yourself.. Unfortunately I misunderstood the question as asking for that, so I got it wrong.

Sometimes we can be too smart for our own good! 😉

Thanks to Yogeshwar for the question.

[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn

george sibbald SSC Guru Points: 104210 More actions · Answer 13

SQLRNNR (3/13/2014)
Based on the wording of the question, I have to throw this out there too!
xp_cmdshell 'net localgroup administrators'
GO
xp_cmdshell 'WMIC USERACCOUNT LIST BRIEF'
GO
xp_cmdshell 'WMIC USERACCOUNT LIST FULL'
GO
Which extended stored procedure can be used to find members of a Windows group?
By that wording alone, we have multiple correct answers.

fancy an argument about using xp_cmdshell?

😀

---------------------------------------------------------------------

PChiragS SSCarpal Tunnel Points: 4965 More actions · Answer 14

PChiragS

SSCarpal Tunnel

Points: 4965

March 13, 2014 at 12:27 pm

#1696925

nice and easy..

thanks for the question.