After looking at the zmprov output a bit, I realized that it output more of the sticky notes
than what I thought. The grep prevented me from seeing it as the output does not contain
com_zimbra_stickynotes on each line.
With that out of the way, there is some definite weirdness going on.
The user has 11 messages that still have functioning stickynotes.
Zmprov outputs 11 lines of stickynotes.
I emphasized lines because those 11 lines contain at least 14 stickynotes. Where most
of the lines look like:
One looks like:
:=:__id::MSG22050,__data::Some random note.
That particular user should have 43 notes in all. I will take a look at what is in mysql in a bit.
:=:__id::MSG14184,__data::Another note. :=:__id::MSG20963,__data::Yet another note. :=:__id::MSG21916,__data::Still another note.:=:__id::MSG22040,__data::And, one more note.