backend/satellite_tools/reports/data/inventory | 7 ++++++- 1 file changed, 6 insertions(+), 1 deletion(-)
New commits: commit d601eb82e67ca34a7ba8a784cfcf43f3c9cb5d93 Author: Jan Pazdziora jpazdziora@redhat.com Date: Thu Jul 23 14:50:26 2009 +0200
reporting: add number of out-of-date packages and errata.
diff --git a/backend/satellite_tools/reports/data/inventory b/backend/satellite_tools/reports/data/inventory index 2483419..304a70b 100755 --- a/backend/satellite_tools/reports/data/inventory +++ b/backend/satellite_tools/reports/data/inventory @@ -4,7 +4,11 @@ ( select login from web_contact where rhnserver.creator_id = web_contact.id ) as registered_by, to_char(rhnserver.created, 'YYYY-MM-DD HH24:MI:SS') as registration_time, ( select to_char(checkin, 'YYYY-MM-DD HH24:MI:SS') from rhnserverinfo where rhnserver.id = server_id ) as last_checkin_time, - running_kernel as kernel_version + running_kernel as kernel_version, + ( select count(distinct rhnpackage.name_id) from rhnpackage, rhnserverneededpackagecache + where rhnserver.id = rhnserverneededpackagecache.server_id + and rhnserverneededpackagecache.package_id = rhnpackage.id ) as packages_out_of_date, + ( select count(*) from rhnServerErrataTypeView where rhnserver.id = server_id ) as errata_out_of_date from rhnserver, ( select server_id, hostname, ipaddr
commit f80bc201023ff87ef282c723e640377ae4f8df0f Author: Jan Pazdziora jpazdziora@redhat.com Date: Thu Jul 23 14:49:25 2009 +0200
reporting: add kernel version to the report.
diff --git a/backend/satellite_tools/reports/data/inventory b/backend/satellite_tools/reports/data/inventory index 3d33ad5..2483419 100755 --- a/backend/satellite_tools/reports/data/inventory +++ b/backend/satellite_tools/reports/data/inventory @@ -3,7 +3,8 @@ rhnservernetwork.hostname, trim(rhnservernetwork.ipaddr) as ip_address, ( select login from web_contact where rhnserver.creator_id = web_contact.id ) as registered_by, to_char(rhnserver.created, 'YYYY-MM-DD HH24:MI:SS') as registration_time, - ( select to_char(checkin, 'YYYY-MM-DD HH24:MI:SS') from rhnserverinfo where rhnserver.id = server_id ) as last_checkin_time + ( select to_char(checkin, 'YYYY-MM-DD HH24:MI:SS') from rhnserverinfo where rhnserver.id = server_id ) as last_checkin_time, + running_kernel as kernel_version from rhnserver, ( select server_id, hostname, ipaddr
spacewalk-commits@lists.fedorahosted.org