Take a look at the readme in the new D9 release (released today). Download as always here.That I get. One thing comes to mind though. Tickets in the ticket.db have unique ID attached to them, even though you can't install them as CIA unless that unique IS is changed to zeros.
I think that even clean .db might have some tickets with unique ID attached to it from preloaded stuff (such as that dinosaur 3d video?). I know preloaded games do have zeros as IDs, but I don't think that's the case with everything.
My question is, assume the following case:
2 3ds (same region/type)
First 3DS, unique ID AAAAAA .. Clean otherwise
Second 3DS, unique ID BBBBBB .. Filled with shit we want to get rid off
So assume I dump .db from 1st 3ds and inject it to the second.. Won't the ticket ID from the first 3ds remain in the second? And then, if we download from eshop, we will have entries on our tickets mixed of AAAAAA and BBBBBB?
Not effectively clean I suppose..?
What you want to do is dump all tickets from the clean one and check (by the naming scheme) for console ids.