How to get itil user list

Chandra31
Tera Contributor

Is there a way to get report on how many ITIL users were removed from ServiceNow Vs how many were added over a 3-month period?

 

@Ankur Bawiskar 

 

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

@Chandra31 

you can check how many were added in last 3 months using sys_user_has_role table

AnkurBawiskar_0-1666192488848.png

 

It would be difficult to determine how many users were there whose itil license was removed in last 3 months

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

1 REPLY 1

Ankur Bawiskar
Tera Patron
Tera Patron

@Chandra31 

you can check how many were added in last 3 months using sys_user_has_role table

AnkurBawiskar_0-1666192488848.png

 

It would be difficult to determine how many users were there whose itil license was removed in last 3 months

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader