Skip to main content

monitored_resources

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

Overview

Namemonitored_resources
TypeResource
Idazure.scom.monitored_resources

Fields

The following fields are returned by SELECT queries:

Operation completed successfully.

NameDatatypeDescription
idstring (arm-id)Fully qualified resource ID for the resource. E.g. "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}"
namestringThe name of the resource
propertiesobjectThe properties of a monitored resource.
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, instanceName, monitoredResourceNameRetrieve the details of the monitored resource.
create_or_updateinsertsubscriptionId, resourceGroupName, instanceName, monitoredResourceNameCreate or update a monitored resource.
deletedeletesubscriptionId, resourceGroupName, instanceName, monitoredResourceNameDelete a monitored resource.

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.
monitoredResourceNamestringThe monitored resource name.
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.

SELECT examples

Retrieve the details of the monitored resource.

SELECT
id,
name,
properties,
systemData,
type
FROM azure.scom.monitored_resources
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND instanceName = '{{ instanceName }}' -- required
AND monitoredResourceName = '{{ monitoredResourceName }}' -- required
;

INSERT examples

Create or update a monitored resource.

INSERT INTO azure.scom.monitored_resources (
subscriptionId,
resourceGroupName,
instanceName,
monitoredResourceName
)
SELECT
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ instanceName }}',
'{{ monitoredResourceName }}'
RETURNING
id,
name,
properties,
systemData,
type
;

DELETE examples

Delete a monitored resource.

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