the resource IDs would not necessarily be in the description of the event. so can you select from event where type like 'VOLUME.*' and see if anything is out there? "VOLUME.CREATE" is expected to be matched by "VOLUME.DELETE", "VOLUME.ATTACH" by "VOLUME.DETACH", etc.
On Fri, May 18, 2018 at 1:03 PM, Melanie Desaive < [email protected]> wrote: > Hi Daan, > > Am 18.05.2018 um 10:28 schrieb Daan Hoogland: > > > It seems that only 5 of those volumes should have been > > reported between the 16th and the 16th, correct? Can you query for events > > for those volumes in the event table? By the order of events we might be > > able to draw some conclusions. > > You asked for a query like the following? > > mysql> select description from event where description like '%2222%' or > description like '%2420%' or description like '%2567%' or description > like '%2719%' or description like '%2920%' or description like '%2528%' > or description like '%2809%' or description like '%2243%' or description > like '%2505%' or description like '%2396%' or description like '%3696%' > or description like '%2239%' or description like '%3174%' or description > like '%3675%' or description like '%2172%' or description like '%2225%' > or description like '%2223%' or description like '%3255%'; > Empty set (0.10 sec) > > This did not return any records. :( > > Or do you ask for a different kind of information? > > Greetings, > > Melanie > -- > -- > > Heinlein Support GmbH > Linux: Akademie - Support - Hosting > > http://www.heinlein-support.de > Tel: 030 / 40 50 51 - 0 > Fax: 030 / 40 50 51 - 19 > > Zwangsangaben lt. §35a GmbHG: > HRB 93818 B / Amtsgericht Berlin-Charlottenburg, > Geschäftsführer: Peer Heinlein -- Sitz: Berlin > > -- Daan
