IP Range Scanning Hour Overview

Get an Overview of Which Scan Times Are Most Frequent in Your Setup

Lansweeper lets you create as many IP Range scanning targets as you like, across as many scanning servers as you want. Each IP Range scanning targets can be triggered at a specific time of day and can create a lot of complexity in your scanning setup. That's why with the report below you'll get a better overview of the amount of IP Range scanning targets that are triggered each day, the specific hour they are triggered, and how many assets those targets contain. You can read more about using this data in the Pro Tips blog post.

IP Range Scanning Hour Overview Query

Select Top 1000000 'Monday' As Day,
Count(tsysIPScanRanges.IprangeID) As IPRanges,
DatePart(HOUR, tsysIPScanRanges.day1time) As Hour,
IsNull(a.[IPs Used], 0) As [IPs Used],
tsysIPScanRanges.Servername
From tsysIPScanRanges
Left Join (Select Count(tblassets.AssetID) As [IPs Used],
DatePart(HOUR, tsysIPScanRanges.day1time) As Hour
From tblassets
Inner Join tblAssetCustom On tblassets.AssetID = tblAssetCustom.AssetID
Inner Join tblState On tblState.State = tblAssetCustom.State
Left Join tsysIPScanRanges On tsysIPScanRanges.Servername =
tblassets.Scanserver
Where tblState.Statename = 'Active' And tblassets.IPNumeric Between
Right('000' + IsNull(ParseName(tsysIPScanRanges.Ipstart, 4), ''), 3) +
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 Right('000' + IsNull(ParseName(tsysIPScanRanges.Ipend, 4), ''),
3) + 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.day1time) As a On a.Hour = DatePart(HOUR,
tsysIPScanRanges.day1time)
Where tsysIPScanRanges.day1 = 1 And tsysIPScanRanges.Enabled = 1
Group By tsysIPScanRanges.day1time,
tsysIPScanRanges.Servername,
a.[IPs Used]
Union All
Select 'Tuesday' As Day,
Count(tsysIPScanRanges.IprangeID) As IPRanges,
DatePart(HOUR, tsysIPScanRanges.day2time) As Hour,
IsNull(a.[IPs Used], 0) As [IPs Used],
tsysIPScanRanges.Servername
From tsysIPScanRanges
Left Join (Select Count(tblassets.AssetID) As [IPs Used],
DatePart(HOUR, tsysIPScanRanges.day2time) As Hour
From tblassets
Inner Join tblAssetCustom On tblassets.AssetID = tblAssetCustom.AssetID
Inner Join tblState On tblState.State = tblAssetCustom.State
Left Join tsysIPScanRanges On tsysIPScanRanges.Servername =
tblassets.Scanserver
Where tblState.Statename = 'Active' And tblassets.IPNumeric Between
Right('000' + IsNull(ParseName(tsysIPScanRanges.Ipstart, 4), ''), 3) +
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 Right('000' + IsNull(ParseName(tsysIPScanRanges.Ipend, 4), ''),
3) + 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.day2time) As a On a.Hour = DatePart(HOUR,
tsysIPScanRanges.day2time)
Where tsysIPScanRanges.day2 = 1 And tsysIPScanRanges.Enabled = 1
Group By tsysIPScanRanges.day2time,
tsysIPScanRanges.Servername,
a.[IPs Used]
Union All
Select 'Wednesday' As Day,
Count(tsysIPScanRanges.IprangeID) As IPRanges,
DatePart(HOUR, tsysIPScanRanges.day3time) As Hour,
IsNull(a.[IPs Used], 0) As [IPs Used],
tsysIPScanRanges.Servername
From tsysIPScanRanges
Left Join (Select Count(tblassets.AssetID) As [IPs Used],
DatePart(HOUR, tsysIPScanRanges.day3time) As Hour
From tblassets
Inner Join tblAssetCustom On tblassets.AssetID = tblAssetCustom.AssetID
Inner Join tblState On tblState.State = tblAssetCustom.State
Left Join tsysIPScanRanges On tsysIPScanRanges.Servername =
tblassets.Scanserver
Where tblState.Statename = 'Active' And tblassets.IPNumeric Between
Right('000' + IsNull(ParseName(tsysIPScanRanges.Ipstart, 4), ''), 3) +
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 Right('000' + IsNull(ParseName(tsysIPScanRanges.Ipend, 4), ''),
3) + 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.day3time) As a On a.Hour = DatePart(HOUR,
tsysIPScanRanges.day3time)
Where tsysIPScanRanges.day3 = 1 And tsysIPScanRanges.Enabled = 1
Group By tsysIPScanRanges.day3time,
tsysIPScanRanges.Servername,
a.[IPs Used]
Union All
Select 'Thursday' As Day,
Count(tsysIPScanRanges.IprangeID) As IPRanges,
DatePart(HOUR, tsysIPScanRanges.day4time) As Hour,
IsNull(a.[IPs Used], 0) As [IPs Used],
tsysIPScanRanges.Servername
From tsysIPScanRanges
Left Join (Select Count(tblassets.AssetID) As [IPs Used],
DatePart(HOUR, tsysIPScanRanges.day4time) As Hour
From tblassets
Inner Join tblAssetCustom On tblassets.AssetID = tblAssetCustom.AssetID
Inner Join tblState On tblState.State = tblAssetCustom.State
Left Join tsysIPScanRanges On tsysIPScanRanges.Servername =
tblassets.Scanserver
Where tblState.Statename = 'Active' And tblassets.IPNumeric Between
Right('000' + IsNull(ParseName(tsysIPScanRanges.Ipstart, 4), ''), 3) +
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 Right('000' + IsNull(ParseName(tsysIPScanRanges.Ipend, 4), ''),
3) + 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.day4time) As a On a.Hour = DatePart(HOUR,
tsysIPScanRanges.day4time)
Where tsysIPScanRanges.day4 = 1 And tsysIPScanRanges.Enabled = 1
Group By tsysIPScanRanges.day4time,
tsysIPScanRanges.Servername,
a.[IPs Used]
Union All
Select 'Friday' As Day,
Count(tsysIPScanRanges.IprangeID) As IPRanges,
DatePart(HOUR, tsysIPScanRanges.day5time) As Hour,
IsNull(a.[IPs Used], 0) As [IPs Used],
tsysIPScanRanges.Servername
From tsysIPScanRanges
Left Join (Select Count(tblassets.AssetID) As [IPs Used],
DatePart(HOUR, tsysIPScanRanges.day5time) As Hour
From tblassets
Inner Join tblAssetCustom On tblassets.AssetID = tblAssetCustom.AssetID
Inner Join tblState On tblState.State = tblAssetCustom.State
Left Join tsysIPScanRanges On tsysIPScanRanges.Servername =
tblassets.Scanserver
Where tblState.Statename = 'Active' And tblassets.IPNumeric Between
Right('000' + IsNull(ParseName(tsysIPScanRanges.Ipstart, 4), ''), 3) +
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 Right('000' + IsNull(ParseName(tsysIPScanRanges.Ipend, 4), ''),
3) + 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.day5time) As a On a.Hour = DatePart(HOUR,
tsysIPScanRanges.day5time)
Where tsysIPScanRanges.day5 = 1 And tsysIPScanRanges.Enabled = 1
Group By tsysIPScanRanges.day5time,
tsysIPScanRanges.Servername,
a.[IPs Used]
Union All
Select 'Saturday' As Day,
Count(tsysIPScanRanges.IprangeID) As IPRanges,
DatePart(HOUR, tsysIPScanRanges.day6time) As Hour,
IsNull(a.[IPs Used], 0) As [IPs Used],
tsysIPScanRanges.Servername
From tsysIPScanRanges
Left Join (Select Count(tblassets.AssetID) As [IPs Used],
DatePart(HOUR, tsysIPScanRanges.day6time) As Hour
From tblassets
Inner Join tblAssetCustom On tblassets.AssetID = tblAssetCustom.AssetID
Inner Join tblState On tblState.State = tblAssetCustom.State
Left Join tsysIPScanRanges On tsysIPScanRanges.Servername =
tblassets.Scanserver
Where tblState.Statename = 'Active' And tblassets.IPNumeric Between
Right('000' + IsNull(ParseName(tsysIPScanRanges.Ipstart, 4), ''), 3) +
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 Right('000' + IsNull(ParseName(tsysIPScanRanges.Ipend, 4), ''),
3) + 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.day6time) As a On a.Hour = DatePart(HOUR,
tsysIPScanRanges.day6time)
Where tsysIPScanRanges.day6 = 1 And tsysIPScanRanges.Enabled = 1
Group By tsysIPScanRanges.day6time,
tsysIPScanRanges.Servername,
a.[IPs Used]
Union All
Select 'Sunday' As Day,
Count(tsysIPScanRanges.IprangeID) As IPRanges,
DatePart(HOUR, tsysIPScanRanges.day7time) As Hour,
IsNull(a.[IPs Used], 0) As [IPs Used],
tsysIPScanRanges.Servername
From tsysIPScanRanges
Left Join (Select Count(tblassets.AssetID) As [IPs Used],
DatePart(HOUR, tsysIPScanRanges.day7time) As Hour
From tblassets
Inner Join tblAssetCustom On tblassets.AssetID = tblAssetCustom.AssetID
Inner Join tblState On tblState.State = tblAssetCustom.State
Left Join tsysIPScanRanges On tsysIPScanRanges.Servername =
tblassets.Scanserver
Where tblState.Statename = 'Active' And tblassets.IPNumeric Between
Right('000' + IsNull(ParseName(tsysIPScanRanges.Ipstart, 4), ''), 3) +
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 Right('000' + IsNull(ParseName(tsysIPScanRanges.Ipend, 4), ''),
3) + 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.day7time) As a On a.Hour = DatePart(HOUR,
tsysIPScanRanges.day7time)
Where tsysIPScanRanges.day7 = 1 And tsysIPScanRanges.Enabled = 1
Group By tsysIPScanRanges.day7time,
tsysIPScanRanges.Servername,
a.[IPs Used]

Run This Report in 3 Easy Steps

1. Download & Install Lansweeper

3. Run the Report

Download Lansweeper to Run this Report

Harness the Power of Reporting