Good afternoon all,
How do I create a report that will show a count of total Network Node Elements per month over a two year period of time? I would like to use this to project when I might need another polling engine.
Thank you
The easiest and most upfront way would be to trend you elements count per month manually.
SELECT ServerName, Elements, Nodes, Interfaces, Volumes FROM Engines
Create a custom SQL report using the above script and then schedule it to run on the 1st of every month and manually compile the 24 months of data.
Otherwise, you could write entries to a SQL table every month and then report out of that table. But I am personally not a huge fan of adding permanent tables to a DB for something so simple.
There is not an easy way to create a historical report for the last 2 years as there is not a "Date Added" time stamp for elements. But you could create a custom property for this and use a SQL trigger to auto-populate the field when adding elements. Just spit-balling ideas here.
- ZackM
http://www.loop1systems.com
I agree with ZachM, there is not a great way of reporting on counts historically that is straight forward. His way would be to the best to begin tracking.
One thing that might work for you would be to report on the response times and traffic utilization. This will rely heavily on your data retention settings. Below is a query that will give you distinct node counts broken out by month and year. It utilizes the responsetime_daily table will look different based on your data retention settings. You can apply the same query on other tables for interfaces and so on.
select datepart(yyyy, datetime) as year, datepart(mm, datetime) as month, count(distinct nodeid) as node_countfrom responsetime_dailygroup by datepart(yyyy, datetime) as year, datepart(mm, datetime)order by datepart(yyyy, datetime) as year, datepart(mm, datetime)
Thanks to both of you. This will guide me in the right direction.
