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:
[Screenshot 1 is not available on this page.]
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:
[Screenshot 2 is not available on this page.]
[Screenshot 3 is not available on this page.]
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:
[Screenshot 4 is not available on this page.]
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
[Screenshot 5 is not available on this page.]
[Screenshot 6 is not available on this page.]
[Screenshot 7 is not available on this page.]
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.