Skip to main content

solutions

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

Overview

Namesolutions
TypeResource
Idazure.operations_management.solutions

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringResource ID.
namestringResource name.
containedResourcesarrayThe azure resources that will be contained within the solutions. They will be locked and gets deleted automatically when the solution is deleted.
locationstringResource location.
planobjectPlan for solution object supported by the OperationsManagement resource provider.
provisioningStatestringThe provisioning state for the solution.
referencedResourcesarrayThe resources that will be referenced from this solution. Deleting any of those solution out of band will break the solution.
tagsobjectResource tags.
typestringResource type.
workspaceResourceIdstringThe azure resourceId for the workspace where the solution will be deployed/enabled. Required.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, solution_name, subscription_idRetrieve solution. Retrieves the user solution.
list_by_resource_groupselectresource_group_name, subscription_idRetrieves the solution list for the subscription. Retrieves the solution list. It will retrieve both first party and third party solutions.
list_by_subscriptionselectsubscription_idRetrieves the solution list for the subscription. Retrieves the solution list. It will retrieve both first party and third party solutions.
create_or_updateinsertresource_group_name, solution_name, subscription_idCreate/Update Solution. Creates or updates the Solution.
updateupdateresource_group_name, solution_name, subscription_idPatch a Solution. Patch a Solution. Only updating tags supported.
create_or_updatereplaceresource_group_name, solution_name, subscription_idCreate/Update Solution. Creates or updates the Solution.
deletedeleteresource_group_name, solution_name, subscription_idDeletes the solution. Deletes the solution in the subscription.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
resource_group_namestringThe name of the resource group to get. The name is case insensitive. Required.
solution_namestringUser Solution Name. Required.
subscription_idstring

SELECT examples

Retrieve solution. Retrieves the user solution.

SELECT
id,
name,
containedResources,
location,
plan,
provisioningState,
referencedResources,
tags,
type,
workspaceResourceId
FROM azure.operations_management.solutions
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND solution_name = '{{ solution_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Create/Update Solution. Creates or updates the Solution.

INSERT INTO azure.operations_management.solutions (
location,
tags,
plan,
properties,
resource_group_name,
solution_name,
subscription_id
)
SELECT
'{{ location }}',
'{{ tags }}',
'{{ plan }}',
'{{ properties }}',
'{{ resource_group_name }}',
'{{ solution_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
location,
plan,
properties,
tags,
type
;

UPDATE examples

Patch a Solution. Patch a Solution. Only updating tags supported.

UPDATE azure.operations_management.solutions
SET
tags = '{{ tags }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND solution_name = '{{ solution_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
location,
plan,
properties,
tags,
type;

REPLACE examples

Create/Update Solution. Creates or updates the Solution.

REPLACE azure.operations_management.solutions
SET
location = '{{ location }}',
tags = '{{ tags }}',
plan = '{{ plan }}',
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND solution_name = '{{ solution_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
location,
plan,
properties,
tags,
type;

DELETE examples

Deletes the solution. Deletes the solution in the subscription.

DELETE FROM azure.operations_management.solutions
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND solution_name = '{{ solution_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;