Isso funcionou para mim:
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 Standard%"
or SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like "%Visio Professional%"
order by SMS_R_System.Name