[rhn-users] How to find out which packeges have been installed during last system update ?

[Jesse Becker]

On Mon, Feb 07, 2005 at 09:23:31AM +0300, Jamal S. Albadia(???? ??????) wrote:
> I have selected three packages to be updated during the last system update via RHN.
> Now I need to know which three packages have been installed during last time the system was updated?

I don't know of a specific way to identify updates in the sense of a
"transaction" (to pull in a database term), but if you know the approximate time the
update was done, you can dump the RPM database, and search that.  Note that
the grep/awk line is one long pipe.

	# rpm -qai > rpm_info.txt
	# grep -C 3 '08 Feb 2005' rpm_info.txt | awk '/^Name/{printf "%s:\t",$3} /^Install/{print $3,$4,$5,$6,$7,$8,$9}'
	krb5-libs:      Tue 08 Feb 2005 06:42:52 PM CST
	rh-postgresql-libs:     Tue 08 Feb 2005 06:44:00 PM CST
	glibc-utils:    Tue 08 Feb 2005 06:46:38 PM CST
	XFree86-Mesa-libGL:     Tue 08 Feb 2005 06:49:30 PM CST
	XFree86-tools:  Tue 08 Feb 2005 06:50:08 PM CST
	xscreensaver:   Tue 08 Feb 2005 06:52:36 PM CST

There is also a "--last" option to newish versions of rpm(8).  For example:

	# rpm -qa --last | more
	ethereal-gnome-0.10.9-1.EL3.1         Tue 08 Feb 2005 07:29:16 PM CST
	ethereal-0.10.9-1.EL3.1               Tue 08 Feb 2005 07:29:14 PM CST
	perl-DBI-1.32-9                       Tue 08 Feb 2005 07:28:47 PM CST
	enscript-1.6.1-24.4                   Tue 08 Feb 2005 07:28:24 PM CST
	less-378-12                           Tue 08 Feb 2005 07:28:07 PM CST


-- 
Jesse Becker
GPG-fingerprint: BD00 7AA4 4483 AFCC 82D0  2720 0083 0931 9A2B 06A2
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://listman.redhat.com/archives/rhn-users/attachments/20050210/81f3a88b/attachment.sig>