Resently Installed Programs

SELECT
    CS.Name0,
    CS.UserName0,
    ISW.ProductName0,
    ISW.VersionMajor0,
    ISW.VersionMinor0,
    ISW.Publisher0,
    ISW.RegisteredUser0,
    ISW.InstallDate0,
    ISW.InstallSource0
FROM
    dbo.v_GS_COMPUTER_SYSTEM CS,
    dbo.v_GS_INSTALLED_SOFTWARE ISW
WHERE
    ISW.ResourceID = CS.ResourceID
ORDER BY
    ISW.InstallDate0 DESC,
    CS.Name0,
    CS.UserName0,
    ISW.ProductName0

Leave a Reply

Your email address will not be published. Required fields are marked *