Two NICs enabled at the same time

Select Distinct
    CS.Name0,
    NIC.Description0,
    NAC.IPAddress0,
    NAC.DefaultIPGateway0,
    NIC.*,
    Nac.*
from
    dbo.v_GS_COMPUTER_SYSTEM CS,
    dbo.v_GS_NETWORK_ADAPTER NIC,
    dbo.v_GS_NETWORK_ADAPTER_CONFIGUR NAC,
    (Select distinct
        CS.ResourceID as ‘ResourceID’,
        count (CS.ResourceID) as ‘Total’
    from
        dbo.v_GS_COMPUTER_SYSTEM CS,
        dbo.v_GS_NETWORK_ADAPTER NIC,
        dbo.v_GS_NETWORK_ADAPTER_CONFIGUR NAC
    Where
        CS.ResourceID = NIC.ResourceID
        and CS.ResourceID = NAC.ResourceID
        and NAC.ServiceName0 = NIC.ServiceName0
        and NAC.IPAddress0 != ”
        and NAC.IPAddress0 != ‘0.0.0.0’
    group by
        CS.ResourceID ) CCS
Where
    CS.ResourceID = NIC.ResourceID
    and CS.ResourceID = NAC.ResourceID
    and CS.ResourceID = CCS.ResourceID
    and NAC.ServiceName0 = NIC.ServiceName0
    and NAC.IPAddress0 != ”
    and NAC.IPAddress0 != ‘0.0.0.0’
    and CCS.Total > 1
Order by
    CS.Name0,
    NIC.Description0,
    NAC.IPAddress0,
    NAC.DefaultIPGateway0

Leave a Reply

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