+ Start a Discussion

Query to get all Role which don't have any users assocated with

Hi,

I need to get all Role Name which don't have any users assosciated with it.

SOQL like this:

Select u.Name, (Select Id From Users) from UserRole u where Id !=null

This is not working. Can any one tell me correct soql for this.

Thanks

Best Answer chosen by Admin (Salesforce Developers)

Superfell
select id, name from UserRole where id not in (select UserRoleId from user)
Message Edited by SimonF on 11-05-2009 01:18 PM

Superfell
select id, name from UserRole where id not in (select UserRoleId from user)
Message Edited by SimonF on 11-05-2009 01:18 PM

This was selected as the best answer

Vipin Pulinholy
Thank You. That worked.

Need an account? Sign Up

Have an account? Sign In