Ability to query Azure Users/Groups via SQL Server

Question

Ability to query Azure Users/Groups via SQL Server

ggusr 1

Hello!

I am working to provide live data from our Users & Groups page on Azure to build a small application for my support team. Is it possible to query this data from the Azure portal from my SQL Server instance in any way?

Thank you in advance

2 answers

Your answer

Answer 1

Ronen Ariely 15,216

hi,

I am working to provide live data from our Users & Groups page on Azure to build a small application for my support team.

Are you speaking about users and groups in Azure Active Directory or in the Azure SQL database level?

Is it possible to query this data from the Azure portal from my SQL Server instance in any way?

Yes

I assume that you speak about Azure SQL logical server.

You can execute queries on Azure SQL Database from the portal

(1) Go to the list of logical servers
https://portal.azure.com/#blade/HubsExtension/BrowseResource/resourceType/microsoft.sql%2Fservers

(2) Click on the server which you ant to use

(3) Navigate to the database that you want to use

(4) n the left menu you have new option: Query Editor

ggusr 1 Reputation point

2022-02-18T18:48:29.55+00:00

Thank you for your response!

I am talking about the users and groups at the Azure Active Directory level. I was wondering if there was a way to access that data from my local sql server database in some way.

Thanks!
Ronen Ariely 15,216 Reputation points

2022-02-19T14:55:26.257+00:00

Hi,

what is the relation between the local SQL Serer and the Azure Active Directory level ?!?

If these Azure Active Directory users do not have a LOGIN in the SQL Server or any other relation to the SQL Server, then it's basically like asking if you can get information about my internet blog from SQL Server :-)

This information is not in the scope of the SQL Server.

You can use SQLCLR or python to get external information like or you can execute cmd commands from on-premises SQL Server using the build-in stored procedure xp_cmdshell and using command shell you can get the information about the Azure Users/Groups

But how this is relevant to the second part of using the Azure Portal?

I don't see the relation of what you are asking for. If you want to get information about Azure Active Directory users FROM THE PORTAL, then why this is relevant to on-premises SQL Server?!?

You can gte the information directly from the Azure portal site

Something in your request is not clear to me and need more clarification if the above do not help you solve your needs

Answer 2

Hi ggusr-4236,
Sorry I’m not familiar with Azure AD.
Here is a similar thread which might be helpful:

I would use Graph API's to get the user info from Azure AD and dump it into any staging table. Now you can use this staging table in your stored procedure.
https://learn.microsoft.com/en-us/azure/active-directory/develop/active-directory-graph-api
Differential Query can be used to optimize the Graph API calls.

Best Regards,
Amelia

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Share via

Ability to query Azure Users/Groups via SQL Server

2 answers

Your answer