missing or not installed

Question

Hello. i am new to SCCM and i am trying to pull out a repot from SCCM to show me which workstation doesn't have a specific version of McAfee installed so i can make sure it gets installed.

any Idea how to get this done?

thank you

Answer 1

Hi, @George Mikhail

Thank you for posting in Microsoft Q&A forum.

We can use a SQL query to get the result that which workstation doesn't have a specific version of software installed.
I take 7-zip for example, you just replace the DisplayName0 and Version0 with your software McAfee.

select name0 from v_r_system   
where name0 not in   
(select Name0 from v_Add_Remove_Programs  
inner join v_R_System on v_Add_Remove_Programs.ResourceID = v_R_System.ResourceID  
where DisplayName0 like '%7-zip%' and Version0 = '19.00.00.0')  

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.