You need to sign in to do that
Don't have an account?
Baylor Peak
query only active system admins in a specific profile
Hello all,
I am able to query all the active users in a specific profile:
select user.id, user.FirstName, user.LastName, user.profile.name, user.Username, user.IsActive FROM user, user.profile where profile.name = 'xxxxx' AND IsActive=True
That just returns the active users for the profile, but I am trying to query only the active system admins in a specific profie.
What am I doing wrong please?:)
This the correct query make sure you put the name of the profile which system admin is using in your org under "profile.name"
select user.id, user.FirstName, user.LastName, user.profile.name, user.Username, user.IsActive FROM user, user.profile where profile.name = 'System Administrator' AND IsActive=True
Thank you for your quick response:) Yes I did that earlier but here is where it gets tricky...
That returns all the Active Users from the 'Profile Name' but this is not what I am looking for:(
What I need is a list of the Active Syetm Admins that have access to the 'Profile Name' that I can export via data loader (hence why I need the query not not APEX).
It's been a brain bender for me and not sure this is possible but please let me know if it is:)
Sorry, I did not get what result are you expecting.
Actually, i hjad it right the first time, but it only works in Query Editor.
Here is my Query:select user.id, user.Email,user.FirstName,user.LastName,user.profile.name,user.Username,user.IsActive FROM user , user.profile WHERE profile.name = 'U.S. Soccer Partner State Associations' AND iSActive=True
I need to Query that for my Export in Data loader but it keeps retyurning 0 successes whereas in Dev Console Query ediitor it workls fine.
How can I extract this same query via Data Loader please?