PRUEBA AHORA

IP Range Scanning Hour Overview

Miscellaneous

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. Scanned hours report

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]

Show

Hide