Skip to main content

vw_managed_instances

Creates, updates, deletes, gets or lists a vw_managed_instances resource.

Overview​

Namevw_managed_instances
TypeView
Idazure.sql.vw_managed_instances

Fields​

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition​

SELECT
location as location,
tags as tags,
identity as identity,
sku as sku,
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.managedInstanceCreateMode') as "managed_instance_create_mode",
JSON_EXTRACT(properties, '$.fullyQualifiedDomainName') as "fully_qualified_domain_name",
JSON_EXTRACT(properties, '$.isGeneralPurposeV2') as "is_general_purpose_v2",
JSON_EXTRACT(properties, '$.administratorLogin') as "administrator_login",
JSON_EXTRACT(properties, '$.administratorLoginPassword') as "administrator_login_password",
JSON_EXTRACT(properties, '$.subnetId') as "subnet_id",
JSON_EXTRACT(properties, '$.state') as "state",
JSON_EXTRACT(properties, '$.licenseType') as "license_type",
JSON_EXTRACT(properties, '$.hybridSecondaryUsage') as "hybrid_secondary_usage",
JSON_EXTRACT(properties, '$.hybridSecondaryUsageDetected') as "hybrid_secondary_usage_detected",
JSON_EXTRACT(properties, '$.vCores') as "v_cores",
JSON_EXTRACT(properties, '$.storageSizeInGB') as "storage_size_in_gb",
JSON_EXTRACT(properties, '$.storageIOps') as "storage_i_ops",
JSON_EXTRACT(properties, '$.storageThroughputMBps') as "storage_throughput_mbps",
JSON_EXTRACT(properties, '$.collation') as "collation",
JSON_EXTRACT(properties, '$.dnsZone') as "dns_zone",
JSON_EXTRACT(properties, '$.dnsZonePartner') as "dns_zone_partner",
JSON_EXTRACT(properties, '$.publicDataEndpointEnabled') as "public_data_endpoint_enabled",
JSON_EXTRACT(properties, '$.sourceManagedInstanceId') as "source_managed_instance_id",
JSON_EXTRACT(properties, '$.restorePointInTime') as "restore_point_in_time",
JSON_EXTRACT(properties, '$.proxyOverride') as "proxy_override",
JSON_EXTRACT(properties, '$.timezoneId') as "timezone_id",
JSON_EXTRACT(properties, '$.instancePoolId') as "instance_pool_id",
JSON_EXTRACT(properties, '$.maintenanceConfigurationId') as "maintenance_configuration_id",
JSON_EXTRACT(properties, '$.privateEndpointConnections') as "private_endpoint_connections",
JSON_EXTRACT(properties, '$.minimalTlsVersion') as "minimal_tls_version",
JSON_EXTRACT(properties, '$.currentBackupStorageRedundancy') as "current_backup_storage_redundancy",
JSON_EXTRACT(properties, '$.requestedBackupStorageRedundancy') as "requested_backup_storage_redundancy",
JSON_EXTRACT(properties, '$.zoneRedundant') as "zone_redundant",
JSON_EXTRACT(properties, '$.primaryUserAssignedIdentityId') as "primary_user_assigned_identity_id",
JSON_EXTRACT(properties, '$.keyId') as "key_id",
JSON_EXTRACT(properties, '$.administrators') as "administrators",
JSON_EXTRACT(properties, '$.servicePrincipal') as "service_principal",
JSON_EXTRACT(properties, '$.virtualClusterId') as "virtual_cluster_id",
JSON_EXTRACT(properties, '$.externalGovernanceStatus') as "external_governance_status",
JSON_EXTRACT(properties, '$.pricingModel') as "pricing_model",
JSON_EXTRACT(properties, '$.createTime') as "create_time",
JSON_EXTRACT(properties, '$.authenticationMetadata') as "authentication_metadata",
JSON_EXTRACT(properties, '$.databaseFormat') as "database_format",
subscriptionId,
resourceGroupName,
managedInstanceName
FROM azure.sql.managed_instances
WHERE subscriptionId = 'replace-me';