→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎08-08-2017 04:08 PM
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
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now