List software installed between two dates

  REVIEWED by Sophos 

This query will list all the software installed between two dates, taking Sophos out of the list. The variable screen is below. It also shows the format. Some software has no date so that is returned just in case it helps


SELECT name, version, publisher, install_date,
install_location AS 'Install Path'
FROM Programs
OR install_date = ''
AND install_date >= '$$StartDate$$'
AND install_date <= '$$EndDate$$'
ORDER BY install_date DESC



This what the result looks like

  • if you remove the date variables you get a list of all the software on your systems and can sort by name to find software(s) that you may not want.

    For example, having run it without dates I found some machines that still had Adobe Flash and a few software packages that I had not managed to remove from every system on our network.