backend/satellite_tools/reports/data/inventory | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)
New commits: commit 5d9956ad502c6e2e96e6b921b954687638a5f787 Author: Jan Pazdziora jpazdziora@redhat.com Date: Fri Oct 23 11:19:10 2009 +0200
reporting: no need to use view which joins back to rhnErrata.
diff --git a/backend/satellite_tools/reports/data/inventory b/backend/satellite_tools/reports/data/inventory index fe75a2c..60af329 100755 --- a/backend/satellite_tools/reports/data/inventory +++ b/backend/satellite_tools/reports/data/inventory @@ -40,7 +40,7 @@ sql: ( 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, + ( select count(*) from rhnServerNeededErrataCache where rhnserver.id = server_id ) as errata_out_of_date, rhnchannel.name as software_channel, rhnconfigchannel.name as configuration_channel, entitlement_data.name as entitlements,
spacewalk-commits@lists.fedorahosted.org