Post reply

Querying on prem AD and Azure AD

  • June 25, 2021 at 3:14 pm

    #3900471

    I have a task that requires me to query multiple on prem AD domains and Azure AD domains to bring all of that data together and do some user account matching.  This will likely all wind up in an SSIS project so that it is repeatable.  My questions is multi-part.

    I've seen the articles on how to query on prem AD using linked servers and open query.   That solution seems like it should work.  I wanted to double check if there were any newer methods in SQL server 2019 or within Azure that could make that task easier.

    For Azure AD I have found much less information.  There is a powershell command get-azureaduser which seems to return 4 attributes for a user.  I haven't found much else.

    TIA!

    • This topic was modified 3 years, 3 months ago by  tommiwan.

  • June 25, 2021 at 8:06 pm

    #3900630

    it has more than 4 properties - but unless you specify -properties * or -properties comma_delimited_list_of_properties it won't "show" them to you.

    even for on prem AD I would advise you to use powershell for everything as it is both easier to code as well as easier to get all properties required.

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

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