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