- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-30-2025
06:00 PM
- last edited on
‎08-07-2025
03:45 PM
by
cvigier
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-31-2025 05:10 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-31-2025 05:10 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-31-2025 05:17 PM
Thank you. I can work with that!