As we reach the end of September 2024, ThreadFix version 3.x on-premises has officially reached its End-of-Life. Therefore, there is no longer support or updates for this version of the product. We have fully transitioned our product and development teams to focus ThreadFix SaaS and migrating all customers over from the on-premises versions. Our Customer Success and Support teams are here to help you in migrating to ThreadFix SaaS and maximizing the value you see from this improved offering from Coalfire. This is the next phase of ThreadFix and our team is looking forward to continuing to support you on this journey.
Total Scan Ingestion Time Report
- Daniel Colon
Reports (Ad-hoc SQL Queries)
Report Title | Last Updated | |
|---|---|---|
Total Scan Ingestion Time | 11/8/2020 | |
Description | Notes: | |
Total start to finish time for all Completed and Active Pending Scans |
| |
Parameters | Detail | Default |
Active filter | This column currently remains |
|
Number of scans included | The number after the TOP keyword can be adjusted or removed all together; this restricts the number of PendingScans included in this report. Ordering parameters also apply. |
|
Order | ASC: earliest scans DESC: latest scans |
|
SQL Query (MS SQL Server) | ||
/*
* Total start to finish time for all 'Completed' and 'active' Pending Scans
* Result time unit: minutes
*/
SELECT
(DATEDIFF(millisecond,
CONVERT(DATETIME2, oldestCreatedDate, 103),
CONVERT(DATETIME2, latestEndDate, 103))/1000 / 60) AS totalTime
FROM
(SELECT
MIN(createdDate) AS oldestCreatedDate, MAX(modifiedDate) AS latestEndDate
FROM
(SELECT TOP 1000 * FROM NewPendingScan
WHERE active = 1 AND pendingScanStatus = 'COMPLETED'
ORDER BY createdDate DESC) ps ) t ;
| ||
www.threadfix.it | www.coalfire.com
Copyright © 2024 Coalfire. All rights reserved.
This Information Security Policy is CoalFire - Public: Distribution of this material is not limited.