# mes.spGetOEEDataSummary

## Description
This stored procedure summarizes Overall Equipment Effectiveness (OEE) for a specified asset over a given date range. It aggregates production runs into one consolidated summary including runtime, downtime, and counter-based production metrics. It then applies a server-side function to compute derived OEE metrics such as availability, performance, and quality.

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

<b>Parameters:</b><br />
@assetId (int): ID of the asset to analyze<br />
@rangeStart (datetime): Start of the analysis range<br />
@rangeEnd (datetime): End of the analysis range<br /><br />

<b>Returns:</b><br />
A single row summarizing:<br />
- Asset metadata (assetId, runStart, runEnd)<br />
- Aggregated time: durationSecs, runtimeSecs, unplannedDowntimeSecs, plannedDowntimeSecs<br />
- Production counters: rawInfeedCount, rawOutfeedCount, rawWasteCount<br />
- Standard rate and package count<br />
- Targets (OEE, availability, performance, quality, threshold)<br />
- Final calculated metrics from `fnGetOEEMetrics`:
  - **Availability**
  - **Performance**
  - **Quality**
  - **OEE**

### Code Example

```sql
EXEC mes.spGetOEEDataSummary
    @assetId = 1001,
    @rangeStart = '2025-07-01',
    @rangeEnd = '2025-07-15';