where is AzureDiagnostics table in log workspace for collecting logicApp standard trackedProperties

George Cao 20 Reputation points
2024-09-04T10:06:45.5866667+00:00

hi Team,

I need help finding the AzureDiagnosetics table for logicApp standard. We are using LogicApp standard and trying to set up tracked properties so that we query a particular salesOrder number in all workflows of a distributed environment.

However, I have had a hard time finding the AzureDiagnostics table after following all the recommended steps for setting up diagnostics for logicApp standard.

If it is a legacy method, can you please advise the alternative way to filter logs based on trackedproperties value

thanks

George

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,087 questions
0 comments
Accepted answer
  1. LeelaRajeshSayana-MSFT 14,831 Reputation points Microsoft Employee
    2024-09-04T15:31:29.6533333+00:00

    Hi @George Cao Greetings! Welcome to Microsoft Q&A forum. Thank you for posting this question here.

    You can use the `LogicAppWorkflowRuntime table under your Log Analytics workspace after enabling Diagnostics under your standard Logic App. Please refer the documentation Monitor and collect diagnostic data for workflows in Azure Logic Apps that outlines all the steps needed to set up and monitor Tracked properties in your workflow.

    Just a side note that you can use expressions in your tracked properties to assign values dynamically. Please refer the below image where I am tracking a property called name which is passed to my workflow through the request body which gets invoked by a HTTP request.

    image

    You can view the tracked properties getting logged under your configured Log Analytics workspace by querying the LogicAppWorkflowRuntime table. Please find the below image where the tracked properties are logged

    enter image description here

    Hope this helps! Please let us know if you have any additional questions or need further clarification.

    Update

    AzureDiagnostics is a legacy method of capturing logs. Going forward, the Azure services are transitioning to use resource-specific mode to store data in a table specific to that service and do not use the AzureDiagnostics table.

    We can query the LogAppWorkflowRuntime table on the TrackedProerpties of the workflows using a query similar to below

    LogicAppWorkflowRuntime 
| project WorkflowName, TrackedProperties, StartTime 
| extend propValue=parse_json(TrackedProperties) 
| where propValue["prop"] == "azure" 
| sort by StartTime desc

    Note that prop in the above query is the name of my TrackedProperty in the workflows.

    If the response helped, please do click Accept Answer and Yes for the answer provided. Doing so would help other community members with similar issue identify the solution. I highly appreciate your contribution to the community.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

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.