View and create queries for monitoring and tracking data in Azure Monitor for Azure Logic Apps

Applies to: Azure Logic Apps (Consumption)

Note

This article applies only to Consumption logic apps. For information about monitoring Standard logic apps, review Enable or open Application Insights after deployment for Standard logic apps.

You can view the underlying queries that produce the results from Azure Monitor logs and create queries that filter the results based on your specific criteria. For example, you can find messages based on a specific interchange control number. Queries use the Kusto query language, which you can edit if you want to view different results. For more information, see Azure Monitor log queries.

Prerequisites

View queries behind results

To view or edit the query that produces the results in your workspace summary, follow these steps:

  1. On any results page, at the bottom, select See all.

    Screenshot that shows a results page with the See all link selected at the bottom left.

    The Logs page opens and shows the query that produces the preceding results page.

    Screenshot that shows the Logs page and the query editor with the selected query that produces the preceding results.

  2. On the Logs page, you can select these options:

    • To view the query results as a table, under the query editor, select Table.

    • To change the query, update the query string and select Run to view the results in the table.

Create your own query

To find or filter results based on specific properties or values, you can create your own query by starting from an empty query or use an existing query. For more information, see Get started with log queries in Azure Monitor.

  1. In the Azure portal, find and select your Log Analytics workspace.

  2. On your workspace menu, under General, select Logs.

  3. Start from an empty query or any available existing queries.

    • To check whether any existing queries are available, on the query toolbar, select either Samples queries > History, which shows queries from previous query runs, or select Query explorer, which shows prebuilt queries.

      For example, the Logic Apps B2B solution provides these prebuilt queries:

      Screenshot that shows the Query explorer and the Logic Apps B2B solution prebuilt queries highlighted.

    • To start from an empty query, in the query editor, start typing the Kusto query language for your query.

      Screenshot that shows a new query and the query editor.