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