Forum Discussion
Racheal2k
Jan 05, 2022Copper Contributor
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...
Clive_Watson
Jan 06, 2022Bronze Contributor
Maybe something like
| summarize _count = count() by bin(TimeGenerated, 1m)
| extend _alive=iff(_count > 1, true, false)
| summarize _count = count() by bin(TimeGenerated, 1m)
| extend _alive=iff(_count > 1, true, false)
Racheal2k
Jan 07, 2022Copper Contributor
Thanks @clive ,
this query has given the same result .
this query has given the same result .