PC by Gateway

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'