Where tsysIPScanRanges.day4 = 1 And tsysIPScanRanges.Enabled = 1ĭatePart(HOUR, tsysIPScanRanges.day5time) As Hour,ĭatePart(HOUR, tsysIPScanRanges.day5time) As Hour Group By tsysIPScanRanges.day4time) As a On a.Hour = DatePart(HOUR, Where tsysIPScanRanges.da圓 = 1 And tsysIPScanRanges.Enabled = 1ĭatePart(HOUR, tsysIPScanRanges.day4time) As Hour,ĭatePart(HOUR, tsysIPScanRanges.day4time) As Hour Group By tsysIPScanRanges.da圓time) As a On a.Hour = DatePart(HOUR, Where tsysIPScanRanges.day2 = 1 And tsysIPScanRanges.Enabled = 1ĭatePart(HOUR, tsysIPScanRanges.da圓time) As Hour,ĭatePart(HOUR, tsysIPScanRanges.da圓time) As Hour Group By tsysIPScanRanges.day2time) As a On a.Hour = DatePart(HOUR, Where tsysIPScanRanges.day1 = 1 And tsysIPScanRanges.Enabled = 1ĭatePart(HOUR, tsysIPScanRanges.day2time) As Hour,ĭatePart(HOUR, tsysIPScanRanges.day2time) As Hour Group By tsysIPScanRanges.day1time) As a On a.Hour = DatePart(HOUR, Right('000' + IsNull(ParseName(tsysIPScanRanges.Ipend, 1), ''), 3) Right('000' + IsNull(ParseName(tsysIPScanRanges.Ipend, 2), ''), 3) + Right('000' + IsNull(ParseName(tsysIPScanRanges.Ipstart, 1), ''),ģ) And Right('000' + IsNull(ParseName(tsysIPScanRanges.Ipend, 4), ''),ģ) + Right('000' + IsNull(ParseName(tsysIPScanRanges.Ipend, 3), ''), 3) + Right('000' + IsNull(ParseName(tsysIPScanRanges.Ipstart, 2), ''), 3) + Right('000' + IsNull(ParseName(tsysIPScanRanges.Ipstart, 3), ''), 3) + Right('000' + IsNull(ParseName(tsysIPScanRanges.Ipstart, 4), ''), 3) + Where tblState.Statename = 'Active' And tblassets.IPNumeric Between Left Join tsysIPScanRanges On tsysIPScanRanges.Servername = Inner Join tblState On tblState.State = tblAssetCustom.State Inner Join tblAssetCustom On tblassets.AssetID = tblAssetCustom.AssetID Left Join (Select Count(tblassets.AssetID) As ,ĭatePart(HOUR, tsysIPScanRanges.day1time) As Hour IP Range Scanning Hour Overview Query Select Top 1000000 'Monday' As Day,Ĭount(tsysIPScanRanges.IprangeID) As IPRanges,ĭatePart(HOUR, tsysIPScanRanges.day1time) As Hour, 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. 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. Lansweeper lets you create as many IP Range scanning targets as you like, across as many scanning servers as you want. Get an Overview of Which Scan Times Are Most Frequent in Your Setup
0 kommentar(er)
