Browse Live Discover and Response Queries by Category
Approved

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

MichaelCurtis
Parents

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

Comment

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

Children
No Data
Unfiltered HTML