Skip to main content

mes.spGetAssetPerformanceEventByShift

Description

Combines data from production events and performance events to return summarized performance information for each shift, including target counts, runtime, coded loss minutes, and performance metrics.

Syntax

mes.spGetAssetPerformanceEventByShift @assetPath, @rangeStart, @rangeEnd

Parameters:
@assetPath (varchar): Asset path string (supports LIKE match)
@rangeStart (datetime): Start of the query range
@rangeEnd (datetime): End of the query range

Returns:
Result set including shift-level performance metrics such as runtime, performance %, infeed rate, target count, and coded loss minutes.

Code Example​

-- Get asset performance by shift between two dates
EXEC mes.spGetAssetPerformanceEventByShift
  @assetPath = 'Site1.Line1%',
  @rangeStart = '2025-07-01',
  @rangeEnd = '2025-07-30';