SCCM Application displayname present in the machines report

Query:

SELECT     TOP (100) PERCENT dbo.v_R_System.Netbios_Name0, dbo.v_R_System.User_Name0, dbo.v_R_System.Operating_System_Name_and0,
                      dbo.v_Add_Remove_Programs.DisplayName0, dbo.v_Add_Remove_Programs.InstallDate0, dbo.v_Add_Remove_Programs.Publisher0
FROM         dbo.v_Add_Remove_Programs INNER JOIN
                      dbo.v_R_System ON dbo.v_Add_Remove_Programs.ResourceID = dbo.v_R_System.ResourceID
WHERE     (dbo.v_Add_Remove_Programs.DisplayName0 LIKE '%autocad%')
ORDER BY dbo.v_R_System.Netbios_Name0