Did you use the Permission Set API name in the query ? Anyway, try the following : SELECT AssigneeId,PermissionSet.Name FROM PermissionSetAssignment Thus you will receive a result containing all the permission set names.
Hi All , as per Dmitry Ofitserov comment it will give 0 result because you did nota dd field to SOQL, here is the correct one select Assignee.Name, PermissionSet.Name from PermissionSetAssignment where PermissionSet.Name='TEST_PER_SEt_Name' ,. mark as correct if you find this suitable
Hi All, along with the user name, I wanted the country from Users profile. So I slightly modified the query to include Assignee Id and did a vlookup. Thanks for the suggestion.
Please try to use the following SOQL:
SELECT AssigneeId FROM PermissionSetAssignment WHERE PermissionSet.Name = 'your_permission_set_name'
Hope it helps.
All Answers
Please try to use the following SOQL:
SELECT AssigneeId FROM PermissionSetAssignment WHERE PermissionSet.Name = 'your_permission_set_name'
Hope it helps.
Make sure you are passing the API name of permission set in query.
Anyway, try the following : SELECT AssigneeId,PermissionSet.Name FROM PermissionSetAssignment
Thus you will receive a result containing all the permission set names.
Hi All,
How to get map<userd, list<Permissionset Assigned to this user>> ?
select Assignee.Name, PermissionSet.Name
from PermissionSetAssignment
where PermissionSet.Name='TEST_PER_SEt_Name' ,.
mark as correct if you find this suitable