How to get a simple report off the sys_journal_field table

[David Christian]

I wanted a daily report in the form of a line graph by hour of the day to that would show the count of journal entries per technician in my department.  However, it doesn't look like you can create such a report from this table.  Is there a way to do it?  

If not what is the alternative to be able to look at when the most work is being done.  I can't use the incident updated by field or timestamp because that is over written with every update so it only shows what it was at that point in time. 

[Komal22]

Hi,

The link you shared does not have  sys_journal table in it.

so does that mean we still cannot create reports on sys_journal table and we need to use a database view. 

Also one more question, If we provide access to the sys_journal table we can create reports? I assume it is not a best practice to provide access to sys_journal .

Thanks!

[Ankur Bawiskar]

Hi,

you will have to add that table in that system property value if not already present

Regards
Ankur