Shirly Radco has uploaded a new change for review. Change subject: reports: added heatmap report ......................................................................
reports: added heatmap report Change-Id: I0e34dbc254d7123f7743d20b0e20e774a4822bbc Bug-Url:https://bugzilla.redhat.com/1169693 Signed-off-by: Shirly Radco <sra...@redhat.com> --- M packaging/ovirt-reports/resources/Reports/Service_level/Hosts/.folder.xml A packaging/ovirt-reports/resources/Reports/Service_level/Hosts/heatmap_report_cpu_usage_br49.xml A packaging/ovirt-reports/resources/Reports/Service_level/Hosts/heatmap_report_cpu_usage_br49_files/br49 full details.jrxml.data A packaging/ovirt-reports/resources/Reports/Service_level/Hosts/heatmap_report_cpu_usage_br49_files/heatmap_report_cpu_usage_br49_jrxml.data A packaging/ovirt-reports/resources/Reports/Service_level/Hosts/heatmap_report_mem_usage_br50.xml A packaging/ovirt-reports/resources/Reports/Service_level/Hosts/heatmap_report_mem_usage_br50_files/br50 full details.jrxml.data A packaging/ovirt-reports/resources/Reports/Service_level/Hosts/heatmap_report_mem_usage_br50_files/heatmap_report_mem_usage_br50_jrxml.data 7 files changed, 1,925 insertions(+), 0 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-reports refs/changes/06/39006/1 diff --git a/packaging/ovirt-reports/resources/Reports/Service_level/Hosts/.folder.xml b/packaging/ovirt-reports/resources/Reports/Service_level/Hosts/.folder.xml index 556bccf..bd51694 100644 --- a/packaging/ovirt-reports/resources/Reports/Service_level/Hosts/.folder.xml +++ b/packaging/ovirt-reports/resources/Reports/Service_level/Hosts/.folder.xml @@ -9,4 +9,6 @@ <resource>cluster_uptime_br7</resource> <resource>single_host_uptime_br8</resource> <resource>top_10_downtime_hosts_br7b</resource> + <resource>heatmap_report_cpu_usage_br49</resource> + <resource>heatmap_report_mem_usage_br50</resource> </folder> diff --git a/packaging/ovirt-reports/resources/Reports/Service_level/Hosts/heatmap_report_cpu_usage_br49.xml b/packaging/ovirt-reports/resources/Reports/Service_level/Hosts/heatmap_report_cpu_usage_br49.xml new file mode 100644 index 0000000..0742034 --- /dev/null +++ b/packaging/ovirt-reports/resources/Reports/Service_level/Hosts/heatmap_report_cpu_usage_br49.xml @@ -0,0 +1,232 @@ +<?xml version="1.0" encoding="UTF-8"?> +<reportUnit exportedWithPermissions="true"> + <folder>/organizations/organization_1/Reports/Service_level/Hosts</folder> + <name>heatmap_report_cpu_usage_br49</name> + <version>0</version> + <label>heatmap_report_cpu_usage_br49</label> + <description></description> + <creationDate>2015-03-22T14:36:27.819+02:00</creationDate> + <updateDate>2014-12-22T15:16:28.447+02:00</updateDate> + <mainReport> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; + exportedWithPermissions="false" + dataFile="heatmap_report_cpu_usage_br49_jrxml.data" xsi:type="fileResource"> + <folder>/organizations/organization_1/Reports/Service_level/Hosts/heatmap_report_cpu_usage_br49_files</folder> + <name>heatmap_report_cpu_usage_br49_jrxml</name> + <version>0</version> + <label>Main Jrxml</label> + <description></description> + <creationDate>2015-03-22T14:36:27.819+02:00</creationDate> + <updateDate>2015-03-22T14:36:27.819+02:00</updateDate> + <fileType>jrxml</fileType> + </localResource> + </mainReport> + <dataSource> + <uri>/organizations/organization_1/reports_resources/JDBC/data_sources/ovirt</uri> + </dataSource> + <inputControl> + <uri>/organizations/organization_1/reports_resources/JDBC/Input_Controls/Period_Affected/non-query_IC/P_Period</uri> + </inputControl> + <inputControl> + <uri>/organizations/organization_1/reports_resources/JDBC/Input_Controls/Period_Affected/non-query_IC/P_Start_Date</uri> + </inputControl> + <inputControl> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; + exportedWithPermissions="false" xsi:type="inputControl"> + <folder>/organizations/organization_1/Reports/Service_level/Hosts/heatmap_report_cpu_usage_br49_files</folder> + <name>P_Active_Host_ListID</name> + <version>0</version> + <label>$R{ic.active.hosts.list}</label> + <description></description> + <creationDate>2015-03-22T14:36:27.819+02:00</creationDate> + <updateDate>2015-03-22T14:36:27.819+02:00</updateDate> + <type>7</type> + <mandatory>true</mandatory> + <readOnly>false</readOnly> + <visible>true</visible> + <query> + <localResource exportedWithPermissions="false" xsi:type="query"> + <folder>/organizations/organization_1/Reports/Service_level/Hosts/heatmap_report_cpu_usage_br49_files/P_Active_Host_ListID_files</folder> + <name>active_hosts_multiselect</name> + <version>0</version> + <label>active_hosts_multiselect</label> + <description></description> + <creationDate>2015-03-22T14:36:27.819+02:00</creationDate> + <updateDate>2015-03-22T14:36:27.819+02:00</updateDate> + <language>sql</language> + <queryString>-- This query will return active hosts list + +SELECT DISTINCT + host_name, + CAST ( host_id AS varchar ) +FROM v3_6_configuration_history_hosts +-- Here we get the latest hosts configuration +WHERE + history_id IN ( + SELECT MAX ( a.history_id ) + FROM v3_6_configuration_history_hosts AS a + GROUP BY a.host_id + ) + AND delete_date IS NULL +ORDER BY host_name</queryString> + <dataSource> + <uri>/organizations/organization_1/reports_resources/JDBC/data_sources/ovirt</uri> + </dataSource> + </localResource> + </query> + <queryVisibleColumn>host_name</queryVisibleColumn> + <queryValueColumn>host_id</queryValueColumn> + </localResource> + </inputControl> + <inputControl> + <uri>/organizations/organization_1/reports_resources/JDBC/Input_Controls/Period_Affected/non-query_IC/P_Utilization_Measure</uri> + </inputControl> + <resource> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; + exportedWithPermissions="false" + dataFile="br49 full details.jrxml.data" xsi:type="fileResource"> + <folder>/organizations/organization_1/Reports/Service_level/Hosts/heatmap_report_cpu_usage_br49_files</folder> + <name>br49 full details.jrxml</name> + <version>0</version> + <label>br49 full details.jrxml</label> + <creationDate>2015-03-22T14:36:27.819+02:00</creationDate> + <updateDate>2015-03-22T14:36:27.819+02:00</updateDate> + <fileType>jrxml</fileType> + </localResource> + </resource> + <resource> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; + exportedWithPermissions="false" xsi:type="fileResource"> + <folder>/organizations/organization_1/Reports/Service_level/Hosts/heatmap_report_cpu_usage_br49_files</folder> + <name>ovirt_reports_bundle_en_US.properties</name> + <version>0</version> + <label>ovirt_reports_bundle_en_US.properties</label> + <creationDate>2015-03-22T14:36:27.819+02:00</creationDate> + <updateDate>2015-03-22T14:36:27.819+02:00</updateDate> + <referenceUri>/organizations/organization_1/reports_resources/localization/ovirt_reports_bundle_en_US.properties</referenceUri> + </localResource> + </resource> + <resource> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; + exportedWithPermissions="false" xsi:type="fileResource"> + <folder>/organizations/organization_1/Reports/Service_level/Hosts/heatmap_report_cpu_usage_br49_files</folder> + <name>ovirt_reports_bundle_zh_CN.properties</name> + <version>0</version> + <label>ovirt_reports_bundle_zh_CN.properties</label> + <creationDate>2015-03-22T14:36:27.819+02:00</creationDate> + <updateDate>2015-03-22T14:36:27.819+02:00</updateDate> + <referenceUri>/organizations/organization_1/reports_resources/localization/ovirt_reports_bundle_zh_CN.properties</referenceUri> + </localResource> + </resource> + <resource> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; + exportedWithPermissions="false" xsi:type="fileResource"> + <folder>/organizations/organization_1/Reports/Service_level/Hosts/heatmap_report_cpu_usage_br49_files</folder> + <name>ovirt_reports_bundle_zh_TW.properties</name> + <version>0</version> + <label>ovirt_reports_bundle_zh_TW.properties</label> + <creationDate>2015-03-22T14:36:27.819+02:00</creationDate> + <updateDate>2015-03-22T14:36:27.819+02:00</updateDate> + <referenceUri>/organizations/organization_1/reports_resources/localization/ovirt_reports_bundle_zh_TW.properties</referenceUri> + </localResource> + </resource> + <resource> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; + exportedWithPermissions="false" xsi:type="fileResource"> + <folder>/organizations/organization_1/Reports/Service_level/Hosts/heatmap_report_cpu_usage_br49_files</folder> + <name>ovirt_reports_bundle_pt_BR.properties</name> + <version>0</version> + <label>ovirt_reports_bundle_pt_BR.properties</label> + <creationDate>2015-03-22T14:36:27.819+02:00</creationDate> + <updateDate>2015-03-22T14:36:27.819+02:00</updateDate> + <referenceUri>/organizations/organization_1/reports_resources/localization/ovirt_reports_bundle_pt_BR.properties</referenceUri> + </localResource> + </resource> + <resource> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; + exportedWithPermissions="false" xsi:type="fileResource"> + <folder>/organizations/organization_1/Reports/Service_level/Hosts/heatmap_report_cpu_usage_br49_files</folder> + <name>ovirt_reports_bundle_fr.properties</name> + <version>0</version> + <label>ovirt_reports_bundle_fr.properties</label> + <creationDate>2015-03-22T14:36:27.819+02:00</creationDate> + <updateDate>2015-03-22T14:36:27.819+02:00</updateDate> + <referenceUri>/organizations/organization_1/reports_resources/localization/ovirt_reports_bundle_fr.properties</referenceUri> + </localResource> + </resource> + <resource> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; + exportedWithPermissions="false" xsi:type="fileResource"> + <folder>/organizations/organization_1/Reports/Service_level/Hosts/heatmap_report_cpu_usage_br49_files</folder> + <name>ovirt_reports_bundle_ja.properties</name> + <version>0</version> + <label>ovirt_reports_bundle_ja.properties</label> + <creationDate>2015-03-22T14:36:27.819+02:00</creationDate> + <updateDate>2015-03-22T14:36:27.819+02:00</updateDate> + <referenceUri>/organizations/organization_1/reports_resources/localization/ovirt_reports_bundle_ja.properties</referenceUri> + </localResource> + </resource> + <resource> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; + exportedWithPermissions="false" xsi:type="fileResource"> + <folder>/organizations/organization_1/Reports/Service_level/Hosts/heatmap_report_cpu_usage_br49_files</folder> + <name>ovirt_reports_bundle.properties</name> + <version>0</version> + <label>ovirt_reports_bundle.properties</label> + <creationDate>2015-03-22T14:36:27.819+02:00</creationDate> + <updateDate>2015-03-22T14:36:27.819+02:00</updateDate> + <referenceUri>/organizations/organization_1/reports_resources/localization/ovirt_reports_bundle.properties</referenceUri> + </localResource> + </resource> + <resource> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; + exportedWithPermissions="false" xsi:type="fileResource"> + <folder>/organizations/organization_1/Reports/Service_level/Hosts/heatmap_report_cpu_usage_br49_files</folder> + <name>ovirt_reports_bundle_es.properties</name> + <version>0</version> + <label>ovirt_reports_bundle_es.properties</label> + <creationDate>2015-03-22T14:36:27.819+02:00</creationDate> + <updateDate>2015-03-22T14:36:27.819+02:00</updateDate> + <referenceUri>/organizations/organization_1/reports_resources/localization/ovirt_reports_bundle_es.properties</referenceUri> + </localResource> + </resource> + <resource> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; + exportedWithPermissions="false" xsi:type="fileResource"> + <folder>/organizations/organization_1/Reports/Service_level/Hosts/heatmap_report_cpu_usage_br49_files</folder> + <name>ovirt-icon</name> + <version>0</version> + <label>ovirt-icon</label> + <creationDate>2015-03-22T14:36:27.819+02:00</creationDate> + <updateDate>2015-03-22T14:36:27.819+02:00</updateDate> + <referenceUri>/organizations/organization_1/reports_resources/ovirt-icon</referenceUri> + </localResource> + </resource> + <resource> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; + exportedWithPermissions="false" xsi:type="fileResource"> + <folder>/organizations/organization_1/Reports/Service_level/Hosts/heatmap_report_cpu_usage_br49_files</folder> + <name>ovirt_reports_bundle_de.properties</name> + <version>0</version> + <label>ovirt_reports_bundle_de.properties</label> + <creationDate>2015-03-22T14:36:27.819+02:00</creationDate> + <updateDate>2015-03-22T14:36:27.819+02:00</updateDate> + <referenceUri>/organizations/organization_1/reports_resources/localization/ovirt_reports_bundle_de.properties</referenceUri> + </localResource> + </resource> + <alwaysPromptControls>true</alwaysPromptControls> + <controlsLayout>1</controlsLayout> +</reportUnit> diff --git a/packaging/ovirt-reports/resources/Reports/Service_level/Hosts/heatmap_report_cpu_usage_br49_files/br49 full details.jrxml.data b/packaging/ovirt-reports/resources/Reports/Service_level/Hosts/heatmap_report_cpu_usage_br49_files/br49 full details.jrxml.data new file mode 100644 index 0000000..0162678 --- /dev/null +++ b/packaging/ovirt-reports/resources/Reports/Service_level/Hosts/heatmap_report_cpu_usage_br49_files/br49 full details.jrxml.data @@ -0,0 +1,202 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!-- Created with Jaspersoft Studio version last--> +<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="111" orientation="Landscape" columnWidth="830" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" resourceBundle="ovirt_reports_bundle" uuid="db807cc1-e7e7-46a3-ac18-caf2c1a22869"> + <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="/adhoc/aru/new_reports/heatmap_report_cpu_usage_br49"/> + <property name="ireport.jasperserver.url" value="http://localhost:8080/jasperserver-pro/"/> + <property name="ireport.jasperserver.report.resource" value="/adhoc/aru/new_reports/heatmap_report_cpu_usage_br49_files/br49 full details.jrxml"/> + <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_Host_Type" class="java.lang.Integer"> + <defaultValueExpression><![CDATA[-1]]></defaultValueExpression> + </parameter> + <parameter name="is_active" class="java.lang.String"/> + <parameter name="active_hosts_select" class="java.lang.String"> + <defaultValueExpression><![CDATA["AND delete_date IS NULL"]]></defaultValueExpression> + </parameter> + <parameter name="P_Locale" class="java.lang.String"> + <defaultValueExpression><![CDATA[$P{REPORT_LOCALE}.toString()]]></defaultValueExpression> + </parameter> + <queryString language="SQL"> + <![CDATA[SELECT + v3_6_configuration_history_datacenters.datacenter_name AS datacenter_name, + v3_6_configuration_history_datacenters.delete_date AS datacenter_delete_date, + COALESCE ( + ( + SELECT + ' ' + || + RTRIM ( + CAST ( v3_6_configuration_history_clusters.cluster_name AS varchar ) + ) + FROM v3_6_configuration_history_clusters + WHERE + v3_6_configuration_history_clusters.cluster_id = + CAST ( $P{P_Cluster_ID} AS uuid ) + AND v3_6_configuration_history_clusters.history_id in ( + SELECT MAX ( a.history_id ) + FROM v3_6_configuration_history_clusters AS a + GROUP BY a.cluster_id + ) + ), + 'all' + ) + AS cluster_name, + ( + SELECT v3_6_configuration_history_clusters.delete_date + FROM v3_6_configuration_history_clusters + WHERE + v3_6_configuration_history_clusters.cluster_id = + CAST ( $P{P_Cluster_ID} AS uuid ) + AND v3_6_configuration_history_clusters.history_id in ( + SELECT MAX ( a.history_id ) + FROM v3_6_configuration_history_clusters AS a + GROUP BY a.cluster_id + ) + ) + AS cluster_delete_date, + COALESCE ( + ( + SELECT DISTINCT + COALESCE ( + enum_translator_localized.value_localized, + enum_translator_default.value + ) + FROM enum_translator AS enum_translator_default + LEFT OUTER JOIN ( + SELECT + enum_type, + enum_key, + value AS value_localized + FROM enum_translator + WHERE language_code = $P{P_Locale} + ) + AS enum_translator_localized + ON ( + enum_translator_localized.enum_type = + enum_translator_default.enum_type + AND enum_translator_localized.enum_key = + enum_translator_default.enum_key + ) + WHERE language_code = 'en_US' + AND enum_translator_default.enum_key = $P{P_Host_Type} + AND enum_translator_default.enum_type = 'HOST_TYPE' + ), + 'All' + ) + AS host_type +FROM v3_6_configuration_history_datacenters +WHERE + v3_6_configuration_history_datacenters.datacenter_id = + CAST ( $P{P_DataCenter_ID} AS uuid ) + AND v3_6_configuration_history_datacenters.history_id in ( + SELECT MAX ( a.history_id ) + FROM v3_6_configuration_history_datacenters AS a + GROUP BY a.datacenter_id + )]]> + </queryString> + <field name="datacenter_name" class="java.lang.String"/> + <field name="datacenter_delete_date" class="java.sql.Timestamp"/> + <field name="cluster_name" class="java.lang.String"/> + <field name="cluster_delete_date" class="java.sql.Timestamp"/> + <field name="host_type" class="java.lang.String"/> + <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> + <title> + <band height="88" splitType="Stretch"> + <frame> + <reportElement mode="Opaque" x="0" y="30" width="828" height="40" uuid="0cf5acf1-49ac-4687-a168-d03e63e84886"/> + <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 x="91" y="0" width="381" height="20" uuid="d6ad2d65-29b6-4713-8cfc-e93d6c0246fe"/> + <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 positionType="Float" x="91" y="20" width="381" height="20" uuid="8e8c3f78-4fb8-4bcc-ad68-d77aca9b1093"/> + <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 positionType="Float" x="483" y="0" width="162" height="20" uuid="a4484416-7b97-4b82-bad2-8c814510ac3c"/> + <textElement textAlignment="Justified" verticalAlignment="Middle" markup="html"> + <font fontName="SansSerif" size="11" isBold="false"/> + </textElement> + <textFieldExpression><![CDATA[$F{host_type} != "All" ? "<b>" + $R{full.details.host.type} + ":</b> " + $F{host_type} : "<b>" + $R{full.details.host.type} + ":</b> " + $R{full.details.all}]]></textFieldExpression> + <hyperlinkTooltipExpression><![CDATA[$F{host_type} != "All" ? $F{host_type} : $R{full.details.all}]]></hyperlinkTooltipExpression> + </textField> + <textField> + <reportElement mode="Opaque" x="3" y="3" width="69" height="36" forecolor="#666666" backcolor="#E6E6E6" uuid="d9b2a65a-aaeb-4528-84e7-093f12e7c51a"/> + <textElement textAlignment="Left" verticalAlignment="Middle" markup="none"> + <font fontName="SansSerif" size="13" isBold="true"/> + </textElement> + <textFieldExpression><![CDATA[$R{full.details.criteria} + ":"]]></textFieldExpression> + </textField> + <textField> + <reportElement positionType="Float" x="483" y="20" width="345" height="20" uuid="e7cfe519-e964-4a14-8c2a-ff84b4c4ca21"/> + <textElement textAlignment="Justified" verticalAlignment="Middle" markup="html"> + <font fontName="SansSerif" size="11" isBold="false"/> + </textElement> + <textFieldExpression><![CDATA[$P{active_hosts_select} == "" ? "<b>" + $R{full.details.show.deleted.hosts} + ":</b> " + $R{full.details.yes} : "<b>" + $R{full.details.show.deleted.hosts} + ":</b> " + $R{full.details.no}]]></textFieldExpression> + <hyperlinkTooltipExpression><![CDATA[$P{active_hosts_select} == "" ? $R{full.details.yes} :$R{full.details.no}]]></hyperlinkTooltipExpression> + </textField> + </frame> + <textField evaluationTime="Report" isBlankWhenNull="false"> + <reportElement x="0" y="0" width="830" height="25" forecolor="#666666" uuid="fb1504d3-46a9-4ba1-9a3c-7ffa1f338e4c"/> + <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{br49.title}, $F{cluster_name} == "all" ? $R{full.details.clusters} : msg($R{full.details.cluster.and.name}, $F{cluster_name}) + $V{cluster_star}, $F{datacenter_name} + $V{datacenter_star})]]></textFieldExpression> + </textField> + <image> + <reportElement x="12" y="74" width="10" height="11" uuid="3eb8825d-d2ac-4f88-92bf-9fbcbbb4c23e"> + <printWhenExpression><![CDATA[$F{cluster_delete_date} != null || $F{datacenter_delete_date} != null]]></printWhenExpression> + </reportElement> + <imageExpression><![CDATA["repo:trash-icon"]]></imageExpression> + </image> + <staticText> + <reportElement x="5" y="74" width="5" height="14" forecolor="#666666" uuid="13c02ef8-db4e-42ec-bebf-f8d3b84d9565"> + <printWhenExpression><![CDATA[$F{cluster_delete_date} != null || $F{datacenter_delete_date} != null]]></printWhenExpression> + </reportElement> + <textElement verticalAlignment="Middle"> + <font fontName="SansSerif" size="12"/> + </textElement> + <text><![CDATA[*]]></text> + </staticText> + <textField> + <reportElement x="29" y="74" width="735" height="14" forecolor="#666666" uuid="fb2be784-be1d-4345-bccc-52ebe369603a"/> + <textElement markup="html"> + <font fontName="SansSerif"/> + </textElement> + <textFieldExpression><![CDATA[$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> + </band> + </title> +</jasperReport> diff --git a/packaging/ovirt-reports/resources/Reports/Service_level/Hosts/heatmap_report_cpu_usage_br49_files/heatmap_report_cpu_usage_br49_jrxml.data b/packaging/ovirt-reports/resources/Reports/Service_level/Hosts/heatmap_report_cpu_usage_br49_files/heatmap_report_cpu_usage_br49_jrxml.data new file mode 100644 index 0000000..bef7c31 --- /dev/null +++ b/packaging/ovirt-reports/resources/Reports/Service_level/Hosts/heatmap_report_cpu_usage_br49_files/heatmap_report_cpu_usage_br49_jrxml.data @@ -0,0 +1,535 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!-- Created with Jaspersoft Studio version 5.5.0--> +<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="HeatmapReport" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="26551ed9-94b8-4028-9337-1dfc3a6990c5"> + <property name="com.jaspersoft.studio.data.defaultdataadapter" value="HistoryDB"/> + <property name="ireport.jasperserver.url" value="http://localhost:8080/jasperserver-pro/"/> + <property name="ireport.jasperserver.report.resource" value="/adhoc/aru/new_reports/heatmap_report_cpu_usage_br49_files/heatmap_report_cpu_usage_br49_jrxml"/> + <property name="ireport.jasperserver.reportUnit" value="/adhoc/aru/new_reports/heatmap_report_cpu_usage_br49"/> + <style name="Crosstab_CH" mode="Opaque" backcolor="#F0F8FF"> + <box> + <pen lineWidth="0.5" lineColor="#000000"/> + <topPen lineWidth="0.5" lineColor="#000000"/> + <leftPen lineWidth="0.5" lineColor="#000000"/> + <bottomPen lineWidth="0.5" lineColor="#000000"/> + <rightPen lineWidth="0.5" lineColor="#000000"/> + </box> + </style> + <style name="Crosstab_CG" mode="Opaque" backcolor="#BFE1FF"> + <box> + <pen lineWidth="0.5" lineColor="#000000"/> + <topPen lineWidth="0.5" lineColor="#000000"/> + <leftPen lineWidth="0.5" lineColor="#000000"/> + <bottomPen lineWidth="0.5" lineColor="#000000"/> + <rightPen lineWidth="0.5" lineColor="#000000"/> + </box> + </style> + <style name="Crosstab_CT" mode="Opaque" backcolor="#005FB3"> + <box> + <pen lineWidth="0.5" lineColor="#000000"/> + <topPen lineWidth="0.5" lineColor="#000000"/> + <leftPen lineWidth="0.5" lineColor="#000000"/> + <bottomPen lineWidth="0.5" lineColor="#000000"/> + <rightPen lineWidth="0.5" lineColor="#000000"/> + </box> + </style> + <style name="Crosstab_CD" mode="Opaque" backcolor="#FFFFFF"> + <box> + <pen lineWidth="0.5" lineColor="#000000"/> + <topPen lineWidth="0.5" lineColor="#000000"/> + <leftPen lineWidth="0.5" lineColor="#000000"/> + <bottomPen lineWidth="0.5" lineColor="#000000"/> + <rightPen lineWidth="0.5" lineColor="#000000"/> + </box> + </style> + <style name="Crosstab 1_CH" mode="Opaque" backcolor="#F0F8FF"> + <box> + <pen lineWidth="0.5" lineColor="#000000"/> + <topPen lineWidth="0.5" lineColor="#000000"/> + <leftPen lineWidth="0.5" lineColor="#000000"/> + <bottomPen lineWidth="0.5" lineColor="#000000"/> + <rightPen lineWidth="0.5" lineColor="#000000"/> + </box> + </style> + <style name="Crosstab 1_CG" mode="Opaque" backcolor="#BFE1FF"> + <box> + <pen lineWidth="0.5" lineColor="#000000"/> + <topPen lineWidth="0.5" lineColor="#000000"/> + <leftPen lineWidth="0.5" lineColor="#000000"/> + <bottomPen lineWidth="0.5" lineColor="#000000"/> + <rightPen lineWidth="0.5" lineColor="#000000"/> + </box> + </style> + <style name="Crosstab 1_CT" mode="Opaque" backcolor="#005FB3"> + <box> + <pen lineWidth="0.5" lineColor="#000000"/> + <topPen lineWidth="0.5" lineColor="#000000"/> + <leftPen lineWidth="0.5" lineColor="#000000"/> + <bottomPen lineWidth="0.5" lineColor="#000000"/> + <rightPen lineWidth="0.5" lineColor="#000000"/> + </box> + </style> + <style name="Crosstab 1_CD" mode="Opaque" backcolor="#FFFFFF"> + <box> + <pen lineWidth="0.5" lineColor="#000000"/> + <topPen lineWidth="0.5" lineColor="#000000"/> + <leftPen lineWidth="0.5" lineColor="#000000"/> + <bottomPen lineWidth="0.5" lineColor="#000000"/> + <rightPen lineWidth="0.5" lineColor="#000000"/> + </box> + <conditionalStyle> + <conditionExpression><![CDATA[AND($V{CPU_Usage_MEASURE1}>0,$V{CPU_Usage_MEASURE1}< 10)]]></conditionExpression> + <style forecolor="#FFFFFF" backcolor="#154AE8" fill="Solid"/> + </conditionalStyle> + <conditionalStyle> + <conditionExpression><![CDATA[AND($V{CPU_Usage_MEASURE1}>=10,$V{CPU_Usage_MEASURE1}<20)]]></conditionExpression> + <style mode="Opaque" backcolor="#00BBFF" fill="Solid"/> + </conditionalStyle> + <conditionalStyle> + <conditionExpression><![CDATA[AND($V{CPU_Usage_MEASURE1}>=20,$V{CPU_Usage_MEASURE1}<70)]]></conditionExpression> + <style mode="Opaque" backcolor="#84E307"/> + </conditionalStyle> + <conditionalStyle> + <conditionExpression><![CDATA[AND($V{CPU_Usage_MEASURE1}>=70,$V{CPU_Usage_MEASURE1}<85)]]></conditionExpression> + <style backcolor="#F7FF00"/> + </conditionalStyle> + <conditionalStyle> + <conditionExpression><![CDATA[AND($V{CPU_Usage_MEASURE1}>=85,$V{CPU_Usage_MEASURE1}<95)]]></conditionExpression> + <style backcolor="#FC0320"/> + </conditionalStyle> + <conditionalStyle> + <conditionExpression><![CDATA[$V{CPU_Usage_MEASURE1}>=95]]></conditionExpression> + <style backcolor="#BA0F12"/> + </conditionalStyle> + </style> + <parameter name="P_Active_Host_ListID" class="java.util.Collection"/> + <parameter name="P_Period" class="java.lang.Short"> + <parameterDescription><![CDATA[Period]]></parameterDescription> + <defaultValueExpression><![CDATA[1]]></defaultValueExpression> + </parameter> + <parameter name="calendar_column" class="java.lang.String"> + <parameterDescription><![CDATA[]]></parameterDescription> + <defaultValueExpression><![CDATA[$P{P_Period} == 0 ? "the_datetime" : "the_date"]]></defaultValueExpression> + </parameter> + <parameter name="P_Start_Date" class="java.util.Date"> + <defaultValueExpression><![CDATA[DATE(2013,07,01)]]></defaultValueExpression> + </parameter> + <parameter name="table_name" class="java.lang.String"> + <defaultValueExpression><![CDATA[$P{P_Period} == 0 ? "hourly" : "daily"]]></defaultValueExpression> + </parameter> + <parameter name="P_Utilization_Measure" class="java.lang.Short"> + <parameterDescription><![CDATA[]]></parameterDescription> + <defaultValueExpression><![CDATA[1]]></defaultValueExpression> + </parameter> + <queryString language="SQL"> + <![CDATA[-- This query returns for the chosen hosts the +-- average CPU and MEMory Usage + +SELECT + $P!{calendar_column} AS the_date, + cluster_name, + host_id, + COALESCE ( + host_name, + '' + ) AS host_name, + CASE + WHEN $P!{P_Utilization_Measure} = 1 + THEN AVG ( CPU_Usage ) + ELSE AVG ( MEM_Usage ) + END AS CPU_Usage +FROM ( + SELECT + cluster_name, + v3_4_statistics_hosts_resources_usage_$P!{table_name}.host_id, + CASE + WHEN delete_date IS NULL + THEN host_name + ELSE + host_name + || + ' (Removed on ' + || + CAST ( CAST ( delete_date AS date ) AS varchar ) + || + ')' + END + AS host_name, + v3_4_statistics_hosts_resources_usage_$P!{table_name}.history_datetime AS time, + SUM ( + COALESCE ( + cpu_usage_percent, + 0 + ) * + COALESCE ( + minutes_in_status, + 0 + ) + ) / + SUM ( + COALESCE ( + minutes_in_status, + 0 + ) + ) AS CPU_Usage, + SUM ( + COALESCE ( + memory_usage_percent, + 0 + ) * + COALESCE ( + minutes_in_status, + 0 + ) + ) / + SUM ( + COALESCE ( + minutes_in_status, + 0 + ) + ) AS MEM_Usage + FROM v3_4_statistics_hosts_resources_usage_$P!{table_name} + INNER JOIN v3_4_configuration_history_hosts + ON ( + v3_4_configuration_history_hosts.host_id = + v3_4_statistics_hosts_resources_usage_$P!{table_name}.host_id + ) + LEFT OUTER JOIN v3_4_latest_configuration_clusters + ON ( + v3_4_configuration_history_hosts.cluster_id = + v3_4_latest_configuration_clusters.cluster_id + ) + WHERE + -- Here we filter by active hosts only + v3_4_statistics_hosts_resources_usage_$P!{table_name}.host_status = 1 + -- Here we filter by the hosts chosen by the user + AND $X{ IN, CAST ( v3_4_configuration_history_hosts.host_id AS varchar ), P_Active_Host_ListID } + AND history_datetime >= CAST ( $P{P_Start_Date} AS TIMESTAMP ) + AND history_datetime < + CASE + WHEN $P{P_Period} = 0 + THEN CAST ( $P{P_Start_Date} AS TIMESTAMP ) + interval '1 day' + WHEN $P{P_Period} = 1 + THEN CAST ( $P{P_Start_Date} AS TIMESTAMP ) + interval '1 month' + WHEN $P{P_Period} = 2 + THEN CAST ( $P{P_Start_Date} AS TIMESTAMP ) + interval '3 month' + WHEN $P{P_Period} = 3 + THEN CAST ( $P{P_Start_Date} AS TIMESTAMP ) + interval '1 year' + END + -- Here we get the latest hosts configuration + AND v3_4_configuration_history_hosts.history_id IN ( + SELECT MAX ( a.history_id ) + FROM v3_4_configuration_history_hosts a + GROUP BY a.host_id + ) + GROUP BY + cluster_name, + v3_4_statistics_hosts_resources_usage_$P!{table_name}.host_id, + CASE + WHEN delete_date IS NULL + THEN host_name + ELSE + host_name + || + ' (Removed on ' + || + CAST ( CAST ( delete_date AS date ) AS varchar ) + || + ')' + END, + v3_4_statistics_hosts_resources_usage_$P!{table_name}.history_datetime +) AS a + RIGHT OUTER JOIN calendar b + ON ( time = $P!{calendar_column} ) +WHERE $P!{calendar_column} >= CAST ( $P{P_Start_Date} AS date ) + AND $P!{calendar_column} < + CASE + WHEN $P{P_Period} = 0 + THEN CAST ( $P{P_Start_Date} AS TIMESTAMP ) + interval '1 day' + WHEN $P{P_Period} = 1 + THEN CAST ( $P{P_Start_Date} AS TIMESTAMP ) + interval '1 month' + WHEN $P{P_Period} = 2 + THEN CAST ( $P{P_Start_Date} AS TIMESTAMP ) + interval '3 month' + WHEN $P{P_Period} = 3 + THEN CAST ( $P{P_Start_Date} AS TIMESTAMP ) + interval '1 year' + END +GROUP BY $P!{calendar_column}, cluster_name, host_id, host_name +ORDER BY $P!{calendar_column}, cluster_name, host_id, host_name]]> + </queryString> + <field name="the_date" class="java.sql.Timestamp"/> + <field name="cluster_name" class="java.lang.String"/> + <field name="host_name" class="java.lang.String"/> + <field name="CPU_Usage" class="java.lang.Integer"/> + <title> + <band height="46" splitType="Stretch"> + <image> + <reportElement x="0" y="0" width="228" height="42" uuid="4bfbde15-b291-45fe-b280-0348380f880c"/> + <imageExpression><![CDATA["repo:ovirt-icon"]]></imageExpression> + </image> + <line> + <reportElement x="0" y="43" width="832" height="1" uuid="e624ae33-4296-4794-8b10-2294152d3ded"/> + </line> + <textField pattern=""> + <reportElement x="562" y="27" width="270" height="15" uuid="ad21820f-b1b3-4383-b610-a10c5dac8852"/> + <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> + </band> + </title> + <summary> + <band height="259" splitType="Stretch"> + <crosstab> + <reportElement x="0" y="0" width="801" height="120" uuid="23dcca58-797a-420a-a289-a8a3fcce448d"/> + <crosstabParameter name="P_Host_ListID" class="java.util.Collection"/> + <crosstabHeaderCell> + <cellContents> + <property name="local_mesure_unitheight" value="pixel"/> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + <staticText> + <reportElement style="Crosstab_CH" x="0" y="20" width="90" height="20" uuid="1b757e1a-5725-463a-82b7-6c4032ce261a"> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + </reportElement> + <box> + <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement verticalAlignment="Middle"> + <font size="10" isBold="true"/> + </textElement> + <text><![CDATA[Cluster Name]]></text> + </staticText> + <staticText> + <reportElement style="Crosstab_CH" x="90" y="20" width="60" height="20" uuid="e0077250-32dd-4352-8e24-24c506e3bb10"> + <property name="local_mesure_unitx" value="pixel"/> + <property name="com.jaspersoft.studio.unit.x" value="px"/> + </reportElement> + <box> + <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement verticalAlignment="Middle"> + <font size="10" isBold="true"/> + </textElement> + <text><![CDATA[Host Name]]></text> + </staticText> + <staticText> + <reportElement style="Crosstab_CH" x="90" y="0" width="60" height="20" uuid="90716202-c8ac-4303-8750-631148a1a085"> + <property name="local_mesure_unitx" value="pixel"/> + <property name="com.jaspersoft.studio.unit.x" value="px"/> + </reportElement> + <box> + <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement verticalAlignment="Middle"> + <font isBold="true"/> + </textElement> + <text><![CDATA[Month]]></text> + </staticText> + </cellContents> + </crosstabHeaderCell> + <rowGroup name="cluster_name1" width="90" totalPosition="End"> + <bucket class="java.lang.String"> + <bucketExpression><![CDATA[$F{cluster_name}]]></bucketExpression> + </bucket> + <crosstabRowHeader> + <cellContents mode="Opaque" style="Crosstab 1_CH"> + <property name="local_mesure_unitheight" value="pixel"/> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + <textField isStretchWithOverflow="true" isBlankWhenNull="true"> + <reportElement style="Crosstab_CD" x="0" y="0" width="90" height="20" uuid="5051c6ba-ddb9-419b-a4f7-d39ade6b45dd"> + <property name="local_mesure_unitx" value="pixel"/> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.x" value="px"/> + <property name="local_mesure_unity" value="pixel"/> + <property name="com.jaspersoft.studio.unit.y" value="px"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + </reportElement> + <box> + <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$V{cluster_name1}]]></textFieldExpression> + </textField> + </cellContents> + </crosstabRowHeader> + <crosstabTotalRowHeader> + <cellContents mode="Opaque" style="Crosstab 1_CT"> + <property name="local_mesure_unitheight" value="pixel"/> + <property name="com.jaspersoft.studio.unit.height" value="px"/> + </cellContents> + </crosstabTotalRowHeader> + </rowGroup> + <rowGroup name="host_name1" width="60" totalPosition="End"> + <bucket class="java.lang.String"> + <bucketExpression><![CDATA[$F{host_name}]]></bucketExpression> + </bucket> + <crosstabRowHeader> + <cellContents mode="Opaque" style="Crosstab 1_CH"> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + <textField> + <reportElement style="Crosstab_CD" x="0" y="0" width="60" height="20" uuid="905445c0-b005-4cc7-92f4-ef40a3bdfdec"> + <property name="local_mesure_unitx" value="pixel"/> + </reportElement> + <box> + <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$V{host_name1}]]></textFieldExpression> + </textField> + </cellContents> + </crosstabRowHeader> + <crosstabTotalRowHeader> + <cellContents mode="Opaque" style="Crosstab 1_CG"> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + <property name="local_mesure_unitheight" value="pixel"/> + <property name="com.jaspersoft.studio.unit.height" value="px"/> + </cellContents> + </crosstabTotalRowHeader> + </rowGroup> + <columnGroup name="month" height="20" totalPosition="End" headerPosition="Stretch"> + <bucket class="java.lang.String"> + <bucketExpression><![CDATA[$P{P_Period}==0 ? DATEFORMAT($F{the_date},"MMM d, yyyy") : $P{P_Period}==1 ? DATEFORMAT($F{the_date},"MMMM, yyyy") : DATEFORMAT($F{the_date},"yyyy")]]></bucketExpression> + </bucket> + <crosstabColumnHeader> + <cellContents mode="Opaque" style="Crosstab 1_CH"> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + <property name="local_mesure_unitheight" value="pixel"/> + <property name="com.jaspersoft.studio.unit.height" value="px"/> + <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false"> + <reportElement style="Crosstab_CH" x="0" y="0" width="20" height="20" uuid="7e4c1c05-96a7-4c6c-ad08-50cf24255af9"> + <property name="local_mesure_unitheight" value="pixel"/> + <property name="com.jaspersoft.studio.unit.height" value="px"/> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + </reportElement> + <box> + <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font isBold="true"/> + </textElement> + <textFieldExpression><![CDATA[$V{month}]]></textFieldExpression> + </textField> + </cellContents> + </crosstabColumnHeader> + <crosstabTotalColumnHeader> + <cellContents mode="Opaque" style="Crosstab 1_CT"> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + </cellContents> + </crosstabTotalColumnHeader> + </columnGroup> + <columnGroup name="Day" height="20" totalPosition="End" headerPosition="Stretch"> + <bucket class="java.lang.String"> + <bucketExpression><![CDATA[$P{P_Period}==0 ? DATEFORMAT($F{the_date},"HH") : $P{P_Period}==1 ? DAY($F{the_date}): DATEFORMAT($F{the_date},"MMM")]]></bucketExpression> + </bucket> + <crosstabColumnHeader> + <cellContents> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + <property name="local_mesure_unitheight" value="pixel"/> + <property name="com.jaspersoft.studio.unit.height" value="px"/> + <textField isStretchWithOverflow="true" isBlankWhenNull="true"> + <reportElement style="Crosstab_CH" x="0" y="0" width="20" height="20" uuid="a3699af9-2c6d-4c04-8884-b298f446001a"> + <property name="local_mesure_unitheight" value="pixel"/> + <property name="com.jaspersoft.studio.unit.height" value="px"/> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + </reportElement> + <box> + <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="10" isBold="true"/> + </textElement> + <textFieldExpression><![CDATA[$V{Day}]]></textFieldExpression> + </textField> + </cellContents> + </crosstabColumnHeader> + <crosstabTotalColumnHeader> + <cellContents/> + </crosstabTotalColumnHeader> + </columnGroup> + <measure name="CPU_Usage_MEASURE1" class="java.lang.Integer" calculation="Sum"> + <measureExpression><![CDATA[$F{CPU_Usage}]]></measureExpression> + </measure> + <crosstabCell width="20" height="20"> + <cellContents mode="Opaque" style="Crosstab 1_CD"> + <textField> + <reportElement x="0" y="0" width="20" height="20" uuid="959dcf0a-9fe7-4846-9f10-22df143e13e9"> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + </reportElement> + <box> + <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$V{CPU_Usage_MEASURE1}]]></textFieldExpression> + </textField> + </cellContents> + </crosstabCell> + <crosstabCell width="0" height="20" columnTotalGroup="month"> + <cellContents mode="Opaque" style="Crosstab 1_CT"/> + </crosstabCell> + <crosstabCell width="20" height="0" rowTotalGroup="cluster_name1"> + <cellContents mode="Opaque" style="Crosstab 1_CT"/> + </crosstabCell> + <crosstabCell width="0" height="0" rowTotalGroup="cluster_name1" columnTotalGroup="month"> + <cellContents mode="Opaque" style="Crosstab 1_CT"/> + </crosstabCell> + <crosstabCell width="20" height="0" rowTotalGroup="host_name1"> + <cellContents mode="Opaque" style="Crosstab 1_CG"/> + </crosstabCell> + <crosstabCell width="0" height="0" rowTotalGroup="host_name1" columnTotalGroup="month"> + <cellContents mode="Opaque" style="Crosstab 1_CT"/> + </crosstabCell> + <crosstabCell width="0" height="20" columnTotalGroup="Day"> + <cellContents> + <property name="local_mesure_unitheight" value="pixel"/> + </cellContents> + </crosstabCell> + <crosstabCell width="0" height="0" rowTotalGroup="cluster_name1" columnTotalGroup="Day"> + <cellContents> + <property name="local_mesure_unitheight" value="pixel"/> + </cellContents> + </crosstabCell> + <crosstabCell width="0" height="0" rowTotalGroup="host_name1" columnTotalGroup="Day"> + <cellContents> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + <property name="local_mesure_unitheight" value="pixel"/> + </cellContents> + </crosstabCell> + </crosstab> + </band> + </summary> +</jasperReport> diff --git a/packaging/ovirt-reports/resources/Reports/Service_level/Hosts/heatmap_report_mem_usage_br50.xml b/packaging/ovirt-reports/resources/Reports/Service_level/Hosts/heatmap_report_mem_usage_br50.xml new file mode 100644 index 0000000..4e4c7d7 --- /dev/null +++ b/packaging/ovirt-reports/resources/Reports/Service_level/Hosts/heatmap_report_mem_usage_br50.xml @@ -0,0 +1,229 @@ +<?xml version="1.0" encoding="UTF-8"?> +<reportUnit exportedWithPermissions="true"> + <folder>/organizations/organization_1/Reports/Service_level/Hosts</folder> + <name>heatmap_report_mem_usage_br50</name> + <version>0</version> + <label>heatmap_report_mem_usage_br50</label> + <description></description> + <creationDate>2015-03-22T14:36:41.543+02:00</creationDate> + <updateDate>2014-12-22T13:47:19.990+02:00</updateDate> + <mainReport> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; + exportedWithPermissions="false" + dataFile="heatmap_report_mem_usage_br50_jrxml.data" xsi:type="fileResource"> + <folder>/organizations/organization_1/Reports/Service_level/Hosts/heatmap_report_mem_usage_br50_files</folder> + <name>heatmap_report_mem_usage_br50_jrxml</name> + <version>0</version> + <label>Main jrxml</label> + <description></description> + <creationDate>2015-03-22T14:36:41.543+02:00</creationDate> + <updateDate>2015-03-22T14:36:41.543+02:00</updateDate> + <fileType>jrxml</fileType> + </localResource> + </mainReport> + <dataSource> + <uri>/organizations/organization_1/reports_resources/JDBC/data_sources/ovirt</uri> + </dataSource> + <inputControl> + <uri>/organizations/organization_1/reports_resources/JDBC/Input_Controls/Period_Affected/non-query_IC/P_Period</uri> + </inputControl> + <inputControl> + <uri>/organizations/organization_1/reports_resources/JDBC/Input_Controls/Period_Affected/non-query_IC/P_Start_Date</uri> + </inputControl> + <inputControl> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; + exportedWithPermissions="false" xsi:type="inputControl"> + <folder>/organizations/organization_1/Reports/Service_level/Hosts/heatmap_report_mem_usage_br50_files</folder> + <name>P_Active_Host_ListID</name> + <version>0</version> + <label>$R{ic.active.hosts.list}</label> + <description></description> + <creationDate>2015-03-22T14:36:41.543+02:00</creationDate> + <updateDate>2015-03-22T14:36:41.543+02:00</updateDate> + <type>7</type> + <mandatory>true</mandatory> + <readOnly>false</readOnly> + <visible>true</visible> + <query> + <localResource exportedWithPermissions="false" xsi:type="query"> + <folder>/organizations/organization_1/Reports/Service_level/Hosts/heatmap_report_mem_usage_br50_files/P_Active_Host_ListID_files</folder> + <name>active_hosts_multiselect</name> + <version>0</version> + <label>active_hosts_multiselect</label> + <description></description> + <creationDate>2015-03-22T14:36:41.543+02:00</creationDate> + <updateDate>2015-03-22T14:36:41.543+02:00</updateDate> + <language>sql</language> + <queryString>-- This query will return active hosts list + +SELECT DISTINCT + host_name, + CAST ( host_id AS varchar ) +FROM v3_6_configuration_history_hosts +-- Here we get the latest hosts configuration +WHERE + history_id IN ( + SELECT MAX ( a.history_id ) + FROM v3_6_configuration_history_hosts AS a + GROUP BY a.host_id + ) + AND delete_date IS NULL +ORDER BY host_name</queryString> + <dataSource> + <uri>/organizations/organization_1/reports_resources/JDBC/data_sources/ovirt</uri> + </dataSource> + </localResource> + </query> + <queryVisibleColumn>host_name</queryVisibleColumn> + <queryValueColumn>host_id</queryValueColumn> + </localResource> + </inputControl> + <resource> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; + exportedWithPermissions="false" xsi:type="fileResource"> + <folder>/organizations/organization_1/Reports/Service_level/Hosts/heatmap_report_mem_usage_br50_files</folder> + <name>ovirt_reports_bundle_en_US.properties</name> + <version>0</version> + <label>ovirt_reports_bundle_en_US.properties</label> + <creationDate>2015-03-22T14:36:41.543+02:00</creationDate> + <updateDate>2015-03-22T14:36:41.543+02:00</updateDate> + <referenceUri>/organizations/organization_1/reports_resources/localization/ovirt_reports_bundle_en_US.properties</referenceUri> + </localResource> + </resource> + <resource> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; + exportedWithPermissions="false" xsi:type="fileResource"> + <folder>/organizations/organization_1/Reports/Service_level/Hosts/heatmap_report_mem_usage_br50_files</folder> + <name>ovirt_reports_bundle_zh_CN.properties</name> + <version>0</version> + <label>ovirt_reports_bundle_zh_CN.properties</label> + <creationDate>2015-03-22T14:36:41.543+02:00</creationDate> + <updateDate>2015-03-22T14:36:41.543+02:00</updateDate> + <referenceUri>/organizations/organization_1/reports_resources/localization/ovirt_reports_bundle_zh_CN.properties</referenceUri> + </localResource> + </resource> + <resource> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; + exportedWithPermissions="false" + dataFile="br50 full details.jrxml.data" xsi:type="fileResource"> + <folder>/organizations/organization_1/Reports/Service_level/Hosts/heatmap_report_mem_usage_br50_files</folder> + <name>br50 full details.jrxml</name> + <version>0</version> + <label>br50 full details.jrxml</label> + <creationDate>2015-03-22T14:36:41.543+02:00</creationDate> + <updateDate>2015-03-22T14:36:41.543+02:00</updateDate> + <fileType>jrxml</fileType> + </localResource> + </resource> + <resource> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; + exportedWithPermissions="false" xsi:type="fileResource"> + <folder>/organizations/organization_1/Reports/Service_level/Hosts/heatmap_report_mem_usage_br50_files</folder> + <name>ovirt_reports_bundle_zh_TW.properties</name> + <version>0</version> + <label>ovirt_reports_bundle_zh_TW.properties</label> + <creationDate>2015-03-22T14:36:41.543+02:00</creationDate> + <updateDate>2015-03-22T14:36:41.543+02:00</updateDate> + <referenceUri>/organizations/organization_1/reports_resources/localization/ovirt_reports_bundle_zh_TW.properties</referenceUri> + </localResource> + </resource> + <resource> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; + exportedWithPermissions="false" xsi:type="fileResource"> + <folder>/organizations/organization_1/Reports/Service_level/Hosts/heatmap_report_mem_usage_br50_files</folder> + <name>ovirt_reports_bundle_pt_BR.properties</name> + <version>0</version> + <label>ovirt_reports_bundle_pt_BR.properties</label> + <creationDate>2015-03-22T14:36:41.543+02:00</creationDate> + <updateDate>2015-03-22T14:36:41.543+02:00</updateDate> + <referenceUri>/organizations/organization_1/reports_resources/localization/ovirt_reports_bundle_pt_BR.properties</referenceUri> + </localResource> + </resource> + <resource> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; + exportedWithPermissions="false" xsi:type="fileResource"> + <folder>/organizations/organization_1/Reports/Service_level/Hosts/heatmap_report_mem_usage_br50_files</folder> + <name>ovirt_reports_bundle_fr.properties</name> + <version>0</version> + <label>ovirt_reports_bundle_fr.properties</label> + <creationDate>2015-03-22T14:36:41.543+02:00</creationDate> + <updateDate>2015-03-22T14:36:41.543+02:00</updateDate> + <referenceUri>/organizations/organization_1/reports_resources/localization/ovirt_reports_bundle_fr.properties</referenceUri> + </localResource> + </resource> + <resource> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; + exportedWithPermissions="false" xsi:type="fileResource"> + <folder>/organizations/organization_1/Reports/Service_level/Hosts/heatmap_report_mem_usage_br50_files</folder> + <name>ovirt_reports_bundle_ja.properties</name> + <version>0</version> + <label>ovirt_reports_bundle_ja.properties</label> + <creationDate>2015-03-22T14:36:41.543+02:00</creationDate> + <updateDate>2015-03-22T14:36:41.543+02:00</updateDate> + <referenceUri>/organizations/organization_1/reports_resources/localization/ovirt_reports_bundle_ja.properties</referenceUri> + </localResource> + </resource> + <resource> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; + exportedWithPermissions="false" xsi:type="fileResource"> + <folder>/organizations/organization_1/Reports/Service_level/Hosts/heatmap_report_mem_usage_br50_files</folder> + <name>ovirt_reports_bundle.properties</name> + <version>0</version> + <label>ovirt_reports_bundle.properties</label> + <creationDate>2015-03-22T14:36:41.543+02:00</creationDate> + <updateDate>2015-03-22T14:36:41.543+02:00</updateDate> + <referenceUri>/organizations/organization_1/reports_resources/localization/ovirt_reports_bundle.properties</referenceUri> + </localResource> + </resource> + <resource> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; + exportedWithPermissions="false" xsi:type="fileResource"> + <folder>/organizations/organization_1/Reports/Service_level/Hosts/heatmap_report_mem_usage_br50_files</folder> + <name>ovirt_reports_bundle_es.properties</name> + <version>0</version> + <label>ovirt_reports_bundle_es.properties</label> + <creationDate>2015-03-22T14:36:41.543+02:00</creationDate> + <updateDate>2015-03-22T14:36:41.543+02:00</updateDate> + <referenceUri>/organizations/organization_1/reports_resources/localization/ovirt_reports_bundle_es.properties</referenceUri> + </localResource> + </resource> + <resource> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; + exportedWithPermissions="false" xsi:type="fileResource"> + <folder>/organizations/organization_1/Reports/Service_level/Hosts/heatmap_report_mem_usage_br50_files</folder> + <name>ovirt-icon</name> + <version>0</version> + <label>ovirt-icon</label> + <creationDate>2015-03-22T14:36:41.543+02:00</creationDate> + <updateDate>2015-03-22T14:36:41.543+02:00</updateDate> + <referenceUri>/organizations/organization_1/reports_resources/ovirt-icon</referenceUri> + </localResource> + </resource> + <resource> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; + exportedWithPermissions="false" xsi:type="fileResource"> + <folder>/organizations/organization_1/Reports/Service_level/Hosts/heatmap_report_mem_usage_br50_files</folder> + <name>ovirt_reports_bundle_de.properties</name> + <version>0</version> + <label>ovirt_reports_bundle_de.properties</label> + <creationDate>2015-03-22T14:36:41.543+02:00</creationDate> + <updateDate>2015-03-22T14:36:41.543+02:00</updateDate> + <referenceUri>/organizations/organization_1/reports_resources/localization/ovirt_reports_bundle_de.properties</referenceUri> + </localResource> + </resource> + <alwaysPromptControls>true</alwaysPromptControls> + <controlsLayout>1</controlsLayout> +</reportUnit> diff --git a/packaging/ovirt-reports/resources/Reports/Service_level/Hosts/heatmap_report_mem_usage_br50_files/br50 full details.jrxml.data b/packaging/ovirt-reports/resources/Reports/Service_level/Hosts/heatmap_report_mem_usage_br50_files/br50 full details.jrxml.data new file mode 100644 index 0000000..3ca7cf1 --- /dev/null +++ b/packaging/ovirt-reports/resources/Reports/Service_level/Hosts/heatmap_report_mem_usage_br50_files/br50 full details.jrxml.data @@ -0,0 +1,202 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!-- Created with Jaspersoft Studio version last--> +<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="111" orientation="Landscape" columnWidth="830" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" resourceBundle="ovirt_reports_bundle" uuid="db807cc1-e7e7-46a3-ac18-caf2c1a22869"> + <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="/adhoc/aru/new_reports/heatmap_report_mem_usage_br50"/> + <property name="ireport.jasperserver.url" value="http://localhost:8080/jasperserver-pro/"/> + <property name="ireport.jasperserver.report.resource" value="/adhoc/aru/new_reports/heatmap_report_mem_usage_br50_files/br50 full details.jrxml"/> + <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_Host_Type" class="java.lang.Integer"> + <defaultValueExpression><![CDATA[-1]]></defaultValueExpression> + </parameter> + <parameter name="is_active" class="java.lang.String"/> + <parameter name="active_hosts_select" class="java.lang.String"> + <defaultValueExpression><![CDATA["AND delete_date IS NULL"]]></defaultValueExpression> + </parameter> + <parameter name="P_Locale" class="java.lang.String"> + <defaultValueExpression><![CDATA[$P{REPORT_LOCALE}.toString()]]></defaultValueExpression> + </parameter> + <queryString language="SQL"> + <![CDATA[SELECT + v3_6_configuration_history_datacenters.datacenter_name AS datacenter_name, + v3_6_configuration_history_datacenters.delete_date AS datacenter_delete_date, + COALESCE ( + ( + SELECT + ' ' + || + RTRIM ( + CAST ( v3_6_configuration_history_clusters.cluster_name AS varchar ) + ) + FROM v3_6_configuration_history_clusters + WHERE + v3_6_configuration_history_clusters.cluster_id = + CAST ( $P{P_Cluster_ID} AS uuid ) + AND v3_6_configuration_history_clusters.history_id in ( + SELECT MAX ( a.history_id ) + FROM v3_6_configuration_history_clusters AS a + GROUP BY a.cluster_id + ) + ), + 'all' + ) + AS cluster_name, + ( + SELECT v3_6_configuration_history_clusters.delete_date + FROM v3_6_configuration_history_clusters + WHERE + v3_6_configuration_history_clusters.cluster_id = + CAST ( $P{P_Cluster_ID} AS uuid ) + AND v3_6_configuration_history_clusters.history_id in ( + SELECT MAX ( a.history_id ) + FROM v3_6_configuration_history_clusters AS a + GROUP BY a.cluster_id + ) + ) + AS cluster_delete_date, + COALESCE ( + ( + SELECT DISTINCT + COALESCE ( + enum_translator_localized.value_localized, + enum_translator_default.value + ) + FROM enum_translator AS enum_translator_default + LEFT OUTER JOIN ( + SELECT + enum_type, + enum_key, + value AS value_localized + FROM enum_translator + WHERE language_code = $P{P_Locale} + ) + AS enum_translator_localized + ON ( + enum_translator_localized.enum_type = + enum_translator_default.enum_type + AND enum_translator_localized.enum_key = + enum_translator_default.enum_key + ) + WHERE language_code = 'en_US' + AND enum_translator_default.enum_key = $P{P_Host_Type} + AND enum_translator_default.enum_type = 'HOST_TYPE' + ), + 'All' + ) + AS host_type +FROM v3_6_configuration_history_datacenters +WHERE + v3_6_configuration_history_datacenters.datacenter_id = + CAST ( $P{P_DataCenter_ID} AS uuid ) + AND v3_6_configuration_history_datacenters.history_id in ( + SELECT MAX ( a.history_id ) + FROM v3_6_configuration_history_datacenters AS a + GROUP BY a.datacenter_id + )]]> + </queryString> + <field name="datacenter_name" class="java.lang.String"/> + <field name="datacenter_delete_date" class="java.sql.Timestamp"/> + <field name="cluster_name" class="java.lang.String"/> + <field name="cluster_delete_date" class="java.sql.Timestamp"/> + <field name="host_type" class="java.lang.String"/> + <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> + <title> + <band height="88" splitType="Stretch"> + <frame> + <reportElement mode="Opaque" x="0" y="30" width="828" height="40" uuid="0cf5acf1-49ac-4687-a168-d03e63e84886"/> + <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 x="91" y="0" width="381" height="20" uuid="d6ad2d65-29b6-4713-8cfc-e93d6c0246fe"/> + <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 positionType="Float" x="91" y="20" width="381" height="20" uuid="8e8c3f78-4fb8-4bcc-ad68-d77aca9b1093"/> + <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 positionType="Float" x="483" y="0" width="162" height="20" uuid="a4484416-7b97-4b82-bad2-8c814510ac3c"/> + <textElement textAlignment="Justified" verticalAlignment="Middle" markup="html"> + <font fontName="SansSerif" size="11" isBold="false"/> + </textElement> + <textFieldExpression><![CDATA[$F{host_type} != "All" ? "<b>" + $R{full.details.host.type} + ":</b> " + $F{host_type} : "<b>" + $R{full.details.host.type} + ":</b> " + $R{full.details.all}]]></textFieldExpression> + <hyperlinkTooltipExpression><![CDATA[$F{host_type} != "All" ? $F{host_type} : $R{full.details.all}]]></hyperlinkTooltipExpression> + </textField> + <textField> + <reportElement mode="Opaque" x="3" y="3" width="69" height="36" forecolor="#666666" backcolor="#E6E6E6" uuid="d9b2a65a-aaeb-4528-84e7-093f12e7c51a"/> + <textElement textAlignment="Left" verticalAlignment="Middle" markup="none"> + <font fontName="SansSerif" size="13" isBold="true"/> + </textElement> + <textFieldExpression><![CDATA[$R{full.details.criteria} + ":"]]></textFieldExpression> + </textField> + <textField> + <reportElement positionType="Float" x="483" y="20" width="345" height="20" uuid="e7cfe519-e964-4a14-8c2a-ff84b4c4ca21"/> + <textElement textAlignment="Justified" verticalAlignment="Middle" markup="html"> + <font fontName="SansSerif" size="11" isBold="false"/> + </textElement> + <textFieldExpression><![CDATA[$P{active_hosts_select} == "" ? "<b>" + $R{full.details.show.deleted.hosts} + ":</b> " + $R{full.details.yes} : "<b>" + $R{full.details.show.deleted.hosts} + ":</b> " + $R{full.details.no}]]></textFieldExpression> + <hyperlinkTooltipExpression><![CDATA[$P{active_hosts_select} == "" ? $R{full.details.yes} :$R{full.details.no}]]></hyperlinkTooltipExpression> + </textField> + </frame> + <textField evaluationTime="Report" isBlankWhenNull="false"> + <reportElement x="0" y="0" width="830" height="25" forecolor="#666666" uuid="fb1504d3-46a9-4ba1-9a3c-7ffa1f338e4c"/> + <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{br48.title}, $F{cluster_name} == "all" ? $R{full.details.clusters} : msg($R{full.details.cluster.and.name}, $F{cluster_name}) + $V{cluster_star}, $F{datacenter_name} + $V{datacenter_star})]]></textFieldExpression> + </textField> + <image> + <reportElement x="12" y="74" width="10" height="11" uuid="3eb8825d-d2ac-4f88-92bf-9fbcbbb4c23e"> + <printWhenExpression><![CDATA[$F{cluster_delete_date} != null || $F{datacenter_delete_date} != null]]></printWhenExpression> + </reportElement> + <imageExpression><![CDATA["repo:trash-icon"]]></imageExpression> + </image> + <staticText> + <reportElement x="5" y="74" width="5" height="14" forecolor="#666666" uuid="13c02ef8-db4e-42ec-bebf-f8d3b84d9565"> + <printWhenExpression><![CDATA[$F{cluster_delete_date} != null || $F{datacenter_delete_date} != null]]></printWhenExpression> + </reportElement> + <textElement verticalAlignment="Middle"> + <font fontName="SansSerif" size="12"/> + </textElement> + <text><![CDATA[*]]></text> + </staticText> + <textField> + <reportElement x="29" y="74" width="735" height="14" forecolor="#666666" uuid="fb2be784-be1d-4345-bccc-52ebe369603a"/> + <textElement markup="html"> + <font fontName="SansSerif"/> + </textElement> + <textFieldExpression><![CDATA[$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> + </band> + </title> +</jasperReport> diff --git a/packaging/ovirt-reports/resources/Reports/Service_level/Hosts/heatmap_report_mem_usage_br50_files/heatmap_report_mem_usage_br50_jrxml.data b/packaging/ovirt-reports/resources/Reports/Service_level/Hosts/heatmap_report_mem_usage_br50_files/heatmap_report_mem_usage_br50_jrxml.data new file mode 100644 index 0000000..4e4f660 --- /dev/null +++ b/packaging/ovirt-reports/resources/Reports/Service_level/Hosts/heatmap_report_mem_usage_br50_files/heatmap_report_mem_usage_br50_jrxml.data @@ -0,0 +1,523 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!-- Created with Jaspersoft Studio version 5.5.0--> +<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="HeatmapReport" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="26551ed9-94b8-4028-9337-1dfc3a6990c5"> + <property name="com.jaspersoft.studio.data.defaultdataadapter" value="HistoryDB"/> + <property name="ireport.jasperserver.url" value="http://localhost:8080/jasperserver-pro/"/> + <property name="ireport.jasperserver.report.resource" value="/adhoc/aru/new_reports/heatmap_report_mem_usage_br50_files/heatmap_report_mem_usage_br50_jrxml"/> + <property name="ireport.jasperserver.reportUnit" value="/adhoc/aru/new_reports/heatmap_report_mem_usage_br50"/> + <style name="Crosstab_CH" mode="Opaque" backcolor="#F0F8FF"> + <box> + <pen lineWidth="0.5" lineColor="#000000"/> + <topPen lineWidth="0.5" lineColor="#000000"/> + <leftPen lineWidth="0.5" lineColor="#000000"/> + <bottomPen lineWidth="0.5" lineColor="#000000"/> + <rightPen lineWidth="0.5" lineColor="#000000"/> + </box> + </style> + <style name="Crosstab_CG" mode="Opaque" backcolor="#BFE1FF"> + <box> + <pen lineWidth="0.5" lineColor="#000000"/> + <topPen lineWidth="0.5" lineColor="#000000"/> + <leftPen lineWidth="0.5" lineColor="#000000"/> + <bottomPen lineWidth="0.5" lineColor="#000000"/> + <rightPen lineWidth="0.5" lineColor="#000000"/> + </box> + </style> + <style name="Crosstab_CT" mode="Opaque" backcolor="#005FB3"> + <box> + <pen lineWidth="0.5" lineColor="#000000"/> + <topPen lineWidth="0.5" lineColor="#000000"/> + <leftPen lineWidth="0.5" lineColor="#000000"/> + <bottomPen lineWidth="0.5" lineColor="#000000"/> + <rightPen lineWidth="0.5" lineColor="#000000"/> + </box> + </style> + <style name="Crosstab_CD" mode="Opaque" backcolor="#FFFFFF"> + <box> + <pen lineWidth="0.5" lineColor="#000000"/> + <topPen lineWidth="0.5" lineColor="#000000"/> + <leftPen lineWidth="0.5" lineColor="#000000"/> + <bottomPen lineWidth="0.5" lineColor="#000000"/> + <rightPen lineWidth="0.5" lineColor="#000000"/> + </box> + </style> + <style name="Crosstab 1_CH" mode="Opaque" backcolor="#F0F8FF"> + <box> + <pen lineWidth="0.5" lineColor="#000000"/> + <topPen lineWidth="0.5" lineColor="#000000"/> + <leftPen lineWidth="0.5" lineColor="#000000"/> + <bottomPen lineWidth="0.5" lineColor="#000000"/> + <rightPen lineWidth="0.5" lineColor="#000000"/> + </box> + </style> + <style name="Crosstab 1_CG" mode="Opaque" backcolor="#BFE1FF"> + <box> + <pen lineWidth="0.5" lineColor="#000000"/> + <topPen lineWidth="0.5" lineColor="#000000"/> + <leftPen lineWidth="0.5" lineColor="#000000"/> + <bottomPen lineWidth="0.5" lineColor="#000000"/> + <rightPen lineWidth="0.5" lineColor="#000000"/> + </box> + </style> + <style name="Crosstab 1_CT" mode="Opaque" backcolor="#005FB3"> + <box> + <pen lineWidth="0.5" lineColor="#000000"/> + <topPen lineWidth="0.5" lineColor="#000000"/> + <leftPen lineWidth="0.5" lineColor="#000000"/> + <bottomPen lineWidth="0.5" lineColor="#000000"/> + <rightPen lineWidth="0.5" lineColor="#000000"/> + </box> + </style> + <style name="Crosstab 1_CD" mode="Opaque" backcolor="#FFFFFF"> + <box> + <pen lineWidth="0.5" lineColor="#000000"/> + <topPen lineWidth="0.5" lineColor="#000000"/> + <leftPen lineWidth="0.5" lineColor="#000000"/> + <bottomPen lineWidth="0.5" lineColor="#000000"/> + <rightPen lineWidth="0.5" lineColor="#000000"/> + </box> + <conditionalStyle> + <conditionExpression><![CDATA[AND($V{MEM_Usage_MEASURE1}>0,$V{MEM_Usage_MEASURE1}< 10)]]></conditionExpression> + <style forecolor="#FFFFFF" backcolor="#154AE8" fill="Solid"/> + </conditionalStyle> + <conditionalStyle> + <conditionExpression><![CDATA[AND($V{MEM_Usage_MEASURE1}>=10,$V{MEM_Usage_MEASURE1}<20)]]></conditionExpression> + <style mode="Opaque" backcolor="#00BBFF" fill="Solid"/> + </conditionalStyle> + <conditionalStyle> + <conditionExpression><![CDATA[AND($V{MEM_Usage_MEASURE1}>=20,$V{MEM_Usage_MEASURE1}<70)]]></conditionExpression> + <style mode="Opaque" backcolor="#84E307"/> + </conditionalStyle> + <conditionalStyle> + <conditionExpression><![CDATA[AND($V{MEM_Usage_MEASURE1}>=70,$V{MEM_Usage_MEASURE1}<85)]]></conditionExpression> + <style backcolor="#F7FF00"/> + </conditionalStyle> + <conditionalStyle> + <conditionExpression><![CDATA[AND($V{MEM_Usage_MEASURE1}>=85,$V{MEM_Usage_MEASURE1}<95)]]></conditionExpression> + <style backcolor="#FC0320"/> + </conditionalStyle> + <conditionalStyle> + <conditionExpression><![CDATA[$V{MEM_Usage_MEASURE1}>=95]]></conditionExpression> + <style backcolor="#BA0F12"/> + </conditionalStyle> + </style> + <parameter name="P_Active_Host_ListID" class="java.util.Collection"/> + <parameter name="P_Period" class="java.lang.Short"> + <parameterDescription><![CDATA[Period]]></parameterDescription> + <defaultValueExpression><![CDATA[1]]></defaultValueExpression> + </parameter> + <parameter name="calendar_column" class="java.lang.String"> + <parameterDescription><![CDATA[]]></parameterDescription> + <defaultValueExpression><![CDATA[$P{P_Period} == 0 ? "the_datetime" : "the_date"]]></defaultValueExpression> + </parameter> + <parameter name="P_Start_Date" class="java.util.Date"> + <defaultValueExpression><![CDATA[DATE(2013,07,01)]]></defaultValueExpression> + </parameter> + <parameter name="table_name" class="java.lang.String"> + <defaultValueExpression><![CDATA[$P{P_Period} == 0 ? "hourly" : "daily"]]></defaultValueExpression> + </parameter> + <queryString language="SQL"> + <![CDATA[-- This query returns for the chosen hosts the +-- average CPU and MEMory Usage + +SELECT + $P!{calendar_column} AS the_date, + cluster_name, + host_id, + COALESCE ( + host_name, + '' + ) AS host_name, + AVG ( CPU_Usage ) AS CPU_Usage, + AVG ( MEM_Usage ) AS MEM_Usage +FROM ( + SELECT + cluster_name, + v3_4_statistics_hosts_resources_usage_$P!{table_name}.host_id, + CASE + WHEN delete_date IS NULL + THEN host_name + ELSE + host_name + || + ' (Removed on ' + || + CAST ( CAST ( delete_date AS date ) AS varchar ) + || + ')' + END + AS host_name, + v3_4_statistics_hosts_resources_usage_$P!{table_name}.history_datetime AS time, + SUM ( + COALESCE ( + cpu_usage_percent, + 0 + ) * + COALESCE ( + minutes_in_status, + 0 + ) + ) / + SUM ( + COALESCE ( + minutes_in_status, + 0 + ) + ) AS CPU_Usage, + SUM ( + COALESCE ( + memory_usage_percent, + 0 + ) * + COALESCE ( + minutes_in_status, + 0 + ) + ) / + SUM ( + COALESCE ( + minutes_in_status, + 0 + ) + ) AS MEM_Usage + FROM v3_4_statistics_hosts_resources_usage_$P!{table_name} + INNER JOIN v3_4_configuration_history_hosts + ON ( + v3_4_configuration_history_hosts.host_id = + v3_4_statistics_hosts_resources_usage_$P!{table_name}.host_id + ) + LEFT OUTER JOIN v3_4_latest_configuration_clusters + ON ( + v3_4_configuration_history_hosts.cluster_id = + v3_4_latest_configuration_clusters.cluster_id + ) + WHERE + -- Here we filter by active hosts only + v3_4_statistics_hosts_resources_usage_$P!{table_name}.host_status = 1 + -- Here we filter by the hosts chosen by the user + AND $X{ IN, CAST ( v3_4_configuration_history_hosts.host_id AS varchar ), P_Active_Host_ListID } + AND history_datetime >= CAST ( $P{P_Start_Date} AS TIMESTAMP ) + AND history_datetime < + CASE + WHEN $P{P_Period} = 0 + THEN CAST ( $P{P_Start_Date} AS TIMESTAMP ) + interval '1 day' + WHEN $P{P_Period} = 1 + THEN CAST ( $P{P_Start_Date} AS TIMESTAMP ) + interval '1 month' + WHEN $P{P_Period} = 2 + THEN CAST ( $P{P_Start_Date} AS TIMESTAMP ) + interval '3 month' + WHEN $P{P_Period} = 3 + THEN CAST ( $P{P_Start_Date} AS TIMESTAMP ) + interval '1 year' + END + -- Here we get the latest hosts configuration + AND v3_4_configuration_history_hosts.history_id IN ( + SELECT MAX ( a.history_id ) + FROM v3_4_configuration_history_hosts a + GROUP BY a.host_id + ) + GROUP BY + cluster_name, + v3_4_statistics_hosts_resources_usage_$P!{table_name}.host_id, + CASE + WHEN delete_date IS NULL + THEN host_name + ELSE + host_name + || + ' (Removed on ' + || + CAST ( CAST ( delete_date AS date ) AS varchar ) + || + ')' + END, + v3_4_statistics_hosts_resources_usage_$P!{table_name}.history_datetime +) AS a + RIGHT OUTER JOIN calendar b + ON ( time = $P!{calendar_column} ) +WHERE $P!{calendar_column} >= CAST ( $P{P_Start_Date} AS date ) + AND $P!{calendar_column} < + CASE + WHEN $P{P_Period} = 0 + THEN CAST ( $P{P_Start_Date} AS TIMESTAMP ) + interval '1 day' + WHEN $P{P_Period} = 1 + THEN CAST ( $P{P_Start_Date} AS TIMESTAMP ) + interval '1 month' + WHEN $P{P_Period} = 2 + THEN CAST ( $P{P_Start_Date} AS TIMESTAMP ) + interval '3 month' + WHEN $P{P_Period} = 3 + THEN CAST ( $P{P_Start_Date} AS TIMESTAMP ) + interval '1 year' + END +GROUP BY $P!{calendar_column}, cluster_name, host_id, host_name +ORDER BY $P!{calendar_column}, cluster_name, host_id, host_name]]> + </queryString> + <field name="the_date" class="java.sql.Timestamp"/> + <field name="cluster_name" class="java.lang.String"/> + <field name="host_name" class="java.lang.String"/> + <field name="CPU_Usage" class="java.lang.Integer"/> + <field name="MEM_Usage" class="java.lang.Integer"/> + <title> + <band height="46" splitType="Stretch"> + <image> + <reportElement x="0" y="0" width="228" height="42" uuid="2ca71312-9c67-4ed9-96a5-0a9783c7e682"/> + <imageExpression><![CDATA["repo:ovirt-icon"]]></imageExpression> + </image> + <line> + <reportElement x="0" y="43" width="832" height="1" uuid="e8daa696-2596-4e87-a620-c3eb53fcf346"/> + </line> + <textField pattern=""> + <reportElement x="562" y="27" width="270" height="15" uuid="2fde5575-5e64-4bf2-9636-e32b7018ff1a"/> + <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> + </band> + </title> + <summary> + <band height="259" splitType="Stretch"> + <crosstab> + <reportElement x="0" y="0" width="801" height="120" uuid="23dcca58-797a-420a-a289-a8a3fcce448d"/> + <crosstabParameter name="P_Host_ListID" class="java.util.Collection"/> + <crosstabHeaderCell> + <cellContents> + <property name="local_mesure_unitheight" value="pixel"/> + <staticText> + <reportElement style="Crosstab_CH" x="0" y="20" width="90" height="20" uuid="1b757e1a-5725-463a-82b7-6c4032ce261a"> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + </reportElement> + <box> + <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement verticalAlignment="Middle"> + <font size="10" isBold="true"/> + </textElement> + <text><![CDATA[Cluster Name]]></text> + </staticText> + <staticText> + <reportElement style="Crosstab_CH" x="90" y="20" width="60" height="20" uuid="e0077250-32dd-4352-8e24-24c506e3bb10"> + <property name="local_mesure_unitx" value="pixel"/> + <property name="com.jaspersoft.studio.unit.x" value="px"/> + </reportElement> + <box> + <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement verticalAlignment="Middle"> + <font size="10" isBold="true"/> + </textElement> + <text><![CDATA[Host Name]]></text> + </staticText> + <staticText> + <reportElement style="Crosstab_CH" x="90" y="0" width="60" height="20" uuid="90716202-c8ac-4303-8750-631148a1a085"> + <property name="local_mesure_unitx" value="pixel"/> + <property name="com.jaspersoft.studio.unit.x" value="px"/> + </reportElement> + <box> + <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement verticalAlignment="Middle"> + <font isBold="true"/> + </textElement> + <text><![CDATA[Month]]></text> + </staticText> + </cellContents> + </crosstabHeaderCell> + <rowGroup name="cluster_name1" width="90" totalPosition="End"> + <bucket class="java.lang.String"> + <bucketExpression><![CDATA[$F{cluster_name}]]></bucketExpression> + </bucket> + <crosstabRowHeader> + <cellContents mode="Opaque" style="Crosstab 1_CH"> + <property name="local_mesure_unitheight" value="pixel"/> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + <textField isStretchWithOverflow="true" isBlankWhenNull="true"> + <reportElement style="Crosstab_CD" x="0" y="0" width="90" height="20" uuid="5051c6ba-ddb9-419b-a4f7-d39ade6b45dd"> + <property name="local_mesure_unitx" value="pixel"/> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.x" value="px"/> + <property name="local_mesure_unity" value="pixel"/> + <property name="com.jaspersoft.studio.unit.y" value="px"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + </reportElement> + <box> + <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$V{cluster_name1}]]></textFieldExpression> + </textField> + </cellContents> + </crosstabRowHeader> + <crosstabTotalRowHeader> + <cellContents mode="Opaque" style="Crosstab 1_CT"> + <property name="local_mesure_unitheight" value="pixel"/> + <property name="com.jaspersoft.studio.unit.height" value="px"/> + </cellContents> + </crosstabTotalRowHeader> + </rowGroup> + <rowGroup name="host_name1" width="60" totalPosition="End"> + <bucket class="java.lang.String"> + <bucketExpression><![CDATA[$F{host_name}]]></bucketExpression> + </bucket> + <crosstabRowHeader> + <cellContents mode="Opaque" style="Crosstab 1_CH"> + <textField> + <reportElement style="Crosstab_CD" x="0" y="0" width="60" height="20" uuid="905445c0-b005-4cc7-92f4-ef40a3bdfdec"/> + <box> + <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$V{host_name1}]]></textFieldExpression> + </textField> + </cellContents> + </crosstabRowHeader> + <crosstabTotalRowHeader> + <cellContents mode="Opaque" style="Crosstab 1_CG"> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + <property name="local_mesure_unitheight" value="pixel"/> + <property name="com.jaspersoft.studio.unit.height" value="px"/> + </cellContents> + </crosstabTotalRowHeader> + </rowGroup> + <columnGroup name="month" height="20" totalPosition="End" headerPosition="Stretch"> + <bucket class="java.lang.String"> + <bucketExpression><![CDATA[$P{P_Period}==0 ? DATEFORMAT($F{the_date},"MMM d, yyyy") : $P{P_Period}==1 ? DATEFORMAT($F{the_date},"MMMM, yyyy") : DATEFORMAT($F{the_date},"yyyy")]]></bucketExpression> + </bucket> + <crosstabColumnHeader> + <cellContents mode="Opaque" style="Crosstab 1_CH"> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + <property name="local_mesure_unitheight" value="pixel"/> + <property name="com.jaspersoft.studio.unit.height" value="px"/> + <textField isStretchWithOverflow="true" pattern="" isBlankWhenNull="false"> + <reportElement style="Crosstab_CH" x="0" y="0" width="20" height="20" uuid="7e4c1c05-96a7-4c6c-ad08-50cf24255af9"> + <property name="local_mesure_unitheight" value="pixel"/> + <property name="com.jaspersoft.studio.unit.height" value="px"/> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + </reportElement> + <box> + <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font isBold="true"/> + </textElement> + <textFieldExpression><![CDATA[$V{month}]]></textFieldExpression> + </textField> + </cellContents> + </crosstabColumnHeader> + <crosstabTotalColumnHeader> + <cellContents mode="Opaque" style="Crosstab 1_CT"> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + </cellContents> + </crosstabTotalColumnHeader> + </columnGroup> + <columnGroup name="Day" height="20" totalPosition="End" headerPosition="Stretch"> + <bucket class="java.lang.String"> + <bucketExpression><![CDATA[$P{P_Period}==0 ? DATEFORMAT($F{the_date},"HH") : $P{P_Period}==1 ? DAY($F{the_date}): DATEFORMAT($F{the_date},"MMM")]]></bucketExpression> + </bucket> + <crosstabColumnHeader> + <cellContents> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + <property name="local_mesure_unitheight" value="pixel"/> + <property name="com.jaspersoft.studio.unit.height" value="px"/> + <textField isStretchWithOverflow="true" isBlankWhenNull="true"> + <reportElement style="Crosstab_CH" x="0" y="0" width="20" height="20" uuid="a3699af9-2c6d-4c04-8884-b298f446001a"> + <property name="local_mesure_unitheight" value="pixel"/> + <property name="com.jaspersoft.studio.unit.height" value="px"/> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + </reportElement> + <box> + <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"> + <font size="10" isBold="true"/> + </textElement> + <textFieldExpression><![CDATA[$V{Day}]]></textFieldExpression> + </textField> + </cellContents> + </crosstabColumnHeader> + <crosstabTotalColumnHeader> + <cellContents/> + </crosstabTotalColumnHeader> + </columnGroup> + <measure name="MEM_Usage_MEASURE1" class="java.lang.Integer" calculation="Sum"> + <measureExpression><![CDATA[$F{MEM_Usage}]]></measureExpression> + </measure> + <crosstabCell width="20" height="20"> + <cellContents mode="Opaque" style="Crosstab 1_CD"> + <textField> + <reportElement x="0" y="0" width="20" height="20" uuid="959dcf0a-9fe7-4846-9f10-22df143e13e9"> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + </reportElement> + <box> + <topPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + <rightPen lineWidth="1.0" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Center" verticalAlignment="Middle"/> + <textFieldExpression><![CDATA[$V{MEM_Usage_MEASURE1}]]></textFieldExpression> + </textField> + </cellContents> + </crosstabCell> + <crosstabCell width="0" height="20" columnTotalGroup="month"> + <cellContents mode="Opaque" style="Crosstab 1_CT"/> + </crosstabCell> + <crosstabCell width="20" height="0" rowTotalGroup="cluster_name1"> + <cellContents mode="Opaque" style="Crosstab 1_CT"/> + </crosstabCell> + <crosstabCell width="0" height="0" rowTotalGroup="cluster_name1" columnTotalGroup="month"> + <cellContents mode="Opaque" style="Crosstab 1_CT"/> + </crosstabCell> + <crosstabCell width="20" height="0" rowTotalGroup="host_name1"> + <cellContents mode="Opaque" style="Crosstab 1_CG"/> + </crosstabCell> + <crosstabCell width="0" height="0" rowTotalGroup="host_name1" columnTotalGroup="month"> + <cellContents mode="Opaque" style="Crosstab 1_CT"/> + </crosstabCell> + <crosstabCell width="0" height="20" columnTotalGroup="Day"> + <cellContents> + <property name="local_mesure_unitheight" value="pixel"/> + </cellContents> + </crosstabCell> + <crosstabCell width="0" height="0" rowTotalGroup="cluster_name1" columnTotalGroup="Day"> + <cellContents> + <property name="local_mesure_unitheight" value="pixel"/> + </cellContents> + </crosstabCell> + <crosstabCell width="0" height="0" rowTotalGroup="host_name1" columnTotalGroup="Day"> + <cellContents> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + <property name="local_mesure_unitheight" value="pixel"/> + </cellContents> + </crosstabCell> + </crosstab> + </band> + </summary> +</jasperReport> -- To view, visit https://gerrit.ovirt.org/39006 To unsubscribe, visit https://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I0e34dbc254d7123f7743d20b0e20e774a4822bbc Gerrit-PatchSet: 1 Gerrit-Project: ovirt-reports Gerrit-Branch: master Gerrit-Owner: Shirly Radco <sra...@redhat.com> _______________________________________________ Engine-patches mailing list Engine-patches@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-patches
