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

Question

Jie Yin 80

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.

Answer 1

Dillon Silzer 49,166

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

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.

Jie Yin 80 Reputation points

2023-11-15T00:34:57.52+00:00

Hi Dillon

I have read this doc alreday, but the doc have not provider the right transform query for JSON file. I have tyr write the some transform , but the custom table some column is always null(no data).

The details step is:

https://learn.microsoft.com/en-us/answers/questions/1425222/how-to-collect-the-json-log-file-to-log-analytics
Jie Yin 80 Reputation points

2023-11-15T00:37:09.26+00:00
AnuragSingh-MSFT 17,396 Reputation points

2023-11-16T14:06:17.5733333+00:00

Jie Yin, thank you for the confirmation on other thread about this issue: https://learn.microsoft.com/en-us/answers/questions/1425222/how-to-collect-the-json-log-file-to-log-analytics

1 answer