Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!


Click here to return to the 'List Full Download History of Your Mac ' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
List Full Download History of Your Mac
Authored by: aaronrp on Jul 17, '12 10:43:03AM
It works in 10.6 if you change it slightly, removing the "V*"

sqlite3 ~/Library/Preferences/com.apple.LaunchServices.QuarantineEvents 'select LSQuarantineDataURLString from LSQuarantineEvent'
If you add | uniq after the end, it will present them un-sorted, but with duplicate lines removed (which, in effect, removes all the duplicate blank lines).

[ Reply to This | # ]
Grep or distinct to filter blank lines
Authored by: lullabud on Jul 17, '12 10:58:36AM
I used grep -v '^$' at the end to filter the blanks. Using uniq didn't seem to work. Using select distinct also works.

[ Reply to This | # ]
Grep or distinct to filter blank lines
Authored by: morespace54 on Jul 17, '12 12:28:31PM
Great tip (and the grep bit is a great addition)!
Now I can only wish Apple will keep the Terminal app for a long, long time (I would hate to see it disappear just because 'Average users can screw their computer with it' and because iOS doesn't have such a fine app)...

[ Reply to This | # ]
Grep or distinct to filter blank lines
Authored by: fracai on Jul 19, '12 07:10:33PM
uniq requires the duplicate lines to be consecutive. Otherwise they aren't removed. Another option is sort -u, but that will reorder the list. You could get complicated by printing the date column as well, then radix sort, uniquely on the URL column, and then non-uniquely by the date column.
---
i am jack's amusing sig file


[ Reply to This | # ]