Get inventory Vison all parc

Question

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

Answer 1

Hi,

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

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