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 }}"
}'
;