‎11-05-2019 04:45 PM
Solved! Go to Solution.
a week ago
Hello rtaylor,
The SQL Script that is mentioned in step 8 of the KB article should do that. It will remove the wrong server tab and modify all scanning targets to the new scanning server. Don't forget that step.
7.2 is a pretty old version, must be over 5 years. Hopefully, you also followed the migration steps in this KB article:
https://community.lansweeper.com/t5/lansweeper-maintenance/convert-a-deprecated-sql-compact-database...
a week ago
Hello rtaylor,
The SQL Script that is mentioned in step 8 of the KB article should do that. It will remove the wrong server tab and modify all scanning targets to the new scanning server. Don't forget that step.
7.2 is a pretty old version, must be over 5 years. Hopefully, you also followed the migration steps in this KB article:
https://community.lansweeper.com/t5/lansweeper-maintenance/convert-a-deprecated-sql-compact-database...
‎11-06-2019 04:26 PM
‎11-06-2019 02:38 PM
2 weeks ago
"scanserver" is not an available option in the list of fields.
‎11-06-2019 01:46 PM
Use Lansweeperdb
/* deletes the empty record of the new server, replace NewServer with the NetBIOS name of your new server (as seen in the web console) */
delete from tsysasservers where servername = 'NewServer'
GO
/* Renames your old server to the name of your new server, effectively transferring configuration. Replace NewServer with the NetBIOS name of your new server and OldServer with the NetBIOS name of your old server (as seen in the web console) */
update tsysasservers set servername = 'NewServer' where servername = 'OldServer'
GO
/* Moves the assets scanned by the old server to the new server, replace NewServer with the NetBIOS name of your new server and OldServer with the NetBIOS name of your old server (as seen in the web console) */
update tblassets set scanserver = 'NewServer' where scanserver = 'OldServer'
GO
‎12-12-2023 09:31 PM
Hello, we have a similar issue, except we are getting the following error below when trying to run the script any suggestions to fix the issue?
The DELETE statement conflicted with the REFERENCE constraint "FK_tblLsAgentRelayConfig_tsysASServers". The conflict occurred in database "lansweeperdb", table "dbo.tblLsAgentRelayConfig", column 'Servername'.
The statement has been terminated.
Violation of PRIMARY KEY constraint 'PK_tsysASServers'. Cannot insert duplicate key in object 'dbo.tsysASServers'. The duplicate key value is (***NEW SERVER NAME***).
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now