"Work notes" and "Additional comments" on report

[sr_surendra]

Dear all,

I wanted to extract report where I can add "Worknotes" and "Additional Comments" along with other fields in "incident" or "Requested Item"

Can someone please let me know which table I have to choose or join which all tables etc.

Regards,

Surendra

[Service_RNow]

HI,

Here is an example:

You can not get additional comments in a direct report for incident table.

You have to create a new Database View for that and you have to join sys_journal_field and incident table.

sys_journal_field is the table where all the journal entries are kept. You can query that table using the field name (for you it is Commnets) and the sys_id of that incident. you will get all the comments added in the incident using that query (or report) of the sys_journal_field table.

Please Refer:

https://docs.servicenow.com/bundle/jakarta-performance-analytics-and-reporting/page/use/reporting/co...

Reporting on Journal fields

Thanks