[Reportit] SQL table reportit_results - how to read

[rogersacchelli]

Hi all

I'm trying to parse the info provided by reportit table reportit_results for a specific report that I've configured:

The "Uplink" Column below should show the traffic peak for an interface. The final report from reportit is fine but I can't find relation between its table (reportit_results_1) and the reported value (graph and GUI report).

SELECT:

select host.description,graph_local.id, reportit_results_1.traffic_in__1 as UPLINK from graph_local,host,reportit_results_1 where host.description like 'PUI_%' and host.id = graph_local.host_id and graph_local.id = reportit_results_1.id limit 10;

+------------------------------+-------+---------------+
| description | id | UPLINK |
+------------------------------+-------+---------------+
| PUI_A21_6_COMBO_VLAN_300-TEL | 22062 | 2143781.35504 |
| PUI_A02_5_COMBO_VLAN_138-ECI | 22131 | 416534624.832 |
| PUI_A24_5_COMBO_VLAN_225-TEL | 22215 | 45643574.5008 |
| PUI_A08_4_COMBO_VLAN_145-TEL | 21981 | 71114308.8144 |
| PUI_A09_4_COMBO_VLAN_149-TEL | 21707 | 0 |
| PUI_A09_0_MIX_VLAN_148-TEL | 21706 | 0 |
| PUI_A10_0_MIX_VLAN_152-TEL | 21708 | 0 |
| PUI_A09_SIP_VLAN_163-TEL | 22572 | 263483086.936 |
| PUI_A08_5_SIP_VLAN_162-TEL | 22571 | 179767288.888 |
| PUI_A17_6_SIP_VLAN_94-TEL | 22579 | 165222556.56 |
+------------------------------+-------+---------------+

GRAPH RESULT for RESULT 1:

| description | id | UPLINK |
+------------------------------+-------+---------------+
| PUI_A21_6_COMBO_VLAN_300-TEL | 22062 | 2143781.35504 |




As it's possible to note, seems to be no relation (at least for me), for the graph peak ~820M and the reported value on the table.

I really apreciatte if someone give me a hint.

Thanks in advance.

Roger

[browniebraun]

This is difficult to verify as long as the definition of the measurand is totally unknown.
ReportIt only stores the output of the calculation formula itself within a result table.
The final presentation depends on how you have setup the measurand.

Does the report itself match?

Regards
-Andi

[rogersacchelli]

This is difficult to verify as long as the definition of the measurand is totally unknown.
ReportIt only stores the output of the calculation formula itself within a result table.
The final presentation depends on how you have setup the measurand.

Does the report itself match?

Regards
-Andi

Hi,

Yes the report match.

The measurand is set as f_max*8, does it help?

I have collected the debug output either but I have not seen the any easy way to evaluate the calculation and output.

Thanks for the reply.

Roger