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 WHERE NAME NOT LIKE 'Sophos%'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.