Device info using KQL

0
votes

How can we get a device info using KQL, Is there any inbuilt function in Azure ?

I have checked but am not able to find out. Can anyone help me out of this ?

Thanks in advance,

1
azureazure-functionsazure-data-explorerkql

1 Answers

0
votes

If you are looking at the application insights logs from the invocation logs then you can use Cloud_RoleName for the name of the function app (the app service itself) and operation_name for the function name. In the following example I have a function called MyFunction that is run from the app service MyFunctionApp.

requests
| project timestamp, id, operation_Name, success, resultCode, duration, operation_Id, cloud_RoleName, invocationId=customDimensions['InvocationId']
| where timestamp > ago(30d)
| where cloud_RoleName =~ 'MyFunctionApp' and operation_Name =~ 'MyFunction'
| order by timestamp desc
| take 20