vw_virtual_machine_scale_sets
Creates, updates, deletes, gets or lists a vw_virtual_machine_scale_sets resource.
Overview
| Name | vw_virtual_machine_scale_sets |
| Type | View |
| Id | azure.compute.vw_virtual_machine_scale_sets |
Fields
See the SQL Definition (view DDL) for fields returned by this view.
SQL Definition
- Sqlite3
- Postgres
SELECT
id as id,
name as name,
location as location,
sku as sku,
plan as plan,
identity as identity,
zones as zones,
extendedLocation as extended_location,
etag as etag,
type as type,
tags as tags,
JSON_EXTRACT(properties, '$.upgradePolicy') as "upgrade_policy",
JSON_EXTRACT(properties, '$.scheduledEventsPolicy') as "scheduled_events_policy",
JSON_EXTRACT(properties, '$.automaticRepairsPolicy') as "automatic_repairs_policy",
JSON_EXTRACT(properties, '$.virtualMachineProfile') as "virtual_machine_profile",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.overprovision') as "overprovision",
JSON_EXTRACT(properties, '$.doNotRunExtensionsOnOverprovisionedVMs') as "do_not_run_extensions_on_overprovisioned_vms",
JSON_EXTRACT(properties, '$.uniqueId') as "unique_id",
JSON_EXTRACT(properties, '$.singlePlacementGroup') as "single_placement_group",
JSON_EXTRACT(properties, '$.zoneBalance') as "zone_balance",
JSON_EXTRACT(properties, '$.platformFaultDomainCount') as "platform_fault_domain_count",
JSON_EXTRACT(properties, '$.proximityPlacementGroup') as "proximity_placement_group",
JSON_EXTRACT(properties, '$.hostGroup') as "host_group",
JSON_EXTRACT(properties, '$.additionalCapabilities') as "additional_capabilities",
JSON_EXTRACT(properties, '$.scaleInPolicy') as "scale_in_policy",
JSON_EXTRACT(properties, '$.orchestrationMode') as "orchestration_mode",
JSON_EXTRACT(properties, '$.spotRestorePolicy') as "spot_restore_policy",
JSON_EXTRACT(properties, '$.priorityMixPolicy') as "priority_mix_policy",
JSON_EXTRACT(properties, '$.timeCreated') as "time_created",
JSON_EXTRACT(properties, '$.constrainedMaximumCapacity') as "constrained_maximum_capacity",
JSON_EXTRACT(properties, '$.resiliencyPolicy') as "resiliency_policy",
JSON_EXTRACT(properties, '$.zonalPlatformFaultDomainAlignMode') as "zonal_platform_fault_domain_align_mode",
JSON_EXTRACT(properties, '$.skuProfile') as "sku_profile",
subscriptionId,
resourceGroupName,
vmScaleSetName
FROM azure.compute.virtual_machine_scale_sets
WHERE subscriptionId = 'replace-me';
SELECT
id as id,
name as name,
location as location,
sku as sku,
plan as plan,
identity as identity,
zones as zones,
extendedLocation as extended_location,
etag as etag,
type as type,
tags as tags,
json_extract_path_text(properties, '$.upgradePolicy') as "upgrade_policy",
json_extract_path_text(properties, '$.scheduledEventsPolicy') as "scheduled_events_policy",
json_extract_path_text(properties, '$.automaticRepairsPolicy') as "automatic_repairs_policy",
json_extract_path_text(properties, '$.virtualMachineProfile') as "virtual_machine_profile",
json_extract_path_text(properties, '$.provisioningState') as "provisioning_state",
json_extract_path_text(properties, '$.overprovision') as "overprovision",
json_extract_path_text(properties, '$.doNotRunExtensionsOnOverprovisionedVMs') as "do_not_run_extensions_on_overprovisioned_vms",
json_extract_path_text(properties, '$.uniqueId') as "unique_id",
json_extract_path_text(properties, '$.singlePlacementGroup') as "single_placement_group",
json_extract_path_text(properties, '$.zoneBalance') as "zone_balance",
json_extract_path_text(properties, '$.platformFaultDomainCount') as "platform_fault_domain_count",
json_extract_path_text(properties, '$.proximityPlacementGroup') as "proximity_placement_group",
json_extract_path_text(properties, '$.hostGroup') as "host_group",
json_extract_path_text(properties, '$.additionalCapabilities') as "additional_capabilities",
json_extract_path_text(properties, '$.scaleInPolicy') as "scale_in_policy",
json_extract_path_text(properties, '$.orchestrationMode') as "orchestration_mode",
json_extract_path_text(properties, '$.spotRestorePolicy') as "spot_restore_policy",
json_extract_path_text(properties, '$.priorityMixPolicy') as "priority_mix_policy",
json_extract_path_text(properties, '$.timeCreated') as "time_created",
json_extract_path_text(properties, '$.constrainedMaximumCapacity') as "constrained_maximum_capacity",
json_extract_path_text(properties, '$.resiliencyPolicy') as "resiliency_policy",
json_extract_path_text(properties, '$.zonalPlatformFaultDomainAlignMode') as "zonal_platform_fault_domain_align_mode",
json_extract_path_text(properties, '$.skuProfile') as "sku_profile",
subscriptionId,
resourceGroupName,
vmScaleSetName
FROM azure.compute.virtual_machine_scale_sets
WHERE subscriptionId = 'replace-me';