Skip to main content

mes.spGetAssetStateEventSummary

Description

Summarizes state durations for a given asset within a date range, optionally filtered by event duration and type. Uses `fnGetAssetStateEvents` internally and performs grouping on state dimensions.

Syntax

mes.spGetAssetStateEventSummary @assetId, @rangeStart, @rangeEnd, @durationSecs, @showChanged, @showDowntimeOnly

Parameters:
@assetId (int): ID of the asset.
@rangeStart (datetime): Beginning of the analysis window.
@rangeEnd (datetime): End of the analysis window.
@durationSecs (int): Minimum duration (in seconds) for events to be included.
@showChanged (bit): If 1, only includes events with changed states.
@showDowntimeOnly (bit): If 1, filters to only include downtime states.

Returns:
Grouped state duration (in seconds) by:
- assetName
- assetPath
- stateName
- stateTypeName
- stateCategoryName
- assetStateName
- assetStatePath

Code Example​

EXEC mes.spGetAssetStateEventSummary
    @assetId = 1001,
    @rangeStart = '2025-07-01',
    @rangeEnd = '2025-07-30',
    @durationSecs = 60,
    @showChanged = 1,
    @showDowntimeOnly = 1;