Hello @Deepak_Unravel I highly recommend you to go through the links which I have given in my previous comment. As mentioned above, timeseries data not stored in any of the backend database. It uses LDB [leveldb] storage. If you haven't tried the API Explorer feature in your environment, I request you to try out the same. I have given below the example query which I have tried in my lab using API Explorer to get the HDFS Service Health status for the last 7 days. Navigate to CM UI -> support -> API Explorer -> TimeSeriesResource -> GET /timeseries API call. Example query: Please note to replace the {cm_server_fqdn} & {cm_server_port} curl -X GET "https://{cm_server_fqdn}:{cm_server_port}/api/v57/timeseries?contentType=application%2Fjson&desiredRollup=RAW&from=2025-03-04T09%3A45%3A00.000Z&mustUseDesiredRollup=false&query=select%20health_good_rate%20*%20100%20as%20%22good%20health%22%2C%20health_concerning_rate%20*%20100%20as%20%22concerning%20health%22%2C%20health_bad_rate%20*%20100%20as%20%22bad%20health%22%2C%20health_disabled_rate%20*%20100%20as%20%22disabled%20health%22%2C%20health_unknown_rate%20*%20100%20as%20%22unknown%20health%22%20where%20entityName%3D%22HDFS-1%22&to=now" -H "accept: application/json" If you have any business requirement to create the custom query/chart you shall make use of the timeseries data. For more details, kindly refer https://docs.cloudera.com/cdp-private-cloud-base/7.1.9/monitoring-and-diagnostics/topics/cm-charting-time-series-data.html Also consider reach out to Cloudera Support.
... View more
