Cloudera cluster CPU & Memory utilization

[#1]

I would like to get entire cloudera cluster CPU & Memory utilization for every 1 hour interval for 24 hours. I need to collect the same 24 hours report for a month. 

Kindly advise how would i get the report in simpler method instead of creating a chart, writing tsquery in cloudera manager and adjust the date, time range manually. 

Is there any option to get the report from CM database end? if yes, kindly provide me one sample which should shows CPU min, max, avg utilization. 

[#2]

Hi , It seems to be there is no such option you can only check the CPU and memory utilization in CM under clusters -> Utilization report for 1 day,week and month etc.. and this we need to manually set it for custom dates range. 

Under this you can also set it if you need the report only on weekdays or only any on specific days.