Changing paths in the dbo.dlnk table isn't too difficult, but I came accross something that has me stumped.
Rather than a straight forward path such as \\servername\documents\ there are many that have a URL in the path such as http://servername/exponline/attachmentframe.jsp?filename=83089.pdf&fullpath=%5C%5Cservername%5Cimagetool%5Carchive%5Chce%5C78%5C83089.pdf&dk=h8Tjf4FcM7Km%2BpwH637w6w%3D%3D
Does anyone have a sql script that will filter out the url crud and leave a simple path.
You can see the path in there, it's \\servername\imagetool\archive\hce\78\5C83089.pdf
SET ATTACHMENT_PATHS.absolute_path = #temp.absolute_path
INNER JOIN #temp ON ATTACHMENT_PATHS.master_key = #temp.master_key
WHERE ATTACHMENT_PATHS.absolute_path LIKE '%/exponloine/%'