Post reply

Retrieve AD account's group using OpenQuery

  • April 16, 2009 at 10:19 pm

    #155571

    I want to retrieve a AD account's group which means its [memberof] field in AD,

    but I don't know how to get it using Openquery,a user may have multivalue of 'menmberof' field,so how to implement this?

    does anyone have idea and it would be better provide a fully sample here.

    thanks in advance.

  • April 17, 2009 at 1:15 am

    #979441

    Shayne.Gui (4/16/2009)

    I want to retrieve a AD account's group which means its [memberof] field in AD,

    but I don't know how to get it using Openquery,a user may have multivalue of 'menmberof' field,so how to implement this?

    does anyone have idea and it would be better provide a fully sample here.

    thanks in advance.

    You may get some ideas from this.

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

Viewing 2 posts - 1 through 2 (of 2 total)

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