‎01-02-2019 03:53 PM
select *
From tblAssets
Inner Join (Select tsysIPScanRanges.Servername As servername,
Convert(numeric(18),ParseName(tsysIPScanRanges.Ipstart, 4) +
Right('000' + IsNull(ParseName(tsysIPScanRanges.Ipstart, 3), ''), 3) +
Right('000' + IsNull(ParseName(tsysIPScanRanges.Ipstart, 2), ''), 3) +
Right('000' + IsNull(ParseName(tsysIPScanRanges.Ipstart, 1), ''),
3)) As ipstartnumeric,
Convert(numeric(18),ParseName(tsysIPScanRanges.Ipend, 4) + Right('000' +
IsNull(ParseName(tsysIPScanRanges.Ipend, 3), ''), 3) + Right('000' +
IsNull(ParseName(tsysIPScanRanges.Ipend, 2), ''), 3) + Right('000' +
IsNull(ParseName(tsysIPScanRanges.Ipend, 1), ''), 3)) As ipendnumeric
From tsysIPScanRanges where enabled = 1) As tsir On tblAssets.IPNumeric >=
tsir.ipstartnumeric And tblAssets.IPNumeric <= tsir.ipendnumeric
Where tblAssets.Scanserver <> tsir.servername
update tblassets
set tblassets.scanserver = tsir.servername
From tblAssets
Inner Join (Select tsysIPScanRanges.Servername As servername,
Convert(numeric(18),ParseName(tsysIPScanRanges.Ipstart, 4) +
Right('000' + IsNull(ParseName(tsysIPScanRanges.Ipstart, 3), ''), 3) +
Right('000' + IsNull(ParseName(tsysIPScanRanges.Ipstart, 2), ''), 3) +
Right('000' + IsNull(ParseName(tsysIPScanRanges.Ipstart, 1), ''),
3)) As ipstartnumeric,
Convert(numeric(18),ParseName(tsysIPScanRanges.Ipend, 4) + Right('000' +
IsNull(ParseName(tsysIPScanRanges.Ipend, 3), ''), 3) + Right('000' +
IsNull(ParseName(tsysIPScanRanges.Ipend, 2), ''), 3) + Right('000' +
IsNull(ParseName(tsysIPScanRanges.Ipend, 1), ''), 3)) As ipendnumeric
From tsysIPScanRanges where enabled = 1) As tsir On tblAssets.IPNumeric >=
tsir.ipstartnumeric And tblAssets.IPNumeric <= tsir.ipendnumeric
Where tblAssets.Scanserver <> tsir.servername
‎01-07-2019 02:33 PM
‎01-07-2019 05:31 PM
Charles.X wrote:
Thank you for sharing your reports. I'm sure some people will find them helpful.
Just as an FYI, since there are different configuration tabs for each scanning server, the best practice is to configure the correct scanning target to the preferred scanning server.
This alternative method is not officially supported, but that doesn't mean it doesn't have it's uses 😉
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now