Report on number of tasks a user updated today

[Travers M]

I have a request that I'm not so sure I can accommodate given the circumstances.   I know in SN that the updated by field only retains the last update but I have a request to get a report that shows how many tasks a user updated in a day.     I was thinking it may need done by user and if their name appeared in the activity log in any given day but that's probably a pipe dream.     Has anyone made a report like this or have any idea how to achieve it?

[Rakesh Mamidi]

On sysevent table you will get data of it.However the reporting options are limited.

Query is Created ON today and name CONTAINS .updated

[Travers M]

Thank you for the reply, but do I need to change a setting somewhere to report on the sysevent table?   It doesn't show up in my list, should that be one that's report enabled out of box?

[DaSmith9]

This isn't a solution to your exact need, but at my previous company (also on the ServiceNow platform) we had a similar need, though we chose to focus on counting work notes or comments instead of case note updates. The theory being if you were working on an incident or problem, you should have been documenting your work and updating the notes/comments. The solution was to create a database view joining the sys_journal_field and the task tables on the task.sys_id and the sys_journal_field.element_id fields, then you could report on the work notes or comments added AND easily include the task record/number that was associated as well as count the sys_journal entries. You avoided an inaccurate count of the opened/created by or updated by fields, who only showed who opened it or was last to update.

While not a definitive metric, more of an indicator or barometer, it could be used for a daily productivity measurement to assess which team members were working and documenting tickets and which ones were not but should have been. Particularly helpful for insight into Service Desk productivity where +90% of the role was working tickets.

I couldn't find the original post that led us to that solution, but found a similar one that helps describe the solution.

How to query work notes

[kuavan]

Hi,

is it also possible to make a distinct to count in how many tasks a user has collaborated? Unfortunatly this view show duplicate entry if user add more then one work note/comment into a single task. Is there a solution?

Thanks