# mes.spGetDowntimeDataForReliability

## Description
Classifies downtime states into reliability buckets such as PLANNED, SETUP, MINOR_STOP, BREAKDOWN, or PROCESS_FAILURE. Useful for reliability and maintenance analytics. Derives data from `stateEvent`, `state`, and associated state metadata.

## Syntax
<b>mes.spGetDowntimeDataForReliability @assetId, @rangeStart, @rangeEnd, @shortStop</b>  
<br /><br />

<b>Parameters:</b><br />
@assetId (int): ID of the asset to analyze.<br />
@rangeStart (datetime): Beginning of the evaluation period.<br />
@rangeEnd (datetime): End of the evaluation period.<br />
@shortStop (int): Threshold in seconds used to determine "Minor Stop" classification.<br /><br />

<b>Returns:</b><br />
List of downtime state events with:<br />
- stateType and category details<br />
- timestamps<br />
- part-required indicator<br />
- derived bucket classification

### Code Example

```sql
EXEC mes.spGetDowntimeDataForReliability
    @assetId = 1001,
    @rangeStart = '2025-07-01',
    @rangeEnd = '2025-07-30',
    @shortStop = 300;