Maximo Server upgrade - Attachments how do you update old attachments for the new servers - error when trying to view the old attachments 

Configuring the doclinks, via instructions on new servers. New attachments are viewable 

Copied the folder DOCLINKS to the new server from the old server 

updated the the manage folders for the new server 

The manage library has the old server name \\maxmo00p\DOCLINKS\ATTACHMENTS\20230426_075455.jpg

tried updating a attachment via the library to the new server name  \\maxmo0Xp\DOCLINKS\ATTACHMENTS\20230426_075455.jpg

How do you bulk update the attachments?

Not Found

The requested URL /ATTACHMENTS\20230426_075455.jpg was not found on this server.

SQL update for this is the best approach. It's important that from a case perspective that everything matches identically. IE the system properties (mxe.doclink.doctypes.defpath, mxe.doclink.doctypes.topLevelPaths, etc.), DOCTYPES (Manage Folders), and DOCINFO (the individual attachments) need to reference everything the exact same way. IE \\maximo0xp\DOCLINKS will be handled differently than \\maximo0xp\doclinks and will lead to issues even if you are on platforms that are not case sensitive. 

I used to have a SQL update statement that went through DOCINFO to update all the attachments dynamically but a really simple version that would likely do what you need would be this:

update docinfo set urlname=replace(urlname,'\\maxmo00p\DOCLINKS\','\\maxmo0Xp\DOCLINKS\') where urltype='FILE' and urlname like '\\maxmo00p\DOCLINKS\%';

Steve -  Thank you for the advise and expertise.  It worked perfectly.   Enjoy the weekend.