We have some systems taking a very long time to do quick scans (some 90
plus hours)
Curious if anyone else has the issue. Here is a quick way to see if you do.
Note that the duration and duration in hours can be "Off" because the
duration field only goes up to 24. once it passes 24 it goes back to 1. The
hours field just keep counting up
SELECT
VRS.Name0 as 'Computer Name',
OS.Caption0 as 'Operating System',
HS.LastQuickScanDateTimeStart,
HS.LastQuickScanDateTimeEnd,
SUBSTRING( convert(varchar, DATEADD(ss,SUM(datediff(ss,HS.
LastQuickScanDateTimeStart, HS.LastQuickScanDateTimeEnd)),CAST('00:00:00' AS
TIME)),108),1,5) AS [LastQuickScanDuration],
DATEDIFF(HOUR,HS.LastQuickScanDateTimeStart,HS.LastQuickScanDateTimeEnd) AS
[LastQuickScanDurationInHours],
HS.LastFullScanDateTimeStart,
HS.LastFullScanDateTimeEnd,
SUBSTRING( convert(varchar, DATEADD(ss,SUM(datediff(ss,HS.
LastFullScanDateTimeStart, HS.LastFullScanDateTimeEnd)),CAST('00:00:00' AS
TIME)),108),1,5) AS [LastFullScanDuration],
DATEDIFF(HOUR,HS.LastFullScanDateTimeStart,HS.LastFullScanDateTimeEnd) AS
[LastFullScanDurationInHours],
HS.LastQuickScanAge as 'Days since last quick scan',
HS.LastFullScanAge as 'Days since last full scan'
FROM v_R_System VRS
INNER JOIN v_GS_AntimalwareHealthStatus HS ON HS.ResourceID = VRS.ResourceID
INNER JOIN v_GS_OPERATING_SYSTEM OS ON VRS.ResourceID = OS.ResourceID
Group By
VRS.Name0,
OS.Caption0,
HS.LastQuickScanDateTimeStart,
HS.LastQuickScanDateTimeEnd,
HS.LastFullScanDateTimeStart,
HS.LastFullScanDateTimeEnd,
HS.LastQuickScanAge,
HS.LastFullScanAge
Order By [LastQuickScanDurationInHours] Desc
