Mostly saving this here so I know it's somewhere out there, but it could prove to be a useful resource for you as well. The following query will return element counts as they were each day since the inception of your SolarWinds database. For me, that goes all the way back to 2015!
SELECT
Date, [Nodes], [Volumes], [Interfaces], [Components], [Transactions]
FROM
(
SELECT
Date
,CASE ElementType
WHEN 'SAM Components' THEN 'Components'
ELSE ElementType
END AS 'ElementType'
,Count
FROM
ElementUsage_Daily
WHERE ElementType <> 'SCM Nodes'
) AS et
PIVOT
(
MAX(Count)
FOR ElementType IN([Nodes], [Volumes], [Interfaces], [Components], [Transactions])
) AS pvt
ORDER BY pvt.Date
You can just add in any other element types that exist in your database in both the main SELECT statement and the PIVOT section.
Enjoy!
Jack Vaughan, Jr.
