Skip to main content

entities

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

Overview

Nameentities
TypeResource
Idazure.cloud_health.entities

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
entityNamestringName of the entity. Required.
historyarraySignal history data points. Required.
signalNamestringName of the signal. Required.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_signal_historyselectresource_group_name, health_model_name, entity_name, subscription_idRetrieve the time series history for a signal on an entity.
getselectresource_group_name, health_model_name, entity_name, subscription_idGet a Entity.
list_by_health_modelselectresource_group_name, health_model_name, subscription_idtimestampList Entity resources by HealthModel.
create_or_updateinsertresource_group_name, health_model_name, entity_name, subscription_idCreate a Entity.
create_or_updatereplaceresource_group_name, health_model_name, entity_name, subscription_idCreate a Entity.
deletedeleteresource_group_name, health_model_name, entity_name, subscription_idDelete a Entity.
get_historyexecresource_group_name, health_model_name, entity_name, subscription_idRetrieve the health state transition history for an entity.
ingest_health_reportexecresource_group_name, health_model_name, entity_name, subscription_id, signalName, healthStateIngest a health report for a specific signal on an entity (the entity must already exist).

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
entity_namestringName of the entity. Must be unique within a health model. Required.
health_model_namestringName of health model resource. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
subscription_idstring
timestampstring (date-time)Timestamp to use for the operation. When specified, the version of the resource at this point in time is retrieved. If not specified, the latest version is used. Default value is None.

SELECT examples

Retrieve the time series history for a signal on an entity.

SELECT
entityName,
history,
signalName
FROM azure.cloud_health.entities
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND health_model_name = '{{ health_model_name }}' -- required
AND entity_name = '{{ entity_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Create a Entity.

INSERT INTO azure.cloud_health.entities (
properties,
resource_group_name,
health_model_name,
entity_name,
subscription_id
)
SELECT
'{{ properties }}',
'{{ resource_group_name }}',
'{{ health_model_name }}',
'{{ entity_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
properties,
systemData,
type
;

REPLACE examples

Create a Entity.

REPLACE azure.cloud_health.entities
SET
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND health_model_name = '{{ health_model_name }}' --required
AND entity_name = '{{ entity_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
properties,
systemData,
type;

DELETE examples

Delete a Entity.

DELETE FROM azure.cloud_health.entities
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND health_model_name = '{{ health_model_name }}' --required
AND entity_name = '{{ entity_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;

Lifecycle Methods

Retrieve the health state transition history for an entity.

EXEC azure.cloud_health.entities.get_history 
@resource_group_name='{{ resource_group_name }}' --required,
@health_model_name='{{ health_model_name }}' --required,
@entity_name='{{ entity_name }}' --required,
@subscription_id='{{ subscription_id }}' --required
@@json=
'{
"startAt": "{{ startAt }}",
"endAt": "{{ endAt }}"
}'
;