reporting/reports/data/inventory | 4 +++-
1 file changed, 3 insertions(+), 1 deletion(-)
New commits:
commit 4dee5b77fc78814901cc0c68eafd0798b1b89754
Author: Tomas Kasparek <tkasparek(a)redhat.com>
Date: Mon Jan 28 15:00:59 2013 +0100
237581 - OSAD status report
diff --git a/reporting/reports/data/inventory b/reporting/reports/data/inventory
index 3862c8a..6ec3185 100755
--- a/reporting/reports/data/inventory
+++ b/reporting/reports/data/inventory
@@ -29,6 +29,7 @@ columns:
virtual_host:i System identifier of host, if system is a guest
architecture Architecture of the system
is_virtualized Information whether system is virtualized or not
+ osad_status OSAD status
hardware Hardware information
multival_columns:
@@ -46,7 +47,7 @@ sql:
registration_time, last_checkin_time, kernel_version,
packages_out_of_date, errata_out_of_date,
software_channel, configuration_channel,
- entitlements, system_group, organization, virtual_host, architecture, is_virtualized,
hardware
+ entitlements, system_group, organization, virtual_host, architecture, is_virtualized,
osad_status, hardware
from (
select rhnserver.id as server_id, rhnserver.name as profile_name,
rhnservernetwork.hostname, trim(rhnservernetwork.ipaddr) as ip_address,
@@ -77,6 +78,7 @@ sql:
) as architecture,
(case when (select rhnVirtualInstance.virtual_system_id from rhnVirtualInstance where
rhnVirtualInstance.virtual_system_id=rhnserver.id) is null then 'No' else
'Yes' end
) as is_virtualized,
+ (nvl((select rhnpushclientstate.label from rhnpushclient join rhnpushclientstate on
rhnpushclient.state_id=rhnpushclientstate.id where rhnpushclient.server_id=rhnServer.id),
'Not enabled')) as osad_status,
get_hw_info_as_clob(rhnserver.id, '; ') as hardware
from rhnserver left outer join
(
Show replies by date