KQL Search

Query Details

HomeAI ToolsDevice Query

AMA Agent

Query

//Systems connected using the AMA agent with Azure Arc

Heartbeat
| where ResourceProvider == "Microsoft.HybridCompute"
| extend Agent_Version = Version
| distinct Computer, Agent_Version
| order by Computer

Explanation

This query is looking at the Heartbeat table and filtering for systems that are connected using the AMA agent with Azure Arc. It then extends the table with a new column called Agent_Version, which is the same as the Version column. It then selects distinct values for the Computer and Agent_Version columns and orders the results by the Computer column.

Details

Rod Trent profile picture

Rod Trent

Released: September 15, 2021

Tables

Heartbeat

Keywords

Heartbeat,ResourceProvider,Microsoft.HybridCompute,Agent_Version,Version,Computer

Operators

whereextenddistinctorder by

Actions