IP Range Scan Time Overview

Get an Overview of the Scan Times of IP Ranges

Managing the load on your Lansweeper scanning server can be very important if you’re scanning large amounts of assets. Windows assets automatically log how long a scan takes for each scanned component. Using this data we’re able to compile the total scanning time for IP Ranges based on only the time it takes to scan Windows assets within that range. This provides some indication of how long it takes Lansweeper to perform a scan of your IP Ranges and can identify potential issues, and help with load balancing and determining if additional scanning servers are needed. You can read more about using this data in the Pro Tips blog post.

Scanning Time Query

Select CONCAT(ipstart, ' - ', ipend) as IPRange,
Count(tblassets.AssetID) As [IPs Used],
Cast(ISNULL(sum(a.scantime)/60,0) as decimal(16,2)) as [Scantime (Minutes)],
Cast(ISNULL(avg(a.scantime/60),0) as decimal(16,2)) as [Average Scantime (Minutes)]
From tblassets
Inner Join tblAssetCustom On tblassets.AssetID = tblAssetCustom.AssetID
Inner Join tblState On tblState.State = tblAssetCustom.State
inner Join tsysIPScanRanges On tsysIPScanRanges.Servername =
tblassets.Scanserver
inner join tblComputersystem on tblComputersystem.AssetID = tblassets.AssetID
left join (select sum(ISNULL(scantime, 0)) as scantime,
assetid
from TsysLastscan
group by assetid) as a on a.AssetID = tblassets.AssetID
Where tblState.Statename = 'Active' and tblassets.IPNumeric Between
ParseName(tsysIPScanRanges.Ipstart, 4) +
Right('000' + IsNull(ParseName(tsysIPScanRanges.Ipstart, 3), ''), 3) +
Right('000' + IsNull(ParseName(tsysIPScanRanges.Ipstart, 2), ''), 3) +
Right('000' + IsNull(ParseName(tsysIPScanRanges.Ipstart, 1), ''),
3) And ParseName(tsysIPScanRanges.Ipend, 4)+ Right('000' + IsNull(ParseName(tsysIPScanRanges.Ipend, 3), ''), 3) +
Right('000' + IsNull(ParseName(tsysIPScanRanges.Ipend, 2), ''), 3) +
Right('000' + IsNull(ParseName(tsysIPScanRanges.Ipend, 1), ''), 3)
Group By tsysIPScanRanges.IprangeID,
ipstart, ipend
order by IprangeID

Show

Hide