SCCM report list all the computers with application installed

1. 

   Leo on August 22, 2023 1:52 PM

   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

   Reply
   • 

     Eswar Koneti on January 31, 2025 10:21 PM

     Hi Leo,
     apologies for the delay. here is the combined SQL query.

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

     thanks,
     Eswar
     http://www.eskonr.com

     Reply
2. 

   ThomasC> on June 9, 2020 5:55 PM

   is it possible to get the user for the computer?

   Reply
   • 

     Eswar Koneti on June 15, 2020 12:16 AM

     yes,it is possible to get user for the computer and can get it from v_r_system or v_r_user.

     Thanks
     Eswar

     Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.