Versions Compared

Old Version 1

changes.mady.by.user Daniel Colon

Saved on

compared with

New Version Current

changes.mady.by.user Daniel Colon

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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:

  • 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)

Code Block
languagesql
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;