Link Tracking not working after change new sharepoint server with new hostname (47823)
Link Tracking not working after change new sharepoint server with new hostname
Link Tracking not working after change new sharepoint server with new hostname or rename existing sharepoint hostname
NMSP had written the sharepoint hostname in the link tracking database, so when the existing sharepoint migrate or change the hostname. The link tracking is not working.
In order to get the link tracking working, it needs to change the old server name to the new one in the QuestLinkTracking database.
This is possible using Microsoft SQL Server Management Studio.
WARNING: Before attempting this please make sure to BACKUP or make a COPY of the QuestLinkTracking database!!!!!!!
Issuing the following command in SQL server should fix the server name issue:
UPDATE NotesObjects SET SharePointURL = http://THENEWSERVERNAME + SUBSTRING(SharePointURL, 21, 3900)
Note that the starting point of 20 in the SUBSTRING command is from counting up the number of places the old server name took up, so http://oldsharepoint would is 21.
© 2020 Quest Software Inc. ALL RIGHTS RESERVED.