Remote Provider Import Request Time

Reports (Ad-hoc SQL Queries)

Report Title		Last Updated

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: Import Time (minutes): the total time it took to complete importing scans for all apps associated with the request (or running time if still in progress).
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;