Accessing Active Directory using SQL Server 2000

[Brandon Arnold]

Hello All,

I have a linked ADSI Server to our company Active Directory and
everything is fine. I'm running queries and such using LDAP. BUT how
can I aquire a list of attributes for the classes and categories. Such
as if i wanted to see a user's telephone number and email address for
use in a corporate database? Is this possible?

Thanks

[John Bell]

Hi

I have never tried this.. but...:

The example of ADSI in books online returns the SN and ST attributes of the
contact class. See Books Online:

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\acd
ata.chm::/ac_8_qd_12_94fn.htm

You should then be able to use the same OPENQUERY as the destination of the
update statement. See Books Online:
mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\tsq
lref.chm::/ts_oa-oz_5xix.htm

John

"Brandon Arnold" <bt***@yahoo.com> wrote in message
news:85*************************@posting.google.co m...

Hello All,

I have a linked ADSI Server to our company Active Directory and
everything is fine. I'm running queries and such using LDAP. BUT how
can I aquire a list of attributes for the classes and categories. Such
as if i wanted to see a user's telephone number and email address for
use in a corporate database? Is this possible?

Thanks

[Brandon Arnold]

Thanks John but I'm looking a little deeper than that.

While searching yesterday I ran across another attribute that is
usually shown
in sample LDAP queries and it was "sAMAccountNAme" which is the
account a user may log on with. I'm for a list of attributes for
Computers, People, etc in Active Directory. Is there such a list or
definition table?

"John Bell" <jb************@hotmail.com> wrote in message news:<ib********************@news-text.cableinet.net>...

Hi

I have never tried this.. but...:

The example of ADSI in books online returns the SN and ST attributes of the
contact class. See Books Online:

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\acd
ata.chm::/ac_8_qd_12_94fn.htm

You should then be able to use the same OPENQUERY as the destination of the
update statement. See Books Online:
mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\tsq
lref.chm::/ts_oa-oz_5xix.htm

John

"Brandon Arnold" <bt***@yahoo.com> wrote in message
news:85*************************@posting.google.co m...

Hello All,

I have a linked ADSI Server to our company Active Directory and
everything is fine. I'm running queries and such using LDAP. BUT how
can I aquire a list of attributes for the classes and categories. Such
as if i wanted to see a user's telephone number and email address for
use in a corporate database? Is this possible?

Thanks

[John Bell]

As in ?:
http://msdn.microsoft.com/library/de...ce_mapping.asp

John

"Brandon Arnold" <bt***@yahoo.com> wrote in message
news:85**************************@posting.google.c om...

Thanks John but I'm looking a little deeper than that.

While searching yesterday I ran across another attribute that is
usually shown
in sample LDAP queries and it was "sAMAccountNAme" which is the
account a user may log on with. I'm for a list of attributes for
Computers, People, etc in Active Directory. Is there such a list or
definition table?

"John Bell" <jb************@hotmail.com> wrote in message

news:<ib********************@news-text.cableinet.net>...

Hi

I have never tried this.. but...:

The example of ADSI in books online returns the SN and ST attributes of the contact class. See Books Online:

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\acd ata.chm::/ac_8_qd_12_94fn.htm

You should then be able to use the same OPENQUERY as the destination of the update statement. See Books Online:
mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\tsq lref.chm::/ts_oa-oz_5xix.htm

John

"Brandon Arnold" <bt***@yahoo.com> wrote in message
news:85*************************@posting.google.co m...

Hello All,

I have a linked ADSI Server to our company Active Directory and
everything is fine. I'm running queries and such using LDAP. BUT how
can I aquire a list of attributes for the classes and categories. Such
as if i wanted to see a user's telephone number and email address for
use in a corporate database? Is this possible?

Thanks

[Brandon Arnold]

Yes! Thanks John!
"John Bell" <jb************@hotmail.com> wrote in message news:<L_********************@news-text.cableinet.net>...

As in ?:
http://msdn.microsoft.com/library/de...ce_mapping.asp

John

"Brandon Arnold" <bt***@yahoo.com> wrote in message
news:85**************************@posting.google.c om...

Thanks John but I'm looking a little deeper than that.

While searching yesterday I ran across another attribute that is
usually shown
in sample LDAP queries and it was "sAMAccountNAme" which is the
account a user may log on with. I'm for a list of attributes for
Computers, People, etc in Active Directory. Is there such a list or
definition table?

"John Bell" <jb************@hotmail.com> wrote in message

news:<ib********************@news-text.cableinet.net>...

Hi

I have never tried this.. but...:

The example of ADSI in books online returns the SN and ST attributes of the contact class. See Books Online:

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\acd ata.chm::/ac_8_qd_12_94fn.htm

You should then be able to use the same OPENQUERY as the destination of the update statement. See Books Online:
mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\tsq lref.chm::/ts_oa-oz_5xix.htm

John

"Brandon Arnold" <bt***@yahoo.com> wrote in message
news:85*************************@posting.google.co m...
> Hello All,
>
> I have a linked ADSI Server to our company Active Directory and
> everything is fine. I'm running queries and such using LDAP. BUT how
> can I aquire a list of attributes for the classes and categories. Such
> as if i wanted to see a user's telephone number and email address for
> use in a corporate database? Is this possible?
>
> Thanks