sholloway

--------------------------------------------------------------------
-- Queries related to distribution of metadata.
-- Find the number of users per profile.
SELECT count(id), Profile.name
FROM User
WHERE User.IsActive = true
GROUP BY Profile.name

-- Find the distribution of Apex classes per namespace.
select count(id), NameSpacePrefix