View or report on ITIL users login history

[RKerr]

Hello all, thanks in advance for any ideas.

I am searching for a way to view or report on users with an ITIL role and their login history. 

Goal is to determine if we are utilizing fulfiller license appropriately. I have used the sysevent table, but there does not appear to be a way to filter by users roles.

[poyntzj]

In this case I would look at creating a database view that links the relevant field (parm1) in the sysevent table with the field (user_name) in the sys_user table

sysevent is limited, so long term look at creating a metric.  you can then see how often someone logs in and how frequent

[Dipu Joy]

Please refer this KB for more information for your requirement.

https://hi.service-now.com/kb_view.do?sysparm_article=KB0749943

[RKerr]

In theory both solutions would work, but decided to go the route suggested by Dipu.

Thank you