How to run a report or query on an agent to see which tickets they left a comment or work note....

[Noah_G]

Hi I'm trying to see which of my staff is contributing to tickets in Service Now.

While I can write reports on how many tickets were created or resolved.

I really need this:

How to run a report or query on a specific agent to list which tickets they left a comment or work note in, during a period time , like during the week, month, quarter, or year.

I would like to request no coding be involved if possible or use of APIs.

Thank you.

I apologize if someone already asked this question.

[Noah_G]

If the only way is to code it, can someone please assist?

[Gangadhar Ravi]

Hi @Noah_G,

there is no easy way for this. But you can try querying sys_journal_field table. and Group by based on created_by. it will be like below.

Please mark my answer correct and helpful if this works for you.