/build/static/layout/Breadcrumb_cap_w.png

Systems Management Question


Is there a Query i can use in SCCM 2007 to show all devices that have a static DNS set for Local Area Connection?

02/09/2015 2756 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?

Thanks


0 Comments   [ + ] Show comments

Comments


All Answers

0
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

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ