Forum Discussion

rangari's avatar
rangari
Copper Contributor
Feb 05, 2020

Ability to see customDimensions in Azure logs under ItemType Drop Down

Hi,   I am using Custom Events to track some user activity.  For Example- In our Application every user can set a preference to have certain number of Search results per page. Options being (25,50...
Azure Log Analytics
azure monitor
CliveWatson's avatar
CliveWatson
Former Employee
Feb 06, 2020

rangari 

You probably need to get that column as an integer, very rough example (using a datatable as a fake input):

 

datatable (TimeGenerated:datetime, ItemType:string, customDimensions:string)
    [datetime(1910-06-11), "customEvent", '{"resultsPerPage":"25"}']
| project TimeGenerated, ItemType, customDimensions
| extend rsltsValue =split(customDimensions,":").[1]
| project TimeGenerated , ItemType , val =  toint(trim(@"[^\w]+",tostring(rsltsValue)))

Go to Log Analytics and run query

 

 

 

 

Resources