I need to download all of the files that have been attached to private tasks, with a reference to which PTSK# they were attached to. How do I do this?

[beaublackford]

We had previously used visual task boards for a large project, and the private tasks are were we can see all of the documents that had been attached to each card. I'm needing to move historical data into a new system, but need a way to download all of the documents that were attached to those tasks. I have an output of the task #'s and details, so it would be perfect if the files could reference which PTSK# they were originally attached to.

[Tony Chatfield1]

Hi, I am not sure if this will be straight forward (or as straight forward as it should be)
Attachments are recorded in sys_attachment table and the 'attachment' records contain references to the Table name (table_name) and Table sys_id (table_sys_id) of the record that the file was 'attached' to

OOB PDI example
The attachment
/sys_attachment_list.do?sysparm_query=sys_idSTARTSWITH40f93e16c0a801130137c1f1bf538539&sysparm_view=

The related record
/nav_to.do?uri=incident.do?sys_id=9d385017c611228701d22104cc95c371

So you should be able to find all the relevant attachments simply by filtering sys_attachment on table_name = yourSourceTable.

But extraction of these files will depend on your new platform and it's integration abilities (if any).
If you are unable to import the attachments directly into your new platform via REST, you should be able to write a script using ServiceNow API's that will export the attachments from ServiceNow to a folder location (and name them as you go), but I haven't done this before so do not have an example script and couldn't see anything obvious.

Hopefully someone else can assist, if not I am sure the forum will be able to help you work through the requirement.

[beaublackford]

Thanks for the detailed response!  Unfortunately I'm in over my head here, as I am an express customer that was forced into Enterprise ServiceNow and have no development team to support it.  I am not a developer, nor do I know how to do any of the steps mentioned above.  It's unfortunate that an application this large and expensive is missing common features that are found in other modern systems, like the ability to easily explore and access uploaded files.  I'm wondering if there's a way to get these files from within the system, without scripting or API's?  Thanks again for your help.