Checksysreport.

You will find below some tools that use the rhn api. They are supposed to be helpfull for people involved in supporting RHEL machines.

checksysreport
(rpm, src.rpm )
This packages includes a script that generates automatic reports based on a Red Hat Enterprise Linux sysreport (or sosreport) archive. It helps you detect third party rpm, third party kernel modules and list bugzilla and changelogs entry related to known bugs that are fixed in the updated version of packages installed on the system.
A sample output may be found here.
There is also a graphical tool (yadarh) that let you browse rhn packages and compare fixed bugzilla and changelogs between releases:

You will need a valid rhn login as well as an access to a checksysreport server to use checksysreport. The server stores rhn related information in a postgresql database that can be used by both checksysreport and yadarh.It also comes with a web page that let user post sysreport archives from a web browser and receive result by mail.
Some notes about the server:
(rpm)
The server rpm has been tested on RHEL5 and RHEL4 (with access to the rhel-i386-es-4-appstk-1 channel as you will need php5).
Dependencies: postgresql-server,php,php-pgsql,httpd,threadpool
Threadpool is python module not shipped by Red Hat, nor packaged in Fedora.
You may find here the source rpm, as well as the binary for RHEL4 and RHEL5.
Once checksysreport-server is installed, follow the instruction in /usr/share/doc/checksysreport-server-1.0/README.server .
Be sure postgresql is started up when doing so, or it will fail.

Maintenance tasks such as cache refreshing and database access should be done under the checksysreport user (except for dump-and-restore.sh that should be run as root).
The following tools should be launch regularly:
- fill-cache-packages
  This update the list of existing package from rhn to the local database. You may want to play with the poolSize variable to set how many concurrent thread are used to fetch data from rhn. There is no need to set it too high as there is a bottleneck afterward when feeding all the data in the database anyway.
- fill-cache-advisory
  This update the list of advisroy released, associated bugs and packages. Here too, have a try changing poolSize to see if it s more effective for your available bandwith.
- wcs
  This script handle the requests made by the web form, launch checksysreport and send the result to the requestor.
- dump-and-restore.sh This script should be run as root and is a simple dump of the database, followed by a drop , a recreation of the database, and the reinjection of the same data. It may sounds useless, but it saves _huge_ amount of diskspace in a couple of minutes. Do this as soon as the database starts to be a bit tool large for your machine. Launching regularly a 'vacuum analyse' in checksysreportdb as the checksysreport (or postgres) user may help reducing the speed at wich the database size grows.
The rpms are signed with the following gpg key (Key fingerprint = 1610 E221 3D01 0E3A 1F7C 7737 4C2C 7675 663E 94A1)
fastrackme is a script to be launched as root to subscribe a running system to all available fastrack channels.
listSystems is a sample python script that prompt for a login and a password before listing rhn systems for this account as well as their base channel.
diff-updates is a script that show a list of bugzilla fixes and new changelog entry between 2 RHEL updates. You will have to prepare some files with the udpates iso you are interested in first and have a working checksyreport installation before using this script.