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

[Faye Jeska]

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.

[ParagM]

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

Thanks,

Parag Mone

[Rachamalla Srav]

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.