mes.fnGetOEEMetrics

Description

Returns calculated OEE metrics from raw counts and durations.

Syntax

mes.fnGetOEEMetrics(@assetId, @startDate, @endDate, @durationSecs, @runtimeSecs, @unplannedDowntimeSecs, @plannedDowntimeSecs, @infeedCount, @outfeedCount, @wasteCount, @packageCount, @standardRate, @period)

Parameters:

@assetId (int): Asset Id

@startDate (datetime): Start of the time range

@endDate (datetime): End of the time range

@durationSecs (int): Total duration in seconds

@runtimeSecs (int): Runtime seconds

@unplannedDowntimeSecs (int): Unplanned downtime seconds

@plannedDowntimeSecs (int): Planned downtime seconds

@infeedCount (float): Infeed count

@outfeedCount (float): Outfeed count

@wasteCount (float): Waste count

@packageCount (float): Packaging factor

@standardRate (float): Standard rate

@period (varchar(50)): Period ('Hour' or 'Minute')

Returns:
Returns a table. Columns include OEE metrics like availability, performance, quality, and infeed rate.

Code Example

-- Get calculated OEE metrics for asset and input parameters
SELECT *
FROM mes.fnGetOEEMetrics(
  2076,                        -- assetId
  '2025-07-01T00:00:00',       -- startDate
  '2025-07-30T23:59:59',       -- endDate
  86400,                       -- durationSecs
  72000,                       -- runtimeSecs
  7200,                        -- unplannedDowntimeSecs
  1800,                        -- plannedDowntimeSecs
  10000,                       -- infeedCount
  9800,                        -- outfeedCount
  200,                         -- wasteCount
  1,                           -- packageCount
  15,                          -- standardRate
  'Hour'                       -- period
);