→ Upcoming Keynote Event - Introducing Lansweeper's 2023 Spring Release: 'Duvel' - Learn More
12-12-2022 11:01 AM - edited 02-08-2023 04:45 PM
Moving your Lansweeper server configuration manually from one scanning server to another can be straightforward but results in the old server being removed. This article introduces a more accessible method that achieves the same result by running a database script. The advantage of this script is that the old server will not be removed.
The script copies the configuration (threads, cleanup settings, and active scanning options) from the old source server to the new destination server. For this script to work correctly, the new server's service must have started successfully at least once.
Use Lansweeperdb
UPDATE tsysASServers
SET
[Listenport] = existing.listenport,
[ConcurrentThreads] = existing.[ConcurrentThreads],
[IPscanThreads] = existing.[IPscanThreads],
[RMADCOMP] = existing.[RMADCOMP],
[NAADCOMP] = existing.[NAADCOMP],
[RMADUSER] = existing.[RMADUSER],
[MAKEACTIVE] = existing.[MAKEACTIVE],
[DELHIST] = existing.[DELHIST],
[DELHISTDAYS] = existing.[DELHISTDAYS],
[DELCOMP] = existing.[DELCOMP],
[DELCOMPDAYS] = existing.[DELCOMPDAYS],
[NACOMP] = existing.[NACOMP],
[NACOMPDAYS] = existing.[NACOMPDAYS],
[DELEVENTDAYS] = existing.[DELEVENTDAYS],
[DELSYSLOGDAYS] = existing.[DELSYSLOGDAYS],
[REFRADCOMP] = existing.[REFRADCOMP],
[REFRADUSERS] = existing.[REFRADUSERS],
[RMDIUSER] = existing.[RMDIUSER],
[RMDICOMP] = existing.[RMDICOMP],
[NADICOMP] = existing.[NADICOMP],
[Scanuser] = existing.[Scanuser],
[EVinfo] = existing.[EVinfo],
[EVsuccess] = existing.[EVsuccess],
[DELUptimeDays] = existing.[DELUptimeDays],
[EVwarning] = existing.[EVwarning],
[EVfailure] = existing.[EVfailure],
[DELLOGONINFO] = existing.[DELLOGONINFO],
[renamedComputerDetection] = existing.[renamedComputerDetection],
[MaxDeploymentThreads] = existing.[MaxDeploymentThreads],
[DELDEPLOYMENTLOGDAYS] = existing.[DELDEPLOYMENTLOGDAYS],
[ScanHistoryDays] = existing.[ScanHistoryDays],
[ActiveScanningMaxRescanTime] = existing.[ActiveScanningMaxRescanTime],
[ActiveScanningMinRescanTime] = existing.[ActiveScanningMinRescanTime],
[ActiveScanningInterval] = existing.[ActiveScanningInterval],
[Delconfigurationlogdays] = existing.[Delconfigurationlogdays],
[Delloginlogdays] = existing.[Delloginlogdays],
[DoFallbackScanning] = existing.[DoFallbackScanning],
DelPerformanceCounterDays = existing.[DelPerformanceCounterDays]
FROM tsysasservers
INNER JOIN tsysasservers existing ON existing.servername = 'sourceserver'
WHERE tsysasservers.servername = 'destinationserver';
Test Drive Lansweeper Yourself. Explore our interactive Demo or sign up for free 14-day trial.
Try Now