reporting/reports/data/inventory | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-)
New commits: commit 4dee5b77fc78814901cc0c68eafd0798b1b89754 Author: Tomas Kasparek tkasparek@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 (
spacewalk-commits@lists.fedorahosted.org