applications

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

Overview

Name	applications
Type	Resource
Id	azure.managed_applications.applications

Fields

vw_applications

Name	Datatype	Description
applicationId	text	field from the properties object
applicationName	text	field from the properties object
application_definition_id	text	field from the properties object
artifacts	text	field from the properties object
authorizations	text	field from the properties object
billing_details	text	field from the properties object
created_by	text	field from the properties object
customer_support	text	field from the properties object
identity	text	Identity for the resource.
jit_access_policy	text	field from the properties object
kind	text	The kind of the managed application. Allowed values are MarketPlace and ServiceCatalog.
managed_by	text	field from the properties object
managed_resource_group_id	text	field from the properties object
management_mode	text	field from the properties object
outputs	text	field from the properties object
parameters	text	field from the properties object
plan	text	Plan for the managed application.
provisioning_state	text	field from the properties object
publisher_tenant_id	text	field from the properties object
resourceGroupName	text	field from the properties object
sku	text	SKU for the resource.
subscriptionId	text	field from the properties object
support_urls	text	field from the properties object
updated_by	text	field from the properties object

applications

Name	Datatype	Description
identity	object	Identity for the resource.
kind	string	The kind of the managed application. Allowed values are MarketPlace and ServiceCatalog.
managedBy	string	ID of the resource that manages this resource.
plan	object	Plan for the managed application.
properties	object	The managed application properties.
sku	object	SKU for the resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	applicationName, resourceGroupName, subscriptionId	Gets the managed application.
get_by_id	SELECT	applicationId	Gets the managed application.
list_allowed_upgrade_plans	SELECT	applicationName, resourceGroupName, subscriptionId	List allowed upgrade plans for application.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Lists all the applications within a resource group.
list_by_subscription	SELECT	subscriptionId	Lists all the applications within a subscription.
create_or_update	INSERT	applicationName, resourceGroupName, subscriptionId, data__kind, data__properties	Creates or updates a managed application.
delete	DELETE	applicationName, resourceGroupName, subscriptionId	Deletes the managed application.
delete_by_id	DELETE	applicationId	Deletes the managed application.
update	UPDATE	applicationName, resourceGroupName, subscriptionId	Updates an existing managed application.
refresh_permissions	EXEC	applicationName, resourceGroupName, subscriptionId	Refresh Permissions for application.
update_by_id	EXEC	applicationId	Updates an existing managed application.

SELECT examples

Gets the managed application.

vw_applications

SELECT
applicationId,
applicationName,
application_definition_id,
artifacts,
authorizations,
billing_details,
created_by,
customer_support,
identity,
jit_access_policy,
kind,
managed_by,
managed_resource_group_id,
management_mode,
outputs,
parameters,
plan,
provisioning_state,
publisher_tenant_id,
resourceGroupName,
sku,
subscriptionId,
support_urls,
updated_by
FROM azure.managed_applications.vw_applications
WHERE applicationId = '{{ applicationId }}';

applications

SELECT
identity,
kind,
managedBy,
plan,
properties,
sku
FROM azure.managed_applications.applications
WHERE applicationId = '{{ applicationId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.managed_applications.applications (
applicationName,
resourceGroupName,
subscriptionId,
data__kind,
data__properties,
properties,
plan,
kind,
identity,
managedBy,
sku
)
SELECT 
'{{ applicationName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ data__kind }}',
'{{ data__properties }}',
'{{ properties }}',
'{{ plan }}',
'{{ kind }}',
'{{ identity }}',
'{{ managedBy }}',
'{{ sku }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: managedResourceGroupId
          value: string
        - name: applicationDefinitionId
          value: string
        - name: parameters
          value: object
        - name: outputs
          value: object
        - name: provisioningState
          value: []
        - name: billingDetails
          value:
            - name: resourceUsageId
              value: string
        - name: jitAccessPolicy
          value:
            - name: jitAccessEnabled
              value: boolean
            - name: jitApprovalMode
              value: []
            - name: jitApprovers
              value:
                - - name: id
                    value: string
                  - name: type
                    value: string
                  - name: displayName
                    value: string
            - name: maximumJitAccessDuration
              value: string
        - name: publisherTenantId
          value: string
        - name: authorizations
          value:
            - - name: principalId
                value: string
              - name: roleDefinitionId
                value: string
        - name: managementMode
          value: []
        - name: customerSupport
          value:
            - name: contactName
              value: string
            - name: email
              value: string
            - name: phone
              value: string
        - name: supportUrls
          value:
            - name: publicAzure
              value: string
            - name: governmentCloud
              value: string
        - name: artifacts
          value:
            - - name: name
                value: []
              - name: uri
                value: string
              - name: type
                value: []
        - name: createdBy
          value:
            - name: oid
              value: string
            - name: puid
              value: string
            - name: applicationId
              value: string
    - name: plan
      value:
        - name: name
          value: string
        - name: publisher
          value: string
        - name: product
          value: string
        - name: promotionCode
          value: string
        - name: version
          value: string
    - name: kind
      value: string
    - name: identity
      value:
        - name: principalId
          value: string
        - name: tenantId
          value: string
        - name: type
          value: string
        - name: userAssignedIdentities
          value: object
    - name: managedBy
      value: string
    - name: sku
      value:
        - name: name
          value: string
        - name: tier
          value: string
        - name: size
          value: string
        - name: family
          value: string
        - name: model
          value: string
        - name: capacity
          value: integer

UPDATE example

Updates a applications resource.

/*+ update */
UPDATE azure.managed_applications.applications
SET 
properties = '{{ properties }}',
plan = '{{ plan }}',
kind = '{{ kind }}',
identity = '{{ identity }}',
managedBy = '{{ managedBy }}',
sku = '{{ sku }}'
WHERE 
applicationName = '{{ applicationName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified applications resource.

/*+ delete */
DELETE FROM azure.managed_applications.applications
WHERE applicationId = '{{ applicationId }}';