Help > Views > V_ThroughputDetailCurrHour

View: V_ThroughputDetailCurrHour

This view shows the total processing time per service type (ServiceType) from check-out to check-in and calculates total worker performance during the past hour.

Column	Description
ServiceType	0 = Activity 1 = Collector 2 = Agent 3 = Global Parameter Set 4 = Client Parameter Set 5 = Process Parameter Set 6 = Interactive 7 = Platform 8 = License 9 = Activity and Parameter Set 10 = Feature Group (ServiceType in V_SumDurationCurrentHour)
SumDurationHours	The number of hours in which the documents for this step were checked out. (The sum of SumDurationHours in V_SumDurationCurrentHour.)
DocumentCount	The number of documents for one service type (the sum of DocumentCount in V_SumDurationCurrentHour).
ThroughputHours	The number of documents for one service type, divided by the number of hours in which the documents were checked out. (Sum of DocumentCount / sum of SumDurationHours in V_SumDurationCurrentHour).

SQL Script

CREATE VIEW [dbo].[V_ThroughputDetailCurrHour]
AS
SELECT   ServiceType, SUM(SumDurationHours) AS SumDurationHours, SUM(DocumentCount) AS DocumentCount, SUM(DocumentCount)
	           / SUM(SumDurationHours) AS ThroughputHours
FROM     dbo.V_SumDurationCurrentHour
GROUP BY ServiceType

Uses

V_SumDurationCurrentHour

The available tables

The available views