Are you ok with the data being split into buckets (equal-length time periods) that each have a min, max, and average value for the metric during that time period? If so, you should be able to use findDataForResource() from MeasurementDataManagerRemote via the CLI:

http://docs.redhat.com/docs/en-US/JBoss_Operations_Network/2.4/html/API_Guid...

If not, you might have to resort to SQL.

Note, after data is a few days old, RHQ starts compressing it by averaging it, so you won't be able to get raw data for the entire past month. http://mc4j.org/javadoc/remote-api/org/rhq/enterprise/server/measurement/MeasurementDataManagerRemote.html --Ian

On 12/15/2010 10:51 AM, Márk Tamás Nyiri wrote:

Hi *.*

Can you help me anybody how to export over 1 month collected measurments data from RHQ ? I need a simple script, - a method - of making solution to get a resource/metric data be exported into csv.

Example

I need XX resource YY Metric data from the last ZZ days

Primarily interested in CLI, but if there is no other solution, then either postgres sql script could be envisaged. I tried the following solution, but this is a bug reports are generated

Thanks for help.

---

Nyiri Márk | CIB Bank Zrt. | Middleware Email: nyiri.mark@cib.hu Tel: +36-1-802-3249 Mobil: +36-30-867-5370 Belső mellék: 23249

---

---

rhq-users mailing list rhq-users@lists.fedorahosted.org https://fedorahosted.org/mailman/listinfo/rhq-users