Useful Queries
A book of queries for things that you want to know in SFDC.
Who has what permission?
A few housekeeping items The permission set object is an amalgamation of Permission Sets and Pro...
License Management
Who has what Salesforce License? SELECT Id, Name, UserName, Profile.Name, Profile.UserLicense.Ma...
Approval Processes
Housekeeping Here is the ERD for the Approval Process Objects. Typically reporting will be done...
Content Documents
Housekeeping ERD for Content Documents When a Content Document is created, a content version re...
Querying Flows and Mass Deleting Old Versions
A Warning in Advance Via the tooling api, we're going to delete some historic flow versions, thi...
When you don't follow best practices or just need to do some cleaning
Queries to help you find what to yeet Layouts without page layout assignments (using Tooling API...