How to pull report for the works notes that is updated by the fulfiller or any of my team member

raul14
Kilo Contributor

How to pull report for the works notes that is updated by the fulfiller or any of my team member . For example: If any of the fulfiller updates the request or incident, it should be displayed under the dashboard. Once it is answered by one of the team member the request or incident should disappear from the dashboard. 

 

Second thing, I need to now how many of my team member has followed up on the request or incident using the work notes or additional notes

Third thing, I need to know how can i create a report for the request approval when it is approved. I tried doing this, but unable to get the right result. The reason is all the request is assigned to my team but the product approval goes to product owner. How can i achieve this

3 REPLIES 3

Tony Chatfield1
Kilo Patron
Hi, you should create metric definitions so that you have metric instance records for future reporting. If you are trying to monitor tasks based on last update I would suggest you add another field to the task table which you populate via br based on the sys_updated_by field.l ( I use client, internal, NOC and third party). #3 requirement is not clear

Joshwa Antony S
Mega Guru

Hello,

You could use table "sys_journal_field", Here you can see the entries for all journal input fields (Eg:- comments and worknotes)

https://<yourinstance>.service-now.com/sys_journal_field_list.do?sysparm_query=name%3Dincident%5Eelement%3Dwork_notes&sysparm_view=

Regards,

JAS

raul14
Kilo Contributor

Third one, I have created a report using Sysapproval_approver table. but I am unable to add the catalog name for which i need to pull the approval report