When looking at the data in the CSV, there are two entries for every interface with different timestamps. This seems like it would impact calculations...
The only unique identifier if the "policy UUID" but I don't know how to find those uuids.
Cybersecurity
DevOps Cloud (ADM)
IT Operations Cloud
If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it!  Learn more
When looking at the data in the CSV, there are two entries for every interface with different timestamps. This seems like it would impact calculations...
The only unique identifier if the "policy UUID" but I don't know how to find those uuids.
I think its the monitoring policy where you select the performance collection metrics etc. UUID is not exposed if I recall but you can find it in the DB.
Thanks... I am not good enough to script a search loop of all tables. do you happen to know in which Table it exists..?
Unfortunately I don't have a instance with PerfSpi enabled. Should be a table with policy in the table name.
I will check if I have some notes on that.
You were right.... they were in "poling_policy"
One is called "Interface LAN Performance Monitoring (Etherlike SNMP v2 &v3)
The other is "Interface Performance Monitoring (SNMP v2 &v3)
both are collecting performance metrics. They don't seem to collect the same data twice but they still create two entries every polling cycle. Now I just need to figure out which radio button in the GUI will turn one off.
Thanks again
Perfect.
Thanks for sharing the table names. Will be handy for future answer seekers.
For details on Interface performance metrics.. following may help
Interface Settings for Monitoring - Network Node Manager i (microfocus.com)