Yaniv Dary has uploaded a new change for review. Change subject: reports: added single vm uptime br46 (#862019) ......................................................................
reports: added single vm uptime br46 (#862019) This report contains one gauge displaying the weighted average uptime of a single selected VM for a requested period. Bug-Url: https://bugzilla.redhat.com/862019 Change-Id: I50951e7380be136162bb2beb86ec0ed4bbe46d1e Signed-off-by: Yaniv Dary <yd...@redhat.com> --- M reports/repository_files/resources/Reports/Service_level/VMs/.folder.xml A reports/repository_files/resources/Reports/Service_level/VMs/single_vm_uptime_br46.xml A reports/repository_files/resources/Reports/Service_level/VMs/single_vm_uptime_br46_files/full details.jrxml.data A reports/repository_files/resources/Reports/Service_level/VMs/single_vm_uptime_br46_files/single_vm_uptime_br46_jrxml.data M reports/repository_files/resources/reports_resources/localization/ovirt_reports_bundle_en_US.properties.data 5 files changed, 746 insertions(+), 0 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-reports refs/changes/34/10234/1 diff --git a/reports/repository_files/resources/Reports/Service_level/VMs/.folder.xml b/reports/repository_files/resources/Reports/Service_level/VMs/.folder.xml index 0e94cdc..62e8619 100644 --- a/reports/repository_files/resources/Reports/Service_level/VMs/.folder.xml +++ b/reports/repository_files/resources/Reports/Service_level/VMs/.folder.xml @@ -7,4 +7,5 @@ <updateDate>2011-06-20T17:29:08.000+03:00</updateDate> <resource>cluster_quality_of_service_vms_br13</resource> <resource>virtual_servers_uptime_br14</resource> + <resource>single_vm_uptime_br46</resource> </folder> diff --git a/reports/repository_files/resources/Reports/Service_level/VMs/single_vm_uptime_br46.xml b/reports/repository_files/resources/Reports/Service_level/VMs/single_vm_uptime_br46.xml new file mode 100644 index 0000000..a1a96ab --- /dev/null +++ b/reports/repository_files/resources/Reports/Service_level/VMs/single_vm_uptime_br46.xml @@ -0,0 +1,196 @@ +<?xml version="1.0" encoding="UTF-8"?> +<reportUnit> + <folder>/Reports/Service_level/VMs</folder> + <name>single_vm_uptime_br46</name> + <version>16</version> + <label>Single Virtual Machine Uptime (BR46)</label> + <description>This report contains one gauge displaying the weighted average uptime of a single selected VM for a requested period.</description> + <creationDate>2012-12-19T14:11:38.919+02:00</creationDate> + <updateDate>2012-12-19T14:45:04.146+02:00</updateDate> + <mainReport> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; + dataFile="single_vm_uptime_br46_jrxml.data" xsi:type="fileResource"> + <folder>/Reports/Service_level/VMs/single_vm_uptime_br46_files</folder> + <name>single_vm_uptime_br46_jrxml</name> + <version>4</version> + <label>Main jrxml</label> + <description>Main jrxml</description> + <creationDate>2012-12-19T14:11:38.919+02:00</creationDate> + <updateDate>2012-12-19T14:11:38.919+02:00</updateDate> + <fileType>jrxml</fileType> + </localResource> + </mainReport> + <dataSource> + <uri>/reports_resources/JDBC/data_sources/ovirt</uri> + </dataSource> + <inputControl> + <uri>/reports_resources/JDBC/Input_Controls/Period_Affected/non-query_IC/is_deleted</uri> + </inputControl> + <inputControl> + <uri>/reports_resources/JDBC/Input_Controls/Period_Affected/non-query_IC/P_Period</uri> + </inputControl> + <inputControl> + <uri>/reports_resources/JDBC/Input_Controls/Period_Affected/non-query_IC/P_Start_Date</uri> + </inputControl> + <inputControl> + <uri>/reports_resources/JDBC/Input_Controls/Period_Affected/single_select/datacenter_ic/all_dcs_with_vms/P_DataCenter_ID</uri> + </inputControl> + <inputControl> + <uri>/reports_resources/JDBC/Input_Controls/Period_Affected/single_select/cluster_ic/all_cluster_with_vms/P_Cluster_ID</uri> + </inputControl> + <inputControl> + <uri>/reports_resources/JDBC/Input_Controls/Period_Affected/single_select/vm_ic/P_VM_Type</uri> + </inputControl> + <inputControl> + <uri>/reports_resources/JDBC/Input_Controls/Period_Affected/single_select/vm_ic/P_VM_ID</uri> + </inputControl> + <resource> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; + dataFile="full details.jrxml.data" xsi:type="fileResource"> + <folder>/Reports/Service_level/VMs/single_vm_uptime_br46_files</folder> + <name>full details.jrxml</name> + <version>3</version> + <label>full details.jrxml</label> + <creationDate>2012-12-19T14:11:38.919+02:00</creationDate> + <updateDate>2012-12-19T14:11:38.919+02:00</updateDate> + <fileType>jrxml</fileType> + </localResource> + </resource> + <resource> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:type="fileResource"> + <folder>/Reports/Service_level/VMs/single_vm_uptime_br46_files</folder> + <name>ovirt-icon</name> + <version>0</version> + <label>ovirt-icon</label> + <creationDate>2012-12-19T14:11:38.919+02:00</creationDate> + <updateDate>2012-12-19T14:11:38.919+02:00</updateDate> + <referenceUri>/reports_resources/ovirt-icon</referenceUri> + </localResource> + </resource> + <resource> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:type="fileResource"> + <folder>/Reports/Service_level/VMs/single_vm_uptime_br46_files</folder> + <name>trash-icon</name> + <version>0</version> + <label>trash-icon</label> + <creationDate>2012-12-19T14:11:38.919+02:00</creationDate> + <updateDate>2012-12-19T14:11:38.919+02:00</updateDate> + <referenceUri>/reports_resources/trash-icon</referenceUri> + </localResource> + </resource> + <resource> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:type="fileResource"> + <folder>/Reports/Service_level/VMs/single_vm_uptime_br46_files</folder> + <name>ovirt_reports_bundle.properties</name> + <version>0</version> + <label>ovirt_reports_bundle.properties</label> + <creationDate>2012-12-19T14:11:38.919+02:00</creationDate> + <updateDate>2012-12-19T14:11:38.919+02:00</updateDate> + <referenceUri>/reports_resources/localization/ovirt_reports_bundle.properties</referenceUri> + </localResource> + </resource> + <resource> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:type="fileResource"> + <folder>/Reports/Service_level/VMs/single_vm_uptime_br46_files</folder> + <name>ovirt_reports_bundle_de.properties</name> + <version>0</version> + <label>ovirt_reports_bundle_de.properties</label> + <creationDate>2012-12-19T14:11:38.919+02:00</creationDate> + <updateDate>2012-12-19T14:11:38.919+02:00</updateDate> + <referenceUri>/reports_resources/localization/ovirt_reports_bundle_de.properties</referenceUri> + </localResource> + </resource> + <resource> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:type="fileResource"> + <folder>/Reports/Service_level/VMs/single_vm_uptime_br46_files</folder> + <name>ovirt_reports_bundle_en_US.properties</name> + <version>0</version> + <label>ovirt_reports_bundle_en_US.properties</label> + <creationDate>2012-12-19T14:11:38.919+02:00</creationDate> + <updateDate>2012-12-19T14:11:38.919+02:00</updateDate> + <referenceUri>/reports_resources/localization/ovirt_reports_bundle_en_US.properties</referenceUri> + </localResource> + </resource> + <resource> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:type="fileResource"> + <folder>/Reports/Service_level/VMs/single_vm_uptime_br46_files</folder> + <name>ovirt_reports_bundle_es.properties</name> + <version>0</version> + <label>ovirt_reports_bundle_es.properties</label> + <creationDate>2012-12-19T14:11:38.919+02:00</creationDate> + <updateDate>2012-12-19T14:11:38.919+02:00</updateDate> + <referenceUri>/reports_resources/localization/ovirt_reports_bundle_es.properties</referenceUri> + </localResource> + </resource> + <resource> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:type="fileResource"> + <folder>/Reports/Service_level/VMs/single_vm_uptime_br46_files</folder> + <name>ovirt_reports_bundle_fr.properties</name> + <version>0</version> + <label>ovirt_reports_bundle_fr.properties</label> + <creationDate>2012-12-19T14:11:38.919+02:00</creationDate> + <updateDate>2012-12-19T14:11:38.919+02:00</updateDate> + <referenceUri>/reports_resources/localization/ovirt_reports_bundle_fr.properties</referenceUri> + </localResource> + </resource> + <resource> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:type="fileResource"> + <folder>/Reports/Service_level/VMs/single_vm_uptime_br46_files</folder> + <name>ovirt_reports_bundle_ja.properties</name> + <version>0</version> + <label>ovirt_reports_bundle_ja.properties</label> + <creationDate>2012-12-19T14:11:38.919+02:00</creationDate> + <updateDate>2012-12-19T14:11:38.919+02:00</updateDate> + <referenceUri>/reports_resources/localization/ovirt_reports_bundle_ja.properties</referenceUri> + </localResource> + </resource> + <resource> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:type="fileResource"> + <folder>/Reports/Service_level/VMs/single_vm_uptime_br46_files</folder> + <name>ovirt_reports_bundle_pt_BR.properties</name> + <version>0</version> + <label>ovirt_reports_bundle_pt_BR.properties</label> + <creationDate>2012-12-19T14:11:38.919+02:00</creationDate> + <updateDate>2012-12-19T14:11:38.919+02:00</updateDate> + <referenceUri>/reports_resources/localization/ovirt_reports_bundle_pt_BR.properties</referenceUri> + </localResource> + </resource> + <resource> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:type="fileResource"> + <folder>/Reports/Service_level/VMs/single_vm_uptime_br46_files</folder> + <name>ovirt_reports_bundle_zh_CN.properties</name> + <version>0</version> + <label>ovirt_reports_bundle_zh_CN.properties</label> + <creationDate>2012-12-19T14:11:38.919+02:00</creationDate> + <updateDate>2012-12-19T14:11:38.919+02:00</updateDate> + <referenceUri>/reports_resources/localization/ovirt_reports_bundle_zh_CN.properties</referenceUri> + </localResource> + </resource> + <resource> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:type="fileResource"> + <folder>/Reports/Service_level/VMs/single_vm_uptime_br46_files</folder> + <name>ovirt_reports_bundle_zh_TW.properties</name> + <version>0</version> + <label>ovirt_reports_bundle_zh_TW.properties</label> + <creationDate>2012-12-19T14:11:38.919+02:00</creationDate> + <updateDate>2012-12-19T14:11:38.919+02:00</updateDate> + <referenceUri>/reports_resources/localization/ovirt_reports_bundle_zh_TW.properties</referenceUri> + </localResource> + </resource> + <inputControlRenderingView></inputControlRenderingView> + <alwaysPromptControls>true</alwaysPromptControls> + <controlsLayout>1</controlsLayout> +</reportUnit> diff --git a/reports/repository_files/resources/Reports/Service_level/VMs/single_vm_uptime_br46_files/full details.jrxml.data b/reports/repository_files/resources/Reports/Service_level/VMs/single_vm_uptime_br46_files/full details.jrxml.data new file mode 100644 index 0000000..2af9989 --- /dev/null +++ b/reports/repository_files/resources/Reports/Service_level/VMs/single_vm_uptime_br46_files/full details.jrxml.data @@ -0,0 +1,268 @@ +<?xml version="1.0" encoding="UTF-8"?> +<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd"; name="report1" language="groovy" pageWidth="830" pageHeight="170" orientation="Landscape" columnWidth="830" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" resourceBundle="ovirt_reports_bundle" whenResourceMissingType="Error" uuid="d20fa8c8-000f-40f7-9117-eed6a5d972c4"> + <property name="ireport.zoom" value="1.0"/> + <property name="ireport.x" value="0"/> + <property name="ireport.y" value="0"/> + <property name="ireport.jasperserver.reportUnit" value="/Reports/Service_level/VMs/single_vm_uptime_br46"/> + <property name="ireport.jasperserver.url" value="http://localhost:8080/jasperserver-pro/services/repository"/> + <parameter name="is_deleted" class="java.lang.String"> + <defaultValueExpression><![CDATA["AND delete_date IS NULL"]]></defaultValueExpression> + </parameter> + <parameter name="P_Period" class="java.lang.String"> + <parameterDescription><![CDATA[Period]]></parameterDescription> + <defaultValueExpression><![CDATA["Daily"]]></defaultValueExpression> + </parameter> + <parameter name="P_Start_Date" class="java.util.Date"> + <defaultValueExpression><![CDATA["01/01/2000"]]></defaultValueExpression> + </parameter> + <parameter name="P_DataCenter_ID" class="java.lang.String"> + <parameterDescription><![CDATA[Select a DataCenter]]></parameterDescription> + <defaultValueExpression><![CDATA["00000000-0000-0000-0000-000000000000"]]></defaultValueExpression> + </parameter> + <parameter name="P_Cluster_ID" class="java.lang.String"> + <parameterDescription><![CDATA[Select a Cluster]]></parameterDescription> + <defaultValueExpression><![CDATA["00000000-0000-0000-0000-000000000000"]]></defaultValueExpression> + </parameter> + <parameter name="P_VM_Type" class="java.lang.Integer"> + <parameterDescription><![CDATA[Select a VM Type]]></parameterDescription> + <defaultValueExpression><![CDATA[-1]]></defaultValueExpression> + </parameter> + <parameter name="P_VM_ID" class="java.lang.String"> + <parameterDescription><![CDATA[Select an VM]]></parameterDescription> + <defaultValueExpression><![CDATA["00000000-0000-0000-0000-000000000000"]]></defaultValueExpression> + </parameter> + <queryString> + <![CDATA[SELECT vm_name, + cast(delete_date as date) as vm_delete_date, + cast(create_date as date) as vm_create_date, + high_availability, + round(cast(memory_size_mb as float)::numeric/1024,1) as memory_size, + (cpu_per_socket*number_of_sockets) as number_of_cpus, + (SELECT v3_2_enum_translator.value + FROM v3_2_enum_translator + WHERE v3_2_enum_translator.enum_key = v3_2_configuration_history_vms.operating_system + AND v3_2_enum_translator.enum_type = 'OS_TYPE') as operating_system, + coalesce((SELECT ' ' || v3_2_configuration_history_clusters.cluster_name + FROM v3_2_configuration_history_clusters + WHERE v3_2_configuration_history_clusters.cluster_id = cast($P{P_Cluster_ID} as uuid) + and history_id in (SELECT max(b.history_id) + FROM v3_2_configuration_history_clusters as b + GROUP BY b.cluster_id)), 'all') AS cluster_name, + (SELECT cast(v3_2_configuration_history_clusters.delete_date as date) + FROM v3_2_configuration_history_clusters + WHERE v3_2_configuration_history_clusters.cluster_id = cast($P{P_Cluster_ID} as uuid) + and history_id in (SELECT max(c.history_id) + FROM v3_2_configuration_history_clusters as c + GROUP BY c.cluster_id)) as cluster_delete_date, + coalesce((SELECT v3_2_enum_translator.value + FROM v3_2_enum_translator + WHERE v3_2_enum_translator.enum_key = v3_2_configuration_history_vms.vm_type + AND v3_2_enum_translator.enum_type = 'VM_TYPE'), 'All') as vm_type, + (SELECT v3_2_configuration_history_datacenters.datacenter_name + FROM v3_2_configuration_history_datacenters + WHERE v3_2_configuration_history_datacenters.datacenter_id = cast($P{P_DataCenter_ID} as uuid) + and history_id in (SELECT max(d.history_id) + from v3_2_configuration_history_datacenters as d + GROUP BY d.datacenter_id)) as datacenter_name, + (SELECT CAST(v3_2_configuration_history_datacenters.delete_date as date) + FROM v3_2_configuration_history_datacenters + WHERE v3_2_configuration_history_datacenters.datacenter_id = cast($P{P_DataCenter_ID} as uuid) + and history_id in (SELECT max(d.history_id) + FROM v3_2_configuration_history_datacenters as d + GROUP BY d.datacenter_id)) as datacenter_delete_date, + CASE + WHEN $P{P_Period} = 'Monthly' THEN CAST(cast($P{P_Start_Date} as date) + interval '1 month' - interval '1 day' as date) + WHEN $P{P_Period} = 'Quarterly' THEN CAST(cast($P{P_Start_Date} as date) + interval '3 month' - interval '1 day' as date) + WHEN $P{P_Period} = 'Yearly' THEN CAST(cast($P{P_Start_Date} as date) + interval '1 year' - interval '1 day' as date) + END as end_date +FROM v3_2_configuration_history_vms +WHERE vm_id = cast($P{P_VM_ID} as uuid) + and history_id in (SELECT max(a.history_id) + FROM v3_2_configuration_history_vms as a + GROUP BY a.vm_id)]]> + </queryString> + <field name="vm_name" class="java.lang.String"/> + <field name="vm_delete_date" class="java.sql.Date"/> + <field name="vm_create_date" class="java.sql.Date"/> + <field name="high_availability" class="java.lang.Boolean"/> + <field name="memory_size" class="java.math.BigDecimal"/> + <field name="number_of_cpus" class="java.lang.Integer"/> + <field name="operating_system" class="java.lang.String"/> + <field name="cluster_name" class="java.lang.String"/> + <field name="cluster_delete_date" class="java.sql.Date"/> + <field name="vm_type" class="java.lang.String"/> + <field name="datacenter_name" class="java.lang.String"/> + <field name="datacenter_delete_date" class="java.sql.Date"/> + <field name="end_date" class="java.sql.Date"/> + <variable name="datacenter_star" class="java.lang.String" resetType="None"> + <variableExpression><![CDATA[$F{datacenter_delete_date} != null ? "*" : ""]]></variableExpression> + </variable> + <variable name="cluster_star" class="java.lang.String" resetType="None"> + <variableExpression><![CDATA[$F{cluster_delete_date} != null ? "*" : ""]]></variableExpression> + </variable> + <variable name="vm_star" class="java.lang.String" resetType="None"> + <variableExpression><![CDATA[$F{vm_delete_date} != null ? "*" : ""]]></variableExpression> + </variable> + <title> + <band height="145" splitType="Stretch"> + <frame> + <reportElement uuid="04de54a1-b116-4e10-a68d-21e8264d2b72" mode="Opaque" x="0" y="30" width="828" height="40"/> + <box> + <pen lineWidth="1.0" lineColor="#CCCCCC"/> + <topPen lineWidth="1.0" lineColor="#CCCCCC"/> + <leftPen lineWidth="1.0" lineColor="#CCCCCC"/> + <bottomPen lineWidth="1.0" lineColor="#CCCCCC"/> + <rightPen lineWidth="1.0" lineColor="#CCCCCC"/> + </box> + <textField> + <reportElement uuid="a333738a-3a06-487c-9ba7-22d86f534665" positionType="Float" x="83" y="20" width="338" height="20"/> + <textElement textAlignment="Justified" verticalAlignment="Middle" markup="html"> + <font fontName="SansSerif" size="11" isBold="false"/> + </textElement> + <textFieldExpression><![CDATA["<b>" + $R{full.details.period} + ":</b> " + $P{P_Period}]]></textFieldExpression> + <hyperlinkTooltipExpression><![CDATA[$P{P_Period}]]></hyperlinkTooltipExpression> + </textField> + <textField> + <reportElement uuid="82ca373b-48b5-467b-894c-b3dc1c917770" x="83" y="0" width="338" height="20"/> + <textElement verticalAlignment="Middle" markup="html"> + <font fontName="SansSerif" size="11" isBold="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/> + </textElement> + <textFieldExpression><![CDATA["<b>" + $R{full.details.datacenter} + ": </b>" + $F{datacenter_name} + $V{datacenter_star}]]></textFieldExpression> + <hyperlinkTooltipExpression><![CDATA[$F{datacenter_name} + $V{datacenter_star}]]></hyperlinkTooltipExpression> + </textField> + <textField> + <reportElement uuid="2b3a861a-529d-4557-9884-0be577766cca" positionType="Float" x="446" y="20" width="326" height="20"/> + <textElement textAlignment="Justified" verticalAlignment="Middle" markup="html"> + <font fontName="SansSerif" size="11" isBold="false"/> + </textElement> + <textFieldExpression><![CDATA[$P{P_Period} == "Daily" ? "<b>" + $R{full.details.date.range} + ": </b>" + DateFormat.getDateInstance(DateFormat.SHORT, $P{REPORT_LOCALE}).format($P{P_Start_Date}) : "<b>" + $R{full.details.date.range} + ": </b>" + DateFormat.getDateInstance(DateFormat.SHORT, $P{REPORT_LOCALE}).format($P{P_Start_Date}) + " - " + DateFormat.getDateInstance(DateFormat.SHORT, $P{REPORT_LOCALE}).format($F{end_date})]]></textFieldExpression> + <hyperlinkTooltipExpression><![CDATA[$P{P_Period} == "Daily" ? DateFormat.getDateInstance(DateFormat.SHORT, $P{REPORT_LOCALE}).format($P{P_Start_Date}) : DateFormat.getDateInstance(DateFormat.SHORT, $P{REPORT_LOCALE}).format($P{P_Start_Date}) + " - " + DateFormat.getDateInstance(DateFormat.SHORT, $P{REPORT_LOCALE}).format($F{end_date})]]></hyperlinkTooltipExpression> + </textField> + <textField> + <reportElement uuid="a2bc8c37-9a1f-45f8-927f-db05ce6e7932" positionType="Float" x="446" y="0" width="326" height="20"/> + <textElement textAlignment="Justified" verticalAlignment="Middle" markup="html"> + <font fontName="SansSerif" size="11" isBold="false"/> + </textElement> + <textFieldExpression><![CDATA[$F{cluster_name} != "all" ? "<b>" + $R{full.details.cluster} + ":</b> " + $F{cluster_name} + $V{cluster_star} : "<b>" + $R{full.details.cluster} + ":</b> "+ $R{full.details.all}]]></textFieldExpression> + <hyperlinkTooltipExpression><![CDATA[$F{cluster_name} != "all" ? $F{cluster_name} + $V{cluster_star} : $R{full.details.all}]]></hyperlinkTooltipExpression> + </textField> + <textField> + <reportElement uuid="cacecc05-6787-48f3-a471-c40c93b95c74" mode="Opaque" x="2" y="2" width="69" height="36" forecolor="#666666" backcolor="#E6E6E6"/> + <textElement textAlignment="Left" verticalAlignment="Middle" markup="none"> + <font fontName="SansSerif" size="13" isBold="true"/> + </textElement> + <textFieldExpression><![CDATA[$R{full.details.criteria} + ":"]]></textFieldExpression> + </textField> + </frame> + <textField evaluationTime="Report" isBlankWhenNull="false"> + <reportElement uuid="b53dd370-d330-4bd1-aa5c-77a604eb4fd2" x="0" y="0" width="830" height="25" forecolor="#666666"/> + <textElement textAlignment="Left" verticalAlignment="Top" markup="html"> + <font fontName="SansSerif" size="17" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false"/> + </textElement> + <textFieldExpression><![CDATA[msg($R{br46.title}, $F{vm_name} + $V{vm_star})]]></textFieldExpression> + </textField> + <image> + <reportElement uuid="50c8fedf-db89-4549-adc2-2ef9ba5e1bf6" x="12" y="73" width="10" height="11"> + <printWhenExpression><![CDATA[$F{cluster_delete_date} != null || $F{datacenter_delete_date} != null || $F{vm_delete_date} != null]]></printWhenExpression> + </reportElement> + <imageExpression><![CDATA["repo:trash-icon"]]></imageExpression> + </image> + <staticText> + <reportElement uuid="f5b4d575-475e-41ff-8172-a017cc2f71a5" x="5" y="71" width="5" height="14" forecolor="#666666"> + <printWhenExpression><![CDATA[$F{cluster_delete_date} != null || $F{datacenter_delete_date} != null || $F{vm_delete_date} != null]]></printWhenExpression> + </reportElement> + <textElement verticalAlignment="Middle"> + <font fontName="SansSerif" size="12"/> + </textElement> + <text><![CDATA[*]]></text> + </staticText> + <textField> + <reportElement uuid="6f8db19f-1949-464b-836b-3caee5335507" x="29" y="73" width="735" height="13" forecolor="#666666"/> + <textElement markup="html"> + <font fontName="SansSerif"/> + </textElement> + <textFieldExpression><![CDATA[$F{vm_delete_date} != null ? $F{cluster_delete_date} != null ? +$F{datacenter_delete_date} != null ? msg($R{full.details.deleted.comment.datacenter.cluster.and.vm}, DateFormat.getDateInstance(DateFormat.SHORT, $P{REPORT_LOCALE}).format($F{datacenter_delete_date}), DateFormat.getDateInstance(DateFormat.SHORT, $P{REPORT_LOCALE}).format($F{cluster_delete_date}), DateFormat.getDateInstance(DateFormat.SHORT, $P{REPORT_LOCALE}).format($F{vm_delete_date})) : +msg($R{full.details.deleted.comment.cluster.and.vm}, DateFormat.getDateInstance(DateFormat.SHORT, $P{REPORT_LOCALE}).format($F{cluster_delete_date}), DateFormat.getDateInstance(DateFormat.SHORT, $P{REPORT_LOCALE}).format($F{vm_delete_date})) : +$F{datacenter_delete_date} != null ? msg($R{full.details.deleted.comment.datacenter.and.vm}, DateFormat.getDateInstance(DateFormat.SHORT, $P{REPORT_LOCALE}).format($F{datacenter_delete_date}), DateFormat.getDateInstance(DateFormat.SHORT, $P{REPORT_LOCALE}).format($F{vm_delete_date})) : msg($R{full.details.deleted.comment.vm}, DateFormat.getDateInstance(DateFormat.SHORT, $P{REPORT_LOCALE}).format($F{vm_delete_date})) : +$F{cluster_delete_date} != null ? +$F{datacenter_delete_date} != null ? msg($R{full.details.deleted.comment.datacenter.and.cluster}, DateFormat.getDateInstance(DateFormat.SHORT, $P{REPORT_LOCALE}).format($F{datacenter_delete_date}), DateFormat.getDateInstance(DateFormat.SHORT, $P{REPORT_LOCALE}).format($F{cluster_delete_date})) : +msg($R{full.details.deleted.comment.cluster}, DateFormat.getDateInstance(DateFormat.SHORT, $P{REPORT_LOCALE}).format($F{cluster_delete_date})) : +$F{datacenter_delete_date} != null ? msg($R{full.details.deleted.comment.datacenter}, DateFormat.getDateInstance(DateFormat.SHORT, $P{REPORT_LOCALE}).format($F{datacenter_delete_date})) : ""]]></textFieldExpression> + </textField> + <textField> + <reportElement uuid="3f224ffe-c6ab-4510-8b5a-88b58855a8ec" mode="Opaque" x="0" y="89" width="364" height="16" forecolor="#3A5E75"/> + <textElement textAlignment="Left" verticalAlignment="Middle" markup="none"> + <font fontName="SansSerif" size="13" isBold="true"/> + </textElement> + <textFieldExpression><![CDATA[$R{full.details.vm.details}]]></textFieldExpression> + </textField> + <frame> + <reportElement uuid="5c1e10f1-61aa-4491-9f18-08489fb781bc" mode="Opaque" x="0" y="105" width="828" height="40"/> + <box> + <pen lineWidth="1.0" lineColor="#CCCCCC"/> + <topPen lineWidth="1.0" lineColor="#CCCCCC"/> + <leftPen lineWidth="1.0" lineColor="#CCCCCC"/> + <bottomPen lineWidth="1.0" lineColor="#CCCCCC"/> + <rightPen lineWidth="1.0" lineColor="#CCCCCC"/> + </box> + <textField isBlankWhenNull="false"> + <reportElement uuid="43b21ad7-a9b7-4124-bc3f-dc5f3dcbd0dc" x="12" y="20" width="270" height="20"/> + <textElement verticalAlignment="Middle" markup="html"> + <font fontName="SansSerif" size="11" isBold="false" pdfEncoding="Cp1252" isPdfEmbedded="false"/> + </textElement> + <textFieldExpression><![CDATA[$F{operating_system} != null ? "<b>" + $R{full.details.os} + ": </b>" + $F{operating_system} : "<b>" + $R{full.details.os} + ": </b>"]]></textFieldExpression> + <hyperlinkTooltipExpression><![CDATA[$F{operating_system} != null ? $F{operating_system} : ""]]></hyperlinkTooltipExpression> + </textField> + <textField> + <reportElement uuid="f3219591-edfa-4962-be72-75ca78ea470e" positionType="Float" x="695" y="0" width="110" height="20"/> + <textElement textAlignment="Justified" verticalAlignment="Middle" markup="html"> + <font fontName="SansSerif" size="11" isBold="false"/> + </textElement> + <textFieldExpression><![CDATA[$F{number_of_cpus} != null ? "<b>" + $R{full.details.number.of.vm.cores} + ": </b>" + $F{number_of_cpus}.toString() : "<b>" + $R{full.details.number.of.vm.cores} + ": </b>"]]></textFieldExpression> + <hyperlinkTooltipExpression><![CDATA[$F{number_of_cpus} != null ? $F{number_of_cpus}.toString() : ""]]></hyperlinkTooltipExpression> + </textField> + <textField> + <reportElement uuid="2f48dc38-aebc-4903-9624-b56021d37bb4" positionType="Float" x="502" y="0" width="162" height="20"/> + <textElement textAlignment="Justified" verticalAlignment="Middle" markup="html"> + <font fontName="SansSerif" size="11" isBold="false"/> + </textElement> + <textFieldExpression><![CDATA[$F{memory_size} != null ? "<b>" + $R{full.details.memory.size} + ": </b>" + $F{memory_size}.toString() + " " + $R{full.details.gb} : "<b>" + $R{full.details.memory.size} + ": </b>"]]></textFieldExpression> + <hyperlinkTooltipExpression><![CDATA[$F{memory_size} != null ? $F{memory_size}.toString() + " " + $R{full.details.gb} : ""]]></hyperlinkTooltipExpression> + </textField> + <textField> + <reportElement uuid="764849d0-9de7-46b1-adcd-9a0ea2dc1d7b" positionType="Float" x="502" y="20" width="162" height="20"/> + <textElement textAlignment="Justified" verticalAlignment="Middle" markup="html"> + <font fontName="SansSerif" size="11" isBold="false"/> + </textElement> + <textFieldExpression><![CDATA[$F{vm_type} != "All" ? "<b>" + $R{full.details.vm.type} + ":</b> " + $F{vm_type} : "<b>" + $R{full.details.vm.type} + ":</b> " + $R{full.details.all}]]></textFieldExpression> + <hyperlinkTooltipExpression><![CDATA[$F{vm_type} != "All" ? $F{vm_type} : $R{full.details.all}]]></hyperlinkTooltipExpression> + </textField> + <textField> + <reportElement uuid="b41f9eaf-b1b3-4549-920d-b7d9dac8511a" positionType="Float" x="12" y="0" width="201" height="20"/> + <textElement textAlignment="Justified" verticalAlignment="Middle" markup="html"> + <font fontName="SansSerif" size="11" isBold="false"/> + </textElement> + <textFieldExpression><![CDATA[$F{vm_create_date} != null ? "<b>" + $R{full.details.create.date} + ": </b>" + DateFormat.getDateInstance(DateFormat.SHORT, $P{REPORT_LOCALE}).format($F{vm_create_date}) : "<b>" + $R{full.details.create.date} + ": </b>"]]></textFieldExpression> + <hyperlinkTooltipExpression><![CDATA[$F{vm_create_date} != null ? DateFormat.getDateInstance(DateFormat.SHORT, $P{REPORT_LOCALE}).format($F{vm_create_date}) : ""]]></hyperlinkTooltipExpression> + </textField> + <textField> + <reportElement uuid="95878a71-8bbe-4503-b19f-884afcc7748e" positionType="Float" x="309" y="20" width="167" height="20"/> + <textElement textAlignment="Justified" verticalAlignment="Middle" markup="html"> + <font fontName="SansSerif" size="11" isBold="false"/> + </textElement> + <textFieldExpression><![CDATA[$F{high_availability} ? "<b>" + $R{full.details.vm.high.availability} + ": </b>" + $R{full.details.yes} : "<b>" + $R{full.details.vm.high.availability} + ": </b>" + $R{full.details.no}]]></textFieldExpression> + <hyperlinkTooltipExpression><![CDATA[$F{high_availability} ? $R{full.details.yes} : $R{full.details.no}]]></hyperlinkTooltipExpression> + </textField> + <textField> + <reportElement uuid="7f0cb684-6bbe-4c99-9388-b6ddcf89d556" positionType="Float" x="309" y="0" width="162" height="20"/> + <textElement textAlignment="Justified" verticalAlignment="Middle" markup="html"> + <font fontName="SansSerif" size="11" isBold="false"/> + </textElement> + <textFieldExpression><![CDATA[$F{vm_delete_date} != null ? "<b>" + $R{full.details.delete.date} + ": </b>" + DateFormat.getDateInstance(DateFormat.SHORT, $P{REPORT_LOCALE}).format($F{vm_delete_date}) : "<b>" + $R{full.details.delete.date} + ": </b>"]]></textFieldExpression> + <hyperlinkTooltipExpression><![CDATA[$F{vm_delete_date} != null ? DateFormat.getDateInstance(DateFormat.SHORT, $P{REPORT_LOCALE}).format($F{vm_delete_date}) : ""]]></hyperlinkTooltipExpression> + </textField> + </frame> + </band> + </title> +</jasperReport> diff --git a/reports/repository_files/resources/Reports/Service_level/VMs/single_vm_uptime_br46_files/single_vm_uptime_br46_jrxml.data b/reports/repository_files/resources/Reports/Service_level/VMs/single_vm_uptime_br46_files/single_vm_uptime_br46_jrxml.data new file mode 100644 index 0000000..c54167e --- /dev/null +++ b/reports/repository_files/resources/Reports/Service_level/VMs/single_vm_uptime_br46_files/single_vm_uptime_br46_jrxml.data @@ -0,0 +1,279 @@ +<?xml version="1.0" encoding="UTF-8"?> +<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports"; xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd"; name="BR8" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="832" leftMargin="5" rightMargin="5" topMargin="5" bottomMargin="5" resourceBundle="ovirt_reports_bundle" whenResourceMissingType="Error" uuid="13c1c15e-06cb-4d41-9dab-ecec78188c4c"> + <property name="ireport.jasperserver.reportUnit" value="/Reports/Service_level/VMs/single_vm_uptime_br8"/> + <property name="ireport.jasperserver.url" value="http://localhost:8080/jasperserver/services/repository"/> + <property name="ireport.zoom" value="1.0"/> + <property name="ireport.x" value="0"/> + <property name="ireport.y" value="0"/> + <style name="Crosstab Data Text" hAlign="Center"/> + <parameter name="is_deleted" class="java.lang.String"> + <defaultValueExpression><![CDATA["AND delete_date IS NULL"]]></defaultValueExpression> + </parameter> + <parameter name="P_Period" class="java.lang.String"> + <parameterDescription><![CDATA[Period]]></parameterDescription> + <defaultValueExpression><![CDATA["Daily"]]></defaultValueExpression> + </parameter> + <parameter name="P_Start_Date" class="java.util.Date"> + <defaultValueExpression><![CDATA["01/01/2000"]]></defaultValueExpression> + </parameter> + <parameter name="P_DataCenter_ID" class="java.lang.String"> + <parameterDescription><![CDATA[Select a DataCenter]]></parameterDescription> + <defaultValueExpression><![CDATA["00000000-0000-0000-0000-000000000000"]]></defaultValueExpression> + </parameter> + <parameter name="P_Cluster_ID" class="java.lang.String"> + <parameterDescription><![CDATA[Select a Cluster]]></parameterDescription> + <defaultValueExpression><![CDATA["00000000-0000-0000-0000-000000000000"]]></defaultValueExpression> + </parameter> + <parameter name="P_VM_Type" class="java.lang.Integer"/> + <parameter name="P_VM_ID" class="java.lang.String"> + <defaultValueExpression><![CDATA["00000000-0000-0000-0000-000000000000"]]></defaultValueExpression> + </parameter> + <parameter name="REPORT_NAME" class="java.lang.String" isForPrompting="false"/> + <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false"> + <defaultValueExpression><![CDATA["C:\\Clients\\BO Client Folders\\oVirt\\iReports\\"]]></defaultValueExpression> + </parameter> + <parameter name="table_name" class="java.lang.String"> + <defaultValueExpression><![CDATA[$P{P_Period} == "Daily" ? "hourly" : "daily"]]></defaultValueExpression> + </parameter> + <parameter name="calendar_column" class="java.lang.String"> + <defaultValueExpression><![CDATA[$P{P_Period} == "Daily" ? "the_datetime" : "the_date"]]></defaultValueExpression> + </parameter> + <queryString> + <![CDATA[SELECT SUM(CASE WHEN vm_status = 2 or vm_status = 0 THEN coalesce(v3_2_statistics_vms_resources_usage_$P!{table_name}.minutes_in_status,0) ELSE 0 END)AS planned_downtime_mins + ,SUM(CASE WHEN vm_status = 3 THEN coalesce(v3_2_statistics_vms_resources_usage_$P!{table_name}.minutes_in_status,0) ELSE 0 END)AS unplanned_downtime_mins + ,SUM(CASE WHEN vm_status = 1 THEN coalesce(v3_2_statistics_vms_resources_usage_$P!{table_name}.minutes_in_status,0) ELSE 0 END)AS uptime_mins + ,Sum(v3_2_statistics_vms_resources_usage_$P!{table_name}.minutes_in_status) as total +FROM v3_2_statistics_vms_resources_usage_$P!{table_name} +WHERE v3_2_statistics_vms_resources_usage_$P!{table_name}.vm_id = + CASE $P{P_VM_ID} + WHEN '00000000-0000-0000-0000-000000000000' THEN '00000000-0000-0000-0000-000000000000' + WHEN null THEN '00000000-0000-0000-0000-000000000000' + WHEN '11111111-1111-1111-1111-111111111111' THEN '00000000-0000-0000-0000-000000000000' + ELSE cast($P{P_VM_ID} as uuid) + END +AND history_datetime >= cast($P{P_Start_Date} as timestamp) +AND history_datetime <= CASE + WHEN $P{P_Period} = 'Daily' THEN CAST($P{P_Start_Date} as TIMESTAMP) + interval '1 day' + WHEN $P{P_Period} = 'Monthly' THEN CAST($P{P_Start_Date} as TIMESTAMP) + interval '1 month' + WHEN $P{P_Period} = 'Quarterly' THEN CAST($P{P_Start_Date} as TIMESTAMP) + interval '3 month' + WHEN $P{P_Period} = 'Yearly' THEN CAST($P{P_Start_Date} as TIMESTAMP) + interval '1 year' + END]]> + </queryString> + <field name="planned_downtime_mins" class="java.math.BigDecimal"/> + <field name="unplanned_downtime_mins" class="java.math.BigDecimal"/> + <field name="uptime_mins" class="java.math.BigDecimal"/> + <field name="total" class="java.math.BigDecimal"/> + <variable name="CURRENT_PAGE_NUMBER" class="java.lang.Integer" resetType="None" incrementType="Page"> + <variableExpression><![CDATA[$V{PAGE_NUMBER}]]></variableExpression> + <initialValueExpression><![CDATA[]]></initialValueExpression> + </variable> + <group name="Datacenter"> + <groupExpression><![CDATA[$P{P_DataCenter_ID}]]></groupExpression> + <groupFooter> + <band height="300"> + <textField> + <reportElement uuid="210a1512-5049-435c-8cd8-91681089b101" x="254" y="263" width="183" height="15"/> + <textElement markup="none"> + <font fontName="SansSerif" size="12" isBold="true"/> + </textElement> + <textFieldExpression><![CDATA[$R{br8.meter.planned.downtime} + ":"]]></textFieldExpression> + </textField> + <textField> + <reportElement uuid="2c9f4e90-bf84-4b9a-a123-2e7eef83ad63" x="254" y="282" width="183" height="15"/> + <textElement markup="none"> + <font fontName="SansSerif" size="12" isBold="true"/> + </textElement> + <textFieldExpression><![CDATA[$R{br8.meter.unplanned.downtime} + ":"]]></textFieldExpression> + </textField> + <textField> + <reportElement uuid="82404938-19c9-41b6-b2b2-dfcb01ac9111" x="305" y="10" width="222" height="17" forecolor="#3A5E75"/> + <textElement textAlignment="Center" verticalAlignment="Middle" markup="none"> + <font fontName="SansSerif" size="13" isBold="true"/> + </textElement> + <textFieldExpression><![CDATA[$R{br8.meter.title}]]></textFieldExpression> + </textField> + <meterChart> + <chart evaluationTime="Report" renderType="draw" theme="default"> + <reportElement uuid="ca98b215-2f5e-417e-ad6b-234e21d10a8f" mode="Transparent" x="319" y="34" width="200" height="200"/> + <box> + <pen lineWidth="0.0"/> + <topPen lineWidth="0.0"/> + <leftPen lineWidth="0.0"/> + <bottomPen lineWidth="0.0"/> + <rightPen lineWidth="0.0"/> + </box> + <chartTitle color="#3A5E75"> + <font fontName="Arial"/> + </chartTitle> + <chartSubtitle/> + <chartLegend/> + </chart> + <valueDataset> + <valueExpression><![CDATA[Math.round( $F{uptime_mins}/$F{total}*100 )]]></valueExpression> + </valueDataset> + <meterPlot shape="dial" tickInterval="5.0" needleColor="#000000" tickColor="#000000"> + <plot/> + <valueDisplay mask="0"/> + <dataRange> + <lowExpression><![CDATA[0]]></lowExpression> + <highExpression><![CDATA[100]]></highExpression> + </dataRange> + <meterInterval label="All" color="#3A5E7E" alpha="1.0"> + <dataRange> + <lowExpression><![CDATA[0]]></lowExpression> + <highExpression><![CDATA[100]]></highExpression> + </dataRange> + </meterInterval> + </meterPlot> + </meterChart> + <textField> + <reportElement uuid="7eda181a-96f2-450c-9c98-bd4ba4ea49a2" x="254" y="244" width="183" height="15" forecolor="#3A5E75"/> + <textElement markup="none"> + <font fontName="SansSerif" size="12" isBold="true"/> + </textElement> + <textFieldExpression><![CDATA[$R{br8.meter.uptime} + ":"]]></textFieldExpression> + </textField> + <frame> + <reportElement uuid="023a9d15-d09e-4b62-afe4-79f30cdc6615" x="444" y="244" width="150" height="15"/> + <textField> + <reportElement uuid="bee201b4-b883-4876-b4a9-4b6e280f9f59" x="0" y="0" width="32" height="15" forecolor="#3A5E75"> + <printWhenExpression><![CDATA[((($F{uptime_mins}/60)/24).intValue()) != 0]]></printWhenExpression> + </reportElement> + <textElement textAlignment="Right" verticalAlignment="Middle"> + <font fontName="SansSerif" size="12" isBold="true"/> + </textElement> + <textFieldExpression><![CDATA[((($F{uptime_mins}/60)/24).intValue()).toString() + "d"]]></textFieldExpression> + </textField> + <textField> + <reportElement uuid="ace42702-aaa7-4aa2-97cf-76c81a1267aa" x="35" y="0" width="30" height="15" forecolor="#3A5E75"> + <printWhenExpression><![CDATA[((($F{uptime_mins}/60)/24).intValue()) != 0 || (($F{uptime_mins}/60).intValue()-(((($F{uptime_mins}/60)/24).intValue())*24)) != 0]]></printWhenExpression> + </reportElement> + <textElement textAlignment="Right" verticalAlignment="Middle"> + <font fontName="SansSerif" size="12" isBold="true"/> + </textElement> + <textFieldExpression><![CDATA[(($F{uptime_mins}/60).intValue()-(((($F{uptime_mins}/60)/24).intValue())*24)).toString() + "h"]]></textFieldExpression> + </textField> + <textField> + <reportElement uuid="064b51f3-4ab0-4ff1-b805-0038e534254e" x="65" y="0" width="30" height="15" forecolor="#3A5E75"/> + <textElement textAlignment="Right" verticalAlignment="Middle"> + <font fontName="SansSerif" size="12" isBold="true"/> + </textElement> + <textFieldExpression><![CDATA[($F{uptime_mins} - ((($F{uptime_mins}/60).intValue()-(((($F{uptime_mins}/60)/24).intValue())*24))*60)-(((($F{uptime_mins}/60)/24).intValue())*60*24)).intValue().toString() + "m"]]></textFieldExpression> + </textField> + <textField> + <reportElement uuid="fedb4ae3-a819-4eb8-a2ba-8d4cf1be4ffd" x="100" y="0" width="50" height="15" forecolor="#3A5E75"/> + <textElement textAlignment="Right" verticalAlignment="Middle"> + <font fontName="SansSerif" size="12" isBold="true"/> + </textElement> + <textFieldExpression><![CDATA["(" + (100-(($F{planned_downtime_mins}/$F{total})*100).intValue()-(($F{unplanned_downtime_mins}/$F{total})*100).intValue()).toString() + "%)"]]></textFieldExpression> + </textField> + </frame> + <frame> + <reportElement uuid="00855d57-30a2-4350-b6c0-35cf51d5bfa4" x="450" y="263" width="144" height="15"/> + <textField> + <reportElement uuid="f942afb7-886c-4e33-9e52-87d387976c8f" x="0" y="0" width="27" height="15"> + <printWhenExpression><![CDATA[((($F{planned_downtime_mins}/60)/24).intValue()) != 0]]></printWhenExpression> + </reportElement> + <textElement textAlignment="Right" verticalAlignment="Middle"> + <font fontName="SansSerif" size="12" isBold="false"/> + </textElement> + <textFieldExpression><![CDATA[((($F{planned_downtime_mins}/60)/24).intValue()).toString() + "d"]]></textFieldExpression> + </textField> + <textField> + <reportElement uuid="468fe497-5fe2-4cb9-9010-addd0d83df61" x="31" y="0" width="27" height="15"> + <printWhenExpression><![CDATA[((($F{planned_downtime_mins}/60)/24).intValue()) != 0 || (($F{planned_downtime_mins}/60).intValue()-(((($F{planned_downtime_mins}/60)/24).intValue())*24)) != 0]]></printWhenExpression> + </reportElement> + <textElement textAlignment="Right" verticalAlignment="Middle"> + <font fontName="SansSerif" size="12" isBold="false"/> + </textElement> + <textFieldExpression><![CDATA[(($F{planned_downtime_mins}/60).intValue()-(((($F{planned_downtime_mins}/60)/24).intValue())*24)).toString() + "h"]]></textFieldExpression> + </textField> + <textField> + <reportElement uuid="8206bb9f-3625-43af-9c35-f77daee20b59" x="62" y="0" width="27" height="15"/> + <textElement textAlignment="Right" verticalAlignment="Middle"> + <font fontName="SansSerif" size="12" isBold="false"/> + </textElement> + <textFieldExpression><![CDATA[($F{planned_downtime_mins} - ((($F{planned_downtime_mins}/60).intValue()-(((($F{planned_downtime_mins}/60)/24).intValue())*24))*60)-(((($F{planned_downtime_mins}/60)/24).intValue())*60*24)).intValue().toString() + "m"]]></textFieldExpression> + </textField> + <textField> + <reportElement uuid="c5d7a7a9-309d-4ac1-87cb-65aff9957c4f" x="94" y="0" width="50" height="15"/> + <textElement textAlignment="Right" verticalAlignment="Middle"> + <font fontName="SansSerif" size="12" isBold="false"/> + </textElement> + <textFieldExpression><![CDATA["(" + (($F{planned_downtime_mins}/$F{total})*100).intValue().toString() + "%)"]]></textFieldExpression> + </textField> + </frame> + <frame> + <reportElement uuid="4e60c78c-64f1-448d-9776-92991bb5b8d9" x="450" y="282" width="145" height="15"/> + <textField> + <reportElement uuid="840103d4-9f5c-466a-90de-c1528d83c2ab" x="0" y="0" width="27" height="15"> + <printWhenExpression><![CDATA[((($F{unplanned_downtime_mins}/60)/24).intValue()) != 0]]></printWhenExpression> + </reportElement> + <textElement textAlignment="Right" verticalAlignment="Middle"> + <font fontName="SansSerif" size="12" isBold="false"/> + </textElement> + <textFieldExpression><![CDATA[((($F{unplanned_downtime_mins}/60)/24).intValue()).toString() + "d"]]></textFieldExpression> + </textField> + <textField> + <reportElement uuid="356126fd-b6a1-4432-acec-0ef365745cc3" x="31" y="0" width="27" height="15"> + <printWhenExpression><![CDATA[((($F{unplanned_downtime_mins}/60)/24).intValue()) != 0 || (($F{unplanned_downtime_mins}/60).intValue()-(((($F{unplanned_downtime_mins}/60)/24).intValue())*24)) != 0]]></printWhenExpression> + </reportElement> + <textElement textAlignment="Right" verticalAlignment="Middle"> + <font fontName="SansSerif" size="12" isBold="false"/> + </textElement> + <textFieldExpression><![CDATA[(($F{unplanned_downtime_mins}/60).intValue()-(((($F{unplanned_downtime_mins}/60)/24).intValue())*24)).toString() + "h"]]></textFieldExpression> + </textField> + <textField> + <reportElement uuid="0ba05d57-ff10-49ef-9b22-d2be91a120e7" x="62" y="0" width="27" height="15"/> + <textElement textAlignment="Right" verticalAlignment="Middle"> + <font fontName="SansSerif" size="12" isBold="false"/> + </textElement> + <textFieldExpression><![CDATA[($F{unplanned_downtime_mins} - ((($F{unplanned_downtime_mins}/60).intValue()-(((($F{unplanned_downtime_mins}/60)/24).intValue())*24))*60)-(((($F{unplanned_downtime_mins}/60)/24).intValue())*60*24)).intValue().toString() + "m"]]></textFieldExpression> + </textField> + <textField pattern=""> + <reportElement uuid="acae7374-52d9-4997-89d1-b6a424c126a5" x="94" y="0" width="50" height="15"/> + <textElement textAlignment="Right" verticalAlignment="Middle"> + <font fontName="SansSerif" size="12" isBold="false"/> + </textElement> + <textFieldExpression><![CDATA["(" + (($F{unplanned_downtime_mins}/$F{total})*100).intValue().toString() + "%)"]]></textFieldExpression> + </textField> + </frame> + </band> + </groupFooter> + </group> + <pageHeader> + <band height="190" splitType="Prevent"> + <subreport> + <reportElement uuid="d7af8d5e-75ba-4bf1-9538-5a7569133a5a" x="1" y="45" width="830" height="145"/> + <parametersMapExpression><![CDATA[$P{REPORT_PARAMETERS_MAP}]]></parametersMapExpression> + <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> + <subreportExpression><![CDATA["repo:full details.jrxml"]]></subreportExpression> + </subreport> + <textField pattern=""> + <reportElement uuid="e9e75b39-a5ec-499f-91d2-931f7f711e23" x="509" y="27" width="323" height="15"/> + <textElement textAlignment="Right"> + <font fontName="SansSerif" size="11" isBold="false"/> + </textElement> + <textFieldExpression><![CDATA[DateFormat.getDateInstance(DateFormat.LONG, $P{REPORT_LOCALE}).format(new Date())]]></textFieldExpression> + </textField> + <line> + <reportElement uuid="486ac95a-e477-4ff5-a057-b1b47dba27c0" x="0" y="43" width="832" height="1"/> + </line> + <image> + <reportElement uuid="43745c9b-e28e-4505-b9cc-bc0f189e6d84" x="0" y="0" width="228" height="42"/> + <imageExpression><![CDATA["repo:ovirt-icon"]]></imageExpression> + </image> + </band> + </pageHeader> + <pageFooter> + <band height="15" splitType="Stretch"> + <textField evaluationTime="Auto"> + <reportElement uuid="90fb43c2-15f4-4956-82e7-e8f86851646c" x="291" y="0" width="250" height="15"/> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font fontName="SansSerif"/> + </textElement> + <textFieldExpression><![CDATA[msg($R{footer.pagination}, $V{CURRENT_PAGE_NUMBER}, $V{PAGE_NUMBER})]]></textFieldExpression> + </textField> + </band> + </pageFooter> +</jasperReport> diff --git a/reports/repository_files/resources/reports_resources/localization/ovirt_reports_bundle_en_US.properties.data b/reports/repository_files/resources/reports_resources/localization/ovirt_reports_bundle_en_US.properties.data index 5ed49de..cef8fce 100644 --- a/reports/repository_files/resources/reports_resources/localization/ovirt_reports_bundle_en_US.properties.data +++ b/reports/repository_files/resources/reports_resources/localization/ovirt_reports_bundle_en_US.properties.data @@ -318,3 +318,5 @@ br45.table.average.memory.usage.percent=Avg Memory Usage % br45.table.peak.memory.usage.percent=Max Memory Usage % br45.title=Users'' Spice Sessions Activity in <b>{0}</b> of <b>Data Center {1}</b> +dr.count.list.storage.domains=Storage Domains +br46.title=Uptime of <b>Virtual Machine {0}</b> -- To view, visit http://gerrit.ovirt.org/10234 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I50951e7380be136162bb2beb86ec0ed4bbe46d1e Gerrit-PatchSet: 1 Gerrit-Project: ovirt-reports Gerrit-Branch: master Gerrit-Owner: Yaniv Dary <yd...@redhat.com> _______________________________________________ Engine-patches mailing list Engine-patches@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-patches
