Regarding the Database installed in the Azure VM

Question

Hi

We are looking to get the inventory for the Databases which installed in the Azure VM. Looking for a solution or exploration on how to get the database which are running on the list of Azure Vm which we have for our subscriptions

For ex : Want to get the database name, version, vm-name etc., which is running on VM

Thanks for the help

Regards
Phani Sankar

Answer 1

Hi @Malapaka, Phani Sankar (GE Corporate, consultant) ,

There is a github repo and script for this kind of extract ARI

Hope this helps.

JS

==
Please "Accept the answer" if the information helped you. This will help us and others in the community as well.

Answer 2

In the Azure portal, the SQL virtual machines resource is an independent management service to manage SQL Server on Azure Virtual Machines (VMs) that have been registered with the SQL Server IaaS Agent extension. You can use the resource to view all of your SQL Server VMs simultaneously and to fetch more details from one place:

The SQL virtual machines resource is only available to SQL Server VMs that have been registered with the SQL IaaS Agent extension.

----------

--please don't forget to upvote and Accept as answer if the reply is helpful--