Comments and Work notes extraction

[joelmcm]

Hi,

I've been tasked with extracting some records from a legacy ServiceNow instance (excel export), the data the client wants to extract includes the comments and work notes fields. Ideally, I would like to use the singular "Comments and Work Notes" field that comes from the Task table to export everything as a single field, however as this is legacy instance, it doesn't seem to have this field.

Since both "Comments" and "Work notes" are of Journal Input type, their entries seem to be stored on the Journal Entries table (sys_journal_field), however I've noticed that quite a lot of the entries I can see on individual records are missing from this table.

My questions would be:
Is there somewhere else these are stored?
Is there an easy solution to extracting these particular fields as a singular value?

Thanks!

[JP - Kyndryl]

Hi Joel,

I would suggest you create a new Journal List type field (so recreating the OOTB one).

Then go into the list and add the Dependent field:

Insert "comments,work_notes" in this Dependent field  and Update the table record.

You now have your new field to report on.