Report to count number of comments and worknotes per user in Customer Service>Case

Faye Jeska
Kilo Explorer

I would like to create a report for counting the number of comments and work notes a user has created in Cases at a certain period of time. Is this possible? If not, is there a workaround where I can export all the list of work notes and comments in Cases.

2 REPLIES 2

parag-mone
ServiceNow Employee
ServiceNow Employee

Hi,

Work Notes and Comments are captured in the SYS_AUDIT table. You can develop a report based on this table.

Query: tablenameSTARTSWITHsn_customerservice_case^fieldname=work_notes^ORfieldname=comments

find_real_file.png

Thanks,

Parag Mone

Rachamalla Srav
ServiceNow Employee
ServiceNow Employee

Hello, 
Work Notes and Additional Comments are stored in a table named "sys_journal_field".
You can query this table and filter results based on "Name" and "Element" columns to achieve your usecase.