question

BoopathiSubramaniam-6294 avatar image
0 Votes"
BoopathiSubramaniam-6294 asked AllenLiu-MSFT answered

SSRS report for Installed Programs

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

mem-cm-general
visio.jpg (98.9 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AllenLiu-MSFT avatar image
0 Votes"
AllenLiu-MSFT answered

Hi, @BoopathiSubramaniam-6294
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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

GarthJones-9654 avatar image
0 Votes"
GarthJones-9654 answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.