02/09/2015 2522 views
Is there a Query i can use in SCCM 2007 to show all devices that have a static DNS set for Local Area Connection?  Im using the one below to query static ip addresses

select distinct SMS_R_System.Name, SMS_R_System.IPAddresses, SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.DHCPEnabled from  SMS_R_System inner join SMS_G_System_NETWORK_ADAPTER_CONFIGURATION on SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.IPEnabled = 1 and SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.DHCPEnabled = 0 and SMS_G_System_OPERATING_SYSTEM.Name not like "Microsoft Windows NT%Server%"

is there a query i can use to query devices with static dns?


0 Comments   [ + ] Show comments


All Answers

This is a query of the registry keys that contain that information I use for a different Management system, do not know if this helps but gives you a place to find that info if you can convert it to SCCM use.

 reg query HKLM\SYSTEM\CurrentControlSet\services\Tcpip\Parameters\Interfaces /s /v nameserver
Answered 02/09/2015 by: SMal.tmcc
Red Belt