How i get database view(Grid view )

[udayatom]

Hello RHQ Friends,

                                           I referred this article from Heiko , That illustrates how to get the information using query. Finally the output comes as the Graph...  can i get the information on the data format(like the database view). What are the procedures to get it..

Regards,

Udaya kumar

[mazz]

That was my blog entry showing how you can use the Database plugin's Query Service resource to obtain metric values based on data in a database. The graph is just the normal metric graphs for any resource in RHQ - it just so happens this resource's metric comes from a database. You can use the RHQ REST interface to obtain any metric data in JSON data format - including this data you see in the graph. From there you can import the data to any data analysis tool or spreadsheet. I think if you google, you'll find information on how you can use a REST client and the RHQ REST API to obtain metric data from it (I seem to remember Heiko or someone mentioning how to do this, but do not remember where).