How to get a simple report off the sys_journal_field table

David Christian
Kilo Guru

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. 

6 REPLIES 6

johnfeist
Mega Sage
Mega Sage

Hi David,

There is one major underlying problems.  sys_journal_field is not reportable, at least as far as I can tell from the report designer (it won't show up in the list of tables).  Since you are talking about service management, I might suggest that you create a new table to capture what you need.  I'm going to assume that the tables where you are looking to base your measures all extend from task.

Add an after update rule on task to add a row to the new table and include whatever relevant data you need.  You can tell what kind of task is involved from the number field among others.  Since there is no need for anyone to interact with the new table online, it should be pretty straight forward to build and then build your report(s).

Hope that helps.

:{)

Helpful and Correct tags are appreciated and help others to find information faster

Hope that helps.

:{)

Helpful and Correct tags are appreciated and help others to find information faster

Ankur Bawiskar
Tera Patron
Tera Patron

Hi David,

sys_journal_field is not available for reporting because it is system table and is huge table considering the fact that it stores the journal entries for journal fields of the tables

So currently you cannot

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur

 

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Hi,

Is it still the same ?

 

Thanks!

Hi,

there is system property which you can update and it should allow

refer this

Reporting on system tables

Regards
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader