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

Question

Jie Yin 105 Microsoft External Staff

Nov 14, 2023, 3:58 PM

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.

1 answer

Answer 1

Dillon Silzer 57,696

Nov 14, 2023, 6:16 PM

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 105 Reputation points Microsoft External Staff

Nov 15, 2023, 12:34 AM

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 105 Reputation points Microsoft External Staff

Nov 15, 2023, 12:37 AM
AnuragSingh-MSFT 21,501 Reputation points

Nov 16, 2023, 2:06 PM

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