Query sensors report data manually from applicare database

To manually get the sensors report data from applicare dashboard

Execute the below query to see all sensors added for different server in different dashboards

SELECT i.rl rl, i.server_name_id, i.dashboard_name, i.sensor_name, t.mbean_type, i.mbean_name, p.property, i.load_interval FROM runtime_mbean_types t JOIN runtime_mbean_properties p ON p.mbean_type_rl = t.rl JOIN mbean_prop_identifier i ON i.mbean_prop_rl = p.rl

Sample result:

Execute the below query to get details of the App

SELECT i.rl rl, s.apps app, i.server_name_id, i.dashboard_name, i.sensor_name, t.mbean_type, i.mbean_name, p.property, i.load_interval FROM runtime_mbean_types t JOIN runtime_mbean_properties p ON p.mbean_type_rl = t.rl JOIN mbean_prop_identifier i ON i.mbean_prop_rl = p.rl JOIN server s ON s.name = i.server_name_id ORDER BY s.apps

Sample result:






We should use the rl values from the above result to get the data of individual sensors in the below query

eg:
SELECT dt, prop_value FROM mbean_property_values WHERE mpi_rl = 1099 ORDER BY dt DESC

To filter by time:
In Mysql and Derby
SELECT dt, prop_value FROM mbean_property_values WHERE mpi_rl = 1099 AND dt > '2018-10-30 00:00:00' ORDER BY dt DESC

In Oracle
SELECT TO_CHAR(dt , 'DD/MM/YYYY HH:MI:SS') dt, prop_value FROM mbean_property_values WHERE mpi_rl = 1099 AND dt > to_date( '30-oct-2018 00:00:00', 'dd-mon-yyyy hh24:mi:ss' ) ORDER BY dt DESC


sample result:

To find applicare database connection string:
login applicare dashboard and Go to Menu -> Applicare Information -> Applicare Properties or open Applicare.pros file from Applicare Home Directory









Find the value of below properties:

• applicare.dbVendor
• applicare.dburl
• applicare.dbUsername
• applicare.dbPassword

Note: Value of the property applicare.dbPassword is encrypted. We should use the decrypted password

We can use corresponding database management tool for your DB vendor to connect the applicare database and execute the queries.