The Now Platform® Washington DC release is live. Watch now!
10-26-2018 08:20 AM
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.
10-26-2018 08:32 AM
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
06-03-2019 02:35 PM
Please refer this KB for more information for your requirement.
https://hi.service-now.com/kb_view.do?sysparm_article=KB0749943
07-19-2019 07:30 AM
In theory both solutions would work, but decided to go the route suggested by Dipu.
Thank you