select
*
from
dbo.v_GS_NETWORK_ADAPTER_CONFIGUR
where
IPAddress0 IS not NULL
and IPAddress0 like ‘192.168.[1-9].%’