You need to sign in to do that
Don't have an account?
Ikram Momin 16
I have a question regarding SOQL :
I am using below query to fetch PermissionSet assigned to users in org :
SELECT Id, PermissionSetId, AssigneeId FROM PermissionSetAssignment
And to fetch PermissionSetLicense assigned to users in org :
SELECT Id, AssigneeId, PermissionSetLicenseId FROM PermissionSetLicenseAssign
Is there any query / innerjoin or other way to fetch both((PermissionSet & PermissionSetLicense)) in single query?
OR Can I fetch both(PermissionSet & PermissionSetLicense) while fetching users ?
my users query is :
SELECT Id, Username, LastName, FirstName FROM User
Select Id,(SELECT Id, PermissionSetId, AssigneeId FROM PermissionSetAssignments),(SELECT Id, AssigneeId, PermissionSetLicenseId FROM PermissionSetLicenseAssignments) from User
All Answers
Select Id,(SELECT Id, PermissionSetId, AssigneeId FROM PermissionSetAssignments),(SELECT Id, AssigneeId, PermissionSetLicenseId FROM PermissionSetLicenseAssignments) from User
1.can you please help me to modify above query such way to fetch Groups and check if user isFrozen ?
currently i am using,
Group Query :SELECT UserOrGroupId,Group.Name FROM GroupMember where Group.Type='Regular' order by UserOrGroupId
isFrozen Query : SELECT UserId, IsFrozen FROM UserLogin WHERE IsFrozen = true order by UserLogin.UserId
2. Also What would be the query if i had to fetch PermissionSetId and PermissionSetLicenseId only and not users?
Select Id,(SELECT Id, PermissionSetId, AssigneeId FROM PermissionSetAssignments),(SELECT Id, AssigneeId, PermissionSetLicenseId FROM PermissionSetLicenseAssignments),(Select Id from GroupMemberships) from User
2. Use these queries to get details of PermissionSet and PermissionSetLicense directly:
Select Id from PermissionSet
Select Id from PermissionSetLicense
1. i tried as
Select Id,(SELECT Id, PermissionSetId, AssigneeId FROM PermissionSetAssignments),(SELECT Id, AssigneeId, PermissionSetLicenseId FROM PermissionSetLicenseAssignments),(Select Id from GroupMember) from User
but not working.
2. specifically i was asking to fetch PermissionSet and PermissionSetLicenses in single query ?