?

Log in

No account? Create an account

Previous Entry | Next Entry

SMS: SQL query - Static IP Addressing

SELECT DISTINCT
v_R_System.Netbios_Name0, v_GS_NETWORK_ADAPTER_CONFIGUR.DHCPEnabled0, v_GS_NETWORK_ADAPTER_CONFIGUR.IPAddress0,
v_R_System.ResourceType
FROM v_R_System INNER JOIN
v_GS_NETWORK_ADAPTER_CONFIGUR ON v_R_System.ResourceID = v_GS_NETWORK_ADAPTER_CONFIGUR.ResourceID
WHERE (v_GS_NETWORK_ADAPTER_CONFIGUR.DHCPEnabled0 = 0) AND (NOT (v_GS_NETWORK_ADAPTER_CONFIGUR.IPAddress0 IS NULL))

Tags:

Comments

( 1 comment — Leave a comment )
msmcfeeley
May. 23rd, 2006 07:12 am (UTC)
I wholeheartedly agree!
( 1 comment — Leave a comment )