Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

"Work notes" and "Additional comments" on report

sr_surendra
Giga Expert

‎04-05-2018 02:44 PM

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

Labels:
0 Helpfuls
  • 13,328 Views
10 REPLIES 10

Service_RNow
Mega Sage

‎02-10-2019 11:21 PM

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

0 Helpfuls