Standardrapportfrågor
Standardrapporterna som ingår i Kofax Capture baseras på följande frågor. Du kan använda dem som underlag för egna anpassade rapporter.
Rapportfrågan Systemstatus
Vyn viewBatchList lades till för att göra det enklare att skapa en liknande rapport med något avvikande data.
SELECT
ModuleName,
BatchStatus,
COUNT(*) AS NumBatches,
SUM(ActualDocs) AS NumDocs,
SUM(ActualPages) AS NumPages
FROM
viewBatchList
GROUP BY
ModuleName, BatchStatus
Rapportfrågan Batchsummering
Observera att vyn viewStatsBatchSummary lades till för att göra det enklare att skapa en liknande rapport med något avvikande data.
SELECT
BatchClass,
COUNT(ExternalBatchID) AS Batches,
SUM(ProcessingSeconds) AS ProcessingSecondsTotal,
SUM(EndToEndSeconds) AS EndToEndSecondsTotal,
SUM(Documents) AS Documents,
SUM(Pages) AS Pages
FROM
viewStatsBatchSummary
WHERE
Exported > 0
AND LastSessionDateTime >= {?Report Start}
AND LastSessionDateTime <= {?Report End}
GROUP BY
BatchClass
Rapportfrågan Modulproduktivitet
Observera att vyn viewStatsSession lades till för att göra det enklare att skapa en liknande rapport med något avvikande data.
SELECT
ModuleName,
COUNT(ExternalBatchID) AS Sessions,
COUNT(DISTINCT ExternalBatchID) AS Batches,
SUM(DateDiff("s", SessionStartDateTime, SessionEndDateTime)) AS ProcessingSeconds,
SUM(CompletedDocuments) AS CompletedDocuments,
SUM(KeyStrokes) AS KeyStrokes
FROM
viewStatsSession
INNER JOIN
(
SELECT BatchModuleID,
SUM(CompletedDocs) AS CompletedDocuments,
SUM(KS_Manual + KS_OCRRepair + KS_ICRRepair + KS_BCRepair + KS_OMRRepair) AS KeyStrokes
FROM StatsFormType
GROUP BY BatchModuleID
) AS d
ON viewStatsSession.BatchModuleID = d.BatchModuleID
WHERE
ModuleStartDateTime IS NOT NULL
AND SessionEndDateTime >= {?Report Start}
AND SessionEndDateTime <= {?Report End}
GROUP BY
ModuleName
ORDER BY
ModuleName
Rapportfrågan Användarproduktivitet
Observera att vyn viewStatsSession lades till för att göra det enklare att skapa en liknande rapport med något avvikande data.
SELECT
ModuleName, UserName,
COUNT(ExternalBatchID) AS Sessions,
COUNT(DISTINCT ExternalBatchID) AS Batches,
SUM(DateDiff("s", SessionStartDateTime, SessionEndDateTime)) AS ProcessingSeconds,
SUM(CompletedDocuments) AS CompletedDocuments,
SUM(KeyStrokes) AS KeyStrokes
FROM
viewStatsSession
INNER JOIN
(
SELECT BatchModuleID,
SUM(CompletedDocs) AS CompletedDocuments,
SUM(KS_Manual + KS_OCRRepair + KS_ICRRepair + KS_BCRepair + KS_OMRRepair) AS KeyStrokes
FROM StatsFormType
GROUP BY BatchModuleID
) AS d
ON viewStatsSession.BatchModuleID = d.BatchModuleID
WHERE
SessionEndDateTime >= {?Report Start}
AND SessionEndDateTime <= {?Report End}
AND ModuleName IS NOT NULL
GROUP BY
ModuleName, UserName
ORDER BY
ModuleName, UserName
Rapportfrågan Skannade sidor
Observera att vyn viewStatsSession lades till för att göra det enklare att skapa en liknande rapport med något avvikande data.
SELECT
SiteName, StationID,
SUM(PagesScanned) AS PagesScanned,
YEAR(SessionEndDateTime) AS ScanYear,
MONTH(SessionEndDateTime) AS ScanMonth,
DAY(SessionEndDateTime) AS ScanDay
FROM
viewStatsSession
WHERE
SessionEndDateTime >= {?Report Start}
AND SessionEndDateTime <= {?Report End}
AND Deleted = 0
GROUP BY
YEAR(SessionEndDateTime),
MONTH(SessionEndDateTime),
DAY(SessionEndDateTime),
SiteName, StationID
HAVING
SUM(PagesScanned)<>0
ORDER BY
YEAR(SessionEndDateTime),
MONTH(SessionEndDateTime),
SiteName,
DAY(SessionEndDateTime),
StationID