Sccm collection showing networkadapter and Computer model

[denmyos]

I can get this to work when i do Queries, but i would like to make it work in a collection.

But the collection will not show the model name (lenovo T460 etc)

What i'm i doing wrong.

 

 

 

select SMS_R_System.Name, SMS_G_System_COMPUTER_SYSTEM_PRODUCT.Version, SMS_G_System_COMPUTER_SYSTEM_PRODUCT.IdentifyingNumber, SMS_G_System_COMPUTER_SYSTEM_PRODUCT.Name, SMS_G_System_NETWORK_ADAPTER.ProductName from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM_PRODUCT on SMS_G_System_COMPUTER_SYSTEM_PRODUCT.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_NETWORK_ADAPTER on SMS_G_System_NETWORK_ADAPTER.ResourceID = SMS_R_System.ResourceId where SMS_G_System_NETWORK_ADAPTER.Name = "Intel® Dual Band Wireless-AC 8260"

 

 

Any help is appriciated

Thanks

Edited February 23, 2022 by denmyos