Skip to main content

instances

Creates, updates, deletes, gets or lists an instances resource.

Overview

Nameinstances
TypeResource
Idazure.scom.instances

Fields

The following fields are returned by SELECT queries:

Operation completed successfully.

NameDatatypeDescription
identityobjectThe Azure Active Directory identity of the SCOM instance
locationstringThe geo-location where the resource lives
propertiesobjectThe properties of a SCOM instance resource
tagsobjectResource tags.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, instanceNameGet SCOM managed instance details
list_by_resource_groupselectsubscriptionId, resourceGroupNameLists all SCOM managed instances in a resource group
list_by_subscriptionselectsubscriptionIdLists all SCOM managed instances in a subscription
create_or_updateinsertsubscriptionId, resourceGroupName, instanceNamevalidationModeCreate or update SCOM managed instance
updateupdatesubscriptionId, resourceGroupName, instanceNamePatch SCOM managed instance
deletedeletesubscriptionId, resourceGroupName, instanceNameDelete a SCOM managed instance
scaleexecsubscriptionId, resourceGroupName, instanceNameScaling SCOM managed instance.
patch_serversexecsubscriptionId, resourceGroupName, instanceNameUpdate SCOM servers with latest scom software.
link_log_analyticsexecsubscriptionId, resourceGroupName, instanceNameLink Log Analytics workspace for SCOM monitoring instance
unlink_log_analyticsexecsubscriptionId, resourceGroupName, instanceNameUnlink Log Analytics workspace for SCOM monitoring instance

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
instanceNamestringName of the SCOM managed instance.
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstring (uuid)The ID of the target subscription. The value must be an UUID.
validationModebooleanValidation mode for the SCOM managed instance

SELECT examples

Get SCOM managed instance details

SELECT
identity,
location,
properties,
tags
FROM azure.scom.instances
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND instanceName = '{{ instanceName }}' -- required
;

INSERT examples

Create or update SCOM managed instance

INSERT INTO azure.scom.instances (
data__tags,
data__location,
data__properties,
data__identity,
subscriptionId,
resourceGroupName,
instanceName,
validationMode
)
SELECT
'{{ tags }}',
'{{ location }}',
'{{ properties }}',
'{{ identity }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ instanceName }}',
'{{ validationMode }}'
RETURNING
identity,
location,
properties,
tags
;

UPDATE examples

Patch SCOM managed instance

UPDATE azure.scom.instances
SET
data__identity = '{{ identity }}',
data__tags = '{{ tags }}'
WHERE
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND instanceName = '{{ instanceName }}' --required
RETURNING
identity,
location,
properties,
tags;

DELETE examples

Delete a SCOM managed instance

DELETE FROM azure.scom.instances
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND instanceName = '{{ instanceName }}' --required
;

Lifecycle Methods

Scaling SCOM managed instance.

EXEC azure.scom.instances.scale 
@subscriptionId='{{ subscriptionId }}' --required,
@resourceGroupName='{{ resourceGroupName }}' --required,
@instanceName='{{ instanceName }}' --required
@@json=
'{
"serverCount": {{ serverCount }}
}'
;