Is there a Query i can use in SCCM 2007 to show all devices that have a static DNS set for Local Area Connection?
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?
Thanks
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
SMal.tmcc
9 years ago
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
reg query HKLM\SYSTEM\CurrentControlSet\services\Tcpip\Parameters\Interfaces /s /v nameserver
