- changed status to resolved
Overview sort error
Issue #29
resolved
The Overview page has 2 errors in the execution of the "sort" command:
Fix:
<query>| mstats avg(_value) as value where `nmon_metrics_index` `def_cpu_all_os_metric_filters`
[ | mstats avg(_value) as value where `nmon_metrics_index` `def_cpu_all_os_metric_filters` earliest=-60m latest=now groupby metric_name, OStype, host span=1s
| `def_all_os_cpu_load_percent`
| stats avg(cpu_load_percent) as cpu_load_percent by host
| sort - 30 cpu_load_percent
| sort 30 - cpu_load_percent
| table host ] groupby metric_name, OStype, host span=1s
| `def_all_os_cpu_load_percent`
| timechart `nmon_span` limit=0 useother=f avg(cpu_load_percent) as cpu_load_percent by host</query>
<earliest>-4h@m</earliest>
<latest>now</latest>
<refresh>30s</refresh>
<refreshType>delay</refreshType>
</search>
<option name="charting.axisTitleX.visibility">collapsed</option>
<option name="charting.axisTitleY.text">% cpu</option>
<option name="charting.chart">line</option>
<option name="charting.drilldown">all</option>
<option name="charting.legend.placement">bottom</option>
<option name="height">450</option>
<option name="refresh.display">none</option>
<drilldown>
<link target="_blank">/app/metricator-for-nmon/Nmon_Summary?form.host=$click.name2$&form.timerange.earliest=-4h&form.timerange.latest=now</link>
</drilldown>
</chart>
<chart depends="$chart2$">
<search depends="$chart2$">
<query>| mstats avg(_value) as value where `nmon_metrics_index` metric_name=os.unix.nmon.cpu.cpu_all.Wait_PCT
[ | mstats avg(_value) as value where `nmon_metrics_index` metric_name=os.unix.nmon.cpu.cpu_all.Wait_PCT earliest=-60m latest=now groupby metric_name, OStype, host span=1s
| stats avg(value) as cpu_iowait_percent by host
| sort - 30 cpu_iowait_percent
| sort 30 - cpu_iowait_percent
| table host ] groupby metric_name, OStype, host span=1s
| timechart `nmon_span` limit=0 useother=f avg(value) as cpu_iowait_percent by host</query>
<earliest>-4h@m</earliest>
<latest>now</latest>
Comments (1)
-
reporter - Log in to comment
Fix Issue
#29→ <<cset 672a3880451e>>