SQL QUERY for Display name is for Adobe Shockwave Player

Example for Adobe Shockwave Player:

select v_R_System.ResourceID,
v_R_System.ResourceType,
v_R_System.Name0,
v_R_System.SMS_Unique_Identifier0,
v_R_System.Resource_Domain_OR_Workgr0,
v_R_SYSTEM.Client0
from v_R_System
inner join v_GS_COMPUTER_SYSTEM on v_GS_COMPUTER_SYSTEM.ResourceID = v_R_System.ResourceI
d where v_GS_COMPUTER_SYSTEM.Name0 not in
(select distinct v_GS_COMPUTER_SYSTEM.Name0
from  v_R_System inner join v_GS_COMPUTER_SYSTEM on v_GS_COMPUTER_SYSTEM.ResourceID = v_R_System.ResourceId
inner join v_GS_ADD_REMOVE_PROGRAMS on v_GS_ADD_REMOVE_PROGRAMS.ResourceID = v_R_System.ResourceId
where v_GS_ADD_REMOVE_PROGRAMS.DisplayName0 LIKE '%Adobe%Shockwave%Player%' )