|
<%#
|
|
name: Subscription - Entitlement Report
|
|
snippet: false
|
|
model: ReportTemplate
|
|
template_inputs:
|
|
- name: Days from Now
|
|
required: true
|
|
input_type: user
|
|
description: "Show subscriptions expiring in <= this many days. Select 'no limit' to show all entitlements."
|
|
advanced: false
|
|
value_type: plain
|
|
options: "no limit\r\n7\r\n30\r\n60\r\n90\r\n120\r\n180"
|
|
require:
|
|
- plugin: katello
|
|
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 (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| -%>
|
|
<%- 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 -%>
|