I’m using self hosted Octopus - Download: 2020.1.15 - Octopus Deploy
I’m trying to generate a list of all production deployments, with ideally the Changes information shown on Project > Deloyments > Releases page.
My first confusion is that when I look at a project and view Releases, I definitely can’t see all the production deployments I’ve done.
I also tried the the Octopus CLI and it only came back with 44 entries despite there being 558 if I query the DeploymentHistory DB table (the number it returned seemed to be similar to what was showing under Project > Releases)
octo list-deployments --server=“https://ci.server” --apiKey=“API-CREATE_YOUR_OWN_KEY” --environment=“PRD” --number=“1000” --outputFormat=Json > OctopusDeployDeployments.json
select * from DeploymentHistory
where EnvironmentName = ‘PRD’
So I’m unsure firstly why there is that large difference between the UI and Octopus CLI versus the DeploymentHistory DB table - thoughts?
If I then focus on DeploymentHistory table, I cannot see how you would get the “Changes” list for a release? (which is displayed when you click a release on the dashboard (project/environment combination - see earlier screenshot).
Is it simply looking at all releases between it and the previous one to that environment to create that Changes list?
Thanks in advance.