Skip to main content

vw_instances

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

Overview​

Namevw_instances
TypeView
Idazure.scom.vw_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,
JSON_EXTRACT(properties, '$.productVersion') as "product_version",
JSON_EXTRACT(properties, '$.vNetSubnetId') as "vnet_subnet_id",
JSON_EXTRACT(properties, '$.managementEndpoints') as "management_endpoints",
JSON_EXTRACT(properties, '$.databaseInstance') as "database_instance",
JSON_EXTRACT(properties, '$.domainController') as "domain_controller",
JSON_EXTRACT(properties, '$.domainUserCredentials') as "domain_user_credentials",
JSON_EXTRACT(properties, '$.gmsaDetails') as "gmsa_details",
JSON_EXTRACT(properties, '$.azureHybridBenefit') as "azure_hybrid_benefit",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.logAnalyticsProperties') as "log_analytics_properties",
JSON_EXTRACT(properties, '$.operationsStatus') as "operations_status",
subscriptionId,
resourceGroupName,
instanceName
FROM azure.scom.instances
WHERE subscriptionId = 'replace-me';