reporting/reports/data/inventory | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
New commits:
commit 794500f707bddf9c29675ca4ad54cf91bed1c367
Author: Tomas Kasparek <tkasparek(a)redhat.com>
Date: Tue Jun 11 13:24:31 2013 +0200
963754 - inventory report should now display correct number of errata
diff --git a/reporting/reports/data/inventory b/reporting/reports/data/inventory
index 6ec3185..09d54fa 100644
--- a/reporting/reports/data/inventory
+++ b/reporting/reports/data/inventory
@@ -59,7 +59,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 rhnServerNeededErrataCache where rhnserver.id = server_id ) as
errata_out_of_date,
+ ( select count(*) from rhnServerNeededErrataCache where rhnserver.id = server_id and
errata_id is not null) as errata_out_of_date,
rhnchannel.name as software_channel,
rhnchannel.parent_channel as parent_channel,
rhnchannel.id as channel_id,
Show replies by date