Skip to main content

vw_sims

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

Overview​

Namevw_sims
TypeView
Idazure.mobile_network.vw_sims

Fields​

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

SQL Definition​

SELECT
JSON_EXTRACT(properties, '$.authenticationKey') as "authentication_key",
JSON_EXTRACT(properties, '$.operatorKeyCode') as "operator_key_code",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.simState') as "sim_state",
JSON_EXTRACT(properties, '$.siteProvisioningState') as "site_provisioning_state",
JSON_EXTRACT(properties, '$.internationalMobileSubscriberIdentity') as "international_mobile_subscriber_identity",
JSON_EXTRACT(properties, '$.integratedCircuitCardIdentifier') as "integrated_circuit_card_identifier",
JSON_EXTRACT(properties, '$.deviceType') as "device_type",
JSON_EXTRACT(properties, '$.simPolicy') as "sim_policy",
JSON_EXTRACT(properties, '$.staticIpConfiguration') as "static_ip_configuration",
JSON_EXTRACT(properties, '$.vendorName') as "vendor_name",
JSON_EXTRACT(properties, '$.vendorKeyFingerprint') as "vendor_key_fingerprint",
subscriptionId,
resourceGroupName,
simGroupName,
simName
FROM azure.mobile_network.sims
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND simGroupName = 'replace-me';