Forum Discussion

Copper Contributor

Jan 05, 2022

How to analyse the missing timeframe logs

Hi , Subject might look different from what my question is. I'm using requests table to find the availability of application. This table will have record for every minute . there won't be rec...

azure monitor

Racheal2k

Copper Contributor

Jan 10, 2022

Hi,

Does anyone knows how to get those result?

Thanks !

Racheal2k
Copper Contributor
Jan 10, 2022
Interestingly i came across, make-series operator which has an option to provide default value if no record is found. below queries gives 0 for the minutes where there is no record from 04:00 to 04:07
requests
|where name in ( "/health")
|make-series num=count() default=0 on timestamp from datetime(2022-01-01 02:00) to datetime(2022-01-01 02:15) step 1m by name

eg:
num
[0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]

Is there equivalent operator like 'default' for summarize statement so there will be rows with missing timeframe with value as '0'

Thanks!