sims

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

Overview

Name	sims
Type	Resource
Id	azure.mobile_network.sims

Fields

vw_sims

Name	Datatype	Description
authentication_key	text	field from the properties object
device_type	text	field from the properties object
integrated_circuit_card_identifier	text	field from the properties object
international_mobile_subscriber_identity	text	field from the properties object
operator_key_code	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
simGroupName	text	field from the properties object
simName	text	field from the properties object
sim_policy	text	field from the properties object
sim_state	text	field from the properties object
site_provisioning_state	text	field from the properties object
static_ip_configuration	text	field from the properties object
subscriptionId	text	field from the properties object
vendor_key_fingerprint	text	field from the properties object
vendor_name	text	field from the properties object

sims

Name	Datatype	Description
properties	object	SIM properties.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, simGroupName, simName, subscriptionId	Gets information about the specified SIM.
list_by_group	SELECT	resourceGroupName, simGroupName, subscriptionId	Gets all the SIMs in a SIM group.
create_or_update	INSERT	resourceGroupName, simGroupName, simName, subscriptionId, data__properties	Creates or updates a SIM.
delete	DELETE	resourceGroupName, simGroupName, simName, subscriptionId	Deletes the specified SIM.
bulk_delete	EXEC	resourceGroupName, simGroupName, subscriptionId, data__sims	Bulk delete SIMs from a SIM group.
bulk_upload	EXEC	resourceGroupName, simGroupName, subscriptionId, data__sims	Bulk upload SIMs to a SIM group.
bulk_upload_encrypted	EXEC	resourceGroupName, simGroupName, subscriptionId, data__azureKeyIdentifier, data__encryptedTransportKey, data__signedTransportKey, data__sims, data__vendorKeyFingerprint, data__version	Bulk upload SIMs in encrypted form to a SIM group. The SIM credentials must be encrypted.
clone	EXEC	resourceGroupName, simGroupName, subscriptionId	Clone SIMs to another SIM Group
move	EXEC	resourceGroupName, simGroupName, subscriptionId	Move SIMs to another SIM Group

SELECT examples

Gets all the SIMs in a SIM group.

vw_sims

SELECT
authentication_key,
device_type,
integrated_circuit_card_identifier,
international_mobile_subscriber_identity,
operator_key_code,
provisioning_state,
resourceGroupName,
simGroupName,
simName,
sim_policy,
sim_state,
site_provisioning_state,
static_ip_configuration,
subscriptionId,
vendor_key_fingerprint,
vendor_name
FROM azure.mobile_network.vw_sims
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND simGroupName = '{{ simGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

sims

SELECT
properties
FROM azure.mobile_network.sims
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND simGroupName = '{{ simGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

Use the following StackQL query and manifest file to create a new sims resource.

All Properties

/*+ create */
INSERT INTO azure.mobile_network.sims (
resourceGroupName,
simGroupName,
simName,
subscriptionId,
data__properties,
properties
)
SELECT 
'{{ resourceGroupName }}',
'{{ simGroupName }}',
'{{ simName }}',
'{{ subscriptionId }}',
'{{ data__properties }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: authenticationKey
          value: string
        - name: operatorKeyCode
          value: string
        - name: provisioningState
          value: []
        - name: simState
          value: []
        - name: siteProvisioningState
          value: []
        - name: internationalMobileSubscriberIdentity
          value: string
        - name: integratedCircuitCardIdentifier
          value: string
        - name: deviceType
          value: string
        - name: simPolicy
          value:
            - name: id
              value: string
        - name: staticIpConfiguration
          value:
            - - name: attachedDataNetwork
                value:
                  - name: id
                    value: string
              - name: slice
                value:
                  - name: id
                    value: string
              - name: staticIp
                value:
                  - name: ipv4Address
                    value: []
        - name: vendorName
          value: string
        - name: vendorKeyFingerprint
          value: string

DELETE example

Deletes the specified sims resource.

/*+ delete */
DELETE FROM azure.mobile_network.sims
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND simGroupName = '{{ simGroupName }}'
AND simName = '{{ simName }}'
AND subscriptionId = '{{ subscriptionId }}';