DHCP servers play a critical role in managing IP address allocation and network configuration across enterprise environments. In this article, we will create an SCCM device collection query to identify servers with the DHCP Server role installed. This dynamic collection helps administrators streamline patch management, compliance monitoring, reporting, and operational management for DHCP infrastructure.
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 = "DHCPServer"
