Liste des incidents "offline" sur la gdev

J’étais curieux de voir la liste des imOnline.SomeOffline sur la gdev :

query Offline {
  event(where: {name: {_eq: "SomeOffline"}}, orderBy: {block: {height: DESC}}) {
    block { height}
    pallet
    name
    args
  }
}

Pour convertir les pubkey hexadécimales en addresses ss58 cf Manipulation d'adresses SS58.

Ensuite pour trouver les identités des validateurs, y compris quand ils ont changé de clé :

query FindNames(\$addresses: [String!]) {
    account(where: {id: {_in: \$addresses}}){
      id
      identity {name}
      wasIdentity{identity{name}}
    }
}

Ce qui en CSV donne le résultat suivant :

block,addr,name
2861076,5CfdJjEgh3jDkg3bzmZ1ED1xVhXAARtNmZJWbcXh53rU8z5a,cgeek (old)
2656502,5CfdJjEgh3jDkg3bzmZ1ED1xVhXAARtNmZJWbcXh53rU8z5a,cgeek (old)
2655967,5CfdJjEgh3jDkg3bzmZ1ED1xVhXAARtNmZJWbcXh53rU8z5a,cgeek (old)
2655429,5CfdJjEgh3jDkg3bzmZ1ED1xVhXAARtNmZJWbcXh53rU8z5a,cgeek (old)
2654889,5CfdJjEgh3jDkg3bzmZ1ED1xVhXAARtNmZJWbcXh53rU8z5a,cgeek (old)
2654356,5CfdJjEgh3jDkg3bzmZ1ED1xVhXAARtNmZJWbcXh53rU8z5a,cgeek (old)
2581609,5ChAhNCVVT2FWeC5D8wwHSuHGd6ZjYVMzTSeDjrJ46BbxyXU,1000i100
2581081,5ChAhNCVVT2FWeC5D8wwHSuHGd6ZjYVMzTSeDjrJ46BbxyXU,1000i100
2541270,5HDikVWZ2xHfqvVVFwex5zmRsH4LuR3KqMgKZYEbCSjStSKw,moul
2485238,5CQ8T4qpbYJq7uVsxGPQ5q2df7x3Wa4aRY6HUWMBYjfLZhnn,poka
2148409,5CfdJjEgh3jDkg3bzmZ1ED1xVhXAARtNmZJWbcXh53rU8z5a,cgeek (old)
2147878,5CfdJjEgh3jDkg3bzmZ1ED1xVhXAARtNmZJWbcXh53rU8z5a,cgeek (old)
2147358,5CfdJjEgh3jDkg3bzmZ1ED1xVhXAARtNmZJWbcXh53rU8z5a,cgeek (old)
2146830,5CfdJjEgh3jDkg3bzmZ1ED1xVhXAARtNmZJWbcXh53rU8z5a,cgeek (old)
2146305,5CfdJjEgh3jDkg3bzmZ1ED1xVhXAARtNmZJWbcXh53rU8z5a,cgeek (old)
2065429,5D6aqdN9m5uhAsJycKPQra6WqaaxzVb6BptgiY5HsrPkAotL,tuxmain
2064960,5D6aqdN9m5uhAsJycKPQra6WqaaxzVb6BptgiY5HsrPkAotL,tuxmain
2055975,5CfdJjEgh3jDkg3bzmZ1ED1xVhXAARtNmZJWbcXh53rU8z5a,cgeek (old)
2055489,5CfdJjEgh3jDkg3bzmZ1ED1xVhXAARtNmZJWbcXh53rU8z5a,cgeek (old)
1832679,5GBVhdJUdsGhxozu6R8X6x2pTZvuuW46s7JSU4tiW7Zd3WmY,Pini
1832188,5GBVhdJUdsGhxozu6R8X6x2pTZvuuW46s7JSU4tiW7Zd3WmY,Pini
1796923,5HDikVWZ2xHfqvVVFwex5zmRsH4LuR3KqMgKZYEbCSjStSKw,moul
1691419,5CfdJjEgh3jDkg3bzmZ1ED1xVhXAARtNmZJWbcXh53rU8z5a,cgeek (old)
1576831,5HDikVWZ2xHfqvVVFwex5zmRsH4LuR3KqMgKZYEbCSjStSKw,moul
1576290,5HDikVWZ2xHfqvVVFwex5zmRsH4LuR3KqMgKZYEbCSjStSKw,moul
1155122,5HDikVWZ2xHfqvVVFwex5zmRsH4LuR3KqMgKZYEbCSjStSKw,moul
1154574,5HDikVWZ2xHfqvVVFwex5zmRsH4LuR3KqMgKZYEbCSjStSKw,moul
882259,5CfdJjEgh3jDkg3bzmZ1ED1xVhXAARtNmZJWbcXh53rU8z5a,cgeek (old)
881728,5CfdJjEgh3jDkg3bzmZ1ED1xVhXAARtNmZJWbcXh53rU8z5a,cgeek (old)
881182,5CfdJjEgh3jDkg3bzmZ1ED1xVhXAARtNmZJWbcXh53rU8z5a,cgeek (old)
880648,5CfdJjEgh3jDkg3bzmZ1ED1xVhXAARtNmZJWbcXh53rU8z5a,cgeek (old)
880102,5CfdJjEgh3jDkg3bzmZ1ED1xVhXAARtNmZJWbcXh53rU8z5a,cgeek (old)
830444,5HDikVWZ2xHfqvVVFwex5zmRsH4LuR3KqMgKZYEbCSjStSKw,moul
829906,5HDikVWZ2xHfqvVVFwex5zmRsH4LuR3KqMgKZYEbCSjStSKw,moul
820998,5HDikVWZ2xHfqvVVFwex5zmRsH4LuR3KqMgKZYEbCSjStSKw,moul
820466,5HDikVWZ2xHfqvVVFwex5zmRsH4LuR3KqMgKZYEbCSjStSKw,moul
814010,5CfdJjEgh3jDkg3bzmZ1ED1xVhXAARtNmZJWbcXh53rU8z5a,cgeek (old)
813466,5CfdJjEgh3jDkg3bzmZ1ED1xVhXAARtNmZJWbcXh53rU8z5a,cgeek (old)
812936,5CfdJjEgh3jDkg3bzmZ1ED1xVhXAARtNmZJWbcXh53rU8z5a,cgeek (old)
812406,5CfdJjEgh3jDkg3bzmZ1ED1xVhXAARtNmZJWbcXh53rU8z5a,cgeek (old)
778985,5HDikVWZ2xHfqvVVFwex5zmRsH4LuR3KqMgKZYEbCSjStSKw,moul
778442,5HDikVWZ2xHfqvVVFwex5zmRsH4LuR3KqMgKZYEbCSjStSKw,moul
777310,5HDikVWZ2xHfqvVVFwex5zmRsH4LuR3KqMgKZYEbCSjStSKw,moul
776774,5HDikVWZ2xHfqvVVFwex5zmRsH4LuR3KqMgKZYEbCSjStSKw,moul
774505,5HDikVWZ2xHfqvVVFwex5zmRsH4LuR3KqMgKZYEbCSjStSKw,moul
773963,5HDikVWZ2xHfqvVVFwex5zmRsH4LuR3KqMgKZYEbCSjStSKw,moul
746491,5HDikVWZ2xHfqvVVFwex5zmRsH4LuR3KqMgKZYEbCSjStSKw,moul
745956,5HDikVWZ2xHfqvVVFwex5zmRsH4LuR3KqMgKZYEbCSjStSKw,moul
525133,5CfdJjEgh3jDkg3bzmZ1ED1xVhXAARtNmZJWbcXh53rU8z5a,cgeek (old)
384520,5D6aqdN9m5uhAsJycKPQra6WqaaxzVb6BptgiY5HsrPkAotL,tuxmain
1 Like