UtilizationEvents
- Last UpdatedJan 11, 2021
- 1 minute read
This Azure function custom query returns the utilization events. The custom query expression supports the following parameters:
|
Parameter Name |
Parameter Choice |
Example |
Description |
|
QueryName |
Required |
UtilizationEvents |
Azure function query name |
|
SelectColumn |
Optional |
["*"] Or [ "Equipment AS EquipmentName", "Namespace AS Namespace", "Location AS Location", "EquipmentState AS State", "UtilizationReason AS Reason", "StartTime" ] |
Option to pick required properties from AVEVA Insight |
|
Equipment |
Required |
{ "Filter": "contains(Location,'Lake Forest')" } |
Equipment expression is used to apply a filter on the equipment to be used to retrieve utilization events. |
|
StartDateTime |
Optional |
"2019-01-01T00:00:00Z" |
Any valid UTC date time value, Optional parameter to restrict back fill data. |
Sample query expression
{
"QueryName": "UtilizationEvents",
"SelectColumn": [
"Equipment AS Equipment Name",
"Namespace AS Namespace",
"Location AS Location",
"EquipmentState AS State",
"UtilizationReason AS Reason",
"StartTime"
],
"Equipment": {
"Filter": "contains(Location,'Lake Forest')"
},
"StartDateTime":"2019-01-01T00:00:00Z"
}