Help > Views > V_StepThroughputSum

View: V_StepThroughputSum

This view shows how many documents were processed per process step in the last hour.

Column

Description

DocumentCount

The total number of documents per process step (the sum of DocumentCount in V_StepThroughput).

Client

The name of the client (Client in V_StepThroughput).

Process

The name of the process (Process in V_StepThroughput).

ProcessStep

The name of the process step (Name in V_StepThroughput).

SQL Script

CREATE VIEW [dbo].[V_StepThroughputSum]
AS
SELECT SUM(DocumentCount) AS DocumentCountClient, Process, Name AS ProcessStep
FROM dbo.V_StepThroughput
GROUP BY Process, Name, Client

Uses

The available tables

The available views