How to collect the JSON log file to Log analytics workspace custom table using DCR?

Jie Yin 100 Reputation points Microsoft Vendor
2023-11-14T15:58:54.41+00:00

I will collect the log file (format JSON) to Log analytics workspace custom table based Azure monitor DCR, but the custom table some column is null.

Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
3,196 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Dillon Silzer 57,231 Reputation points
    2023-11-14T18:16:25.6733333+00:00

    Hi Jie,

    You will want to either do this through the portal or ARM template:

    Create a data collection rule to collect data from a text or JSON file

    https://learn.microsoft.com/EN-us/azure/azure-monitor/agents/data-collection-text-log?tabs=portal#create-a-data-collection-rule-to-collect-data-from-a-text-or-json-file

    Also, is it possible to provide us what your setup is (if you have one) and how are you querying the data?


    If this is helpful please accept answer.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.