management_associations

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

Overview

Name	management_associations
Type	Resource
Id	azure.operations_management.management_associations

Fields

vw_management_associations

Name	Datatype	Description
id	text	Resource ID.
name	text	Resource name.
application_id	text	field from the properties object
location	text	Resource location
managementAssociationName	text	field from the properties object
providerName	text	field from the properties object
resourceGroupName	text	field from the properties object
resourceName	text	field from the properties object
resourceType	text	field from the properties object
subscriptionId	text	field from the properties object
type	text	Resource type.

management_associations

Name	Datatype	Description
id	string	Resource ID.
name	string	Resource name.
location	string	Resource location
properties	object	ManagementAssociation properties supported by the OperationsManagement resource provider.
type	string	Resource type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	managementAssociationName, providerName, resourceGroupName, resourceName, resourceType, subscriptionId	Retrieves the user ManagementAssociation.
list_by_subscription	SELECT	subscriptionId	Retrieves the ManagementAssociations list.
create_or_update	INSERT	managementAssociationName, providerName, resourceGroupName, resourceName, resourceType, subscriptionId	Creates or updates the ManagementAssociation.
delete	DELETE	managementAssociationName, providerName, resourceGroupName, resourceName, resourceType, subscriptionId	Deletes the ManagementAssociation in the subscription.

SELECT examples

Retrieves the ManagementAssociations list.

vw_management_associations

SELECT
id,
name,
application_id,
location,
managementAssociationName,
providerName,
resourceGroupName,
resourceName,
resourceType,
subscriptionId,
type
FROM azure.operations_management.vw_management_associations
WHERE subscriptionId = '{{ subscriptionId }}';

management_associations

SELECT
id,
name,
location,
properties,
type
FROM azure.operations_management.management_associations
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.operations_management.management_associations (
managementAssociationName,
providerName,
resourceGroupName,
resourceName,
resourceType,
subscriptionId,
location,
properties
)
SELECT 
'{{ managementAssociationName }}',
'{{ providerName }}',
'{{ resourceGroupName }}',
'{{ resourceName }}',
'{{ resourceType }}',
'{{ subscriptionId }}',
'{{ location }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: location
      value: string
    - name: properties
      value:
        - name: applicationId
          value: string

DELETE example

Deletes the specified management_associations resource.

/*+ delete */
DELETE FROM azure.operations_management.management_associations
WHERE managementAssociationName = '{{ managementAssociationName }}'
AND providerName = '{{ providerName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND resourceName = '{{ resourceName }}'
AND resourceType = '{{ resourceType }}'
AND subscriptionId = '{{ subscriptionId }}';