Scanning: IP Range scanning targets (Built-in)

[Nick_VDB]

Added in v.6.0.100

The report below lists the IP Range scanning targets and their settings that have been created under Scanning\Scanning Targets.

Select Top 1000000 tsysIPScanRanges.Enabled,
  tsysIPScanRanges.Ipstart,
  tsysIPScanRanges.Ipend,
  tsysIPScanRanges.Description,
  tsysIPScanRanges.Servername As ScanningServer,
  tsysIPScanRanges.Day1 As Monday,
  tsysIPScanRanges.Day2 As Tuesday,
  tsysIPScanRanges.Day3 As Wednesday,
  tsysIPScanRanges.Day4 As Thursday,
  tsysIPScanRanges.Day5 As Friday,
  tsysIPScanRanges.Day6 As Saturday,
  tsysIPScanRanges.Day7 As Sunday,
  Convert(nvarchar(5),tsysIPScanRanges.Day1time,114) As MondayTime,
  Convert(nvarchar(5),tsysIPScanRanges.Day2time,114) As TuesdayTime,
  Convert(nvarchar(5),tsysIPScanRanges.Day3time,114) As WednesdayTime,
  Convert(nvarchar(5),tsysIPScanRanges.Day4time,114) As ThursdayTime,
  Convert(nvarchar(5),tsysIPScanRanges.Day5time,114) As FridayTime,
  Convert(nvarchar(5),tsysIPScanRanges.Day6time,114) As SaturdayTime,
  Convert(nvarchar(5),tsysIPScanRanges.Day7time,114) As SundayTime,
  tsysIPScanRanges.Recurring,
  tsysIPScanRanges.Waittime As RecurringEvery,
  Case tsysIPScanRanges.Minutes When 0 Then 'Hours' When 1 Then 'Minutes'
  End As RecurringSchedule,
  tsysIPScanRanges.PingTimeout As PingTimeoutSeconds,
  tsysIPScanRanges.DontPing,
  tsysIPScanRanges.SavePingedIP,
  tsysIPScanRanges.IPIgnoreWindows As IgnoreWindows,
  tsysIPScanRanges.IPIgnoreKnownWindows As NewWindowsOnly,
  tsysIPScanRanges.NoSSH,
  tsysIPScanRanges.SSHport,
  tsysIPScanRanges.SIPport,
  tsysIPScanRanges.LastIPscan
From tsysIPScanRanges
Order By tsysIPScanRanges.Ipstart