Identify users without any roles

[Leon Els]

Greetings all,

Please provide guidance on the best way for me to locate all employees without any roles assigned:

I tried the below, but nothing came up:

My goal is to locate all employees without Roles:  
cmdb_read
service_viewer

Cheers 🙂 

[Ramkumar Thanga · Accepted solution]

Hi Leon,

You can use the below background script to retrieve all the user's name with no roles.

var user = new GlideRecord('sys_user');

user.query();

while(user.next())

{

var userRole = new GlideRecord('sys_user_has_role');

userRole.addQuery('user',user.sys_id);

userRole.query();

if(!userRole.next())

{

gs.print('User Name : ' + user.name);

}

}

Thanks!!

Ram.

Please mark this as Helpful/Correct 

[DrewW · Accepted solution]

If you are doing a report or going to the user table then just do

[Ramkumar Thanga · Accepted solution]

Hi Leon,

You can use the below background script to retrieve all the user's name with no roles.

var user = new GlideRecord('sys_user');

user.query();

while(user.next())

{

var userRole = new GlideRecord('sys_user_has_role');

userRole.addQuery('user',user.sys_id);

userRole.query();

if(!userRole.next())

{

gs.print('User Name : ' + user.name);

}

}

Thanks!!

Ram.

Please mark this as Helpful/Correct 

[DrewW · Accepted solution]

If you are doing a report or going to the user table then just do

[Leon Els]

Thank you SO much for your response!

[Karan Chhabra6]

Hi @Leon Els ,

To get the list of users with no roles, use this filter condition: 
SysID   is not   javascript: getRoledUsers();

If my answer has helped with your question, please mark it as helpful and accepted solution.

Thanks!