https://community.cloudera.com/t5/Support-Questions/Average-CPU-usage-for-last-30-days-data-granularity-quot/m-p/302894#M221287 <P>Hi,</P><P>&nbsp;</P><P>we are trying to export csv/Json for average CPU usage for last 30 days (with data granularity "Hourly") using Cloudera manager and used following query:-</P><P>&nbsp;</P><P><EM>SELECT cpu_percent_across_hosts WHERE entityName = "1" AND category = CLUSTER</EM></P><P>&nbsp;</P><P>Queries:-</P><P>1. is this correct query/parameter to pull average cpu usage for cluster?&nbsp; if not, please suggest on how can we get this data.</P><P>2. If answer to question 1 is yes, challenge is,&nbsp;If we take data for last 30 days, we do not get granularity lesser than 6 hours but if we select last 7 days, we get data grouped by 1 hour (which we need). can we do something about this?</P><P>&nbsp;</P><P>thanks,&nbsp;</P><P>Gaurav</P><P><a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/14107">@admin</a>&nbsp;</P><P><a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/5530">@support</a>&nbsp;</P> Tue, 15 Sep 2020 16:39:48 GMT GauravCha 2020-09-15T16:39:48Z