Cacti (home)ForumsRepositoryDocumentation
Cacti: offical forums and support  

 FAQFAQ   SearchSearch   MemberlistMemberlist    RegisterRegister   ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in    


Reportit handling of NAN

 
Post new topic   Reply to topic    Cacti Forum Index -> Plugin General
Author Message
GlueGuy
Cacti User


Joined: 04 Nov 2005
Posts: 68
Location: Ca US
PostPosted: Fri Apr 18, 2008 2:08 am    Post subject: Reportit handling of NAN Reply with quote
I think this might be termed a philosophical issue, but it appears that Reportit treats NAN data as non-existent.

This may be technically correct, but it throws off calculations to find the aggregate data passed for a period of time (day, week, etc.).

As an example, we have a customer that turns off their equipment when they're not using it. As a result, SNMP queries to their interface yield NAN data when it's off, which is most of the time.

When I run the report, all the NANs get thrown out, and the only data points are when the interface is on, and moving data.

I plug the averages into a spreadsheet, and calculate the daily aggregate data by that customer, but that is way off, as all the zero data points are missing.

Perhaps there could be an option for how NANs are handled: throw away, or as zero?
Back to top
GlueGuy
Cacti User


Joined: 04 Nov 2005
Posts: 68
Location: Ca US
PostPosted: Fri Apr 18, 2008 3:33 pm    Post subject: Reply with quote
Well, if you leave me to it long enough, I sometimes figure it out.

As I (eventually) got to poking through some of the Reportit threads, I found that I could use the formula:
Quote:
(f_num*step/1000000000*f_avg)

which gives me GB, and setting the window to monthly, I get what I "think" I wanted in the first place.

However, there is an anomaly. I have a couple of devices acting as a router to other customers. I would expect the sum of the subs to be less than the total going through the router, but in a couple of cases the sum of the subs exceeds the total through the router (some of the others don't do this).

Example:

Code:

Router        16.83 GB/month
Sub1          16.07 GB/month
Sub2           7.62 GB/month
Sub3           5.18 GB/month
----------------------------
Sub total     28.87 GB/month
============================
Net          -12.04 GB/month


I would think that it should be impossible for the total of the subs to exceed the throughput of the router.

Is there something I may be misunderstanding (hah! now there's an understatement!)?
Back to top
Display posts from previous:   
Post new topic   Reply to topic    Cacti Forum Index -> Plugin General All times are GMT - 5 Hours
Page 1 of 1

 



Powered by phpBB © 2001, 2005 phpBB Group