- 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
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