troubleshoot
troubleshoot copied to clipboard
analyzer: `kots` installed application version history
Describe the rationale for the suggested feature.
It should be possible to see from a support bundle if KOTS application manager is installed, which versions of which apps were deployed and when.
https://community.replicated.com/t/how-can-i-see-the-version-history-of-a-customer-in-a-support-bundle/930
Describe the feature
We get a copy the app manager's postgres database and we could rebuild it in a postgres pod and dump the necessary rows from the app_version database:
postgres=# select app_id, sequence, update_cursor, channel_name, upstream_released_at, created_at, version_label from app_version;
app_id | sequence | update_cursor | channel_name | upstream_released_at | created_at | version_label
-----------------------------+----------+---------------+---------------+----------------------+----------------------------+---------------
2B2i7cvNC6zaV9jUBmjkMdBjDFc | 0 | 1 | Stable-10.5.2 | 2022-04-05 12:51:29 | 2022-06-24 22:40:21.710572 | 10.5.2_303
2B2i7cvNC6zaV9jUBmjkMdBjDFc | 1 | 1 | Stable-10.5.2 | | 2022-07-25 17:59:02.251215 | 10.5.2_303
2B2i7cvNC6zaV9jUBmjkMdBjDFc | 2 | 33 | Stable | 2022-06-30 19:32:04 | 2022-07-25 17:59:14.357903 | 10.8.1_381