Hello Guys, 

I'm developing server inventory report in SCCM 2012 R2 and currently trying to find out inventory information for all NICs. I could not find out information for disabled NIC, on server I have 4 NICs.

2 of 4 are teamed,

1 of 4 is enabled

1 of 4 is disabled

My issue is that i'm not able to find NIC information if it is disabled, it doesn't listed in any of below tables, please help

select * from v_GS_NETWORK_ADAPTER 
select * from v_GS_NETWORK_ADAPTER_CONFIGUR 
select * from v_GS_NETWORK_ADAPTER_CONFIGURATION 

Artak,

The following query should get you the IP-Address of all Systemes, if the Adapter is enabled and has an IP-Address:

select SMS_R_System.Name, SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.IPAddress from  SMS_R_System inner join SMS_G_System_NETWORK_ADAPTER_CONFIGURATION on SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.ResourceID = SMS_R_System.ResourceId where SMS_G_System_NETWORK_ADAPTER_CONFIGURATION.IPEnabled = 1 order by SMS_R_System.Name

@Simon, thank for reply, but I need the disabled NIC to be inventoried and disabled NIC doesn't have  IP enabled property. 

Ah, in that case i misread your question.

The NICs actually should get inventoried no matter if they are enabled or disabled. If you check the Ressource Explorer (-> Network Adapter) you should see all Network Adapters even if they are dis

Have you checked the actual WMI classes on the servers themselves to see if the data is there? Namely Win32_NetworkAdapter and Win32_NetworkAdapaterConfiguration?