ARP Display Name with OS and Region

ARP Display Name with OS and Region : -


SELECT DISTINCT v_GS_SYSTEM.Name0, v_GS_ADD_REMOVE_PROGRAMS.DisplayName0, v_R_System.Operating_System_Name_and0 ,
v_R_System.operatingSystem0,v_R_System.user_domain0,v_R_System.Resource_Domain_OR_Workgr0,
v_R_System.User_Name0
FROM v_GS_SYSTEM INNER JOIN v_GS_ADD_REMOVE_PROGRAMS ON v_GS_SYSTEM.ResourceID = v_GS_ADD_REMOVE_PROGRAMS.ResourceID
INNER JOIN v_R_System ON v_GS_SYSTEM.ResourceID = v_R_System.ResourceID
WHERE (v_GS_ADD_REMOVE_PROGRAMS.DisplayName0) like '%SAP Business Explorer%'
  and v_R_System.Resource_Domain_OR_Workgr0 ='AS'




Select distinct sys.Netbios_Name0, fcm.SiteCode, sys.User_Domain0, sys.User_Name0, arp.DisplayName0 ,
 v_R_User.Full_User_Name0, v_R_User.Mail0, arp.version0

 FROM v_r_system sys
 JOIN v_R_User on sys.User_Name0 = v_R_User.User_Name0
 JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID
 JOIN v_FullCollectionMembership fcm on sys.ResourceID = fcm.ResourceID
 WHERE DisplayName0 LIKE '%SAP Business Explorer%' and sys.Resource_Domain_OR_Workgr0 like 'AS%'