Computer groups in Azure Monitor log queries

Computer groups in Azure Monitor allow you to scope log queries to a particular set of computers. Each group is populated with computers using a query that you define. When the group is included in a log query, the results are limited to records that match the computers in the group.

Note

This article was recently updated to use the term Azure Monitor logs instead of Log Analytics. Log data is still stored in a Log Analytics workspace and is still collected and analyzed by the same Log Analytics service. We are updating the terminology to better reflect the role of logs in Azure Monitor. See Azure Monitor terminology changes for details.

Creating a computer group

You can create a computer group in Azure Monitor using the methods in the following table. Details on each method are provided in the sections below.

Method Description
Log query Create a log query that returns a list of computers.
Active Directory No longer supported
Configuration Manager No longer supported
Windows Server Update Services No longer supported

Log query

Computer groups created from a log query contain all of the computers returned by a query that you define. This query is run every time the computer group is used so that any changes since the group was created is reflected.

You can use any query for a computer group, but it must return a distinct set of computers by using distinct Computer. Following is a typical example query that you could use for as a computer group.

Heartbeat | where Computer contains "srv" | distinct Computer

Use the following procedure to create a computer group from a log search in the Azure portal.

  1. Click Logs in the Azure Monitor menu in the Azure portal.
  2. Create and run a query that returns the computers that you want in the group.
  3. Click Save at the top of the screen, and select Save as function from the dropdown.
  4. Select Save as computer group.
  5. Provide values for each property for the computer group described in the table and click Save.

The following table describes the properties that define a computer group.

Property Description
Function name Name of the query to display in the portal.
Legacy category Category to organize the queries in the portal.
Parameters Add a parameter for each variable in the function that requires a value when it's used. For more information, see Function parameters.

Active Directory

No longer supported

Windows Server Update Service

No longer supported

Configuration Manager

No longer supported

Managing computer groups

You can view computer groups that were created from a log query from the Legacy computer groups menu item in your Log Analytics workspace in the Azure portal. Select the Saved Groups tab to view the list of groups.

Click the Run query icon for a group to run the group's log search that returns its members. Click the Delete icon to delete the computer group. You can't modify a computer group but instead must delete and then recreate it with the modified settings.

Screenshot of a Log Analytics resource in Azure with Legacy computer groups pane,  Saved Groups tab, Run query icon, and Delete icon highlighted.

Using a computer group in a log query

You use a Computer group created from a log query in a query by treating its alias as a function, typically with the following syntax:

Table | where Computer in (ComputerGroup)

For example, you could use the following to return UpdateSummary records for only computers in a computer group called mycomputergroup.

UpdateSummary | where Computer in (mycomputergroup)

Next steps

  • Learn about log queries to analyze the data collected from data sources and solutions.