SCCM applications displayname report with install source location and username

Query:


SELECT        dbo.v_GS_SYSTEM.Name0 AS [Machine Name], dbo.v_R_System.User_Name0 AS UserName, dbo.v_GS_SYSTEM.SystemType0 AS [Proceesor Type], dbo.v_R_System.AD_Site_Name0 AS [AD Site Name],
                         dbo.v_R_System.Operating_System_Name_and0 AS [Operating System], dbo.v_GS_INSTALLED_SOFTWARE.Publisher0 AS Manufacture,
                         dbo.v_GS_INSTALLED_SOFTWARE.ARPDisplayName0 AS [ARP Application Name], dbo.v_GS_INSTALLED_SOFTWARE.ProductName0 AS [Application Name],
                         dbo.v_GS_INSTALLED_SOFTWARE.ProductVersion0 AS [Software Version], dbo.v_GS_INSTALLED_SOFTWARE.InstallDate0 AS InstallDate, dbo.v_GS_INSTALLED_SOFTWARE.InstallSource0 AS [Install Source],
                         dbo.v_GS_INSTALLED_SOFTWARE.InstalledLocation0 AS [Installed Location]
FROM            dbo.v_GS_INSTALLED_SOFTWARE INNER JOIN
                         dbo.v_R_System ON dbo.v_GS_INSTALLED_SOFTWARE.ResourceID = dbo.v_R_System.ResourceID INNER JOIN
                         dbo.v_GS_SYSTEM ON dbo.v_R_System.ResourceID = dbo.v_GS_SYSTEM.ResourceID
WHERE        (dbo.v_GS_INSTALLED_SOFTWARE.ARPDisplayName0 LIKE '%autocad%')

order by dbo.v_GS_INSTALLED_SOFTWARE.InstallDate0 desc