azure_mgmt_list_sql_virtual_machines_by_resource_group.py

1from azure.identity import DefaultAzureCredential
2from azure.mgmt.sqlvirtualmachine import SqlVirtualMachineManagementClient
3
4def main():
5    # Substitution variables for your specific Azure environment
6    subscription_id = "00000000-0000-0000-0000-000000000000"
7    resource_group_name = "myResourceGroup"
8
9    # Acquire a credential object using CLI-based or Environment-based auth
10    credential = DefaultAzureCredential()
11
12    # Initialize the management client
13    sql_vm_client = SqlVirtualMachineManagementClient(
14        credential=credential,
15        subscription_id=subscription_id
16    )
17
18    # List SQL Virtual Machines in the specified resource group
19    print(f"Listing SQL Virtual Machines in resource group: {resource_group_name}")
20    sql_vms = sql_vm_client.sql_virtual_machines.list_by_resource_group(resource_group_name)
21
22    for vm in sql_vms:
23        print(f"Name: {vm.name}")
24        print(f"Location: {vm.location}")
25        print(f"SQL Server License Type: {vm.sql_server_license_type}")
26        print("-" * 20)
27
28if __name__ == "__main__":
29    main()