I’d like to use Insights to monitor our Microsoft Azure auto-scaling rules, and I’ve written a tool that creates a custom Insights event whenever one of our Azure webapps scales up or down.
I’m trying to use NRQL to plot a timeseries graph with the number of instances a particular webapp is using over time. The data looks roughly like this:
timestamp appName newInstanceCount scaleDirection 00:10 site1 2 ScaleUp 00:15 site2 4 ScaleDown 04:00 site1 3 ScaleUp 05:00 site1 2 ScaleDown
I’m using a NRQL query like
SELECT max(newInstanceCount) FROM AutoScaleAction SINCE 1 DAY AGO WHERE appName = 'site1' TIMESERIES AUTO to render a line chart with the value of
newInstanceCount over time.
The problem I’m running into is that when using TIMESERIES, periods during which there is no data are rendered as zero on the graph. Since I only insert an event when the value of
newInstanceCount changes, the line drops to zero between 00:10 and 04:00. I’d like the line chart to display the last-known value for periods where there is no data, rather than zero.
I’ve looked at the NRQL reference but I can’t seem to figure out a way to graph the data the way I want – Is this sort of scenario supported? What am I doing wrong here?