Forum Discussion

Copper Contributor

Dec 08, 2017

Log Analytics Query - Azure Active Directory ExtendedProperties

Hello, I'm currently working on a query in Log Analytics which requires me to filter on properties which are in the ExtendedProperties field. See below example, I would like to use the Extended...

azure monitor

Query Language

Noa Kuperberg

Microsoft

Dec 12, 2017

You can access a specific item on the array using [1] or [2], and then access an item named "Value" is through ".Value" as shown here:

extend second_item_value = your_array[1].Value

More examples are available here:

https://docs.loganalytics.io/docs/Learn/Tutorials/Working-with-JSON-and-data-structures