mes.spGetStateEvent

Description

This stored procedure returns detailed diagnostic information for a given `stateEventId`. It identifies the start and end timestamps, associated asset, state codes, and descriptive metadata from multiple joined views and tables. Useful for event auditing and state history analysis.

Syntax

mes.spGetStateEvent @stateEventId

Parameters:
@stateEventId (int): The unique identifier of the state event to retrieve.

Returns:
A single row with the following key columns:
- **stateEventId**: Identifier of the state event
- **assetId / assetName / assetPath**: Associated asset information
- **stateCode / origStateCode**: Current and original state codes
- **assetStateId / origAssetId**: State-specific asset details
- **stateName / stateTypeName / stateCategoryName**: Descriptive state metadata
- **stateStart / stateEnd**: Start and end time of the event
- **note / changedBy**: Change metadata

Code Example

EXEC mes.spGetStateEvent @stateEventId = 9042;