product/views/Service.yaml
#
# 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: Services
# Menu name
name: Service
# Main DB table report is based on
db: Service
db_options:
:use_sql_view: true
# Columns to fetch from the main table
cols:
- name
- description
- Type
- Retired
- created_at
- v_total_vms
- aggregate_all_vm_cpus
- aggregate_all_vm_memory
- aggregate_all_vm_disk_count
- aggregate_all_vm_disk_space_allocated
- aggregate_all_vm_disk_space_used
- aggregate_all_vm_memory_on_disk
# Included tables (joined, has_one, has_many) and columns
include:
service_template:
include:
picture:
columns:
- id
# Order of columns (from all tables)
col_order:
- name
- description
- type
- retired
- created_at
- v_total_vms
- aggregate_all_vm_cpus
- aggregate_all_vm_memory
- aggregate_all_vm_disk_count
- aggregate_all_vm_disk_space_allocated
- aggregate_all_vm_disk_space_used
- aggregate_all_vm_memory_on_disk
# Column titles, in order
headers:
- Name
- Description
- Type
- Retired
- Created On
- Total VMs
- Total CPUs
- Total Memory
- Total VM Disk Count
- Total VM Disk Space Allocated
- Total VM Disk Space Used
- Total VM Memory on Disk
# 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: