SCCM application installed manual report

Query:

SELECT    dbo.v_GS_SYSTEM.Domain0, dbo.v_GS_SYSTEM.Name0, dbo.v_GS_SYSTEM.SystemType0, dbo.v_GS_SYSTEM.SystemRole0,
                      dbo.v_GS_INSTALLED_SOFTWARE.ResourceID, dbo.v_GS_INSTALLED_SOFTWARE.InstallDate0,
                      dbo.v_GS_INSTALLED_SOFTWARE.ARPDisplayName0, dbo.v_GS_INSTALLED_SOFTWARE.InstalledLocation0,
                      dbo.v_GS_INSTALLED_SOFTWARE.InstallSource0, dbo.v_GS_INSTALLED_SOFTWARE.ProductVersion0,
                      dbo.v_GS_INSTALLED_SOFTWARE.Publisher0, dbo.v_GS_INSTALLED_SOFTWARE.ProductName0
FROM         dbo.v_GS_INSTALLED_SOFTWARE INNER JOIN
                      dbo.v_GS_SYSTEM ON dbo.v_GS_INSTALLED_SOFTWARE.ResourceID = dbo.v_GS_SYSTEM.ResourceID
Where dbo.v_GS_INSTALLED_SOFTWARE.InstallSource0 not like '%SMS%$%'
order by dbo.v_GS_INSTALLED_SOFTWARE.InstallDate0 desc