packages by apt installed times and dates

fakie_flip · 10-04-2006, 09:41 PM

I am trying to figure out how to sort the packages installed by apt-get in order and showing the time it was installed or downloaded. I looked at the man pages, and I was not sure about many things. Here is what I tried. The packages are not sorted in order by time, but some are.

Code:

debian:/var/cache/apt/archives# ls -cl
total 10936
-rw-r--r-- 1 root root  103572 2006-10-01 12:49 alien_8.64_all.deb
-rw-r--r-- 1 root root  508216 2006-10-01 12:47 debhelper_5.0.37.3_all.deb
-rw-r--r-- 1 root root 1790392 2006-10-01 12:47 gettext_0.14.6-1_i386.deb
-rw-r--r-- 1 root root   98902 2006-10-01 12:46 html2text_1.3.2a-3_i386.deb
-rw-r--r-- 1 root root   31418 2006-10-01 12:47 intltool-debian_0.35.0+20060710_all.deb
-rw-r--r-- 1 root root 1059950 2006-10-01 13:34 irssi_0.8.10-2_i386.deb
-rw-r--r-- 1 root root  107906 2006-10-01 12:48 libbeecrypt6_4.1.2-6_i386.deb
-rw-r--r-- 1 root root   15308 2006-10-01 13:23 libfontenc-dev_1%3a1.0.2-2_i386.deb-rw-r--r-- 1 root root  641552 2006-10-01 13:23 libfreetype6-dev_2.2.1-5_i386.deb
-rw-r--r-- 1 root root   55534 2006-10-01 12:57 libgl1-mesa-dev_6.5.0.cvs.20060524-1.1_i386.deb
-rw-r--r-- 1 root root   80382 2006-10-01 12:57 libglitz1_0.5.6-1_i386.deb
-rw-r--r-- 1 root root   89800 2006-10-01 12:57 libglitz1-dev_0.5.6-1_i386.deb
-rw-r--r-- 1 root root   30190 2006-10-01 12:57 libglitz-glx1_0.5.6-1_i386.deb
-rw-r--r-- 1 root root   31312 2006-10-01 12:57 libglitz-glx1-dev_0.5.6-1_i386.deb
-rw-r--r-- 1 root root     840 2006-10-01 12:56 libpng3_1.2.8rel-5.2_all.deb
-rw-r--r-- 1 root root  977534 2006-10-01 12:48 librpm4_4.4.1-10_i386.deb
-rw-r--r-- 1 root root 1177112 2006-10-01 12:57 libx11-dev_2%3a1.0.0-9_i386.deb
-rw-r--r-- 1 root root   10334 2006-10-01 12:56 libxau-dev_1%3a1.0.0-4_i386.deb
-rw-r--r-- 1 root root    5550 2006-10-01 12:56 libxcomposite1_1%3a0.2.2.2-3_i386.deb
-rw-r--r-- 1 root root   13844 2006-10-01 12:56 libxdmcp-dev_1%3a1.0.1-2_i386.deb
-rw-r--r-- 1 root root   74906 2006-10-01 12:57 libxext-dev_1%3a1.0.1-2_i386.deb
-rw-r--r-- 1 root root  284388 2006-10-01 13:23 libxfont-dev_1%3a1.2.2-1_i386.deb
-rw-r--r-- 1 root root 2075362 2006-10-01 13:29 links2_2.1pre23-1_i386.deb
-rw-r----- 1 root root       0 2006-10-04 20:16 lock
-rw-r--r-- 1 root root  177540 2006-10-01 12:57 mesa-common-dev_6.5.0.cvs.20060524-1.1_all.deb
drwxr-xr-x 2 root root    4096 2006-10-01 13:34 partial
-rw-r--r-- 1 root root  108878 2006-10-01 12:47 po-debconf_1.0.5_all.deb
-rw-r--r-- 1 root root  829250 2006-10-01 12:49 rpm_4.4.1-10_i386.deb
-rw-r--r-- 1 root root   78446 2006-10-01 12:56 x11proto-core-dev_7.0.7-2_all.deb
-rw-r--r-- 1 root root   12060 2006-10-01 13:23 x11proto-fonts-dev_2.0.2-5_all.deb
-rw-r--r-- 1 root root   14644 2006-10-01 12:56 x11proto-input-dev_1.3.2-4_all.deb
-rw-r--r-- 1 root root   26774 2006-10-01 12:56 x11proto-kb-dev_1.0.3-2_all.deb
-rw-r--r-- 1 root root   41732 2006-10-01 12:56 x11proto-xext-dev_7.0.2-5_all.deb
-rw-r--r-- 1 root root   12650 2006-10-01 12:57 xlibmesa-gl-dev_1%3a7.0.22_all.deb
-rw-r--r-- 1 root root   58906 2006-10-01 12:56 xtrans-dev_1.0.1-2_all.deb
-rw-r--r-- 1 root root  406222 2006-10-01 13:23 zlib1g-dev_1%3a1.2.3-13_i386.deb
debian:/var/cache/apt/archives#

I have had my system installed for about a month, so there is no way I could have downloaded one of these packages in 2005. These dates must be the times the packages were put in the repositories or created.

Code:

debian:/var/cache/apt/archives# ls -tl
total 11052
drwxr-xr-x 2 root root    4096 2006-10-04 21:24 partial
-rw-r----- 1 root root       0 2006-10-04 21:24 lock
-rw-r--r-- 1 root root   55534 2006-09-18 01:02 libgl1-mesa-dev_6.5.0.cvs.20060524-1.1_i386.deb
-rw-r--r-- 1 root root  177540 2006-09-18 01:02 mesa-common-dev_6.5.0.cvs.20060524-1.1_all.deb
-rw-r--r-- 1 root root   12060 2006-09-17 08:32 x11proto-fonts-dev_2.0.2-5_all.deb
-rw-r--r-- 1 root root  114582 2006-09-17 08:17 sasl2-bin_2.1.19.dfsg1-0.5_i386.deb-rw-r--r-- 1 root root 1177112 2006-09-13 19:02 libx11-dev_2%3a1.0.0-9_i386.deb
-rw-r--r-- 1 root root  284388 2006-09-13 03:17 libxfont-dev_1%3a1.2.2-1_i386.deb
-rw-r--r-- 1 root root  641552 2006-09-12 17:47 libfreetype6-dev_2.2.1-5_i386.deb
-rw-r--r-- 1 root root   15308 2006-08-29 19:47 libfontenc-dev_1%3a1.0.2-2_i386.deb-rw-r--r-- 1 root root   13844 2006-08-29 19:32 libxdmcp-dev_1%3a1.0.1-2_i386.deb
-rw-r--r-- 1 root root   58906 2006-08-28 20:47 xtrans-dev_1.0.1-2_all.deb
-rw-r--r-- 1 root root   74906 2006-08-26 17:32 libxext-dev_1%3a1.0.1-2_i386.deb
-rw-r--r-- 1 root root   78446 2006-08-21 20:47 x11proto-core-dev_7.0.7-2_all.deb
-rw-r--r-- 1 root root   26774 2006-08-21 20:32 x11proto-kb-dev_1.0.3-2_all.deb
-rw-r--r-- 1 root root   10334 2006-08-14 16:18 libxau-dev_1%3a1.0.0-4_i386.deb
-rw-r--r-- 1 root root  977534 2006-08-09 05:47 librpm4_4.4.1-10_i386.deb
-rw-r--r-- 1 root root  829250 2006-08-09 05:47 rpm_4.4.1-10_i386.deb
-rw-r--r-- 1 root root  107906 2006-08-09 00:32 libbeecrypt6_4.1.2-6_i386.deb
-rw-r--r-- 1 root root 2075362 2006-08-04 04:03 links2_2.1pre23-1_i386.deb
-rw-r--r-- 1 root root   41732 2006-07-21 03:47 x11proto-xext-dev_7.0.2-5_all.deb
-rw-r--r-- 1 root root   14644 2006-07-21 03:47 x11proto-input-dev_1.3.2-4_all.deb
-rw-r--r-- 1 root root     840 2006-07-16 09:32 libpng3_1.2.8rel-5.2_all.deb
-rw-r--r-- 1 root root   31418 2006-07-10 16:26 intltool-debian_0.35.0+20060710_all.deb
-rw-r--r-- 1 root root  508216 2006-07-10 16:17 debhelper_5.0.37.3_all.deb
-rw-r--r-- 1 root root  406222 2006-07-08 04:47 zlib1g-dev_1%3a1.2.3-13_i386.deb
-rw-r--r-- 1 root root  108878 2006-06-27 12:47 po-debconf_1.0.5_all.deb
-rw-r--r-- 1 root root 1790392 2006-06-23 12:47 gettext_0.14.6-1_i386.deb
-rw-r--r-- 1 root root   80382 2006-06-13 00:47 libglitz1_0.5.6-1_i386.deb
-rw-r--r-- 1 root root   89800 2006-06-13 00:47 libglitz1-dev_0.5.6-1_i386.deb
-rw-r--r-- 1 root root   30190 2006-06-13 00:47 libglitz-glx1_0.5.6-1_i386.deb
-rw-r--r-- 1 root root   31312 2006-06-13 00:47 libglitz-glx1-dev_0.5.6-1_i386.deb
-rw-r--r-- 1 root root   12650 2006-06-11 23:02 xlibmesa-gl-dev_1%3a7.0.22_all.deb
-rw-r--r-- 1 root root    5550 2006-04-19 06:32 libxcomposite1_1%3a0.2.2.2-3_i386.deb
-rw-r--r-- 1 root root 1059950 2006-04-17 08:17 irssi_0.8.10-2_i386.deb
-rw-r--r-- 1 root root  103572 2006-03-30 12:02 alien_8.64_all.deb
-rw-r--r-- 1 root root   98902 2005-09-13 16:02 html2text_1.3.2a-3_i386.deb
debian:/var/cache/apt/archives#

I realize I could also look at /var/log/dpkg.log, but it is hard to read for what I am trying to do.

farslayer · 10-04-2006, 10:47 PM

not sure exactly what you are trying to do but you might want to look at apt-history
http://developer.berlios.de/projects/apt-history/

or apt-listchanges
http://packages.debian.org/unstable/...pt-listchanges

or try
grep "<none>" /var/log/dpkg.log

funny thing is my dpkg.log was empty I had to run this on dpkg.log.1 but the dates look correct for when I installed/updated the packages..

an interesting list of apt utilities is here http://www.linux.com/article.pl?sid=06/07/19/1510245 also where I found the grep command for the dpkg.log

fakie_flip · 10-05-2006, 09:24 AM

I found what I was looking for. I had overlooked it before.

Code:

ls -lu /var/cache/apt/archives

By looking at the times the packages were installed, I can see what was installed together, so that I know what I want to remove. A bad script ran on my computer and caused things to stop working when I tried installing XGL .

I will look at those programs that you gave. I've been wanting something like that for a while. Synaptic shows history, but it should be easier to remove all of those packages to undo what was done. I want to remove the old depenedencies that are not being used anymore. Thanks.