Select v_Add_Remove_Programs.DisplayName0, v_Add_Remove_Programs.Publisher0, v_Add_Remove_Programs.Version0 FROM v_Add_Remove_Programs JOIN v_R_System ON v_Add_Remove_Programs.ResourceID = v_R_System.ResourceID WHERE v_R_System.Netbios_Name0 = @computername