Post reply

Active Directory OPENQUERY Syntax

  • February 24, 2004 at 5:27 pm

    #107092

    I have a query that will use a linked server to the Active Directory to get a list of email addresses for a list of users. What I would like to do is get a list of users within a group. I haven't been able to find much on this except that "multivalued properties cannot be returned in the result set to SQL Server".  Since I am not familiar with Active Directory I am not sure if this means what I think it means (which is "nope, can't do it"). Does anybody have experience with this?

    Thanks,

    George

  • February 24, 2004 at 6:06 pm

    #495451

    Think you need a bit more than this but it may help a bit!

    http://www.atlantamdf.com/presentations/AtlantaMDF_111201_examples.txt

  • February 25, 2004 at 8:45 am

    #495585

    Thanks for the link. I had come across this document while trying to find the syntax I need. I just haven't been able to figure out if it is possible to query for all of the members of a particular group. Thanks for the info!

  • February 25, 2004 at 11:50 am

    #495639

    You might want to check out the MS whitepaper on ADSI at http://www.microsoft.com/windows2000/techinfo/howitworks/activedirectory/adinterface.asp

    here is a snippet from that:

    "select name from 'LDAP://DC=ArcadiayBay,DC=COM' where objectClass='*' ORDER BY NAME"

    This was imbedded in the ADO example in the whitepaper.  I've never used it, but had looked at it since we recently migrated a client to AD.

    Regards,

     


    Joe Johnson
    NETDIO,LLC.

Viewing 4 posts - 1 through 3 (of 3 total)

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