Hyper-V hosts are widely used to run and manage virtualized workloads in enterprise environments. In this article, we will create an SCCM device collection query to identify servers with the Hyper-V role installed. This dynamic collection can help administrators simplify patch deployment, compliance reporting, monitoring, and operational management for virtualization hosts.
select * from SMS_R_System inner join SMS_G_System_SERVICE on
SMS_G_System_SERVICE.ResourceId = SMS_R_System.ResourceId where
SMS_G_System_SERVICE.Name = "vmms"
