Hi,

I am trying to query what wireless driver/firmware is installed on a client and I don't see an existing report for this. I have tried the SQL query below but it does not seem to be valid. Does anyone know of a way to get this information? I have read somewhere that it may involve sending a registry setting to the client via policy so that this can be reported but I was hoping that there is an easier way?

TIA

SELECT SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client 
 FROM SMS_R_System 
 JOIN SMS_G_System_NETWORK_DRIVERS ON SMS_R_System.ResourceID = SMS_G_System_NETWORK_DRIVERS.ResourceID 

You will need a MOF Customization for this :

http://blogs.technet.com/b/configmgr_geek_speak/archive/2013/11/10/inventorying-and-reporting-network-adapter-driver-details-and-how-to-report-only-the-wireless-type-in-configuration-manager-2012.aspx

Just saw a similar thread posted today :

https://social.technet.microsoft.com/Forums/en-US/088a8583-e935-41f5-8546-ee8de8b7b7e2/network-card-inventory?forum=configmanagergeneral

Ok, so this would be the only way to achieve this then? There isn't any of this information stored in SQL?

No, the class you are querying is not a default class and thus this information is not collected by default. You much modifying your inventory per Russ's instructions in the article to collect this info.