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
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