mbraga-sfdc/calculate_storage.sql

Last active December 14, 2020 17:37

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/mbraga-sfdc/fb081b808c0df0782e8e61519f3d9480.js"></script>
Save mbraga-sfdc/fb081b808c0df0782e8e61519f3d9480 to your computer and use it in GitHub Desktop.

Download ZIP

Calculate required storage: When evaluating the required database size, measure the historical growth of your existing Salesforce data. This can be done using a SOQL query similar to the one here.

Raw

calculate_storage.sql

	SELECT calendar_month(CreatedDate), COUNT(Id)
	FROM Account
	WHERE CreatedDate = LAST_FISCAL_YEAR
	GROUP BY calendar_month(CreatedDate)
	ORDER BY COUNT(Id) DESC

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment