dugost wrote:
I did find the db file there and went through the tables. I didn't find any useable info though. That is, I didn't see any readable text that matches up with notifications currently being displayed or those previously displayed.
You can get the text out of the sqllite db by using the 'strings' command in Terminal.**
If you have the strings utility just type strings, a space, and then drag the database file from a Finder window into Terminal (you may have more than one, see below). Click in the window and type a pipe and open -f, like this
strings <drag the Sql db file here> | open -f
then hit 'return'. In Text Edit (assuming that's what opens as the default editor), hit 'command-F' and type NSInformativeText. Use 'command-G' to cycle through the notifications (many will be meaningless application or system notifications without text, and be warned there'll be lots of them). Use 'shift-command-G' to go backwards through the search.
If you're comfortable with Terminal and you know what you're looking for, you can also pipe that 'strings' command through 'grep' and do other text-based operations on it (eg. with sed). Otherwise, just use the 'find' command in your text editor.
If you have more than one notifications db, you may want to concatenate them before searching. You can do that with
strings <first database file> >> ~/Desktop/notificationsLog.txt ; strings <second database file> >> ~/Desktop/notificationsLog.txt
(repeat as required with a semi-colon between each before hitting 'return'). In this scenario, the file won't open automatically, but you'll find it on your Desktop.
**nb. you may have to have Xcode's command line tools installed to have the 'strings' utility, I'm not sure; test by doing 'man strings' and see whether it returns an error.