Get inventory Vison all parc

Nabil Nabil 1 Reputation point

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


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


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




    0 comments No comments