PA dashboard for itil user activity?

[Rick__M]

Can anyone offer some guidance on how to create a report or dashboard showing daily activity for each user with an itil role broken down by hour? Activity would include inserting/updating/viewing task records. The goal is a report highlighting busiest hours of the day and which user(s) have been most active.

I've looked at the Usage Overview report but that shows activity by application. Also tried generating a report from sysevent but that shows username as opposed to a friendly first/last name and I was not able to break down by hour.

[Adam Stout]

In the script you are using for the bucket, try this: (assuming you are using sys_created_on):

current.sys_created_on.getGlideObject().getTime().getHourOfDayLocalTime();

Be sure to set the timezone on your job.