select
CS.Name0,
CS.UserName0,
NA.Description0,
NAC.IPAddress0,
NAC.MACAddress0,
NAC.DefaultIPGateway0
From
dbo.v_GS_COMPUTER_SYSTEM CS
join dbo.v_GS_NETWORK_ADAPTER_CONFIGUR NAC on NAC.ResourceID = CS.ResourceID
join dbo.v_GS_NETWORK_ADAPTER NA on NA.ResourceID = CS.ResourceID and NAC.ServiceName0 = NA.ServiceName0
Where
NAC.DefaultIPGateway0 = '192.168.1.1'
or NAC.DefaultIPGateway0 = '192.168.5.1'