import sqlite3
conn = sqlite3.connect('/opt/friend-cluster/data/friend-cluster-v1.db')
cur = conn.cursor()
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 node_id, status, substr(result,1,100) FROM commands WHERE action='instance.decommission' AND instance_id=? ORDER BY rowid DESC LIMIT 1", (iid,))
    print(iid, cur.fetchone())
conn.close()