Trying to find out which tables contains details of ServiceNow users, their roles and assigned lic

[SowjiC]

Hi Team

I am new to ServiceNow. I am a Data Analyst and a reports developer. I have a requirement to produce a report and analyze the count of users, the roles and the type of lic they are assigned to. Can someone help me with where can I find the tables which contain this information please ?

[Tony Chatfield1]

Hi, users are located in table: sys_user
If you have CSM, you might also find roled (client) users in: customer_contact
Note if you do not have CSM the table probably will not exist.

User to Role relationships: sys_user_has_role

User to Group relationships: sys_user_grmember

Groups: sys_user_group

Roles: sys_user_role

ServiceNow also provide Subscription Management, which may be helpful, depending on how your instance has been configured\managed.

Subscription Management (servicenow.com)

[Harish KM]

Hi you can run a report on sys_user_has_role table alternatively take a look of OOB Subscription management application for license count.

[SowjiC]

Hi Harish, I found Users and their Roles details on Sys_user_has_role.

What I am looking for is  a table name which shows complete list of Users vs License details.