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;