mes.fnGetAssetStateEvents

Description

Returns asset state events with mode and time window overlap information.

Syntax

mes.fnGetAssetStateEvents(@assetId, @stateEventStart, @rangeStart, @rangeEnd, @durationSecs, @showChanged, @showDowntimeOnly)

Parameters:

@assetId (int): Asset Id

@stateEventStart (datetime): Minimum timestamp for state events

@rangeStart (datetime): Start of the filter range

@rangeEnd (datetime): End of the filter range

@durationSecs (int): Minimum duration in seconds

@showChanged (bit): Include changed states only

@showDowntimeOnly (bit): Include downtime states only

Returns:
Returns a table. Columns vary based on query logic.

Code Example

-- Retrieve asset state events with filters applied
SELECT *
FROM mes.fnGetAssetStateEvents(
  2076,                             -- @assetId
  '2025-07-01T00:00:00',            -- @stateEventStart
  '2025-07-01T00:00:00',            -- @rangeStart
  '2025-07-30T23:59:59',            -- @rangeEnd
  60,                               -- @durationSecs (minimum 60s)
  0,                                -- @showChanged (false)
  1                                 -- @showDowntimeOnly (true)
);