Advanced Search
Search Results
5 total results found
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 in Developer Console): SELECT Id, Name, EntityDefinition.MasterLabel FROM Layout WHERE ID NOT IN (SELECT LayoutId FROM ProfileLayout) Permission Sets wi...
Who has what permission?
A few housekeeping items The permission set object is an amalgamation of Permission Sets and Profiles. You can determine if a record is a profile by using the "IsOwnedByProfile" field. You can also query on the permission set permissions to limit results. ...
Content Documents
Housekeeping ERD for Content Documents When a Content Document is created, a content version record is created. Each update gets stored as a version and the content document LatestPublishedVersionId is updated. When linking a content document with a record,...
Approval Processes
Housekeeping Here is the ERD for the Approval Process Objects. Typically reporting will be done from the Process Instance Step => Process Instance => Process Definition or from the Process Instance => Process Definition. Process Instance Steps Process Step...
License Management
Who has what Salesforce License? SELECT Id, Name, UserName, Profile.Name, Profile.UserLicense.MasterLabel FROM User WHERE IsActive = true How Many Licenses do I have? SELECT MasterLabel,MonthlyLoginsEntitlement,MonthlyLoginsUsed,Name,Status,TotalLicenses,...