SSRS report for Installed Programs

Question

Hello,

I am asked to created a SSRS report for Visio installed devices.

Used below query as per https://msendpointmgr.com/2014/01/24/create-custom-reports-for-configmgr-2012-with-report-builder/
select SMS_R_System.Name, SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName, SMS_G_System_ADD_REMOVE_PROGRAMS.Version from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Microsoft Visio%"

But it generates security update as well.

I require a query to pull only devices with application name like below.
Microsoft Visio - en-us, Microsoft Visio Professional 2016 - en-us, Microsoft Visio Professional 2013

Please help

Answer 1

Hi, @Boopathi Subramaniam
Thank you for posting in Microsoft Q&A forum.

You may add SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "Update".

select SMS_R_System.Name, SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName, SMS_G_System_ADD_REMOVE_PROGRAMS.Version from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Microsoft Visio%" and SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName not like "%Update%"  

---

If the answer is helpful, 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.

---

Answer 2

What is wrong with this built-in report for this?