Get inventory Vison all parc

Nabil Nabil 1 Reputation point
2022-01-25T15:19:02.06+00:00

Hi team
Im looking for query or repport to get all product visio installed on our parc

i user this
select SMS_R_System.Name, SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName
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 "%Visio%"

but show me just on Devives ==> Limit collection all

REGARDS

Microsoft System Center
Microsoft System Center
A suite of Microsoft systems management products that offer solutions for managing datacenter resources, private clouds, and client devices.
818 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. XinGuo-MSFT 14,236 Reputation points
    2022-01-26T08:21:46.27+00:00

    Hi,

    In my test lab the query is work perfect, please refer to the screenshot below:

    168672-capture.png

    ------------

    168673-capture1.png

    0 comments No comments