+ Start a Discussion
EdCodeEdCode 

SOQL query or Report (Public Groups, Permission Sets, Teams, Territorries per each User)

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.
Best Answer chosen by EdCode
EdCodeEdCode
I have found this information which I am analysing, it may have a solution or part of it: http://usersinpublicgroup.blogspot.com/

All Answers

EdCodeEdCode
I have found this information which I am analysing, it may have a solution or part of it: http://usersinpublicgroup.blogspot.com/
This was selected as the best answer
wyom jayadanwyom jayadan

Download this beautiful calligraphy font called Chasing Embers Font style from here to make a good or attractive logo, invitation, stationery, wedding plans, online networking posts, ads, product packaging, product structure, and more with incredible typography by use this Month Glade font.
http://chasing-embers-font.jigsy.com/#builder