cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 9

Total Element Count Over Time

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.

Labels (3)
0 Replies