report on content of work notes/additional comments/activities

[johnrob18]

How do I produce a report that shows the content of the fields not the last updated date?

For example in Incidents - need to list all the updates in a report

[Rajesh Mushke · Accepted solution]

Hey  Johnrob,

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:

Reporting on Journal fields

http://wiki.servicenow.com/index.php?title=Database_Views

Let me know if you need more help.

Thanks,

Rajashekhar Mushke

Community Leader - 18

[Rajesh Mushke]

Hey Johnrob,

Any Update on this thread?

Please close this thread, then only this will be helpful for other community users.

Let me know if you need more help.

Thanks,

Rajashekhar Mushke

Community Leader - 18