ManageIQ/manageiq-ui-classic

#
# This is an MIQ Report configuration file
#   Single value parameters are specified as:
#     single_value_parm: value
#   Multiple value parameters are specified as:
#     multi_value_parm:
#       - value 1
#       - value 2
#

# Report title
title: Infrastructure Providers

# Menu name
name: EmsInfra

# Main DB table report is based on
db: EmsInfra

# Columns to fetch from the main table
cols:
- name
- hostname
- ipaddress
- emstype_description
- port
- total_hosts
- total_vcpus
- total_memory
- total_storages
- total_vms
- total_miq_templates
- region_description

# Included tables (joined, has_one, has_many) and columns
include:
  zone:
    columns:
    - name
  tenant:
    columns:
    - name

# Included tables and columns for query performance
include_for_find:
  :tags: {}

# Order of columns (from all tables)
col_order:
- name
- hostname
- ipaddress
- emstype_description
- zone.name
- total_hosts
- total_vcpus
- total_memory
- total_storages
- total_vms
- total_miq_templates
- tenant.name
- region_description

# Format of columns
col_formats:
-
-
-
-
-
-
-
- :megabytes_human

# Column titles, in order
headers:
- Name
- Hostname
- Discovered IP Address
- Type
- EVM Zone
- Hosts
- VCores
- Memory
- Datastores
- VMs
- Templates
- Tenant
- Region

col_options:
  tenant.name:
    :display_method: user_super_admin?

# Condition(s) string for the SQL query
conditions:

# Order string for the SQL query
order: Ascending

# Columns to sort the report on, in order
sortby:
- name

# Group rows (y=yes,n=no,c=count)
group: n

# Graph type
#   Bar
#   Column
#   ColumnThreed
#   ParallelThreedColumn
#   Pie
#   PieThreed
#   StackedBar
#   StackedColumn
#   StackedThreedColumn

graph:

# Dimensions of graph (1 or 2)
#   Note: specifying 2 for a single dimension graph may not return expected results
dims: