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: hamarkus on Jul 17, '12 03:37:09PM

Any idea when this database was first created? I would guess when this 'downloaded bit' was first introduced, ie, with Leopard. But it quite likely might have had its form changed along the way and thus the current version might be much younger (and thus go not back that far).



[ Reply to This | # ]
Re: List Full Download History of Your Mac
Authored by: Uncle Asad on Jul 18, '12 02:02:06PM
On 10.5.8, appending | wc -l to the sqlite3 command gives me 10532; I'm certain I've downloaded more than 10K items in LSFileQuarantineEnabled applications since fall of 2007. So the db must roll over/be purged periodically even within major versions, regardless of what the across-OS-versions behavior is.

[ Reply to This | # ]
List Full Download History of Your Mac
Authored by: fracai on Jul 19, '12 07:12:16PM

There are other columns in the database and one of them looks to be a unix time stamp (seconds from the epoch). I already blew mine away, but you could print the whole table and look at that field.

---
i am jack's amusing sig file



[ Reply to This | # ]