SQLTeam.com | Weblogs | Forums

Querying Azure AD Users User Principle Name via Azure SQL Database

Hi,

I can't add sp_addlinkedserver at Azure SQL to querying the Azure AD User Principle Name as below article:-

Anyone, have the solution for Azure SQl Database Query to querying the Azure AD user principle name?
Please advise.

Thanks

Regards,
Micheale

You could try using POWERSHELL ... windows scripting ...

http://woshub.com/get-aduser-getting-active-directory-users-data-via-powershell/

Hi,

Thanks Sir. I am looking for solution using Azure SQL Database Query to querying the Azure AD user principle name. The powershell is a windows based if I'm not mistaken.

Thanks.

Regards,
Micheale

Yes powershell is windows based