• wyom jayadan
  • NEWBIE
  • -1 Points
  • Member since 2020

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies
Hello Stars!

I need to know the followign information for each User in Salesforce Org.:
  1. what Public Groups are related to each User;
  2. what Permission Sets are related to each User;
  3. what Teams are related to each User;
  4. what Territorries are related to each User;
Beware: there are 4000+ Users so I cannot check this on a User-by-User basis; instead I am looking for an SOQL query to be executed with 'Salesforce Inspector', the 'Dev Console' or 'SF Workbench' or with standard Reports based on a custom Report type?).

The reason I need this information is to, eventually, more easily review all the Sharing Rules (identifying each sharing rule by Ctrl+F searching specific Public Groups) so as to ultimately understand what users are accessing records (because of sharing rules sharing with Public groups) that they should not (historically, security settings has deteriorated and access to data has become a party that I need to remediate).

Could you possibly help witht he above SOQL sentences?

Thank you very much.