select distinct
    R.Netbios_Name0,
    R.User_Name0,
    R.AD_Site_Name0,
    R.Active0,
    R.Client0,
    R.Obsolete0,
    ARP.DisplayName0,
    ARP.Version0,
    R.Operating_System_Name_and0
from 
    v_R_System R inner join v_GS_ADD_REMOVE_PROGRAMS ARP on ARP.ResourceID = R.ResourceId
where
    ARP.DisplayName0 like 'AutoCAD%'
    or ARP.DisplayName0 like 'Autodesk%'
    or ARP.DisplayName0 like 'DWG TrueView%'
    or ARP.DisplayName0 like 'Raster Design%'
    or ARP.DisplayName0 like 'Volo view%'
    and ARP.DisplayName0 != 'Autodesk Design Review 2008'
order by
    ARP.DisplayName0, 
    R.Netbios_Name0