Recently a web site resource in the company got moved to a different location, meaning a part of the URL changed.
Unfortunately I have a vast amount of Web Browser sessions linking to various documents located on the resource that got moved.
So now I'm looking for a convenient way to do a simple Search&Replace operation on all Web Browser sessions which would replace the matching part of the old URL ( "/406/" ) with the updated one ( "/723/" ).
Is there any way to do this in RDM? If not I'd also be thankful about some advice on the SQL statement which might do that job.
Kind regards
Holger
-------------------
Remote Desktop Manager Enterprise Edition 12.6.6.0 64 Bit - Data Source: SQL Server
Running on Windows Server 2012R2 VMs with Remote Desktop Services feature, serving as common work environment for 30 Windows Server administrators
Hello,
Does the beginning and the end part of the website is the same for all the entries?
Could you provide us an example please.
Best regards,
Jeff Dagenais
Hi,
the beginning is the same but that won't be sufficient. As you can see the /406/ can appear multiple times in the same URL and I guess I would also have to make a second S&R for the encoded string %2F406%2F
https://teamsites.intranet.company.com/sites/406/SO/_layouts/OneNote.aspx?id=%2Fsites%2F406%2FSO%2FDocument%20Library%2FSMW-SO%2FDocuments%2F300%20Process%20Instructions%2FSMW-SO%20Knowledge%20Base&wd=target%28Regional%20Topics%20EMEA%2FServer%20Engineer%20of%20the%20week%2FExternal%20Employees.one%7CA6E49B46-D9C6-4C30-BEC5-B2415001D1FD%2FContact%20list%20of%20External%20SO%20Employees%7C4F2819C8-4E09-4C5E-946D-45F0C8A89CAA%2F%29
https://teamsites.intranet.company.com/sites/406/SO/_layouts/15/WopiFrame.aspx?sourcedoc=/sites/406/SO/Document%20Library/SMW-SO/Documents/030%20Organisation/Function%20Groups%20all%20Regions.xlsx&action=default&DefaultItemOpen=1
https://teamsites.intranet.company.com/sites/406/SO/_layouts/15/start.aspx#/Lists/Team/Team%20Server%20Operations.aspx
https://teamsites.intranet.company.com/sites/406/SO/Lists/Server%20Asset%20Data/AllItems.aspx
-------------------
Remote Desktop Manager Enterprise Edition 12.6.6.0 64 Bit - Data Source: SQL Server
Running on Windows Server 2012R2 VMs with Remote Desktop Services feature, serving as common work environment for 30 Windows Server administrators
Hello,
Thank you for the explanation.
This would be possible using a little PowerShell script. I suggest you to test it on 1 or 2 sessions to begin and the rest after just to be sure that the script is working properly. Select your web browser session and click on Edit -> Batch Edit -> Batch Actions -> Custom PowerShell Command and paste the following script.$connection.WebBrowserURL = $connection.WebBrowserURL.Replace("/406/", "/723/");$RDM.Save();Just replace the /406/ and /723/ with %2F406%2F and %2F723%2F to do a second search and replace.
Best regards,
Érica Poirier
Thanks Erica, worked like a charm and is a big time saver for similar tasks :)
-------------------
Remote Desktop Manager Enterprise Edition 12.6.6.0 64 Bit - Data Source: SQL Server
Running on Windows Server 2012R2 VMs with Remote Desktop Services feature, serving as common work environment for 30 Windows Server administrators