Kusto nested logs inside other logs

Question

Hello,

I hope that you are doing fine and that this question isn't already answered in another topic (I've searched many other topics without finding the answer)

I have this log :

I need to query the results of Response of the main table, how can I do that?

Thank you in advance

Answer

Hi @TAHRI Ahmed ,

Thanks for confirming. At this time I don't have a sample data to show the exact query but, I would recommend you to please refer to this public doc which has explanation about the dynamic data type to read complex/nested JSON data values : https://video2.skills-academy.com/en-us/azure/data-explorer/kusto/query/scalar-data-types/dynamic#dynamic-object-accessors

Here is another Stackoverflow thread with a step by step explanation about the same : https://stackoverflow.com/questions/44122574/parsing-json-in-kusto-query

Hope this info helps. Do let us know if you have further query.

----------

Please don't forget to click on and upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
Want a reminder to come back and check responses? Here is how to subscribe to a notification
If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

Share via

Kusto nested logs inside other logs

1 answer

Your answer