NEW SQL query to filter computer model + installed wireless drivers

[leo815]

Hi all,

I am struggling to combine these two queries so that I can get a list of computer models and the installed wireless driver on it.
Any help would be great. Thanks.

SELECT
Model0 AS Model,
COUNT(*) AS Count
FROM
v_GS_COMPUTER_SYSTEM
GROUP BY Model0

select count(name0),Name0 from v_GS_NETWORK_ADAPTER where
v_GS_NETWORK_ADAPTER.Description0 like '%Wireless%'
group by Name0

 

[Garth]

Keep in mind that your queries will not find all wirelss nic.

SELECT
cs.Model0 AS Model,
NA.Name0,
COUNT(*) AS Count
FROM
v_GS_COMPUTER_SYSTEM cs
join v_GS_NETWORK_ADAPTER NA on CS.ResourceID = NA.ResourceID
where
NA.Description0 like '%Wireless%'
GROUP BY
CS.Model0,
NA.Name0

 

[leo815]

Thank you Garth, really appreciate that