SSRS report for Installed Programs

Boopathi Subramaniam 2,376 Reputation points
2021-11-05T14:40:59.357+00:00

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.
146770-visio.jpg

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

Microsoft Configuration Manager
No comments
{count} votes

Accepted answer
  1. AllenLiu-MSFT 22,091 Reputation points Microsoft Employee
    2021-11-08T02:59:17.64+00:00

    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.


    No comments

1 additional answer

Sort by: Most helpful
  1. Garth Jones 1,291 Reputation points
    2021-11-05T14:47:18.187+00:00

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

    No comments