Skip to main content

mes.spGetProductionDataForReliability

Description

This stored procedure collects detailed production and reliability data for a given asset and mode across a defined time range. It calculates raw counters, availability, performance, and quality metrics, including takt time, actual rates, and loss analyses, suitable for reliability and performance dashboards.

Syntax

mes.spGetProductionDataForReliability @assetId, @rangeStart, @rangeEnd, @modeId

Parameters:
@assetId (int): The ID of the asset
@rangeStart (datetime): Start timestamp for the query (optional)
@rangeEnd (datetime): End timestamp for the query (optional)
@modeId (int): Mode identifier to filter production context

Returns:
Each row represents a production period and includes:
- Asset and mode metadata
- Item and work order references
- Duration (in seconds)
- Runtime, downtime, and planned downtime in seconds
- Counter metrics: infeedCount, outfeedCount, wasteCount
- TargetCount and taktTime
- Calculated metrics: - **Availability** - **Performance** - **Quality** - **Infeed rate per second** - **Actual production rate** - **Lossed units and performance loss seconds** - **Quality loss seconds**

Code Example​

EXEC mes.spGetProductionDataForReliability
    @assetId = 1001,
    @rangeStart = '2025-07-01',
    @rangeEnd = '2025-07-10',
    @modeId = 2;