douglascayers/Count.sql

Created September 12, 2017 01:24

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

Select an option

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

Download ZIP

Easy way to count attachments or notes by their parent object type. https://twitter.com/DouglasCAyers/status/885892375108866048

Raw

	SELECT
	parent.type,
	count(id),
	sum(bodyLength)
	FROM
	Attachment
	GROUP BY
	parent.type

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