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'

Leave a Reply

Your email address will not be published. Required fields are marked *