How to get users having only ITIL role but not admin role

[ajay konduru]

How do I get users who have only ITIL role but not any other role like admin role?

[Balaram4]

Hi Ajay,

For achieving this 

Please create a report on (sys_user)table.

And use the below filter conditions.

Active is true and 

Roles is Itil and 

Roles is not admin.

And generate a report.

So that you will get all itil users list not admins.

Please mark this as correct answer or helpful if this really works for you.

Ty,

Balaram.