troubleshoot icon indicating copy to clipboard operation
troubleshoot copied to clipboard

analyzer: `kots` installed application version history

Open adamancini opened this issue 3 years ago • 0 comments

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

adamancini avatar Aug 22 '22 17:08 adamancini