Modelling Active Directory Data

Hello,
I am not sure if this is the right forum, but here goes.
I need to document the members of about 1000 Active Directory Group in a SQL
database. The groups are all in the same OU. I also need to document the
nested members (both groups and users). Putting the root groups in a table is
no problem. I am having trouble with maintaining the relationships between
the root groups\nested groups\nested members. A typical example would be:
Root group
Nested Group 1
Nested User 1
Nested User 2
Nested Group 2
Nested User 1
Nested User 2
Thanks in advance for any suggestions.Hi
You may want to check previous ADSI threads and the ADSI newsgroup such as
http://tinyurl.com/e7vtb
John
"bxr222" wrote:
> Hello,
> I am not sure if this is the right forum, but here goes.
> I need to document the members of about 1000 Active Directory Group in a SQL
> database. The groups are all in the same OU. I also need to document the
> nested members (both groups and users). Putting the root groups in a table is
> no problem. I am having trouble with maintaining the relationships between
> the root groups\nested groups\nested members. A typical example would be:
> Root group
> Nested Group 1
> Nested User 1
> Nested User 2
> Nested Group 2
> Nested User 1
> Nested User 2
> Thanks in advance for any suggestions.
>|||John,
Thanks for responding. I have seen similar info before but do not think this
suits my needs. Particularily, no info exists on getting the members of
groups. I can do this easily using VBScript, but need a table structure to
input it into. Additionally, I need to be able to track changes to these
groups on a quarterly basis. I may be overlooking something here though.
"John Bell" wrote:
> Hi
> You may want to check previous ADSI threads and the ADSI newsgroup such as
> http://tinyurl.com/e7vtb
> John
> "bxr222" wrote:
> > Hello,
> >
> > I am not sure if this is the right forum, but here goes.
> >
> > I need to document the members of about 1000 Active Directory Group in a SQL
> > database. The groups are all in the same OU. I also need to document the
> > nested members (both groups and users). Putting the root groups in a table is
> > no problem. I am having trouble with maintaining the relationships between
> > the root groups\nested groups\nested members. A typical example would be:
> >
> > Root group
> > Nested Group 1
> > Nested User 1
> > Nested User 2
> > Nested Group 2
> > Nested User 1
> > Nested User 2
> >
> > Thanks in advance for any suggestions.
> >|||Hi
The recursion is best handled in the script example, you can then decide on
what you wish to store in the database.
John
"bxr222" wrote:
> John,
> Thanks for responding. I have seen similar info before but do not think this
> suits my needs. Particularily, no info exists on getting the members of
> groups. I can do this easily using VBScript, but need a table structure to
> input it into. Additionally, I need to be able to track changes to these
> groups on a quarterly basis. I may be overlooking something here though.
> "John Bell" wrote:
> > Hi
> >
> > You may want to check previous ADSI threads and the ADSI newsgroup such as
> > http://tinyurl.com/e7vtb
> >
> > John
> >
> > "bxr222" wrote:
> >
> > > Hello,
> > >
> > > I am not sure if this is the right forum, but here goes.
> > >
> > > I need to document the members of about 1000 Active Directory Group in a SQL
> > > database. The groups are all in the same OU. I also need to document the
> > > nested members (both groups and users). Putting the root groups in a table is
> > > no problem. I am having trouble with maintaining the relationships between
> > > the root groups\nested groups\nested members. A typical example would be:
> > >
> > > Root group
> > > Nested Group 1
> > > Nested User 1
> > > Nested User 2
> > > Nested Group 2
> > > Nested User 1
> > > Nested User 2
> > >
> > > Thanks in advance for any suggestions.
> > >