Sign Up ›
  • aslam khan 27
  • NEWBIE
  • 0 Points
  • Member since 2022
  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies
2 replies

I want to query all profiles, permission set with users and also want to count each profile how many users what permission set they assigned . Can anyone help me

SELECT  PermissionSet.Profile.Name , PermissionSet.Name ,AssigneeId , Assignee.Name FROM PermissionSetAssignment GROUP BY  PermissionSet.Profile.Name ORDER BY PermissionSet.Profile.Name ASC