SCCM application displayname report with AD site and user name

Query:

SELECT     TOP (100) PERCENT dbo.v_R_System.Netbios_Name0, dbo.v_R_System.AD_Site_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, dbo.v_Add_Remove_Programs.Version0

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 '%topspro%')

ORDER BY dbo.v_R_System.Netbios_Name0