How to get a list of successful deployments over the past year

Discussion created by Harriet_Kim_1764 on Aug 13, 2017
The Automic Web Interface (AWI) is only able to return the last 500 results of successful deployments.

However, if the records have not yet been deleted from the database (i.e. DB maintenance that deletes old executions), then it can be queried with the following SQL statement: 

select * from Execution where status='8' and PlannedFrom > '2017-06-18'; 

where the PlannedFrom date can be changed to any desired date.