Project

General

Profile

« Previous | Next » 

Revision 1c1d5e25

Added by Ian Ballou 7 months ago

Fixes #36826 - Add Host - Installed Products report
  • Add system purpose role and usage to subscriptions entitlement report

View differences:

app/views/unattended/report_templates/subscription_-_entitlement_report.erb
options: "no limit\r\n7\r\n30\r\n60\r\n90\r\n120\r\n180"
require:
- plugin: katello
version: 4.8.0
version: 4.11.0
-%>
<%- days_from_now = input('Days from Now') -%>
<%- days_from_now = "" if days_from_now == 'no limit' -%>
<%- should_filter = days_from_now.present? -%>
<%- report_headers 'Host Name', 'Organization', 'Lifecycle Environment', 'Content View', 'Host Collections', 'Virtual', 'Guest of Host', 'OS', 'Arch', 'Sockets', 'RAM', 'Cores', 'SLA', 'Products', 'Last Checkin', 'Subscription Name', 'Subscription Type', 'Subscription Total Quantity', 'Subscription Total Consumed', 'Subscriptions Consumed by Host', 'Subscription SKU', 'Subscription Contract', 'Subscription Account', 'Subscription Start', 'Subscription End', 'Subscription Guest', 'Days Remaining' -%>
<%- report_headers 'Host Name', 'Organization', 'Lifecycle Environment', 'Content View', 'Host Collections', 'Virtual', 'Guest of Host', 'OS', 'Arch', 'Sockets', 'RAM (MB)', 'Cores', 'SLA', 'Role', 'Usage', 'Release Version', 'Products', 'Last Checkin', 'Subscription Name', 'Subscription Type', 'Subscription Total Quantity', 'Subscription Total Consumed', 'Subscriptions Consumed by Host', 'Subscription SKU', 'Subscription Contract', 'Subscription Account', 'Subscription Start', 'Subscription End', 'Subscription Guest', 'Days Remaining' -%>
<%- load_hosts(includes: [:operatingsystem, :architecture, :content_view_environments, :organization, :reported_data, :subscription_facet, :pools => [:subscription]], -%>
<%- search: should_filter && "pools_expiring_in_days = #{days_from_now}" -%>
<%- ).each_record do |host| -%>
<%- host.pools.expiring_in_days(days_from_now).sort_by { |p| p.end_date }.each do |pool| -%>
<%- report_row(
'Host Name': host.name,
'Organization': host.organization,
'Lifecycle Environment': host.single_lifecycle_environment.name,
'Content View': host.single_content_view.name,
'Host Collections': host_collections_names(host),
'Virtual': host.virtual,
'Guest of Host': host.hypervisor_host,
'OS': host.operatingsystem,
'Arch': host.architecture,
'Sockets': host.sockets,
'RAM': host.ram,
'Cores': host.cores,
'SLA': host_sla(host),
'Products': host_products_names(host),
'Last Checkin': last_checkin(host).to_s,
'Subscription Name': sub_name(pool),
'Subscription Type': pool.type,
'Subscription Total Quantity': pool.quantity,
'Subscription Total Consumed': pool.consumed,
'Subscriptions Consumed by Host': host.filtered_entitlement_quantity_consumed(pool),
'Subscription SKU': sub_sku(pool),
'Subscription Contract': pool.contract_number,
'Subscription Account': pool.account_number,
'Subscription Start': pool.start_date,
'Subscription End': pool.end_date,
'Subscription Guest': registered_through(host),
'Days Remaining': pool.days_until_expiration
) -%>
<%- unless host.organization.simple_content_access? -%>
<%- report_row(
'Host Name': host.name,
'Organization': host.organization,
'Lifecycle Environment': host.single_lifecycle_environment.name,
'Content View': host.single_content_view.name,
'Host Collections': host_collections_names(host),
'Virtual': host.virtual,
'Guest of Host': host.hypervisor_host,
'OS': host.operatingsystem,
'Arch': host.architecture,
'Sockets': host.sockets,
'RAM (MB)': host.ram,
'Cores': host.cores,
'SLA': host_sla(host),
'Role': host.purpose_role,
'Role Status': host.purpose_role_status_label,
'Usage': host.purpose_usage,
'Usage Status': host.purpose_usage_status_label,
'Release Version': host.release_version,
'Products': host_products_names(host),
'Last Checkin': last_checkin(host).to_s,
'Subscription Name': sub_name(pool),
'Subscription Type': pool.type,
'Subscription Total Quantity': pool.quantity,
'Subscription Total Consumed': pool.consumed,
'Subscriptions Consumed by Host': host.filtered_entitlement_quantity_consumed(pool),
'Subscription SKU': sub_sku(pool),
'Subscription Contract': pool.contract_number,
'Subscription Account': pool.account_number,
'Subscription Start': pool.start_date,
'Subscription End': pool.end_date,
'Subscription Guest': registered_through(host),
'Days Remaining': pool.days_until_expiration
) -%>
<%- end -%>
<%- end -%>
<%- end -%>
<%= report_render -%>

Also available in: Unified diff