Database view to identify users who is actively utilizing ITIL license

[Vikram3]

I need to do database join on syslog_transaction, sys_user & sys_user_has_role tables to find out the users who are actively using ITIL licenses in servicenow.

This is my join and I'm strugging to do it. Can anyone help here.

[AndersBGS]

Hi @Vikram3 ,

why not just utilize the sys_user_has_lincense table and look at last login from a user perspective. By doing this, you will get the users not logging into ServiceNow which are consuming license.

[Vikram3]

Hi @AndersBGS Unfortunately the table is empty.