import sqlite3
conn = sqlite3.connect('/opt/friend-cluster/data/friend-cluster-v1.db')
cur = conn.cursor()
# latest decommission command per instance with timestamps
cur.execute("""SELECT instance_id, id, status, started_at, completed_at, substr(result,1,120) FROM commands
WHERE action='instance.decommission' AND created_at > '2026-08-23T08:51' ORDER BY rowid""")
for r in cur.fetchall():
    print(r)
conn.close()
