NABILIT
Member
- Messages
- 7
- Reaction score
- 0
- Points
- 1
HI team , looking for get list off visio product
i use this query , but the ouput is just one devices , any adea please ?
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%"
i use this query , but the ouput is just one devices , any adea please ?
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%"