Reporting on Journal fields

[NigelUnderwood]

Has anyone been able to run reports against the Journal fields in ServiceNow?

[tony_fugere]

It is possible. You have to run your report off of the sys_journal_field table and you'll probably want to build a database view to join that table to task to get data out that makes sense.

[Inactive_Use714]

Hi Tony,

I'm just trying to do exactly this, but have run into some trouble.

We have a table called u_time_recording which we've joined to the task table, which allows us to report on time stamps & effort put against related tasks.

What we're now trying to do is be able to report against the work notes journal field in the same report, so that when a work note has been added this report will show the task number, time stamp and related work note added at that time.

We've set up a view on the same database view used for the time stamp reporting looking at the sys_journal_field table with the following where clause:

jrnl_element_id = tsk_sys_id

The problem I have is that the when adding the work notes column to the report it shows blank whether a note was added at that time or not. I'm thinking that this is because of the nature of the field in that the work notes field itself (ie. the text box) is always empty as any comments are listed below in the journal.

Any ideas on how to report on the journalled comments in relation to the time stamp.

Thanks,
Joe

[tony_fugere]

Is your report going to the Task's Work Notes or the Journal table's "Value" field? The report will need to display the Value field from sys_journal_field.

[Inactive_Use714]

Thanks Tony, the report is going to the tasks work notes.
When the report is exported as a CSV file the work notes are displayed, just not in the online report.

How do I make it look at the journal table's "Value" field?