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!
Date, [Nodes], [Volumes], [Interfaces], [Components], [Transactions]
WHEN 'SAM Components' THEN 'Components'
END AS 'ElementType'
WHERE ElementType <> 'SCM Nodes'
) AS et
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.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community.
More than 150,000 members are here to solve problems, share technology and best practices, and directly
contribute to our product development process.
Learn more today by joining now.