Query Details
//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
This query looks at systems connected using the AMA agent with Azure Arc. It filters the data to only include systems with the ResourceProvider "Microsoft.HybridCompute", then adds a new column called Agent_Version. It then removes duplicate entries based on Computer and Agent_Version, and finally sorts the results by Computer.

Rod Trent
Released: March 8, 2024
Tables
Keywords
Operators