I need to add a _resourceId table for custom log in log analytics workspace

Brinda Upendra 0

I created VM , DCR , DCE , custom log (DCR) under Log Analytics workspace.

There is no data generated from custom log created.

Requesting to provide schema to add resourceid column to upload under schema and transformation editor.

Best Regards,

Brinda

Pranay Reddy Madireddy 535 Reputation points Microsoft Vendor

2024-09-09T12:48:05.1+00:00
Hii Brinda Upendra

Welcome to the Microsoft Q&A Platform! Thank you for asking your question here.

Example of defining a schema for a custom log in Azure Log Analytics that includes a resourceid column.

If you have a custom log file with field like resourceid, your schema might look like this:

{

"Table": "YourCustomLogTableName",

"Columns": [

{ "name": "resourceid", "type": "string" }

]

}

To set up custom log collection:

Open the Azure Portal and go to your Log Analytics workspace.

Go to "Logs" and choose "Custom Logs."

Check if your custom log is listed and properly set up.

Review the settings like file path, format, and schema.

To make sure your data is being collected and processed correctly, first check that your data is arriving as expected. If there are problems, you might need to fix the schema or verify that the data format is right. Also, if you’re using the Transformation Editor, ensure it’s set up correctly to extract and include the resourceid column.

Check the log data in the Log Analytics workspace to make sure the resourceid column has data and is set up correctly. You can use queries to help with this.

CustomLog_CL

| project resourceid

| limit 50

Replace CustomLog_CL with the real name of your custom log table.

For reference, please review this documentation: https://learn.microsoft.com/en-us/azure/azure-monitor/logs/create-custom-table?tabs=azure-portal-1%2Cazure-portal-2%2Cazure-portal-3#add-or-delete-a-custom-column

If you have any further queries, do let us know.

If the answer is helpful, please click "Accept Answer" and "Upvote it".
Pranay Reddy Madireddy 535 Reputation points Microsoft Vendor

2024-09-10T12:52:04.62+00:00

Hii Brinda Upendra
If you had a chance to see my comment to your question. If it was helpful, please click "Upvote" on my post let us know Thank you...!
Pranay Reddy Madireddy 535 Reputation points Microsoft Vendor

2024-09-18T21:39:44.91+00:00

Hii Brinda Upendra

If you had a chance to see my comment to your question. If it was helpful, please click "Upvote" on my post let us know Thank you...!

Share via

I need to add a _resourceId table for custom log in log analytics workspace

Your answer