Hi Community,
I am trying to generate a timechart by month with the following query:
index=xyz Question="zzz" NOT "Could not get results" NOT "No Deployment Results Found" NOT "No Matching Deployments Found" NOT "Unable to load PatchLib" | sort Computer_Name, patchmeantime | stats max(patchmeantime) as MaxAge by Computer_Name | stats avg(MaxAge) as MTTP
| timechart span=1mon avg(MTTP)
But nothing is showing up, so I am pretty sure I am missing something critical or super simple here but not sure what it is.....
Any help will be really appreciated.
Your query is ultimately looking to show a single figure per month of avg(MTTP), which is an average of a maximum
The way to do this is like this
index=xyz Question="zzz" NOT "Could not get results" NOT "No Deployment Results Found" NOT "No Matching Deployments Found" NOT "Unable to load PatchLib"
| bin _time span=1mon
| stats max(patchmeantime) as MaxAge by _time Computer_Name
| timechart span=1mon avg(MaxAge) as MTTP
This will bucket _time by 1 month and then the stats by _time will calculate the max age for each computer for each month. Then the timechart will calculate that average for all max values in the month.
Note: Do not sort - in this case it has no purpose. In the general case, sort ONLY when necessary and as late as possible in the pipeline.
The timechart command requires the _time field, but that field was discarded by the stats commands. The easiest fix is to replace stats with eventstats.