We’re currently experiencing a high volume of support requests, which may result in longer response times — thank you for your patience and understanding.
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!

Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now