How to debug if my DCR isn't working
I have an on prem Linux server that was onboarded successfully through Azure Agent. I verified the server's status through KQL -> Heartbeat
My purpose for this is to collect Custom application logs from this server and feed it to Log Analyitcs Workspace through DCR. I have followed everything here:
https://learn.microsoft.com/en-us/azure/azure-monitor/agents/data-sources-custom-logs
I have successfully created the Log Analytics Workspace -> Custom table under this workspace
Created the DCR as well, connect the on prem server as resource for this DCR, add the file patterns and file location in the source as well.
But I can't see the rawdata when I try to query it in LogAnalytics Workspace -> Logs using
MyCustomTable_CL | project RawData
So how to debug if the Data Collection Rule is really working? or where is the issue in this?
Here is my Source config:
And here is what the log data looks like in my Linux server:
2025-01-28 08:04:44(PID = 79773) (HOST = 98yd98sadsaddsa.org) INFO - DB CONNECT 'dsdsada'
This is inside .log file