Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
3,668 questions
AFAIK, this is by design because it's a legacy table
_ItemId field missing on Application Insights Workspace-based LogAnalytics
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 64%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECF%3C/text%3E%3C/svg%3E)
Catameo, Fred (Taguig City 1634)
236
Reputation points
From the documentation: https://learn.microsoft.com/en-us/azure/azure-monitor/app/convert-classic-resource, "_ItemId" field on LogAnalytics (workspace-based) maps back to "itemId" on ApplicationInsights (classic/basic/Continuous Export), but when querying the LogAnalytics logs or the archived to storage telemetry file "_ItemId" field is not found. Is this by design? Or something is missing or wrong? Thank you
Azure Monitor
2 answers
Sort by: Most helpful
-
Maxim Sergeev 6,586 Reputation points Microsoft Employee2022-09-26T22:51:44.767+00:00 -
Catameo, Fred (Taguig City 1634) 236 Reputation points
2022-09-27T00:44:16.323+00:00 Thank you for the answer. We really need that field as the unique key for the telemetry for ingestion.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 56.00000000000001%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
Christian Münster 0 Reputation points2023-11-22T13:48:22.4133333+00:00 Not heplful! @Maxim Sergeev We need that field in the export :)
Sign in to comment -
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 62%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Marwa Abouawad 286 Reputation points Microsoft Employee Moderator2022-09-29T17:53:35.67+00:00 Hi @Catameo, Fred (Taguig City 1634)
Welcome to Microsoft Q & A community Forum!
This table doesnt have the _itemid as a column by design.
-
Catameo, Fred (Taguig City 1634) 236 Reputation points
2022-09-29T23:46:58.93+00:00 Thanks. May we know the reason why _itemId has been removed from the LogAnalytics AppInsights telemetry? It was the unique key for each telemetry on the classic AppInsights.
-
Marwa Abouawad 286 Reputation points Microsoft Employee Moderator
2022-10-07T15:29:10.117+00:00 Hi @Catameo, Fred (Taguig City 1634)
I've discussed this issue with the product group.
itemId is still there, but it is just a hidden column instead. You can use “project” operator to check the details as below.
Please let me know if you have any other questions.
To benefit the broader community, please feel free to mark as answered.
-
Catameo, Fred (Taguig City 1634) 236 Reputation points
2022-10-07T17:55:43.19+00:00 Thank you for that info. Is there also a way to include the _ItemId on the Diagnostic Setting > archive to storage json telemetry files? We need a way to trace back the archived to storage json telemetry to the AppInsights logs.
-
Christian Münster 0 Reputation points
2023-11-22T13:42:57.7266667+00:00 I guess not, but why though?
It's really helpful in determining double entries
-
Christian Münster 0 Reputation points
2023-11-22T13:45:16.6633333+00:00 Can @Marwa Abouawad Please follow up here? We need that Itemid or something similar, please :)
-
Christian Münster 0 Reputation points
2023-11-22T13:47:10.21+00:00 also; @Marwa Abouawad how do we achieve what you say here:
"ItemId is still there, but it is just a hidden column instead. You can use “project” operator to check the details as below"
into the Storage account export feature (JSON) using diagnostic Settings on the Application Insights (workspace version) ?
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 97%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Matt Buckleman 5 Reputation points2024-04-11T15:57:25.8266667+00:00 This is a bit of a problem, though.
The _itemId is necessary to be able to use any of the workbook link actions that can be applied to the Grid renderer results of a custom log analytics query.
https://learn.microsoft.com/en-us/azure/azure-monitor/visualize/workbooks-link-actions
Every link type requires _itemId.
I've gone through a long process of creating some complex custom functions to provide us with the types of insights we need - and I've done so against the underlying LogAnalytics workspace data rather than the applicationInsights one itself (for multiple reasons). Now with all of that done, I'm going to have to re-join or union back to the very data set I was avoiding for one simple column.
Sign in to comment -