Reporting on Journal fields

[NigelUnderwood]

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

[tony_fugere]

If you joined sys_journal_field correctly as I believe you have described here, look for the Value field on the Field Chooser.

[Charlie Ward]

Can I get some more information how to "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."

I am needing to do the same as the OP but I don't know how to go about doing this. Do I create a new Table? How do I join that table to task? Any help would be greatly appreciated.

Charlie Ward

[will_smith]

Hi Charlie, check out this wiki article for information on database views: Database Views - ServiceNow Wiki .

[Heather White]

Do you have any suggestions about the where clause?  I'm not sure which field to join.