# How can I see the version history of a customer in a support bundle?

**URL:** <https://community.replicated.com/t/how-can-i-see-the-version-history-of-a-customer-in-a-support-bundle/930>\
**Category:** Uncategorized\
**Created:** [August 22, 2022, 8:27am UTC](https://community.replicated.com/t/how-can-i-see-the-version-history-of-a-customer-in-a-support-bundle/930 "2022-08-22T08:27:49Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![bco](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.replicated.com/bco/32/482_2.png) [@bco](https://community.replicated.com/u/bco)\
**Post date:** [August 22, 2022, 8:27am UTC](https://community.replicated.com/t/how-can-i-see-the-version-history-of-a-customer-in-a-support-bundle/930/1 "2022-08-22T08:27:49Z")

</div>

Is it possible to see from a support bundle what versions were deployed and when?

---

<div class="post-metadata">

**Author:** ![adamancini](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.replicated.com/adamancini/32/229_2.png) [@adamancini](https://community.replicated.com/u/adamancini)\
**Post date:** [August 22, 2022, 6:29pm UTC](https://community.replicated.com/t/how-can-i-see-the-version-history-of-a-customer-in-a-support-bundle/930/2 "2022-08-22T18:29:22Z")

</div>

A support dump should contain a copy of the KOTS Application Manager database, and a Postgres pod can be reconstructed from the database dump. This would be a great idea for an analyzer that will generate a nicely formatted report, but in the meantime you can create a Postgres pod and load the database dump into it and examine the data it contains:

```auto
cd ./<support-bundle-folder>/kots/admin_console/<namespace>/kotsadm-postgres-0
# `ls` should list a file named kotsadm-postgres-db-stdout.txt

# start a postgres pod
kubectl run postgres --image postgres --env="POSTGRES_PASSWORD=password"

# copy the file into the pod
kubectl cp kotsadm-postgres-db-stdout.txt postgres:/tmp

# exec into the pod and load file into the database
kubectl exec -it postgres bash

# inside the pod, start a postgres client
psql -U postgres -f /tmp/kotsadm-postgres-db-stdout.txt

# examine the database
psql -U postgres

# 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
-----------------------------+----------+---------------+---------------+----------------------+----------------------------+---------------
 abcdefg1234567890 | 0 | 1 | Stable-10.5.2 | 2022-04-05 12:51:29 | 2022-06-24 22:40:21.710572 | 10.5.2_303
 abcdefg1234567890 | 1 | 1 | Stable-10.5.2 | | 2022-07-25 17:59:02.251215 | 10.5.2_303
 abcdefg1234567890 | 2 | 33 | Stable | 2022-06-30 19:32:04 | 2022-07-25 17:59:14.357903 | 10.8.1_381
(3 rows)

```

---

<div class="post-metadata">

**Author:** ![bco](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.replicated.com/bco/32/482_2.png) [@bco](https://community.replicated.com/u/bco)\
**Post date:** [April 3, 2023, 11:11am UTC](https://community.replicated.com/t/how-can-i-see-the-version-history-of-a-customer-in-a-support-bundle/930/3 "2023-04-03T11:11:28Z")

</div>

@adamancini I’m guessing this is no longer possible any more since the rqlite switch?

---

<div class="post-metadata">

**Author:** ![adamancini](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.replicated.com/adamancini/32/229_2.png) [@adamancini](https://community.replicated.com/u/adamancini)\
**Post date:** [April 3, 2023, 6:59pm UTC](https://community.replicated.com/t/how-can-i-see-the-version-history-of-a-customer-in-a-support-bundle/930/4 "2023-04-03T18:59:57Z")

</div>

If you’re using a build with rqlite, we can do the same with a `sqlite` client (I’m using `sqlite3` installed on my workstation because I couldn’t find an official sqlite image):

```auto
cd ./<support-bundle-folder>/kots/admin_console/<namespace>/kotsadm-rqlite-0
sqlite3

```

and in the interactive console in `sqlite`:

```auto
sqlite> .read kotsadm-rqlite-db-stdout.txt
sqlite> .headers ON
sqlite> 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
2G071ai0BPUtXYerTRmyFT1Rqjs|0|1|Unstable||1665519449|Unstable-602b66b-dirty
2G071ai0BPUtXYerTRmyFT1Rqjs|1|2|Unstable|1665636684|1665636924|Unstable-602b66b-dirty
2G071ai0BPUtXYerTRmyFT1Rqjs|2|3|Unstable|1670611262|1670616607|Unstable-602b66b-dirty

```