Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
PapaTuck
Engaged Sweeper III

Using Lansweeper Classic only: I need a report that will allow me to see if any scans are scheduled to  kick off around 3 AM daily. Is there such a report? Maybe one that could be modified to show different specific times.

 

1 ACCEPTED SOLUTION
Mister_Nobody
Honored Sweeper III

Did you see this report:

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

View solution in original post

2 REPLIES 2
Mister_Nobody
Honored Sweeper III

Did you see this report:

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

Thank you. I can work with that!