solutions

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

Overview

Name	solutions
Type	Resource
Id	azure.operations_management.solutions

Fields

vw_solutions

Name	Datatype	Description
id	text	Resource ID.
name	text	Resource name.
contained_resources	text	field from the properties object
location	text	Resource location
plan	text	Plan for solution object supported by the OperationsManagement resource provider.
provisioning_state	text	field from the properties object
referenced_resources	text	field from the properties object
resourceGroupName	text	field from the properties object
solutionName	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags
type	text	Resource type.
workspace_resource_id	text	field from the properties object

solutions

Name	Datatype	Description
id	string	Resource ID.
name	string	Resource name.
location	string	Resource location
plan	object	Plan for solution object supported by the OperationsManagement resource provider.
properties	object	Solution properties supported by the OperationsManagement resource provider.
tags	object	Resource tags
type	string	Resource type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, solutionName, subscriptionId	Retrieves the user solution.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Retrieves the solution list. It will retrieve both first party and third party solutions
list_by_subscription	SELECT	subscriptionId	Retrieves the solution list. It will retrieve both first party and third party solutions
create_or_update	INSERT	resourceGroupName, solutionName, subscriptionId	Creates or updates the Solution.
delete	DELETE	resourceGroupName, solutionName, subscriptionId	Deletes the solution in the subscription.
update	UPDATE	resourceGroupName, solutionName, subscriptionId	Patch a Solution. Only updating tags supported.

SELECT examples

Retrieves the solution list. It will retrieve both first party and third party solutions

vw_solutions

SELECT
id,
name,
contained_resources,
location,
plan,
provisioning_state,
referenced_resources,
resourceGroupName,
solutionName,
subscriptionId,
tags,
type,
workspace_resource_id
FROM azure.operations_management.vw_solutions
WHERE subscriptionId = '{{ subscriptionId }}';

solutions

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

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.operations_management.solutions (
resourceGroupName,
solutionName,
subscriptionId,
location,
tags,
plan,
properties
)
SELECT 
'{{ resourceGroupName }}',
'{{ solutionName }}',
'{{ subscriptionId }}',
'{{ location }}',
'{{ tags }}',
'{{ plan }}',
'{{ 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: tags
      value: object
    - name: plan
      value:
        - name: name
          value: string
        - name: publisher
          value: string
        - name: promotionCode
          value: string
        - name: product
          value: string
    - name: properties
      value:
        - name: workspaceResourceId
          value: string
        - name: provisioningState
          value: string
        - name: containedResources
          value:
            - string
        - name: referencedResources
          value:
            - string

UPDATE example

Updates a solutions resource.

/*+ update */
UPDATE azure.operations_management.solutions
SET 
tags = '{{ tags }}'
WHERE 
resourceGroupName = '{{ resourceGroupName }}'
AND solutionName = '{{ solutionName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified solutions resource.

/*+ delete */
DELETE FROM azure.operations_management.solutions
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND solutionName = '{{ solutionName }}'
AND subscriptionId = '{{ subscriptionId }}';