Reports (Ad-hoc SQL Queries)
Report Title | Last Updated | |
|---|---|---|
Remote Provider Import Request Time | 11/8/2020 | |
Description | Notes: | |
Report of Remote Provider Import requests initiated by a user or scheduler. Requests can be, bulk imports, import for single RP app, import from all RP app mapped to a TF app Column Definitions:
| ||
Parameters | Detail | Default |
SQL Query (MS SQL Server) | ||
SELECT rpe.name AS 'RP Connection',
rpt.name AS 'Source Type',
type AS 'Request Type',
status AS 'Status',
(DATEDIFF(millisecond,
CONVERT(DATETIME2, processingStartTimestamp, 103),
COALESCE(CONVERT(DATETIME2, finishedTimestamp, 103), GETDATE()))
/ (1000 * 60)) as 'Import Time (min)',
requestTimestamp AS 'Requested Time',
processingStartTimestamp AS 'Request Import Start Time',
finishedTimestamp AS 'Request Import Finish Time',
applicationId,
remoteProviderApplicationId,
error,
errorMessage,
request.id
FROM RemoteProviderImportRequest request
LEFT JOIN RemoteProviderEntity rpe ON rpe.id = request.remoteProviderEntityId
LEFT JOIN RemoteProviderType rpt ON rpt.id = rpe.remoteProviderTypeId
ORDER BY createdDate DESC;
| ||