Good luck with that one. I am not sure if HP offers to migrate attachments along with your item data from Service Desk to Service Manager.
If I had to do it from scratch, I would probably build a script to extract file name and location from the sd database and copy the file with its original file name and to a new target location based on entity/item id.
Oh, and if you're thinking about the filename in the FTP server, that's a whole other story and the filename and folder structure must be deciphered using the docu that explains the attachment structure in SD4.5.
Does the query that The Pike has posted, return this?
BTW, does anyone have the DB diagram from Service Desk? I've had to build some queries to gather some data to export, and trying to guess what the tables/fields could have is a perfect nightmare as all of you should know...
Jaime, That's not what my query returns. Mine returns the Service Call ID and the file name.
The path to the file is not stored in the database. The path is built with the entity oid and the attachment oid. If you are using SP16 or higher, the path is built out of converting the entity oid and the attachment oid to hexadecimal equivalents.
To get the attachment oid and the entity oid in the query, simply add the ahs_oid and ent_oid columns.
The ER diagrams have been posted previously but I don't have the link nor the files handy. Quick search in the forums with the proper keywords will take you to them.
We have the same problem with the attachments and We have stop with these. Could you explain us how to do the attach export from Service Desk to Service Manager. (We work with Service Desk 4.5 SP18 and Service Manager 7.11)