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

Harriet KimHarriet Kim Team Automic Posts: 196 Specialist ✭✭✭✭
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.
Sign In or Register to comment.