How to get a simple report off the sys_journal_field table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-28-2019 07:35 AM
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.
- Labels:
-
Incident Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-28-2019 08:56 AM
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
:{)
Helpful and Correct tags are appreciated and help others to find information faster
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-28-2019 09:06 AM
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
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-15-2020 04:20 AM
Hi,
Is it still the same ?
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-15-2020 04:29 AM
Hi,
there is system property which you can update and it should allow
refer this
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader