11-08-2011 10:37 AM
We are collecting lots of interesting data from the performance SPI. However, we would like to export that information so that we can visualize the data with a different tool. I only see two options:
1) extractData.ovpl - dumps all the data, which is too much to do every 5 minutes.
2) configureCsvExport.ovpl - automatically creates .csv files every hour, which is not granular enough.
Does anyone have a recommendation on how to get recent data every 5 minutes?
11-09-2011 04:15 AM
Not too difficult, you can schedule a report from the BI server to do that. Only caveat is that the sweep period from Perf to pick up new data from the NNMi polls at 5 minutes would be cutting it close.
Andy Kemp, CISSP
11-14-2011 06:24 AM
I am not too familiar with the reporting utility, but have been poking around. Any hints on how to get a dump of aoo interface metrics for the past 5 minutes?
11-14-2011 08:53 AM
A single report cannot be configured to show all metrics collected so scheduled reports are out.
extractData dumps the whole database with no filtering by time so you don't want that.
Howver, you reject configureCsvExport because you want files more frequently than every hour - I thought that hourly was for SUMMARY data but you get LIVE data whenever it is getting loaded into IQ (that is all configure CSV export daoes, it preserves the files gettting loaded into the database instead of deleting them).
I think you should look at configureCsvExport again and see if you haven't just configured it to dump hourly data, I reckon you should get data at 5 minute intervals (or your polling interval if that is larger).