import sqlite3
conn = sqlite3.connect('/opt/friend-cluster/data/friend-cluster-v1.db')
cur = conn.cursor()
cur.execute("""SELECT c.instance_id, c.status, substr(c.result,1,80) FROM commands c
WHERE c.action='instance.decommission' AND c.created_at > '2026-08-23T08:28' ORDER BY rowid""")
for r in cur.fetchall():
    print(r)
print("=== instances still existing ===")
ids = ['friend-fada02e6','friend-33953b97','friend-cf8a5bba','friend-24654384','friend-c2c95ebc','friend-6368a2e7','friend-58aedcb6','friend-7013d01f','friend-c7c66057','friend-c2ffba03','friend-2d8eba0b','friend-dc86d8f3','friend-b45a4c1b']
for iid in ids:
    cur.execute("SELECT id, desired_run_state, process_state, health_state FROM friend_instances WHERE id=?", (iid,))
    row = cur.fetchone()
    if row:
        print("EXISTS:", row)
conn.close()