Built something you're proud of? Tell the story. A quick G2 review of App Engine or Build Agent helps other developers see what's possible on ServiceNow. Share your experience.

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

@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  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

1 REPLY 1

Ankur Bawiskar
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  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader