@RonKyle, not sure I can agree with your premise. If...

L30 (4/19/2015)

---

Hi asene, are you able to successfully query any other objects in the AD?

Are you able to get results from the group that is not nested, or any group...

LinksUp (4/20/2015)

---

The key is the Row_Number function. Row_Number does just that. It numbers the returned rows in sequential order. But what makes it a very useful function is the partition...

Hi asene, are you able to successfully query any other objects in the AD?

Are you able to get results from the group that is not nested, or any group with...

@LinksUp, thanks yet again. That returned the result I desired. I appreciate you taking the time to have a look at it for me. 🙂

I will have to...

@spaghettidba, apologies for the delay in replying. Other high priority work intervened. LinksUp reply below gave what was needed. However thanks for looking at the post, and I...

Ah... apologies asene, I should have read it more thoroughly. So you want to query a nested group?

If so I found this on StackOverflow

http://stackoverflow.com/questions/13914698/query-ad-group-membership-recursively-through-sql

I can get the following query to work. Directory path has been changed to what you have listed above, it will pay to check it for errors.

SELECT *

FROM OpenQuery(ADSI,...

Thanks LinksUp, and congratulation on your excellent mind reading skills. That looks like it will work just fine. Appreciate you taking the time to respond. 🙂

A general reduction of management is good to see. The traditional command and control model of management has blown itself out of all proportion.

I agree with Patrick, from what...