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:

OK response definition.

NameDatatypeDescription
idstringResource ID.
namestringResource name.
locationstringResource location
planobjectPlan for solution object supported by the OperationsManagement resource provider.
propertiesobjectProperties for solution object supported by the OperationsManagement resource provider.
tagsobjectResource tags
typestringResource type.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, solutionNameRetrieves the user solution.
list_by_resource_groupselectsubscriptionId, resourceGroupNameRetrieves the solution list. It will retrieve both first party and third party solutions
list_by_subscriptionselectsubscriptionIdRetrieves the solution list. It will retrieve both first party and third party solutions
create_or_updateinsertsubscriptionId, resourceGroupName, solutionNameCreates or updates the Solution.
updateupdatesubscriptionId, resourceGroupName, solutionNamePatch a Solution. Only updating tags supported.
deletedeletesubscriptionId, resourceGroupName, solutionNameDeletes 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
resourceGroupNamestringThe name of the resource group to get. The name is case insensitive.
solutionNamestringUser Solution Name.
subscriptionIdstringGets subscription credentials which uniquely identify Microsoft Azure subscription. The subscription ID forms part of the URI for every service call.

SELECT examples

Retrieves the user solution.

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

INSERT examples

Creates or updates the Solution.

INSERT INTO azure.operations_management.solutions (
data__location,
data__tags,
data__plan,
data__properties,
subscriptionId,
resourceGroupName,
solutionName
)
SELECT
'{{ location }}',
'{{ tags }}',
'{{ plan }}',
'{{ properties }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ solutionName }}'
RETURNING
id,
name,
location,
plan,
properties,
tags,
type
;

UPDATE examples

Patch a Solution. Only updating tags supported.

UPDATE azure.operations_management.solutions
SET
data__tags = '{{ tags }}'
WHERE
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND solutionName = '{{ solutionName }}' --required
RETURNING
id,
name,
location,
plan,
properties,
tags,
type;

DELETE examples

Deletes the solution in the subscription.

DELETE FROM azure.operations_management.solutions
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND solutionName = '{{ solutionName }}' --required
;