Shirly Radco has uploaded a new change for review. Change subject: reports: br17 reports - added comments to queries ......................................................................
reports: br17 reports - added comments to queries Changed the code structure so it will be more readable and added commets. Change-Id: I3e48725df27ae1e5a0dc1057471011e398580b94 Signed-off-by: Shirly Radco <[email protected]> --- M packaging/ovirt-reports/resources/Reports/Executive/summary_of_host_usage_resources_br17_files/full details.jrxml.data M packaging/ovirt-reports/resources/Reports/Executive/summary_of_host_usage_resources_br17_files/summary_of_host_usage_resources_br17_jrxml.data 2 files changed, 447 insertions(+), 348 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-reports refs/changes/32/24832/1 diff --git a/packaging/ovirt-reports/resources/Reports/Executive/summary_of_host_usage_resources_br17_files/full details.jrxml.data b/packaging/ovirt-reports/resources/Reports/Executive/summary_of_host_usage_resources_br17_files/full details.jrxml.data index a006c11..771987a 100644 --- a/packaging/ovirt-reports/resources/Reports/Executive/summary_of_host_usage_resources_br17_files/full details.jrxml.data +++ b/packaging/ovirt-reports/resources/Reports/Executive/summary_of_host_usage_resources_br17_files/full details.jrxml.data @@ -1,168 +1,224 @@ <?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="88" orientation="Landscape" columnWidth="830" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" resourceBundle="ovirt_reports_bundle" whenResourceMissingType="Error" uuid="16f8f76c-b429-4077-9f70-ed5df8c08a2f"> - <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/Executive/summary_of_host_usage_resources_br17"/> - <property name="ireport.jasperserver.url" value="http://localhost:8080/jasperserver/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.Short"> - <parameterDescription><![CDATA[Period]]></parameterDescription> - <defaultValueExpression><![CDATA[0]]></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_Locale" class="java.lang.String"> - <defaultValueExpression><![CDATA[$P{REPORT_LOCALE}.toString()]]></defaultValueExpression> - </parameter> - <queryString> - <![CDATA[SELECT v3_4_configuration_history_datacenters.datacenter_name as datacenter_name, - v3_4_configuration_history_datacenters.delete_date as datacenter_delete_date, - coalesce((SELECT ' ' || RTrim(cast(v3_4_configuration_history_clusters.cluster_name as varchar)) - FROM v3_4_configuration_history_clusters - WHERE v3_4_configuration_history_clusters.cluster_id = cast($P{P_Cluster_ID} as uuid) - and v3_4_configuration_history_clusters.history_id in (SELECT max(a.history_id) - FROM v3_4_configuration_history_clusters as a - GROUP BY a.cluster_id)), 'all') as cluster_name, - (SELECT v3_4_configuration_history_clusters.delete_date - FROM v3_4_configuration_history_clusters - WHERE v3_4_configuration_history_clusters.cluster_id = cast($P{P_Cluster_ID} as uuid) - and v3_4_configuration_history_clusters.history_id in (SELECT max(a.history_id) - FROM v3_4_configuration_history_clusters as a - GROUP BY a.cluster_id)) as cluster_delete_date, - CASE - WHEN $P{P_Period} = 1 THEN CAST(cast($P{P_Start_Date} as date) + interval '1 month' - interval '1 day' as date) - WHEN $P{P_Period} = 2 THEN CAST(cast($P{P_Start_Date} as date) + interval '3 month' - interval '1 day' as date) - WHEN $P{P_Period} = 3 THEN CAST(cast($P{P_Start_Date} as date) + interval '1 year' - interval '1 day' as date) - END as end_date, - (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) + <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/Executive/summary_of_host_usage_resources_br17"/> + <property name="ireport.jasperserver.url" value="http://localhost:8080/jasperserver-pro/"/> + <property name="ireport.jasperserver.report.resource" value="/Reports/Executive/summary_of_host_usage_resources_br17_files/full details.jrxml"/> + <parameter name="is_deleted" class="java.lang.String"> + <defaultValueExpression><![CDATA["AND delete_date IS NULL"]]></defaultValueExpression> + </parameter> + <parameter name="P_Period" class="java.lang.Short"> + <parameterDescription><![CDATA[Period]]></parameterDescription> + <defaultValueExpression><![CDATA[0]]></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_Locale" class="java.lang.String"> + <defaultValueExpression><![CDATA[$P{REPORT_LOCALE}.toString()]]></defaultValueExpression> + </parameter> + <queryString language="SQL"> + <![CDATA[SELECT + v3_4_configuration_history_datacenters.datacenter_name + AS datacenter_name, + v3_4_configuration_history_datacenters.delete_date + AS datacenter_delete_date, + COALESCE( + ( + SELECT + ' ' + || + RTrim ( + CAST ( v3_4_configuration_history_clusters.cluster_name AS varchar ) + ) + FROM v3_4_configuration_history_clusters + WHERE + v3_4_configuration_history_clusters.cluster_id = + CAST ( $P{P_Cluster_ID} AS uuid ) + AND v3_4_configuration_history_clusters.history_id in ( + SELECT MAX ( a.history_id ) + FROM v3_4_configuration_history_clusters AS a + GROUP BY a.cluster_id + ) + ), + 'all' + ) + AS cluster_name, + ( + SELECT v3_4_configuration_history_clusters.delete_date + FROM v3_4_configuration_history_clusters + WHERE + v3_4_configuration_history_clusters.cluster_id = + CAST ( $P{P_Cluster_ID} AS uuid ) + AND v3_4_configuration_history_clusters.history_id in ( + SELECT MAX ( a.history_id ) + FROM v3_4_configuration_history_clusters AS a + GROUP BY a.cluster_id + ) + ) + AS cluster_delete_date, + 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 + AS end_date, + ( + 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_Period} - AND enum_translator_default.enum_type = 'REPORTS_PERIOD') as period + AND enum_translator_default.enum_key = $P{P_Period} + AND enum_translator_default.enum_type = 'REPORTS_PERIOD' + ) + AS period FROM v3_4_configuration_history_datacenters -WHERE v3_4_configuration_history_datacenters.datacenter_id = cast($P{P_DataCenter_ID} as uuid) - and v3_4_configuration_history_datacenters.history_id in (SELECT max(a.history_id) - FROM v3_4_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="end_date" class="java.sql.Date"/> - <field name="period" 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 uuid="32479da0-6872-4a1f-8db2-65b395dc6787" 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="074ae344-479f-49b7-924b-43c9e9d0aebc" x="88" y="0" width="389" 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="81a30d04-1dd1-4771-a0f0-fd500a05895d" positionType="Float" x="88" y="20" width="389" 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="34b4febf-c704-4efa-880e-0a7b0199aa9e" positionType="Float" x="599" y="0" width="229" height="20"/> - <textElement textAlignment="Justified" verticalAlignment="Middle" markup="html"> - <font fontName="SansSerif" size="11" isBold="false"/> - </textElement> - <textFieldExpression><![CDATA[$P{P_Period} == 0 ? "<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} == 0 ? 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="6fb831e1-a77f-4aae-9e93-0b7f5140ffe9" positionType="Float" x="487" y="0" width="107" 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> " + $F{period}]]></textFieldExpression> - <hyperlinkTooltipExpression><![CDATA[$F{period}]]></hyperlinkTooltipExpression> - </textField> - <textField> - <reportElement uuid="43cfa544-bb49-49f2-925a-6e7c759e2cae" mode="Opaque" x="2" y="1" 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> - <textField> - <reportElement uuid="6e183f0b-e39e-451e-ad83-394c1fd1d9db" positionType="Float" x="487" y="20" width="341" height="20"/> - <textElement textAlignment="Justified" verticalAlignment="Middle" markup="html"> - <font fontName="SansSerif" size="11" isBold="false"/> - </textElement> - <textFieldExpression><![CDATA[$P{is_deleted} == "" ? "<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{is_deleted} == "" ? $R{full.details.yes} : $R{full.details.no}]]></hyperlinkTooltipExpression> - </textField> - </frame> - <textField evaluationTime="Report" isBlankWhenNull="false"> - <reportElement uuid="e75afcd1-9657-4048-baf2-2dd95ac181fc" 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{br17.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 uuid="906e2dad-403f-4ae0-b2a6-00f0e12733f9" x="12" y="74" width="10" height="11"> - <printWhenExpression><![CDATA[$F{cluster_delete_date} != null || $F{datacenter_delete_date} != null]]></printWhenExpression> - </reportElement> - <imageExpression><![CDATA["repo:trash-icon"]]></imageExpression> - </image> - <staticText> - <reportElement uuid="1c3abd71-e0b1-409a-8c12-043d5d63c5a5" x="5" y="74" width="5" height="14" forecolor="#666666"> - <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 uuid="ad5c8494-daae-4188-b8ac-04b7767a2908" x="29" y="74" width="735" height="14" forecolor="#666666"/> - <textElement markup="html"> - <font fontName="SansSerif"/> - </textElement> - <textFieldExpression><![CDATA[$F{cluster_delete_date} != null ? +WHERE + v3_4_configuration_history_datacenters.datacenter_id = + CAST ( $P{P_DataCenter_ID} AS uuid ) + AND v3_4_configuration_history_datacenters.history_id in ( + SELECT MAX ( a.history_id ) + FROM v3_4_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="end_date" class="java.sql.Date"/> + <field name="period" 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="32479da0-6872-4a1f-8db2-65b395dc6787"/> + <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="88" y="0" width="389" height="20" uuid="074ae344-479f-49b7-924b-43c9e9d0aebc"/> + <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="88" y="20" width="389" height="20" uuid="81a30d04-1dd1-4771-a0f0-fd500a05895d"/> + <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="599" y="0" width="229" height="20" uuid="34b4febf-c704-4efa-880e-0a7b0199aa9e"/> + <textElement textAlignment="Justified" verticalAlignment="Middle" markup="html"> + <font fontName="SansSerif" size="11" isBold="false"/> + </textElement> + <textFieldExpression><![CDATA[$P{P_Period} == 0 ? "<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} == 0 ? 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 positionType="Float" x="487" y="0" width="107" height="20" uuid="6fb831e1-a77f-4aae-9e93-0b7f5140ffe9"/> + <textElement textAlignment="Justified" verticalAlignment="Middle" markup="html"> + <font fontName="SansSerif" size="11" isBold="false"/> + </textElement> + <textFieldExpression><![CDATA["<b>" + $R{full.details.period} + ":</b> " + $F{period}]]></textFieldExpression> + <hyperlinkTooltipExpression><![CDATA[$F{period}]]></hyperlinkTooltipExpression> + </textField> + <textField> + <reportElement mode="Opaque" x="2" y="1" width="69" height="36" forecolor="#666666" backcolor="#E6E6E6" uuid="43cfa544-bb49-49f2-925a-6e7c759e2cae"/> + <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="487" y="20" width="341" height="20" uuid="6e183f0b-e39e-451e-ad83-394c1fd1d9db"/> + <textElement textAlignment="Justified" verticalAlignment="Middle" markup="html"> + <font fontName="SansSerif" size="11" isBold="false"/> + </textElement> + <textFieldExpression><![CDATA[$P{is_deleted} == "" ? "<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{is_deleted} == "" ? $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="e75afcd1-9657-4048-baf2-2dd95ac181fc"/> + <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{br17.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="906e2dad-403f-4ae0-b2a6-00f0e12733f9"> + <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="1c3abd71-e0b1-409a-8c12-043d5d63c5a5"> + <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="ad5c8494-daae-4188-b8ac-04b7767a2908"/> + <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> + </textField> + </band> + </title> </jasperReport> diff --git a/packaging/ovirt-reports/resources/Reports/Executive/summary_of_host_usage_resources_br17_files/summary_of_host_usage_resources_br17_jrxml.data b/packaging/ovirt-reports/resources/Reports/Executive/summary_of_host_usage_resources_br17_files/summary_of_host_usage_resources_br17_jrxml.data index dccb7cd..8b4f705 100644 --- a/packaging/ovirt-reports/resources/Reports/Executive/summary_of_host_usage_resources_br17_files/summary_of_host_usage_resources_br17_jrxml.data +++ b/packaging/ovirt-reports/resources/Reports/Executive/summary_of_host_usage_resources_br17_files/summary_of_host_usage_resources_br17_jrxml.data @@ -1,196 +1,239 @@ <?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="BR17" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="832" leftMargin="5" rightMargin="5" topMargin="5" bottomMargin="5" resourceBundle="ovirt_reports_bundle" whenResourceMissingType="Error"> - <property name="ireport.jasperserver.reportUnit" value="/Reports/Executive/summary_of_host_usage_resources_br17"/> - <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="71"/> - <parameter name="is_deleted" class="java.lang.String"> - <defaultValueExpression><![CDATA["AND delete_date IS NULL"]]></defaultValueExpression> - </parameter> - <parameter name="P_Period" class="java.lang.Short"> - <parameterDescription><![CDATA[Period]]></parameterDescription> - <defaultValueExpression><![CDATA[0]]></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="table_name" class="java.lang.String"> - <defaultValueExpression><![CDATA[$P{P_Period} == 0 ? "hourly" : "daily"]]></defaultValueExpression> - </parameter> - <parameter name="calendar_column" class="java.lang.String"> - <defaultValueExpression><![CDATA[$P{P_Period} == 0 ? "the_datetime" : "the_date"]]></defaultValueExpression> - </parameter> - <queryString> - <![CDATA[-- Hosts Average Usage Peaks +<!-- 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="BR17" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="832" leftMargin="5" rightMargin="5" topMargin="5" bottomMargin="5" resourceBundle="ovirt_reports_bundle" whenResourceMissingType="Error" uuid="5f253524-5387-4824-83ff-c5f1759f87e0"> + <property name="ireport.jasperserver.reportUnit" value="/Reports/Executive/summary_of_host_usage_resources_br17"/> + <property name="ireport.jasperserver.url" value="http://localhost:8080/jasperserver-pro/"/> + <property name="ireport.zoom" value="1.0"/> + <property name="ireport.x" value="0"/> + <property name="ireport.y" value="71"/> + <property name="ireport.jasperserver.report.resource" value="/Reports/Executive/summary_of_host_usage_resources_br17_files/summary_of_host_usage_resources_br17_jrxml"/> + <parameter name="is_deleted" class="java.lang.String"> + <defaultValueExpression><![CDATA["AND delete_date IS NULL"]]></defaultValueExpression> + </parameter> + <parameter name="P_Period" class="java.lang.Short"> + <parameterDescription><![CDATA[Period]]></parameterDescription> + <defaultValueExpression><![CDATA[0]]></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="table_name" class="java.lang.String"> + <defaultValueExpression><![CDATA[$P{P_Period} == 0 ? "hourly" : "daily"]]></defaultValueExpression> + </parameter> + <parameter name="calendar_column" class="java.lang.String"> + <defaultValueExpression><![CDATA[$P{P_Period} == 0 ? "the_datetime" : "the_date"]]></defaultValueExpression> + </parameter> + <queryString language="SQL"> + <![CDATA[--BR17 - This query calculates the hosts "Average Usage Peaks" +-- By Average value of daily "cpu usage peak" vs. +-- Average values of daily "memory usage peak". + SELECT - TBL_$P!{table_name}_PEAKS.host_id - ,host_name - ,delete_date - ,cast(AVG(TBL_$P!{table_name}_PEAKS.cpu_peak) as int) AS avg_cpu_peak - ,cast(AVG(TBL_$P!{table_name}_PEAKS.mem_peak) as int) AS avg_mem_peak -FROM ( + /* If "Period" equals to "Daily" then "table_name" parameter equals to "hourly" else "daily" */ + TBL_$P!{table_name}_PEAKS.host_id, + host_name, + delete_date, + -- Average value of daily cpu usage peak + CAST ( + AVG ( TBL_$P!{table_name}_PEAKS.cpu_peak ) as int + ) + AS avg_cpu_peak, + -- Average values of daily memory usage peak + CAST ( + AVG ( TBL_$P!{table_name}_PEAKS.mem_peak ) AS int + ) + AS avg_mem_peak +FROM ( -- Calculation of daily cpu and memory usage peaks - SELECT v3_4_statistics_hosts_resources_usage_$P!{table_name}.host_id, - host_name, - history_datetime, - delete_date, - MAX(coalesce(max_cpu_usage,0)) as cpu_peak, - MAX(coalesce(max_memory_usage,0)) as mem_peak + SELECT + v3_4_statistics_hosts_resources_usage_$P!{table_name}.host_id, + host_name, + history_datetime, + delete_date, + MAX ( + COALESCE ( max_cpu_usage, 0 ) + ) + AS cpu_peak, + MAX ( + COALESCE ( max_memory_usage, 0 ) + ) + AS mem_peak 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) + 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 + ) WHERE - v3_4_configuration_history_hosts.cluster_id in (SELECT cluster_id - FROM v3_4_configuration_history_clusters - Where datacenter_id = cast($P{P_DataCenter_ID} as uuid)) - AND v3_4_configuration_history_hosts.cluster_id = CASE $P{P_Cluster_ID} - WHEN NULL THEN v3_4_configuration_history_hosts.cluster_id - WHEN '11111111-1111-1111-1111-111111111111' THEN v3_4_configuration_history_hosts.cluster_id - ELSE cast($P{P_Cluster_ID} as uuid) - END - AND history_datetime >= cast($P{P_Start_Date} as date) - 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 - 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) + v3_4_configuration_history_hosts.cluster_id in ( + SELECT cluster_id + FROM v3_4_configuration_history_clusters + Where datacenter_id = CAST ( $P{P_DataCenter_ID} AS uuid ) + ) + AND + v3_4_configuration_history_hosts.cluster_id = + CASE $P{P_Cluster_ID} + WHEN NULL + THEN v3_4_configuration_history_hosts.cluster_id + WHEN '11111111-1111-1111-1111-111111111111' + THEN v3_4_configuration_history_hosts.cluster_id + ELSE CAST ( $P{P_Cluster_ID} AS uuid ) + END + AND history_datetime >= CAST ( $P{P_Start_Date} AS date ) + 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 + 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 + ) $P!{is_deleted} - GROUP BY v3_4_statistics_hosts_resources_usage_$P!{table_name}.host_id, host_name, delete_date, history_datetime - ) AS TBL_$P!{table_name}_PEAKS + GROUP BY + v3_4_statistics_hosts_resources_usage_$P!{table_name}.host_id, + host_name, + delete_date, + history_datetime +) +AS TBL_$P!{table_name}_PEAKS GROUP BY - TBL_$P!{table_name}_PEAKS.host_id, host_name, delete_date -Order by delete_date DESC, host_id]]> - </queryString> - <field name="host_id" class="java.lang.Object"/> - <field name="host_name" class="java.lang.String"/> - <field name="delete_date" class="java.sql.Timestamp"/> - <field name="avg_cpu_peak" class="java.lang.Integer"/> - <field name="avg_mem_peak" class="java.lang.Integer"/> - <variable name="CURRENT_PAGE_NUMBER" class="java.lang.Integer" resetType="None" incrementType="Page"> - <variableExpression><![CDATA[$V{PAGE_NUMBER}]]></variableExpression> - <initialValueExpression><![CDATA[]]></initialValueExpression> - </variable> - <title> - <band height="570" splitType="Stretch"> - <subreport> - <reportElement x="0" y="45" width="830" height="88"/> - <subreportParameter name="P_Cluster_ID"> - <subreportParameterExpression><![CDATA[$P{P_Cluster_ID}]]></subreportParameterExpression> - </subreportParameter> - <subreportParameter name="is_deleted"> - <subreportParameterExpression><![CDATA[$P{is_deleted}]]></subreportParameterExpression> - </subreportParameter> - <subreportParameter name="P_Period"> - <subreportParameterExpression><![CDATA[$P{P_Period}]]></subreportParameterExpression> - </subreportParameter> - <subreportParameter name="P_DataCenter_ID"> - <subreportParameterExpression><![CDATA[$P{P_DataCenter_ID}]]></subreportParameterExpression> - </subreportParameter> - <subreportParameter name="P_Start_Date"> - <subreportParameterExpression><![CDATA[$P{P_Start_Date}]]></subreportParameterExpression> - </subreportParameter> - <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> - <subreportExpression class="java.lang.String"><![CDATA["repo:full details.jrxml"]]></subreportExpression> - </subreport> - <line> - <reportElement x="0" y="43" width="832" height="1"/> - </line> - <textField pattern=""> - <reportElement x="549" y="27" width="283" height="15"/> - <textElement textAlignment="Right"> - <font fontName="SansSerif" size="11" isBold="false"/> - </textElement> - <textFieldExpression class="java.lang.String"><![CDATA[DateFormat.getDateInstance(DateFormat.LONG, $P{REPORT_LOCALE}).format(new Date())]]></textFieldExpression> - </textField> - <image> - <reportElement x="0" y="0" width="228" height="42"/> - <imageExpression class="java.lang.String"><![CDATA["repo:ovirt-icon"]]></imageExpression> - </image> - <scatterChart> - <chart isShowLegend="true" evaluationTime="Report" hyperlinkTarget="Blank" customizerClass="com.ovirt.reports.jasper.ScatterChartCustomizer" renderType="draw" theme="ReportsLineBarChartTheme"> - <reportElement x="199" y="133" width="435" height="435"/> - <box> - <pen lineWidth="1.0" lineColor="#3C617F"/> - <topPen lineWidth="1.0" lineColor="#3C617F"/> - <leftPen lineWidth="1.0" lineColor="#3C617F"/> - <bottomPen lineWidth="1.0" lineColor="#3C617F"/> - <rightPen lineWidth="1.0" lineColor="#3C617F"/> - </box> - <chartTitle color="#3A5E75"> - <font fontName="SansSerif" isBold="true"/> - <titleExpression><![CDATA[$R{br17b.title}]]></titleExpression> - </chartTitle> - <chartSubtitle> - <font fontName="SansSerif"/> - </chartSubtitle> - <chartLegend> - <font fontName="SansSerif"/> - </chartLegend> - </chart> - <xyDataset> - <xySeries> - <seriesExpression><![CDATA[$F{delete_date} == null ? $R{br17.chart.active.hosts} : $R{br17.chart.deleted.hosts}]]></seriesExpression> - <xValueExpression><![CDATA[$F{avg_cpu_peak}]]></xValueExpression> - <yValueExpression><![CDATA[$F{avg_mem_peak}]]></yValueExpression> - <itemHyperlink> - <hyperlinkTooltipExpression><![CDATA[$F{host_name} + " (" + $R{br17.chart.cpu} + ": " + $F{avg_cpu_peak}.toString() + "%, " + $R{br17.chart.memory} + ": " + $F{avg_mem_peak}.toString() + "%)"]]></hyperlinkTooltipExpression> - </itemHyperlink> - </xySeries> - </xyDataset> - <scatterPlot isShowLines="false" isShowShapes="true"> - <plot/> - <xAxisLabelExpression><![CDATA[$R{axis.cpu.usage.percent}]]></xAxisLabelExpression> - <xAxisFormat> - <axisFormat labelColor="#666666" verticalTickLabels="false"> - <labelFont> - <font fontName="SansSerif"/> - </labelFont> - <tickLabelFont> - <font fontName="SansSerif"/> - </tickLabelFont> - </axisFormat> - </xAxisFormat> - <yAxisLabelExpression><![CDATA[$R{axis.memory.usage.percent}]]></yAxisLabelExpression> - <yAxisFormat> - <axisFormat labelColor="#666666" verticalTickLabels="false"> - <labelFont> - <font fontName="SansSerif"/> - </labelFont> - <tickLabelFont> - <font fontName="SansSerif"/> - </tickLabelFont> - </axisFormat> - </yAxisFormat> - <domainAxisMinValueExpression><![CDATA[0]]></domainAxisMinValueExpression> - <domainAxisMaxValueExpression><![CDATA[100]]></domainAxisMaxValueExpression> - <rangeAxisMinValueExpression><![CDATA[0]]></rangeAxisMinValueExpression> - <rangeAxisMaxValueExpression><![CDATA[100]]></rangeAxisMaxValueExpression> - </scatterPlot> - </scatterChart> - </band> - </title> - <pageFooter> - <band height="15" splitType="Stretch"> - <textField evaluationTime="Auto"> - <reportElement x="224" y="0" width="385" height="15"/> - <textElement textAlignment="Center" verticalAlignment="Middle"> - <font fontName="SansSerif"/> - </textElement> - <textFieldExpression class="java.lang.String"><![CDATA[msg($R{footer.pagination}, $V{CURRENT_PAGE_NUMBER}, $V{PAGE_NUMBER})]]></textFieldExpression> - </textField> - </band> - </pageFooter> + TBL_$P!{table_name}_PEAKS.host_id, + host_name, delete_date +ORDER BY delete_date DESC, host_id]]> + </queryString> + <field name="host_id" class="java.lang.Object"/> + <field name="host_name" class="java.lang.String"/> + <field name="delete_date" class="java.sql.Timestamp"/> + <field name="avg_cpu_peak" class="java.lang.Integer"/> + <field name="avg_mem_peak" class="java.lang.Integer"/> + <variable name="CURRENT_PAGE_NUMBER" class="java.lang.Integer" resetType="None" incrementType="Page"> + <variableExpression><![CDATA[$V{PAGE_NUMBER}]]></variableExpression> + <initialValueExpression><![CDATA[]]></initialValueExpression> + </variable> + <title> + <band height="570" splitType="Stretch"> + <subreport> + <reportElement x="0" y="45" width="830" height="88" uuid="0cea00f2-db56-43be-a76b-a6c4eefe191c"/> + <subreportParameter name="P_Cluster_ID"> + <subreportParameterExpression><![CDATA[$P{P_Cluster_ID}]]></subreportParameterExpression> + </subreportParameter> + <subreportParameter name="is_deleted"> + <subreportParameterExpression><![CDATA[$P{is_deleted}]]></subreportParameterExpression> + </subreportParameter> + <subreportParameter name="P_Period"> + <subreportParameterExpression><![CDATA[$P{P_Period}]]></subreportParameterExpression> + </subreportParameter> + <subreportParameter name="P_DataCenter_ID"> + <subreportParameterExpression><![CDATA[$P{P_DataCenter_ID}]]></subreportParameterExpression> + </subreportParameter> + <subreportParameter name="P_Start_Date"> + <subreportParameterExpression><![CDATA[$P{P_Start_Date}]]></subreportParameterExpression> + </subreportParameter> + <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> + <subreportExpression><![CDATA["repo:full details.jrxml"]]></subreportExpression> + </subreport> + <line> + <reportElement x="0" y="43" width="832" height="1" uuid="86fc3d8e-ef33-45c1-8e64-1b17b8f6d535"/> + </line> + <textField pattern=""> + <reportElement x="549" y="27" width="283" height="15" uuid="e6253de2-f104-45c0-b5c7-9e063d727c22"/> + <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> + <image> + <reportElement x="0" y="0" width="228" height="42" uuid="4a193df8-441e-406f-8b88-52426731e443"/> + <imageExpression><![CDATA["repo:ovirt-icon"]]></imageExpression> + </image> + <scatterChart> + <chart isShowLegend="true" evaluationTime="Report" hyperlinkTarget="Blank" customizerClass="com.ovirt.reports.jasper.ScatterChartCustomizer" renderType="draw" theme="ReportsLineBarChartTheme"> + <reportElement x="199" y="133" width="435" height="435" uuid="c9c4e171-0847-4051-a4ef-e078017f4eb9"/> + <box> + <pen lineWidth="1.0" lineColor="#3C617F"/> + <topPen lineWidth="1.0" lineColor="#3C617F"/> + <leftPen lineWidth="1.0" lineColor="#3C617F"/> + <bottomPen lineWidth="1.0" lineColor="#3C617F"/> + <rightPen lineWidth="1.0" lineColor="#3C617F"/> + </box> + <chartTitle color="#3A5E75"> + <font fontName="SansSerif" isBold="true"/> + <titleExpression><![CDATA[$R{br17b.title}]]></titleExpression> + </chartTitle> + <chartSubtitle> + <font fontName="SansSerif"/> + </chartSubtitle> + <chartLegend> + <font fontName="SansSerif"/> + </chartLegend> + </chart> + <xyDataset> + <xySeries> + <seriesExpression><![CDATA[$F{delete_date} == null ? $R{br17.chart.active.hosts} : $R{br17.chart.deleted.hosts}]]></seriesExpression> + <xValueExpression><![CDATA[$F{avg_cpu_peak}]]></xValueExpression> + <yValueExpression><![CDATA[$F{avg_mem_peak}]]></yValueExpression> + <itemHyperlink> + <hyperlinkTooltipExpression><![CDATA[$F{host_name} + " (" + $R{br17.chart.cpu} + ": " + $F{avg_cpu_peak}.toString() + "%, " + $R{br17.chart.memory} + ": " + $F{avg_mem_peak}.toString() + "%)"]]></hyperlinkTooltipExpression> + </itemHyperlink> + </xySeries> + </xyDataset> + <scatterPlot isShowLines="false" isShowShapes="true"> + <plot/> + <xAxisLabelExpression><![CDATA[$R{axis.cpu.usage.percent}]]></xAxisLabelExpression> + <xAxisFormat> + <axisFormat labelColor="#666666" verticalTickLabels="false"> + <labelFont> + <font fontName="SansSerif"/> + </labelFont> + <tickLabelFont> + <font fontName="SansSerif"/> + </tickLabelFont> + </axisFormat> + </xAxisFormat> + <yAxisLabelExpression><![CDATA[$R{axis.memory.usage.percent}]]></yAxisLabelExpression> + <yAxisFormat> + <axisFormat labelColor="#666666" verticalTickLabels="false"> + <labelFont> + <font fontName="SansSerif"/> + </labelFont> + <tickLabelFont> + <font fontName="SansSerif"/> + </tickLabelFont> + </axisFormat> + </yAxisFormat> + <domainAxisMinValueExpression><![CDATA[0]]></domainAxisMinValueExpression> + <domainAxisMaxValueExpression><![CDATA[100]]></domainAxisMaxValueExpression> + <rangeAxisMinValueExpression><![CDATA[0]]></rangeAxisMinValueExpression> + <rangeAxisMaxValueExpression><![CDATA[100]]></rangeAxisMaxValueExpression> + </scatterPlot> + </scatterChart> + </band> + </title> + <pageFooter> + <band height="15" splitType="Stretch"> + <textField evaluationTime="Auto"> + <reportElement x="224" y="0" width="385" height="15" uuid="5f9b69b6-3d35-436d-b4a8-7a893dfad079"/> + <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> -- To view, visit http://gerrit.ovirt.org/24832 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I3e48725df27ae1e5a0dc1057471011e398580b94 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-reports Gerrit-Branch: master Gerrit-Owner: Shirly Radco <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
