Aug 07 2018
01:25 PM
- last edited on
Apr 07 2022
05:25 PM
by
TechCommunityAP
Aug 07 2018
01:25 PM
- last edited on
Apr 07 2022
05:25 PM
by
TechCommunityAP
datatable(StartTime:datetime,EndTime:datetime)[
datetime("2018-05-17T08:11:00.00"), datetime("2018-05-17T15:33:00.000"),
datetime("2018-05-17T08:11:00.00"), datetime("2018-05-17T15:45:00.000"),
datetime("2018-05-17T08:13:00.00"), datetime("2018-05-17T15:47:00.000"),
datetime("2018-05-17T08:13:00.00"), datetime("2018-05-17T15:49:00.000"),
datetime("2018-05-17T08:09:00.00"), datetime("2018-05-17T15:43:00.000"),
datetime("2018-05-17T17:34:00.00"), datetime("2018-05-18T00:00:00.000")]
| summarize max(EndTime) by StartTime
| summarize max(EndTime) by tostring(StartTime)
datetime("2018-05-17T08:11:00.00"), datetime("2018-05-17T15:33:00.000"),
datetime("2018-05-17T08:11:00.00"), datetime("2018-05-17T15:45:00.000"),
datetime("2018-05-17T08:13:00.00"), datetime("2018-05-17T15:47:00.000"),
datetime("2018-05-17T08:13:00.00"), datetime("2018-05-17T15:49:00.000"),
datetime("2018-05-17T08:09:00.00"), datetime("2018-05-17T15:43:00.000"),
datetime("2018-05-17T17:34:00.00"), datetime("2018-05-18T00:00:00.000") // is alone
datetime("2018-05-17T08:09:00.00"), datetime("2018-05-17T15:49:00.000")
datetime("2018-05-17T17:34:00.00"), datetime("2018-05-18T00:00:00.000")
Thank you very very much in advance!
Best regards,
David
Nov 18 2018 07:12 AM
Hi,
Indeed the first issue you raise seems strange, I'm trying to find more about why it behaves that way, will update when I get answers.
The second issue - identifying the longest common time range - is more difficult, I don't know of a simple way to do exactly that, but a somewhat similar issue is solved in this example.
Noa
Nov 25 2018 07:42 AM
Hi,
So about the first issue (unexpected binning) - the documented change hasn't been updated in Log Analytics yet... that's a long time coming, I hope it'd be applied soon.
Meantime, another workaround would be to bin to "1tick" which is the exact value you want:
datatable(StartTime:datetime,EndTime:datetime)[ datetime("2018-05-17T08:11:00.00"), datetime("2018-05-17T15:33:00.000"), datetime("2018-05-17T08:11:00.00"), datetime("2018-05-17T15:45:00.000"), datetime("2018-05-17T08:13:00.00"), datetime("2018-05-17T15:47:00.000"), datetime("2018-05-17T08:13:00.00"), datetime("2018-05-17T15:49:00.000"), datetime("2018-05-17T08:09:00.00"), datetime("2018-05-17T15:43:00.000"), datetime("2018-05-17T17:34:00.00"), datetime("2018-05-18T00:00:00.000")] | summarize max(EndTime) by bin(StartTime, 1tick)
Nov 27 2018 04:53 AM
Hi Noa,
Greetings!
Noa this script is only for the timing of VM's or anything else.??