May 10 2018
11:14 AM
- last edited on
Apr 07 2022
04:59 PM
by
TechCommunityAP
May 10 2018
11:14 AM
- last edited on
Apr 07 2022
04:59 PM
by
TechCommunityAP
I am using following query in AppInsights Analytics
{"{OriginalFormat}":"Time taken to process validation message with operation Id - {0} is : {1} seconds","CategoryName":"WebJob.Sample","ActivityID":"f3cd894d-5b92-45d4-12bd-08d5b6695afc","0":"f3cd894d-5b92-45d4-12bd-08d5b6695afc","1":"6.2814211"} |
May 14 2018 09:54 AM
Hi,
This seems to be an issue of data types.
If your customDimensions field had been a String, the extractjson method you used would have worked well. For example, see this query.
However, your customDimensions field is of type dynamic, so you should instead use the parsejson method as shown here. In your case it should be:
... | extend duration = customDimensions["1"]
As for the text search, a more efficient solution would be something like this:
... | where customDimensions["{OriginalFormat}"] contains "Time taken to process validation message with operation Id"
HTH,
Noa