NEWSQL query to filter computer model + installed wireless drivers

leo815

leo815

Member
6
0
1
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

Garth

Well-Known Member
Staff member
1,812
156
63
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

最新的文章

Forum statistics

Threads
5,723
Messages
22,305
Members
12,505
Latest member
Squuiid