Shirly Radco has uploaded a new change for review. Change subject: reports: added Capacity Planing (BR48) report ......................................................................
reports: added Capacity Planing (BR48) report Change-Id: Ie811404cb38b243959fcbcf8311f1e98e43f681a Bug-Url:https://bugzilla.redhat.com/1179118 Signed-off-by: Shirly Radco <sra...@redhat.com> --- M packaging/ovirt-reports/resources/Reports/Inventory/.folder.xml A packaging/ovirt-reports/resources/Reports/Inventory/capacity_planing_br48.xml A packaging/ovirt-reports/resources/Reports/Inventory/capacity_planing_br48_files/br48 full details.jrxml.data A packaging/ovirt-reports/resources/Reports/Inventory/capacity_planing_br48_files/br48_legend.jrxml.data A packaging/ovirt-reports/resources/Reports/Inventory/capacity_planing_br48_files/capacity_planing_br48_jrxml.data M packaging/ovirt-reports/resources/reports_resources/JDBC/Input_Controls/Regular_Input_Controls/.folder.xml A packaging/ovirt-reports/resources/reports_resources/JDBC/Input_Controls/Regular_Input_Controls/all_dcs_with_hosts_multi_select/.folder.xml A packaging/ovirt-reports/resources/reports_resources/JDBC/Input_Controls/Regular_Input_Controls/all_dcs_with_hosts_multi_select/P_DataCenter_ID.xml 8 files changed, 2,683 insertions(+), 0 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-reports refs/changes/05/39005/1 diff --git a/packaging/ovirt-reports/resources/Reports/Inventory/.folder.xml b/packaging/ovirt-reports/resources/Reports/Inventory/.folder.xml index ab17024..4b6e1cd 100644 --- a/packaging/ovirt-reports/resources/Reports/Inventory/.folder.xml +++ b/packaging/ovirt-reports/resources/Reports/Inventory/.folder.xml @@ -11,4 +11,5 @@ <resource>VM_Inventory</resource> <resource>ccp_vm_inventory_br44</resource> <resource>storage_domains_inventory_br47</resource> + <resource>capacity_planing_br48</resource> </folder> diff --git a/packaging/ovirt-reports/resources/Reports/Inventory/capacity_planing_br48.xml b/packaging/ovirt-reports/resources/Reports/Inventory/capacity_planing_br48.xml new file mode 100644 index 0000000..5007b3c --- /dev/null +++ b/packaging/ovirt-reports/resources/Reports/Inventory/capacity_planing_br48.xml @@ -0,0 +1,191 @@ +<?xml version="1.0" encoding="UTF-8"?> +<reportUnit exportedWithPermissions="true"> + <folder>/organizations/organization_1/Reports/Inventory</folder> + <name>capacity_planing_br48</name> + <version>0</version> + <label>Capacity Planing (BR48)</label> + <description></description> + <creationDate>2015-03-22T14:35:16.244+02:00</creationDate> + <updateDate>2015-03-22T14:34:23.524+02:00</updateDate> + <mainReport> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" + exportedWithPermissions="false" + dataFile="capacity_planing_br48_jrxml.data" xsi:type="fileResource"> + <folder>/organizations/organization_1/Reports/Inventory/capacity_planing_br48_files</folder> + <name>capacity_planing_br48_jrxml</name> + <version>0</version> + <label>Main Jrxml</label> + <description></description> + <creationDate>2015-03-22T14:35:16.244+02:00</creationDate> + <updateDate>2015-03-22T14:35:16.244+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/Regular_Input_Controls/all_dcs_with_hosts_multi_select/P_DataCenter_ID</uri> + </inputControl> + <resource> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" + exportedWithPermissions="false" + dataFile="br48_legend.jrxml.data" xsi:type="fileResource"> + <folder>/organizations/organization_1/Reports/Inventory/capacity_planing_br48_files</folder> + <name>br48_legend.jrxml</name> + <version>0</version> + <label>br48_legend.jrxml</label> + <creationDate>2015-03-22T14:35:16.244+02:00</creationDate> + <updateDate>2015-03-22T14:35:16.244+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/Inventory/capacity_planing_br48_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:35:16.244+02:00</creationDate> + <updateDate>2015-03-22T14:35:16.244+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/Inventory/capacity_planing_br48_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:35:16.244+02:00</creationDate> + <updateDate>2015-03-22T14:35:16.244+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/Inventory/capacity_planing_br48_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:35:16.244+02:00</creationDate> + <updateDate>2015-03-22T14:35:16.244+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/Inventory/capacity_planing_br48_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:35:16.244+02:00</creationDate> + <updateDate>2015-03-22T14:35:16.244+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" + dataFile="br48 full details.jrxml.data" xsi:type="fileResource"> + <folder>/organizations/organization_1/Reports/Inventory/capacity_planing_br48_files</folder> + <name>br48 full details.jrxml</name> + <version>0</version> + <label>br48 full details.jrxml</label> + <creationDate>2015-03-22T14:35:16.244+02:00</creationDate> + <updateDate>2015-03-22T14:35:16.244+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/Inventory/capacity_planing_br48_files</folder> + <name>ovirt_reports_bundle_fr.properties</name> + <version>0</version> + <label>ovirt_reports_bundle_fr.properties</label> + <creationDate>2015-03-22T14:35:16.244+02:00</creationDate> + <updateDate>2015-03-22T14:35:16.244+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/Inventory/capacity_planing_br48_files</folder> + <name>ovirt_reports_bundle_ja.properties</name> + <version>0</version> + <label>ovirt_reports_bundle_ja.properties</label> + <creationDate>2015-03-22T14:35:16.244+02:00</creationDate> + <updateDate>2015-03-22T14:35:16.244+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/Inventory/capacity_planing_br48_files</folder> + <name>ovirt_reports_bundle.properties</name> + <version>0</version> + <label>ovirt_reports_bundle.properties</label> + <creationDate>2015-03-22T14:35:16.244+02:00</creationDate> + <updateDate>2015-03-22T14:35:16.244+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/Inventory/capacity_planing_br48_files</folder> + <name>ovirt_reports_bundle_es.properties</name> + <version>0</version> + <label>ovirt_reports_bundle_es.properties</label> + <creationDate>2015-03-22T14:35:16.244+02:00</creationDate> + <updateDate>2015-03-22T14:35:16.244+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/Inventory/capacity_planing_br48_files</folder> + <name>ovirt-icon</name> + <version>0</version> + <label>ovirt-icon</label> + <creationDate>2015-03-22T14:35:16.244+02:00</creationDate> + <updateDate>2015-03-22T14:35:16.244+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/Inventory/capacity_planing_br48_files</folder> + <name>ovirt_reports_bundle_de.properties</name> + <version>0</version> + <label>ovirt_reports_bundle_de.properties</label> + <creationDate>2015-03-22T14:35:16.244+02:00</creationDate> + <updateDate>2015-03-22T14:35:16.244+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/Inventory/capacity_planing_br48_files/br48 full details.jrxml.data b/packaging/ovirt-reports/resources/Reports/Inventory/capacity_planing_br48_files/br48 full details.jrxml.data new file mode 100644 index 0000000..ba2b11b --- /dev/null +++ b/packaging/ovirt-reports/resources/Reports/Inventory/capacity_planing_br48_files/br48 full details.jrxml.data @@ -0,0 +1,88 @@ +<?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="report1" language="groovy" pageWidth="820" pageHeight="111" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="820" 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/capacity_planing_br48"/> + <property name="ireport.jasperserver.url" value="http://localhost:8080/jasperserver-pro/"/> + <property name="ireport.jasperserver.report.resource" value="/adhoc/aru/new_reports/capacity_planing_br48_files/br48 full details.jrxml"/> + <property name="com.jaspersoft.studio.unit." value="pixel"/> + <property name="com.jaspersoft.studio.unit.pageHeight" value="pixel"/> + <property name="com.jaspersoft.studio.unit.pageWidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.topMargin" value="pixel"/> + <property name="com.jaspersoft.studio.unit.bottomMargin" value="pixel"/> + <property name="com.jaspersoft.studio.unit.leftMargin" value="pixel"/> + <property name="com.jaspersoft.studio.unit.rightMargin" value="pixel"/> + <property name="com.jaspersoft.studio.unit.columnWidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.columnSpacing" value="pixel"/> + <property name="com.jaspersoft.studio.data.defaultdataadapter" value="HistoryDB"/> + <queryString language="SQL"> + <![CDATA[]]> + </queryString> + <title> + <band height="88" splitType="Stretch"> + <frame> + <reportElement mode="Opaque" x="0" y="30" width="820" height="40" uuid="0cf5acf1-49ac-4687-a168-d03e63e84886"> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + </reportElement> + <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>" + $R{full.details.all}]]></textFieldExpression> + </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["<b>" + $R{full.details.cluster} + ":</b> "+ $R{full.details.all}]]></textFieldExpression> + </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["<b>" + $R{full.details.host.type} + ":</b> " + $R{full.details.all}]]></textFieldExpression> + </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="335" height="20" uuid="e7cfe519-e964-4a14-8c2a-ff84b4c4ca21"> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + </reportElement> + <textElement textAlignment="Justified" verticalAlignment="Middle" markup="html"> + <font fontName="SansSerif" size="11" isBold="false"/> + </textElement> + <textFieldExpression><![CDATA["<b>" + $R{full.details.show.deleted.hosts} + ":</b> " + $R{full.details.no}]]></textFieldExpression> + </textField> + </frame> + <textField evaluationTime="Report" isBlankWhenNull="false"> + <reportElement x="0" y="0" width="820" height="25" forecolor="#666666" uuid="fb1504d3-46a9-4ba1-9a3c-7ffa1f338e4c"> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + </reportElement> + <textElement textAlignment="Left" verticalAlignment="Top" markup="html"> + <font fontName="SansSerif" size="17" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false"/> + </textElement> + <textFieldExpression><![CDATA[$R{br48.title}]]></textFieldExpression> + </textField> + </band> + </title> +</jasperReport> diff --git a/packaging/ovirt-reports/resources/Reports/Inventory/capacity_planing_br48_files/br48_legend.jrxml.data b/packaging/ovirt-reports/resources/Reports/Inventory/capacity_planing_br48_files/br48_legend.jrxml.data new file mode 100644 index 0000000..b25e68a --- /dev/null +++ b/packaging/ovirt-reports/resources/Reports/Inventory/capacity_planing_br48_files/br48_legend.jrxml.data @@ -0,0 +1,103 @@ +<?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="br48_legend" language="groovy" pageWidth="600" pageHeight="802" whenNoDataType="AllSectionsNoDetail" columnWidth="600" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" resourceBundle="ovirt_reports_bundle" whenResourceMissingType="Error" uuid="776ed311-a899-4ef9-a0db-e3385d445b39"> + <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/capacity_planing_br48"/> + <property name="ireport.jasperserver.url" value="http://localhost:8080/jasperserver-pro/"/> + <property name="ireport.jasperserver.report.resource" value="/adhoc/aru/new_reports/capacity_planing_br48_files/br48_legend.jrxml"/> + <property name="com.jaspersoft.studio.unit." value="pixel"/> + <property name="com.jaspersoft.studio.data.defaultdataadapter" value="HistoryDB"/> + <title> + <band height="14" splitType="Stretch"> + <property name="local_mesure_unitheight" value="pixel"/> + <property name="com.jaspersoft.studio.unit.height" value="px"/> + <rectangle> + <reportElement x="290" y="3" width="8" height="8" backcolor="#FC9800" uuid="0cb68089-da48-4bca-b7af-8e92de359f0a"> + <property name="local_mesure_unitx" 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"/> + </reportElement> + </rectangle> + <rectangle> + <reportElement x="0" y="3" width="8" height="8" backcolor="#FC3200" uuid="b28aab9c-23a6-490f-aee1-7d33743b5e0a"/> + </rectangle> + <textField isStretchWithOverflow="true"> + <reportElement x="446" y="0" width="130" height="14" uuid="ea067af7-f380-4c13-8b8b-3a46ac98d75b"> + <property name="local_mesure_unitx" 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="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + </reportElement> + <textElement verticalAlignment="Middle" markup="none"> + <font fontName="SansSerif"/> + </textElement> + <textFieldExpression><![CDATA[$R{br48.no.allocation}]]></textFieldExpression> + <hyperlinkTooltipExpression><![CDATA[$R{br7b.table.unplanned.downtime}]]></hyperlinkTooltipExpression> + </textField> + <textField isStretchWithOverflow="true"> + <reportElement x="301" y="0" width="130" height="14" uuid="047d821f-3e90-45f9-9540-2f4c79c0dfe6"> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + <property name="local_mesure_unitx" 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"/> + </reportElement> + <textElement verticalAlignment="Middle" markup="none"> + <font fontName="SansSerif"/> + </textElement> + <textFieldExpression><![CDATA[$R{br48.table.medium.allocated.percent}]]></textFieldExpression> + <hyperlinkTooltipExpression><![CDATA[$R{br7b.table.planned.downtime}]]></hyperlinkTooltipExpression> + </textField> + <textField isStretchWithOverflow="true"> + <reportElement x="11" y="0" width="130" height="14" uuid="03b56239-eeaf-40ab-869d-edd69354cb31"> + <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"/> + </reportElement> + <textElement verticalAlignment="Middle" markup="none"> + <font fontName="SansSerif"/> + </textElement> + <textFieldExpression><![CDATA[$R{br48.table.usage.over.allocated}]]></textFieldExpression> + <hyperlinkTooltipExpression><![CDATA[$R{br7b.table.uptime}]]></hyperlinkTooltipExpression> + </textField> + <rectangle> + <reportElement x="435" y="3" width="8" height="8" backcolor="#F8FC00" uuid="0712807a-a023-4af7-b7f0-9df8c2314693"> + <property name="local_mesure_unitx" 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"/> + </reportElement> + </rectangle> + <rectangle> + <reportElement x="146" y="3" width="8" height="8" backcolor="#CF8817" uuid="d1f9c7e5-fd35-4166-a8c1-c4dddd90fe2c"> + <property name="local_mesure_unitx" 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"/> + </reportElement> + </rectangle> + <textField isStretchWithOverflow="true"> + <reportElement x="157" y="0" width="130" height="14" uuid="ea75b8ff-4cf4-480c-9802-78de39acaabb"> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + <property name="local_mesure_unitx" 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"/> + </reportElement> + <textElement verticalAlignment="Middle" markup="none"> + <font fontName="SansSerif"/> + </textElement> + <textFieldExpression><![CDATA[$R{br48.table.high.allocated.percent}]]></textFieldExpression> + <hyperlinkTooltipExpression><![CDATA[$R{br7b.table.uptime}]]></hyperlinkTooltipExpression> + </textField> + </band> + </title> +</jasperReport> diff --git a/packaging/ovirt-reports/resources/Reports/Inventory/capacity_planing_br48_files/capacity_planing_br48_jrxml.data b/packaging/ovirt-reports/resources/Reports/Inventory/capacity_planing_br48_files/capacity_planing_br48_jrxml.data new file mode 100644 index 0000000..1907422 --- /dev/null +++ b/packaging/ovirt-reports/resources/Reports/Inventory/capacity_planing_br48_files/capacity_planing_br48_jrxml.data @@ -0,0 +1,2130 @@ +<?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="Clusters" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="832" leftMargin="5" rightMargin="5" topMargin="5" bottomMargin="5" whenResourceMissingType="Empty" uuid="24ea2f96-883c-4654-b650-7b261e63fb92"> + <property name="ireport.zoom" value="1.0"/> + <property name="ireport.x" value="47"/> + <property name="ireport.y" value="451"/> + <property name="com.jaspersoft.studio.unit." value="pixel"/> + <property name="ireport.jasperserver.url" value="http://localhost:8080/jasperserver-pro/"/> + <property name="ireport.jasperserver.report.resource" value="/adhoc/aru/new_reports/capacity_planing_br48_files/capacity_planing_br48_jrxml"/> + <property name="ireport.jasperserver.reportUnit" value="/adhoc/aru/new_reports/capacity_planing_br48"/> + <property name="com.jaspersoft.studio.data.defaultdataadapter" value="HistoryDB"/> + <style name="Title" forecolor="#FFFFFF" fontName="Times New Roman" fontSize="50" isBold="false" pdfFontName="Times-Bold"/> + <style name="SubTitle" forecolor="#666666" fontName="Times New Roman" fontSize="18" isBold="false" pdfFontName="Times-Roman"/> + <style name="Column header" forecolor="#666666" fontName="Times New Roman" fontSize="14" isBold="true" pdfFontName="Times-Roman"/> + <style name="Detail" mode="Transparent" fontName="Times New Roman" pdfFontName="Times-Roman"/> + <style name="Row" mode="Transparent" fontName="Times New Roman" pdfFontName="Times-Roman"> + <conditionalStyle> + <conditionExpression><![CDATA[$V{REPORT_COUNT}%2 == 0]]></conditionExpression> + <style mode="Opaque" backcolor="#F0EFEF"/> + </conditionalStyle> + </style> + <style name="Table_TH" mode="Opaque" backcolor="#0000FF"> + <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="Table_CH" mode="Opaque" backcolor="#BFBFFF"> + <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="Table_TD" 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="Table 1_TH" 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="Table 1_CH" mode="Opaque" backcolor="#D8E2FF"> + <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="Table 1_TD" 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="Table 2_TH" mode="Opaque" backcolor="#0000FF"> + <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="Table 2_CH" mode="Opaque" backcolor="#BFBFFF"> + <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="Table 2_TD" 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="CPU" backcolor="#FFFFFF" fill="Solid" pattern=""> + <conditionalStyle> + <conditionExpression><![CDATA[$F{total_vms_cpu_cores}/$F{total_hosts_num_of_cpus}>= 1.0]]></conditionExpression> + <style mode="Opaque" backcolor="#FC3200"/> + </conditionalStyle> + <conditionalStyle> + <conditionExpression><![CDATA[AND($F{total_vms_cpu_cores}/$F{total_hosts_num_of_cpus}>= 0.85, $F{total_vms_cpu_cores}/$F{total_hosts_num_of_cpus}<1)]]></conditionExpression> + <style mode="Opaque" backcolor="#FC9800"/> + </conditionalStyle> + </style> + <style name="CPU_Running" pattern=""> + <conditionalStyle> + <conditionExpression><![CDATA[$F{cpu_cores_running}/$F{total_hosts_num_of_cpus}>= 1]]></conditionExpression> + <style mode="Opaque" backcolor="#FC3200"/> + </conditionalStyle> + <conditionalStyle> + <conditionExpression><![CDATA[AND($F{cpu_cores_running}/$F{total_hosts_num_of_cpus}>= 0.85, $F{cpu_cores_running}/$F{total_hosts_num_of_cpus}<1)]]></conditionExpression> + <style mode="Opaque" backcolor="#FC9800" scaleImage="Clip"/> + </conditionalStyle> + </style> + <style name="MEM" backcolor="#FFFFFF" fill="Solid" pattern=""> + <conditionalStyle> + <conditionExpression><![CDATA[$F{total_vms_mem}/$F{memory_size_mb}>= 1.0]]></conditionExpression> + <style mode="Opaque" backcolor="#FC3200"/> + </conditionalStyle> + <conditionalStyle> + <conditionExpression><![CDATA[AND($F{total_vms_mem}/$F{memory_size_mb}>= 0.95, $F{total_vms_mem}/$F{memory_size_mb}<1)]]></conditionExpression> + <style mode="Opaque" backcolor="#CF8817"/> + </conditionalStyle> + <conditionalStyle> + <conditionExpression><![CDATA[AND($F{total_vms_mem}/$F{memory_size_mb}>= 0.85, $F{total_vms_mem}/$F{memory_size_mb}<0.95)]]></conditionExpression> + <style mode="Opaque" backcolor="#FC9800"/> + </conditionalStyle> + </style> + <style name="MEM_Runing" backcolor="#FFFFFF" fill="Solid" pattern=""> + <conditionalStyle> + <conditionExpression><![CDATA[$F{mem_running}/$F{memory_size_mb}>= 1.0]]></conditionExpression> + <style mode="Opaque" backcolor="#FC3200"/> + </conditionalStyle> + <conditionalStyle> + <conditionExpression><![CDATA[AND($F{mem_running}/$F{memory_size_mb}>= 0.95, $F{mem_running}/$F{memory_size_mb}<1)]]></conditionExpression> + <style mode="Opaque" backcolor="#CF8817"/> + </conditionalStyle> + <conditionalStyle> + <conditionExpression><![CDATA[AND($F{mem_running}/$F{memory_size_mb}>= 0.85, $F{mem_running}/$F{memory_size_mb}<0.95)]]></conditionExpression> + <style mode="Opaque" backcolor="#FC9800"/> + </conditionalStyle> + </style> + <style name="DiskUsed" backcolor="#FFFFFF" fill="Solid" pattern=""> + <conditionalStyle> + <conditionExpression><![CDATA[$F{dc_used_disk_size_gb}.doubleValue()/$F{dc_total_disk_size_gb}.doubleValue()> 1.0]]></conditionExpression> + <style mode="Opaque" backcolor="#FC3200"/> + </conditionalStyle> + <conditionalStyle> + <conditionExpression><![CDATA[$F{dc_used_disk_size_gb}.doubleValue()/$F{dc_total_disk_size_gb}.doubleValue()== 1.0]]></conditionExpression> + <style mode="Opaque" backcolor="#CF8817"/> + </conditionalStyle> + <conditionalStyle> + <conditionExpression><![CDATA[AND($F{dc_used_disk_size_gb}.doubleValue()/$F{dc_total_disk_size_gb}.doubleValue()>= 0.85, $F{dc_used_disk_size_gb}.doubleValue()/$F{dc_total_disk_size_gb}.doubleValue()<1.0)]]></conditionExpression> + <style mode="Opaque" backcolor="#FC9800"/> + </conditionalStyle> + <conditionalStyle> + <conditionExpression><![CDATA[$F{dc_used_disk_size_gb}.doubleValue() == 0.0]]></conditionExpression> + <style mode="Opaque" backcolor="#F8FC00"/> + </conditionalStyle> + </style> + <style name="DiskUsage-Allocated VM" backcolor="#FFFFFF" fill="Solid" pattern=""> + <conditionalStyle> + <conditionExpression><![CDATA[$F{vms_allocated_disk_size_gb}.doubleValue()/$F{dc_total_disk_size_gb}.doubleValue()> 1.0]]></conditionExpression> + <style mode="Opaque" backcolor="#FC3200"/> + </conditionalStyle> + <conditionalStyle> + <conditionExpression><![CDATA[$F{vms_allocated_disk_size_gb}.doubleValue()/$F{dc_total_disk_size_gb}.doubleValue() == 1.0]]></conditionExpression> + <style mode="Opaque" backcolor="#CF8817"/> + </conditionalStyle> + <conditionalStyle> + <conditionExpression><![CDATA[AND($F{vms_allocated_disk_size_gb}.doubleValue()/$F{dc_total_disk_size_gb}.doubleValue()>= 0.85, $F{vms_allocated_disk_size_gb}.doubleValue()/$F{dc_total_disk_size_gb}.doubleValue()<1.0)]]></conditionExpression> + <style mode="Opaque" backcolor="#FC9800"/> + </conditionalStyle> + <conditionalStyle> + <conditionExpression><![CDATA[$F{vms_allocated_disk_size_gb}.doubleValue() == 0.0]]></conditionExpression> + <style mode="Opaque" backcolor="#F8FC00"/> + </conditionalStyle> + </style> + <subDataset name="Table" uuid="1d00f5f8-2aed-4d50-ba2f-4ea2739cd2c6"> + <property name="com.jaspersoft.studio.data.defaultdataadapter" value="HistoryDB"/> + <queryString language="SQL"> + <![CDATA[-- This query returns the +-- average number of CPU Cores and Physical Memory +-- for the vms in the specific cluster. + + +SELECT + COALESCE( + tag_name, + 'Unknown' + ) AS tag_name, + datacenter_name, + datacenter_description, + cluster_name, + cluster_description, + COUNT( DISTINCT host_id ) AS number_of_hosts, + SUM ( + COALESCE ( + v3_6_latest_configuration_hosts.number_of_cores, + 0 + ) * + COALESCE ( + v3_6_latest_configuration_hosts.number_of_sockets, + 0 + ) + ) AS total_hosts_num_of_cpus, + SUM ( + COALESCE ( + v3_6_latest_configuration_hosts.memory_size_mb, + 0 + ) * 0.000976562 + ) AS memory_size_mb, + num_of_vms.num_of_running_vms, + num_of_vms.total_configured_vms, + cpu_memory_allocation.total_vms_cpu_cores, + cpu_memory_allocation.cpu_cores_running, + cpu_memory_allocation.total_vms_mem, + cpu_memory_allocation.mem_running, + dc_storage.dc_used_disk_size_gb, + dc_storage.dc_available_disk_size_gb, + dc_storage.dc_total_disk_size_gb, + vms_storage.vms_allocated_disk_size_gb +FROM v3_6_latest_configuration_datacenters + INNER JOIN v3_6_latest_configuration_clusters + ON ( + v3_6_latest_configuration_datacenters.datacenter_id = + v3_6_latest_configuration_clusters.datacenter_id + ) + INNER JOIN v3_6_latest_configuration_hosts + ON ( + v3_6_latest_configuration_clusters.cluster_id = + v3_6_latest_configuration_hosts.cluster_id + ) + LEFT OUTER JOIN v3_6_latest_tags_relations + ON ( + v3_6_latest_configuration_hosts.host_id = + v3_6_latest_tags_relations.entity_id + AND v3_6_latest_tags_relations.entity_type = 3 + ) + LEFT OUTER JOIN v3_6_latest_tags_details + ON ( + v3_6_latest_tags_relations.parent_id = + v3_6_latest_tags_details.tag_id + ) + LEFT OUTER JOIN ( + SELECT + vm_count.cluster_id, + SUM ( + CASE + WHEN vm_count.vm_status = 1 + THEN vm_count.num_of_vms + ELSE 0 + END + ) AS num_of_running_vms, + SUM ( vm_count.num_of_vms ) AS total_configured_vms + FROM ( + SELECT + a.cluster_id AS cluster_id, + v3_6_statistics_vms_resources_usage_hourly.vm_status as vm_status, + COUNT( DISTINCT a.vm_id ) AS num_of_vms + FROM v3_6_statistics_vms_resources_usage_hourly + INNER JOIN v3_6_latest_configuration_vms a + ON ( + a.vm_id = + v3_6_statistics_vms_resources_usage_hourly.vm_id + ) + WHERE + v3_6_statistics_vms_resources_usage_hourly.history_id IN ( + SELECT MAX ( history_id ) + FROM v3_6_statistics_vms_resources_usage_hourly b + GROUP BY vm_id + ) + GROUP BY + a.cluster_id, v3_6_statistics_vms_resources_usage_hourly.vm_status + ) AS vm_count + GROUP BY cluster_id + ) AS num_of_vms + ON ( + num_of_vms.cluster_id = + v3_6_latest_configuration_clusters.cluster_id + ) + LEFT OUTER JOIN ( + SELECT + a.cluster_id, + SUM ( + COALESCE ( + v3_6_configuration_history_vms.cpu_per_socket, + 0 + )* + COALESCE ( + v3_6_configuration_history_vms.number_of_sockets, + 0 + ) + ) + AS total_vms_cpu_cores, + SUM ( + CASE + WHEN v3_6_statistics_vms_resources_usage_hourly.vm_status = 1 + THEN + COALESCE ( + v3_6_configuration_history_vms.cpu_per_socket, + 0 + ) * + COALESCE ( + v3_6_configuration_history_vms.number_of_sockets, + 0 + ) + ELSE 0 + END + ) + AS cpu_cores_running, + SUM ( + COALESCE ( + v3_6_configuration_history_vms.memory_size_mb, + 0 + ) + ) *0.000976562 + AS total_vms_mem, + SUM ( + CASE + WHEN v3_6_statistics_vms_resources_usage_hourly.vm_status = 1 + THEN + COALESCE ( + v3_6_configuration_history_vms.memory_size_mb, + 0 + ) + ELSE 0 + END + ) * 0.000976562 + AS mem_running + FROM v3_6_statistics_vms_resources_usage_hourly + INNER JOIN v3_6_configuration_history_vms + ON ( + v3_6_configuration_history_vms.history_id = + v3_6_statistics_vms_resources_usage_hourly.vm_configuration_version + ) + INNER JOIN v3_6_latest_configuration_vms a + ON ( + a.vm_id = + v3_6_statistics_vms_resources_usage_hourly.vm_id + ) + WHERE + v3_6_statistics_vms_resources_usage_hourly.history_id IN ( + SELECT MAX ( history_id ) + FROM v3_6_statistics_vms_resources_usage_hourly b + GROUP BY vm_id + ) + GROUP BY + a.cluster_id + ) AS cpu_memory_allocation + ON ( + cpu_memory_allocation.cluster_id = + v3_6_latest_configuration_clusters.cluster_id + ) + LEFT OUTER JOIN ( + SELECT + datacenter_id, + SUM ( + COALESCE ( + samples.used_disk_size_gb, + daily.used_disk_size_gb + ) + ) + AS dc_used_disk_size_gb, + SUM ( + COALESCE ( + samples.available_disk_size_gb, + daily.available_disk_size_gb + ) + ) + AS dc_available_disk_size_gb, + SUM ( + COALESCE ( + samples.available_disk_size_gb + samples.used_disk_size_gb, + daily.available_disk_size_gb + daily.used_disk_size_gb + ) + ) + AS dc_total_disk_size_gb + FROM v3_6_latest_configuration_storage_domains + INNER JOIN v3_6_latest_map_datacenters_storage_domains + ON ( + v3_6_latest_configuration_storage_domains.storage_domain_id = + v3_6_latest_map_datacenters_storage_domains.storage_domain_id + ) + LEFT OUTER JOIN v3_6_statistics_storage_domains_resources_usage_samples AS samples + ON ( + v3_6_latest_configuration_storage_domains.storage_domain_id = + samples.storage_domain_id + AND samples.history_id IN ( + SELECT MAX ( a.history_id ) + FROM v3_6_statistics_storage_domains_resources_usage_samples a + GROUP BY a.storage_domain_id + ) + ) + LEFT OUTER JOIN v3_6_statistics_storage_domains_resources_usage_daily AS daily + ON ( + v3_6_latest_configuration_storage_domains.storage_domain_id = + daily.storage_domain_id + AND daily.history_id IN ( + SELECT MAX ( a.history_id ) + FROM v3_6_statistics_storage_domains_resources_usage_daily a + GROUP BY a.storage_domain_id + ) + ) + WHERE + -- Here we filter by the "Data" storage type + storage_domain_type IN ( 0, 1 ) + GROUP BY datacenter_id + ) AS dc_storage + ON ( + dc_storage.datacenter_id = + v3_6_latest_configuration_datacenters.datacenter_id + ) + LEFT OUTER JOIN ( + SELECT + datacenter_id, + SUM ( + v3_6_latest_configuration_vms_disks.vm_disk_size_mb + ) * 0.0009765625 + AS vms_allocated_disk_size_gb + FROM v3_6_latest_configuration_storage_domains + INNER JOIN v3_6_latest_map_datacenters_storage_domains + ON ( + v3_6_latest_map_datacenters_storage_domains.storage_domain_id = + v3_6_latest_configuration_storage_domains.storage_domain_id + ) + INNER JOIN v3_6_latest_configuration_vms_disks + ON ( + v3_6_latest_configuration_storage_domains.storage_domain_id = + v3_6_latest_configuration_vms_disks.storage_domain_id + ) + LEFT OUTER JOIN v3_6_statistics_vms_disks_resources_usage_samples AS samples + ON ( + v3_6_latest_configuration_vms_disks.vm_disk_id = + samples.vm_disk_id + AND samples.history_id IN ( + SELECT MAX ( a.history_id ) + FROM v3_6_statistics_vms_disks_resources_usage_samples a + GROUP BY a.vm_disk_id + ) + ) + LEFT OUTER JOIN v3_6_statistics_vms_disks_resources_usage_daily AS daily + ON ( + v3_6_latest_configuration_vms_disks.vm_disk_id = + daily.vm_disk_id + AND daily.history_id IN ( + SELECT MAX ( a.history_id ) + FROM v3_6_statistics_vms_disks_resources_usage_daily a + GROUP BY a.vm_disk_id + ) + ) + WHERE + -- Here we filter by the "Data" storage type + storage_domain_type IN ( 0, 1 ) + GROUP BY datacenter_id + ) AS vms_storage + ON ( + vms_storage.datacenter_id = + v3_6_latest_configuration_datacenters.datacenter_id + ) +GROUP BY + tag_name, + datacenter_name, + datacenter_description, + cluster_name, + cluster_description, + num_of_vms.num_of_running_vms, + num_of_vms.total_configured_vms, + cpu_memory_allocation.total_vms_cpu_cores, + cpu_memory_allocation.cpu_cores_running, + cpu_memory_allocation.total_vms_mem, + cpu_memory_allocation.mem_running, + dc_storage.dc_used_disk_size_gb, + dc_storage.dc_available_disk_size_gb, + dc_storage.dc_total_disk_size_gb, + vms_storage.vms_allocated_disk_size_gb]]> + </queryString> + <field name="tag_name" class="java.lang.String"/> + <field name="datacenter_name" class="java.lang.String"/> + <field name="cluster_name" class="java.lang.String"/> + <field name="cluster_description" class="java.lang.String"/> + <field name="number_of_hosts" class="java.lang.Long"/> + <field name="total_hosts_num_of_cpus" class="java.lang.Long"/> + <field name="memory_size_mb" class="java.lang.Long"/> + <field name="num_of_running_vms" class="java.math.BigDecimal"/> + <field name="total_configured_vms" class="java.math.BigDecimal"/> + <field name="total_vms_cpu_cores" class="java.lang.Long"/> + <field name="cpu_cores_running" class="java.lang.Long"/> + <field name="total_vms_mem" class="java.lang.Long"/> + <field name="mem_running" class="java.lang.Long"/> + <field name="dc_used_disk_size_gb" class="java.lang.Long"/> + <field name="dc_total_disk_size_gb" class="java.lang.Long"/> + <field name="vms_allocated_disk_size_gb" class="java.lang.Long"/> + <field name="dc_available_disk_size_gb" class="java.lang.Long"/> + <field name="datacenter_description" class="java.lang.String"/> + <group name="Tag"> + <groupExpression><![CDATA[$F{tag_name}]]></groupExpression> + </group> + <group name="Cluster"> + <groupExpression><![CDATA[$F{datacenter_name}]]></groupExpression> + </group> + </subDataset> + <subDataset name="Totals" uuid="cd19f289-691b-4e5f-9c7e-48f94eb8ed0c"> + <property name="com.jaspersoft.studio.data.defaultdataadapter" value="HistoryDB"/> + <queryString language="SQL"> + <![CDATA[-- This query returns the totals for +-- CPU Cores and Physical Memory. + +SELECT + COUNT( DISTINCT host_id ) AS number_of_hosts, + SUM ( + COALESCE ( + v3_6_latest_configuration_hosts.number_of_cores, + 0 + ) * + COALESCE ( + v3_6_latest_configuration_hosts.number_of_sockets, + 0 + ) + ) AS total_hosts_num_of_cpus, + SUM ( + COALESCE ( + v3_6_latest_configuration_hosts.memory_size_mb, + 0 + ) + ) AS memory_size_mb, + SUM(num_of_vms.num_of_running_vms), + SUM(num_of_vms.total_configured_vms), + SUM(cpu_memory_allocation.total_vms_cpu_cores), + SUM(cpu_memory_allocation.cpu_cores_running), + SUM(cpu_memory_allocation.total_vms_mem), + SUM(cpu_memory_allocation.mem_running), + SUM(dc_storage.dc_used_disk_size_gb), + SUM(dc_storage.dc_available_disk_size_gb), + SUM(dc_storage.dc_total_disk_size_gb), + SUM(vms_storage.vms_allocated_disk_size_gb) +FROM v3_6_latest_configuration_datacenters + INNER JOIN v3_6_latest_configuration_clusters + ON ( + v3_6_latest_configuration_datacenters.datacenter_id = + v3_6_latest_configuration_clusters.datacenter_id + ) + INNER JOIN v3_6_latest_configuration_hosts + ON ( + v3_6_latest_configuration_clusters.cluster_id = + v3_6_latest_configuration_hosts.cluster_id + ) + LEFT OUTER JOIN ( + SELECT + vm_count.cluster_id, + SUM ( + CASE + WHEN vm_count.vm_status = 1 + THEN vm_count.num_of_vms + ELSE 0 + END + ) AS num_of_running_vms, + SUM ( vm_count.num_of_vms ) AS total_configured_vms + FROM ( + SELECT + a.cluster_id AS cluster_id, + v3_6_statistics_vms_resources_usage_hourly.vm_status as vm_status, + COUNT( DISTINCT a.vm_id ) AS num_of_vms + FROM v3_6_statistics_vms_resources_usage_hourly + INNER JOIN v3_6_latest_configuration_vms a + ON ( + a.vm_id = + v3_6_statistics_vms_resources_usage_hourly.vm_id + ) + WHERE + v3_6_statistics_vms_resources_usage_hourly.history_id IN ( + SELECT MAX ( history_id ) + FROM v3_6_statistics_vms_resources_usage_hourly b + GROUP BY vm_id + ) + GROUP BY + a.cluster_id, v3_6_statistics_vms_resources_usage_hourly.vm_status + ) AS vm_count + GROUP BY cluster_id + ) AS num_of_vms + ON ( + num_of_vms.cluster_id = + v3_6_latest_configuration_clusters.cluster_id + ) + LEFT OUTER JOIN ( + SELECT + a.cluster_id, + SUM ( + COALESCE ( + v3_6_configuration_history_vms.cpu_per_socket, + 0 + )* + COALESCE ( + v3_6_configuration_history_vms.number_of_sockets, + 0 + ) + ) + AS total_vms_cpu_cores, + SUM ( + CASE + WHEN v3_6_statistics_vms_resources_usage_hourly.vm_status = 1 + THEN + COALESCE ( + v3_6_configuration_history_vms.cpu_per_socket, + 0 + ) * + COALESCE ( + v3_6_configuration_history_vms.number_of_sockets, + 0 + ) + ELSE 0 + END + ) + AS cpu_cores_running, + SUM ( + COALESCE ( + v3_6_configuration_history_vms.memory_size_mb, + 0 + ) + ) + AS total_vms_mem, + SUM ( + CASE + WHEN v3_6_statistics_vms_resources_usage_hourly.vm_status = 1 + THEN + COALESCE ( + v3_6_configuration_history_vms.memory_size_mb, + 0 + ) + ELSE 0 + END + ) + AS mem_running + FROM v3_6_statistics_vms_resources_usage_hourly + INNER JOIN v3_6_configuration_history_vms + ON ( + v3_6_configuration_history_vms.history_id = + v3_6_statistics_vms_resources_usage_hourly.vm_configuration_version + ) + INNER JOIN v3_6_latest_configuration_vms a + ON ( + a.vm_id = + v3_6_statistics_vms_resources_usage_hourly.vm_id + ) + WHERE + v3_6_statistics_vms_resources_usage_hourly.history_id IN ( + SELECT MAX ( history_id ) + FROM v3_6_statistics_vms_resources_usage_hourly b + GROUP BY vm_id + ) + GROUP BY + a.cluster_id + ) AS cpu_memory_allocation + ON ( + cpu_memory_allocation.cluster_id = + v3_6_latest_configuration_clusters.cluster_id + ) + LEFT OUTER JOIN ( + SELECT + datacenter_id, + SUM ( + COALESCE ( + samples.used_disk_size_gb, + daily.used_disk_size_gb + ) + ) + AS dc_used_disk_size_gb, + SUM ( + COALESCE ( + samples.used_disk_size_gb, + daily.used_disk_size_gb + ) + ) + AS dc_available_disk_size_gb, + SUM ( + COALESCE ( + samples.available_disk_size_gb + samples.used_disk_size_gb, + daily.available_disk_size_gb + daily.used_disk_size_gb + ) + ) + AS dc_total_disk_size_gb + FROM v3_6_latest_configuration_storage_domains + INNER JOIN v3_6_latest_map_datacenters_storage_domains + ON ( + v3_6_latest_configuration_storage_domains.storage_domain_id = + v3_6_latest_map_datacenters_storage_domains.storage_domain_id + ) + LEFT OUTER JOIN v3_6_statistics_storage_domains_resources_usage_samples AS samples + ON ( + v3_6_latest_configuration_storage_domains.storage_domain_id = + samples.storage_domain_id + AND samples.history_id IN ( + SELECT MAX ( a.history_id ) + FROM v3_6_statistics_storage_domains_resources_usage_samples a + GROUP BY a.storage_domain_id + ) + ) + LEFT OUTER JOIN v3_6_statistics_storage_domains_resources_usage_daily AS daily + ON ( + v3_6_latest_configuration_storage_domains.storage_domain_id = + daily.storage_domain_id + AND daily.history_id IN ( + SELECT MAX ( a.history_id ) + FROM v3_6_statistics_storage_domains_resources_usage_daily a + GROUP BY a.storage_domain_id + ) + ) + WHERE + -- Here we filter by the "Data" storage type + storage_domain_type IN ( 0, 1 ) + GROUP BY datacenter_id + ) AS dc_storage + ON ( + dc_storage.datacenter_id = + v3_6_latest_configuration_datacenters.datacenter_id + ) + LEFT OUTER JOIN ( + SELECT + datacenter_id, + SUM ( + v3_6_latest_configuration_vms_disks.vm_disk_size_mb + ) * 0.0009765625 + AS vms_allocated_disk_size_gb + FROM v3_6_latest_configuration_storage_domains + INNER JOIN v3_6_latest_map_datacenters_storage_domains + ON ( + v3_6_latest_map_datacenters_storage_domains.storage_domain_id = + v3_6_latest_configuration_storage_domains.storage_domain_id + ) + INNER JOIN v3_6_latest_configuration_vms_disks + ON ( + v3_6_latest_configuration_storage_domains.storage_domain_id = + v3_6_latest_configuration_vms_disks.storage_domain_id + ) + LEFT OUTER JOIN v3_6_statistics_vms_disks_resources_usage_samples AS samples + ON ( + v3_6_latest_configuration_vms_disks.vm_disk_id = + samples.vm_disk_id + AND samples.history_id IN ( + SELECT MAX ( a.history_id ) + FROM v3_6_statistics_vms_disks_resources_usage_samples a + GROUP BY a.vm_disk_id + ) + ) + LEFT OUTER JOIN v3_6_statistics_vms_disks_resources_usage_daily AS daily + ON ( + v3_6_latest_configuration_vms_disks.vm_disk_id = + daily.vm_disk_id + AND daily.history_id IN ( + SELECT MAX ( a.history_id ) + FROM v3_6_statistics_vms_disks_resources_usage_daily a + GROUP BY a.vm_disk_id + ) + ) + WHERE + -- Here we filter by the "Data" storage type + storage_domain_type IN ( 0, 1 ) + GROUP BY datacenter_id + ) AS vms_storage + ON ( + vms_storage.datacenter_id = + v3_6_latest_configuration_datacenters.datacenter_id + )]]> + </queryString> + <field name="tag_name" class="java.lang.String"/> + <field name="datacenter_name" class="java.lang.String"/> + <field name="cluster_name" class="java.lang.String"/> + <field name="cluster_description" class="java.lang.String"/> + <field name="number_of_hosts" class="java.lang.Long"/> + <field name="total_hosts_num_of_cpus" class="java.lang.Long"/> + <field name="memory_size_mb" class="java.lang.Long"/> + <field name="num_of_running_vms" class="java.math.BigDecimal"/> + <field name="total_configured_vms" class="java.math.BigDecimal"/> + <field name="total_vms_cpu_cores" class="java.lang.Long"/> + <field name="cpu_cores_running" class="java.lang.Long"/> + <field name="total_vms_mem" class="java.lang.Long"/> + <field name="mem_running" class="java.lang.Long"/> + <field name="dc_used_disk_size_gb" class="java.lang.Long"/> + <field name="dc_total_disk_size_gb" class="java.lang.Long"/> + <field name="vms_allocated_disk_size_gb" class="java.math.BigDecimal"/> + <field name="dc_available_disk_size_gb" class="java.lang.Long"/> + </subDataset> + <subDataset name="Dataset1" uuid="e7d000fb-821a-459b-a019-a3bba58dcb9d"> + <property name="com.jaspersoft.studio.data.defaultdataadapter" value="HistoryDB"/> + <queryString language="SQL"> + <![CDATA[-- This query returns the +-- average number of CPU Cores and Physical Memory +-- for the vms in the specific cluster. + + +SELECT + COUNT( DISTINCT host_id ) AS number_of_hosts, + SUM ( + COALESCE ( + hosts_latest_conf.number_of_cores, + 0 + ) * + COALESCE ( + hosts_latest_conf.number_of_sockets, + 0 + ) + ) AS total_hosts_num_of_cpus, + SUM ( + COALESCE ( + hosts_latest_conf.memory_size_mb, + 0 + ) * 0.000976562 + ) AS memory_size_mb, + num_of_vms.num_of_running_vms, + num_of_vms.total_configured_vms, + cpu_memory_allocation.total_vms_cpu_cores, + cpu_memory_allocation.cpu_cores_running, + cpu_memory_allocation.total_vms_mem, + cpu_memory_allocation.mem_running, + dc_storage.dc_used_disk_size_gb, + dc_storage.dc_available_disk_size_gb, + dc_storage.dc_total_disk_size_gb, + vms_storage.vms_allocated_disk_size_gb +FROM v3_6_latest_configuration_datacenters + INNER JOIN v3_6_latest_configuration_clusters AS clusters_latest_conf + ON ( + v3_6_latest_configuration_datacenters.datacenter_id = + clusters_latest_conf.datacenter_id + ) + INNER JOIN v3_6_latest_configuration_hosts AS hosts_latest_conf + ON ( + clusters_latest_conf.cluster_id = + hosts_latest_conf.cluster_id + ), + ( + SELECT + SUM ( + CASE + WHEN vm_count.vm_status = 1 + THEN vm_count.num_of_vms + ELSE 0 + END + ) AS num_of_running_vms, + SUM ( vm_count.num_of_vms ) AS total_configured_vms + FROM ( + SELECT + a.cluster_id AS cluster_id, + v3_6_statistics_vms_resources_usage_hourly.vm_status as vm_status, + COUNT( DISTINCT a.vm_id ) AS num_of_vms + FROM v3_6_statistics_vms_resources_usage_hourly + INNER JOIN v3_6_latest_configuration_vms a + ON ( + a.vm_id = + v3_6_statistics_vms_resources_usage_hourly.vm_id + ) + WHERE + v3_6_statistics_vms_resources_usage_hourly.history_id IN ( + SELECT MAX ( history_id ) + FROM v3_6_statistics_vms_resources_usage_hourly b + GROUP BY vm_id + ) + GROUP BY + a.cluster_id, v3_6_statistics_vms_resources_usage_hourly.vm_status + ) AS vm_count + ) AS num_of_vms, + ( + SELECT + SUM ( + COALESCE ( + v3_6_configuration_history_vms.cpu_per_socket, + 0 + )* + COALESCE ( + v3_6_configuration_history_vms.number_of_sockets, + 0 + ) + ) + AS total_vms_cpu_cores, + SUM ( + CASE + WHEN v3_6_statistics_vms_resources_usage_hourly.vm_status = 1 + THEN + COALESCE ( + v3_6_configuration_history_vms.cpu_per_socket, + 0 + ) * + COALESCE ( + v3_6_configuration_history_vms.number_of_sockets, + 0 + ) + ELSE 0 + END + ) + AS cpu_cores_running, + SUM ( + COALESCE ( + v3_6_configuration_history_vms.memory_size_mb, + 0 + ) + ) * 0.000976562 + AS total_vms_mem, + SUM ( + CASE + WHEN v3_6_statistics_vms_resources_usage_hourly.vm_status = 1 + THEN + COALESCE ( + v3_6_configuration_history_vms.memory_size_mb, + 0 + ) + ELSE 0 + END + ) * 0.000976562 + AS mem_running + FROM v3_6_statistics_vms_resources_usage_hourly + INNER JOIN v3_6_configuration_history_vms + ON ( + v3_6_configuration_history_vms.history_id = + v3_6_statistics_vms_resources_usage_hourly.vm_configuration_version + ) + INNER JOIN v3_6_latest_configuration_vms a + ON ( + a.vm_id = + v3_6_statistics_vms_resources_usage_hourly.vm_id + ) + WHERE + v3_6_statistics_vms_resources_usage_hourly.history_id IN ( + SELECT MAX ( history_id ) + FROM v3_6_statistics_vms_resources_usage_hourly b + GROUP BY vm_id + ) + ) AS cpu_memory_allocation, + ( + SELECT + SUM ( + COALESCE ( + samples.used_disk_size_gb, + daily.used_disk_size_gb + ) + ) + AS dc_used_disk_size_gb, + SUM ( + COALESCE ( + samples.available_disk_size_gb, + daily.available_disk_size_gb + ) + ) + AS dc_available_disk_size_gb, + SUM ( + COALESCE ( + samples.available_disk_size_gb + samples.used_disk_size_gb, + daily.available_disk_size_gb + daily.used_disk_size_gb + ) + ) + AS dc_total_disk_size_gb + FROM v3_6_latest_configuration_storage_domains + INNER JOIN v3_6_latest_map_datacenters_storage_domains + ON ( + v3_6_latest_configuration_storage_domains.storage_domain_id = + v3_6_latest_map_datacenters_storage_domains.storage_domain_id + ) + LEFT OUTER JOIN v3_6_statistics_storage_domains_resources_usage_samples AS samples + ON ( + v3_6_latest_configuration_storage_domains.storage_domain_id = + samples.storage_domain_id + AND samples.history_id IN ( + SELECT MAX ( a.history_id ) + FROM v3_6_statistics_storage_domains_resources_usage_samples a + GROUP BY a.storage_domain_id + ) + ) + LEFT OUTER JOIN v3_6_statistics_storage_domains_resources_usage_daily AS daily + ON ( + v3_6_latest_configuration_storage_domains.storage_domain_id = + daily.storage_domain_id + AND daily.history_id IN ( + SELECT MAX ( a.history_id ) + FROM v3_6_statistics_storage_domains_resources_usage_daily a + GROUP BY a.storage_domain_id + ) + ) + WHERE + -- Here we filter by the "Data" storage type + storage_domain_type IN ( 0, 1 ) + ) AS dc_storage, + ( + SELECT + SUM ( + v3_6_latest_configuration_vms_disks.vm_disk_size_mb + ) * 0.0009765625 + AS vms_allocated_disk_size_gb + FROM v3_6_latest_configuration_storage_domains + INNER JOIN v3_6_latest_map_datacenters_storage_domains + ON ( + v3_6_latest_map_datacenters_storage_domains.storage_domain_id = + v3_6_latest_configuration_storage_domains.storage_domain_id + ) + INNER JOIN v3_6_latest_configuration_vms_disks + ON ( + v3_6_latest_configuration_storage_domains.storage_domain_id = + v3_6_latest_configuration_vms_disks.storage_domain_id + ) + LEFT OUTER JOIN v3_6_statistics_vms_disks_resources_usage_samples AS samples + ON ( + v3_6_latest_configuration_vms_disks.vm_disk_id = + samples.vm_disk_id + AND samples.history_id IN ( + SELECT MAX ( a.history_id ) + FROM v3_6_statistics_vms_disks_resources_usage_samples a + GROUP BY a.vm_disk_id + ) + ) + LEFT OUTER JOIN v3_6_statistics_vms_disks_resources_usage_daily AS daily + ON ( + v3_6_latest_configuration_vms_disks.vm_disk_id = + daily.vm_disk_id + AND daily.history_id IN ( + SELECT MAX ( a.history_id ) + FROM v3_6_statistics_vms_disks_resources_usage_daily a + GROUP BY a.vm_disk_id + ) + ) + WHERE + -- Here we filter by the "Data" storage type + storage_domain_type IN ( 0, 1 ) + ) AS vms_storage +GROUP BY + num_of_vms.num_of_running_vms, + num_of_vms.total_configured_vms, + cpu_memory_allocation.total_vms_cpu_cores, + cpu_memory_allocation.cpu_cores_running, + cpu_memory_allocation.total_vms_mem, + cpu_memory_allocation.mem_running, + dc_storage.dc_used_disk_size_gb, + dc_storage.dc_available_disk_size_gb, + dc_storage.dc_total_disk_size_gb, + vms_storage.vms_allocated_disk_size_gb]]> + </queryString> + <field name="number_of_hosts" class="java.lang.Long"/> + <field name="total_hosts_num_of_cpus" class="java.lang.Long"/> + <field name="memory_size_mb" class="java.lang.Long"/> + <field name="num_of_running_vms" class="java.math.BigDecimal"/> + <field name="total_configured_vms" class="java.math.BigDecimal"/> + <field name="total_vms_cpu_cores" class="java.lang.Long"/> + <field name="cpu_cores_running" class="java.lang.Long"/> + <field name="total_vms_mem" class="java.lang.Long"/> + <field name="mem_running" class="java.lang.Long"/> + <field name="dc_used_disk_size_gb" class="java.lang.Long"/> + <field name="dc_available_disk_size_gb" class="java.lang.Long"/> + <field name="dc_total_disk_size_gb" class="java.lang.Long"/> + <field name="vms_allocated_disk_size_gb" class="java.math.BigDecimal"/> + </subDataset> + <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="active_hosts_select" class="java.lang.String"> + <defaultValueExpression><![CDATA["AND delete_date IS NULL"]]></defaultValueExpression> + </parameter> + <queryString language="SQL"> + <![CDATA[-- This query returns the +-- average number of CPU Cores and Physical Memory +-- for the vms in the specific cluster. + + +SELECT + COALESCE( + tag_name, + 'Unknown' + ) AS tag_name, + datacenter_name, + datacenter_description, + cluster_name, + cluster_description, + COUNT( DISTINCT host_id ) AS number_of_hosts, + SUM ( + COALESCE ( + v3_6_latest_configuration_hosts.number_of_cores, + 0 + ) * + COALESCE ( + v3_6_latest_configuration_hosts.number_of_sockets, + 0 + ) + ) AS total_hosts_num_of_cpus, + SUM ( + COALESCE ( + v3_6_latest_configuration_hosts.memory_size_mb, + 0 + ) + ) AS memory_size_mb, + num_of_vms.num_of_running_vms, + num_of_vms.total_configured_vms, + cpu_memory_allocation.total_vms_cpu_cores, + cpu_memory_allocation.cpu_cores_running, + cpu_memory_allocation.total_vms_mem, + cpu_memory_allocation.mem_running, + dc_storage.dc_used_disk_size_gb, + dc_storage.dc_available_disk_size_gb, + dc_storage.dc_total_disk_size_gb, + vms_storage.vms_allocated_disk_size_gb +FROM v3_6_latest_configuration_datacenters + INNER JOIN v3_6_latest_configuration_clusters + ON ( + v3_6_latest_configuration_datacenters.datacenter_id = + v3_6_latest_configuration_clusters.datacenter_id + ) + INNER JOIN v3_6_latest_configuration_hosts + ON ( + v3_6_latest_configuration_clusters.cluster_id = + v3_6_latest_configuration_hosts.cluster_id + ) + LEFT OUTER JOIN v3_6_latest_tags_relations + ON ( + v3_6_latest_configuration_hosts.host_id = + v3_6_latest_tags_relations.entity_id + AND v3_6_latest_tags_relations.entity_type = 3 + ) + LEFT OUTER JOIN v3_6_latest_tags_details + ON ( + v3_6_latest_tags_relations.parent_id = + v3_6_latest_tags_details.tag_id + ) + LEFT OUTER JOIN ( + SELECT + vm_count.cluster_id, + SUM ( + CASE + WHEN vm_count.vm_status = 1 + THEN vm_count.num_of_vms + ELSE 0 + END + ) AS num_of_running_vms, + SUM ( vm_count.num_of_vms ) AS total_configured_vms + FROM ( + SELECT + a.cluster_id AS cluster_id, + v3_6_statistics_vms_resources_usage_hourly.vm_status as vm_status, + COUNT( DISTINCT a.vm_id ) AS num_of_vms + FROM v3_6_statistics_vms_resources_usage_hourly + INNER JOIN v3_6_latest_configuration_vms a + ON ( + a.vm_id = + v3_6_statistics_vms_resources_usage_hourly.vm_id + ) + WHERE + v3_6_statistics_vms_resources_usage_hourly.history_id IN ( + SELECT MAX ( history_id ) + FROM v3_6_statistics_vms_resources_usage_hourly b + GROUP BY vm_id + ) + GROUP BY + a.cluster_id, v3_6_statistics_vms_resources_usage_hourly.vm_status + ) AS vm_count + GROUP BY cluster_id + ) AS num_of_vms + ON ( + num_of_vms.cluster_id = + v3_6_latest_configuration_clusters.cluster_id + ) + LEFT OUTER JOIN ( + SELECT + a.cluster_id, + SUM ( + COALESCE ( + v3_6_configuration_history_vms.cpu_per_socket, + 0 + )* + COALESCE ( + v3_6_configuration_history_vms.number_of_sockets, + 0 + ) + ) + AS total_vms_cpu_cores, + SUM ( + CASE + WHEN v3_6_statistics_vms_resources_usage_hourly.vm_status = 1 + THEN + COALESCE ( + v3_6_configuration_history_vms.cpu_per_socket, + 0 + ) * + COALESCE ( + v3_6_configuration_history_vms.number_of_sockets, + 0 + ) + ELSE 0 + END + ) + AS cpu_cores_running, + SUM ( + COALESCE ( + v3_6_configuration_history_vms.memory_size_mb, + 0 + ) + ) + AS total_vms_mem, + SUM ( + CASE + WHEN v3_6_statistics_vms_resources_usage_hourly.vm_status = 1 + THEN + COALESCE ( + v3_6_configuration_history_vms.memory_size_mb, + 0 + ) + ELSE 0 + END + ) + AS mem_running + FROM v3_6_statistics_vms_resources_usage_hourly + INNER JOIN v3_6_configuration_history_vms + ON ( + v3_6_configuration_history_vms.history_id = + v3_6_statistics_vms_resources_usage_hourly.vm_configuration_version + ) + INNER JOIN v3_6_latest_configuration_vms a + ON ( + a.vm_id = + v3_6_statistics_vms_resources_usage_hourly.vm_id + ) + WHERE + v3_6_statistics_vms_resources_usage_hourly.history_id IN ( + SELECT MAX ( history_id ) + FROM v3_6_statistics_vms_resources_usage_hourly b + GROUP BY vm_id + ) + GROUP BY + a.cluster_id + ) AS cpu_memory_allocation + ON ( + cpu_memory_allocation.cluster_id = + v3_6_latest_configuration_clusters.cluster_id + ) + LEFT OUTER JOIN ( + SELECT + datacenter_id, + SUM ( + COALESCE ( + samples.used_disk_size_gb, + daily.used_disk_size_gb + ) + ) + AS dc_used_disk_size_gb, + SUM ( + COALESCE ( + samples.available_disk_size_gb, + daily.available_disk_size_gb + ) + ) + AS dc_available_disk_size_gb, + SUM ( + COALESCE ( + samples.available_disk_size_gb + samples.used_disk_size_gb, + daily.available_disk_size_gb + daily.used_disk_size_gb + ) + ) + AS dc_total_disk_size_gb + FROM v3_6_latest_configuration_storage_domains + INNER JOIN v3_6_latest_map_datacenters_storage_domains + ON ( + v3_6_latest_configuration_storage_domains.storage_domain_id = + v3_6_latest_map_datacenters_storage_domains.storage_domain_id + ) + LEFT OUTER JOIN v3_6_statistics_storage_domains_resources_usage_samples AS samples + ON ( + v3_6_latest_configuration_storage_domains.storage_domain_id = + samples.storage_domain_id + AND samples.history_id IN ( + SELECT MAX ( a.history_id ) + FROM v3_6_statistics_storage_domains_resources_usage_samples a + GROUP BY a.storage_domain_id + ) + ) + LEFT OUTER JOIN v3_6_statistics_storage_domains_resources_usage_daily AS daily + ON ( + v3_6_latest_configuration_storage_domains.storage_domain_id = + daily.storage_domain_id + AND daily.history_id IN ( + SELECT MAX ( a.history_id ) + FROM v3_6_statistics_storage_domains_resources_usage_daily a + GROUP BY a.storage_domain_id + ) + ) + WHERE + -- Here we filter by the "Data" storage type + storage_domain_type IN ( 0, 1 ) + GROUP BY datacenter_id + ) AS dc_storage + ON ( + dc_storage.datacenter_id = + v3_6_latest_configuration_datacenters.datacenter_id + ) + LEFT OUTER JOIN ( + SELECT + datacenter_id, + SUM ( + v3_6_latest_configuration_vms_disks.vm_disk_size_mb + ) * 0.0009765625 + AS vms_allocated_disk_size_gb + FROM v3_6_latest_configuration_storage_domains + INNER JOIN v3_6_latest_map_datacenters_storage_domains + ON ( + v3_6_latest_map_datacenters_storage_domains.storage_domain_id = + v3_6_latest_configuration_storage_domains.storage_domain_id + ) + INNER JOIN v3_6_latest_configuration_vms_disks + ON ( + v3_6_latest_configuration_storage_domains.storage_domain_id = + v3_6_latest_configuration_vms_disks.storage_domain_id + ) + LEFT OUTER JOIN v3_6_statistics_vms_disks_resources_usage_samples AS samples + ON ( + v3_6_latest_configuration_vms_disks.vm_disk_id = + samples.vm_disk_id + AND samples.history_id IN ( + SELECT MAX ( a.history_id ) + FROM v3_6_statistics_vms_disks_resources_usage_samples a + GROUP BY a.vm_disk_id + ) + ) + LEFT OUTER JOIN v3_6_statistics_vms_disks_resources_usage_daily AS daily + ON ( + v3_6_latest_configuration_vms_disks.vm_disk_id = + daily.vm_disk_id + AND daily.history_id IN ( + SELECT MAX ( a.history_id ) + FROM v3_6_statistics_vms_disks_resources_usage_daily a + GROUP BY a.vm_disk_id + ) + ) + WHERE + -- Here we filter by the "Data" storage type + storage_domain_type IN ( 0, 1 ) + GROUP BY datacenter_id + ) AS vms_storage + ON ( + vms_storage.datacenter_id = + v3_6_latest_configuration_datacenters.datacenter_id + ) +GROUP BY + tag_name, + datacenter_name, + datacenter_description, + cluster_name, + cluster_description, + num_of_vms.num_of_running_vms, + num_of_vms.total_configured_vms, + cpu_memory_allocation.total_vms_cpu_cores, + cpu_memory_allocation.cpu_cores_running, + cpu_memory_allocation.total_vms_mem, + cpu_memory_allocation.mem_running, + dc_storage.dc_used_disk_size_gb, + dc_storage.dc_available_disk_size_gb, + dc_storage.dc_total_disk_size_gb, + vms_storage.vms_allocated_disk_size_gb]]> + </queryString> + <field name="tag_name" class="java.lang.String"/> + <field name="datacenter_name" class="java.lang.String"/> + <field name="cluster_name" class="java.lang.String"/> + <field name="cluster_description" class="java.lang.String"/> + <field name="number_of_hosts" class="java.lang.Long"/> + <field name="total_hosts_num_of_cpus" class="java.lang.Long"/> + <field name="memory_size_mb" class="java.lang.Long"/> + <field name="num_of_running_vms" class="java.math.BigDecimal"/> + <field name="total_configured_vms" class="java.math.BigDecimal"/> + <field name="total_vms_cpu_cores" class="java.lang.Long"/> + <field name="cpu_cores_running" class="java.lang.Long"/> + <field name="total_vms_mem" class="java.lang.Long"/> + <field name="mem_running" class="java.lang.Long"/> + <field name="dc_used_disk_size_gb" class="java.lang.Long"/> + <field name="dc_total_disk_size_gb" class="java.lang.Long"/> + <field name="vms_allocated_disk_size_gb" class="java.math.BigDecimal"/> + <field name="dc_available_disk_size_gb" class="java.lang.Long"/> + <field name="datacenter_description" class="java.lang.String"/> + <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="135" splitType="Stretch"> + <line> + <reportElement x="0" y="43" width="832" height="1" uuid="44ce704d-72ee-4eb6-8af1-7cab0f436d4b"/> + </line> + <textField pattern=""> + <reportElement x="561" y="27" width="270" height="15" uuid="3a57d276-8aa9-4c5d-997a-1b44ccbe1b5b"> + <property name="local_mesure_unitx" value="pixel"/> + <property name="com.jaspersoft.studio.unit.x" value="px"/> + </reportElement> + <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="eee400a3-ac2d-4475-9aa2-b4835e500375"/> + <imageExpression><![CDATA["repo:ovirt-icon"]]></imageExpression> + </image> + </band> + </title> + <pageFooter> + <band height="41"> + <property name="local_mesure_unitheight" value="pixel"/> + <property name="com.jaspersoft.studio.unit.height" value="px"/> + <subreport> + <reportElement x="150" y="0" width="600" height="20" uuid="95f623f3-0394-4c2d-a167-8900d4862df9"> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + <property name="local_mesure_unitx" value="pixel"/> + <property name="com.jaspersoft.studio.unit.x" value="px"/> + <property name="local_mesure_unitheight" value="pixel"/> + <property name="com.jaspersoft.studio.unit.height" value="px"/> + </reportElement> + <subreportExpression><![CDATA["repo:br48_legend.jrxml"]]></subreportExpression> + </subreport> + <textField evaluationTime="Auto"> + <reportElement x="221" y="20" width="391" height="15" uuid="2492e057-5d8c-4355-81ed-c318d109b49a"> + <property name="local_mesure_unity" value="pixel"/> + <property name="com.jaspersoft.studio.unit.y" value="px"/> + </reportElement> + <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> + <summary> + <band height="140"> + <property name="local_mesure_unitheight" value="pixel"/> + <componentElement> + <reportElement x="0" y="40" width="750" height="100" uuid="466a3055-a52f-4089-8164-9ceec900c95c"> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + <property name="local_mesure_unitx" value="pixel"/> + <property name="com.jaspersoft.studio.unit.x" value="px"/> + </reportElement> + <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd"> + <datasetRun subDataset="Table" uuid="27124cbe-2816-4d2c-a2be-6a49eadfb987"> + <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> + </datasetRun> + <jr:columnGroup width="750" uuid="e7933cd9-efe1-450a-b19b-769869e87360"> + <property name="local_mesure_unitheight" value="pixel"/> + <jr:groupHeader groupName="Tag"> + <jr:cell height="20"> + <textField isBlankWhenNull="true"> + <reportElement key="" style="Table 1_TH" x="0" y="0" width="750" height="20" isRemoveLineWhenBlank="true" uuid="5b386b46-22ff-434a-983c-e838b080dbd8"> + <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="0.5" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> + <rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement> + <font isBold="true"/> + </textElement> + <textFieldExpression><![CDATA[CONCATENATE("Tag: ",$F{tag_name})]]></textFieldExpression> + </textField> + </jr:cell> + </jr:groupHeader> + <jr:groupHeader groupName="Cluster"> + <jr:cell height="20"> + <textField isBlankWhenNull="true"> + <reportElement style="Table 1_TH" x="0" y="0" width="750" height="20" uuid="ccc46d1a-f6dc-47e1-95cc-3bd839f479e4"> + <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="0.5" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> + <rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> + </box> + <textFieldExpression><![CDATA[IF(AND($F{datacenter_name}!= null,$F{datacenter_description} != null) ,CONCATENATE("Data Center: ",$F{datacenter_name}," - ",$F{datacenter_description}),CONCATENATE("Data Center: ",$F{datacenter_name}))]]></textFieldExpression> + </textField> + </jr:cell> + </jr:groupHeader> + <jr:columnHeader height="0"/> + <jr:column width="100" uuid="c09935b2-a7f7-4bb6-98fd-bcba9d8ac692"> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="local_mesure_unitheight" value="pixel"/> + <jr:columnHeader style="Table 1_CH" height="30"> + <staticText> + <reportElement x="0" y="0" width="100" height="30" uuid="c9b9c4d6-e4ba-4a8b-81ef-5d6dbbf50664"> + <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"/> + </reportElement> + <textElement> + <font isBold="true"/> + </textElement> + <text><![CDATA[Cluster Name]]></text> + </staticText> + </jr:columnHeader> + <jr:detailCell style="Table 1_TD" height="30"> + <textField isBlankWhenNull="true"> + <reportElement key="" x="0" y="0" width="100" height="30" uuid="8b6f7747-6469-42c1-bdb5-04daec64efae"> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + <property name="local_mesure_unitx" 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"/> + </reportElement> + <textElement textAlignment="Left"/> + <textFieldExpression><![CDATA[$F{cluster_name}]]></textFieldExpression> + </textField> + </jr:detailCell> + </jr:column> + <jr:column width="50" uuid="aff3c35f-51d9-4a8d-8a6f-3df034ee0882"> + <jr:columnHeader height="30"> + <staticText> + <reportElement style="Table 1_CH" x="0" y="0" width="50" height="30" uuid="cb3a36e3-e913-4b21-81cf-b6ade047121b"> + <property name="local_mesure_unitheight" value="pixel"/> + <property name="com.jaspersoft.studio.unit.height" value="px"/> + </reportElement> + <textElement> + <font isBold="true"/> + </textElement> + <text><![CDATA[Physical Servers]]></text> + </staticText> + </jr:columnHeader> + <jr:detailCell height="30"> + <textField> + <reportElement x="0" y="0" width="50" height="30" uuid="2066e244-8b48-4cff-819d-73c96479f9b8"/> + <box> + <topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> + <leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> + <bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> + <rightPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> + </box> + <textElement textAlignment="Center" markup="styled"/> + <textFieldExpression><![CDATA[$F{number_of_hosts}]]></textFieldExpression> + </textField> + </jr:detailCell> + </jr:column> + <jr:column width="60" uuid="9cbe0a1e-513d-4829-b6b6-3222c78986ca"> + <property name="local_mesure_unitwidth" value="pixel"/> + <jr:columnHeader style="Table 1_CH" height="30"> + <staticText> + <reportElement x="0" y="0" width="60" height="30" uuid="5505c9b8-5147-49fa-97d9-14113b7d4a2c"> + <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"/> + </reportElement> + <textElement> + <font isBold="true"/> + </textElement> + <text><![CDATA[Configured]]></text> + </staticText> + </jr:columnHeader> + <jr:detailCell style="Table 1_TD" height="30"> + <textField pattern="#,##0.###;(#,##0.###-)" isBlankWhenNull="true"> + <reportElement x="0" y="0" width="60" height="30" uuid="d98dc54f-8287-45a1-a321-584f7b58c114"> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + </reportElement> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{total_configured_vms}]]></textFieldExpression> + </textField> + </jr:detailCell> + </jr:column> + <jr:column width="45" uuid="c8bf8679-94a2-4110-b0ac-e60b75834e80"> + <property name="local_mesure_unitwidth" value="pixel"/> + <jr:columnHeader style="Table 1_CH" height="30"> + <staticText> + <reportElement x="0" y="0" width="45" height="30" uuid="b3bb6417-55d5-42e4-a68b-8a15fd1b7a2c"> + <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"/> + </reportElement> + <textElement> + <font isBold="true"/> + </textElement> + <text><![CDATA[Running]]></text> + </staticText> + </jr:columnHeader> + <jr:detailCell style="Table 1_TD" height="30"> + <textField pattern="#,##0.###;(#,##0.###-)" isBlankWhenNull="true"> + <reportElement key="" x="0" y="0" width="45" height="30" uuid="9e734d51-2d9b-4cb3-ab4c-da34a3f0cebc"> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + </reportElement> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{num_of_running_vms}]]></textFieldExpression> + </textField> + </jr:detailCell> + </jr:column> + <jr:column width="55" uuid="080d64b8-2115-4dd6-a201-08f1ce6b6667"> + <property name="local_mesure_unitwidth" value="pixel"/> + <jr:columnHeader style="Table 1_CH" height="30"> + <staticText> + <reportElement x="0" y="0" width="55" height="30" uuid="cb85b246-5542-4f21-a980-d6801a77762e"> + <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"/> + </reportElement> + <textElement> + <font isBold="true"/> + </textElement> + <text><![CDATA[Hosts]]></text> + </staticText> + </jr:columnHeader> + <jr:detailCell style="Table 1_TD" height="30"> + <textField pattern="#,##0.###;(#,##0.###-)" isBlankWhenNull="true"> + <reportElement x="0" y="0" width="55" height="30" uuid="c2c9e337-53e7-42b4-b1d8-75ab0e0052d8"> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + </reportElement> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{total_hosts_num_of_cpus}]]></textFieldExpression> + </textField> + </jr:detailCell> + </jr:column> + <jr:column width="55" uuid="5b0d0036-de88-4aad-b4a4-4dba22ba2e22"> + <property name="local_mesure_unitwidth" value="pixel"/> + <jr:columnHeader style="Table 1_CH" height="30"> + <staticText> + <reportElement x="0" y="0" width="55" height="30" uuid="749a4624-edfb-4668-a3b0-e22bc5d8f21c"> + <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"/> + </reportElement> + <textElement> + <font isBold="true"/> + </textElement> + <text><![CDATA[VM's]]></text> + </staticText> + </jr:columnHeader> + <jr:detailCell style="Table 1_TD" height="30"> + <textField isBlankWhenNull="true"> + <reportElement style="CPU" x="0" y="0" width="55" height="30" uuid="c3c8f496-3284-4013-afdd-e920b5f59054"> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + </reportElement> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{total_vms_cpu_cores}]]></textFieldExpression> + </textField> + </jr:detailCell> + </jr:column> + <jr:column width="45" uuid="4c8fb284-d8ca-4ef7-8271-0edf8a041728"> + <property name="local_mesure_unitwidth" value="pixel"/> + <jr:columnHeader style="Table 1_CH" height="30"> + <staticText> + <reportElement x="0" y="0" width="45" height="30" uuid="2be3fefb-f7aa-4702-9388-1780772edccc"> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + </reportElement> + <textElement> + <font isBold="true"/> + </textElement> + <text><![CDATA[Running VM's]]></text> + </staticText> + </jr:columnHeader> + <jr:detailCell style="Table 1_TD" height="30"> + <textField pattern="#,##0.###;(#,##0.###-)" isBlankWhenNull="true"> + <reportElement style="CPU_Running" x="0" y="0" width="45" height="30" uuid="5f972898-cebe-49a3-8857-998c3f0327ba"> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + </reportElement> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{cpu_cores_running}]]></textFieldExpression> + </textField> + </jr:detailCell> + </jr:column> + <jr:column width="50" uuid="4abf05d2-a2e4-4586-9d36-9cd16d3f9432"> + <jr:columnHeader style="Table 1_CH" height="30"> + <staticText> + <reportElement x="0" y="0" width="50" height="30" uuid="2746cb37-b49c-434a-b618-5ad653506f8a"/> + <textElement> + <font isBold="true"/> + </textElement> + <text><![CDATA[Hosts]]></text> + </staticText> + </jr:columnHeader> + <jr:detailCell style="Table 1_TD" height="30"> + <textField pattern="#,##0.###;(#,##0.###-)" isBlankWhenNull="true"> + <reportElement x="0" y="0" width="50" height="30" uuid="ff303e4b-8c46-4f5b-b397-825fe7ee228b"/> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{memory_size_mb}]]></textFieldExpression> + </textField> + </jr:detailCell> + </jr:column> + <jr:column width="50" uuid="b783d948-7d51-48f6-8308-632e4ca8e373"> + <jr:columnHeader style="Table 1_CH" height="30"> + <staticText> + <reportElement x="0" y="0" width="50" height="30" uuid="d4672fb1-35f1-4c27-84f1-08f572442e9d"/> + <textElement> + <font isBold="true"/> + </textElement> + <text><![CDATA[VM's]]></text> + </staticText> + </jr:columnHeader> + <jr:detailCell style="Table 1_TD" height="30"> + <textField pattern="#,##0.###;(#,##0.###-)" isBlankWhenNull="true"> + <reportElement style="MEM" x="0" y="0" width="50" height="30" uuid="c61d5657-c7d4-43ba-87bc-c200afc4af3c"/> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{total_vms_mem}]]></textFieldExpression> + </textField> + </jr:detailCell> + </jr:column> + <jr:column width="55" uuid="60c75347-b1c9-4a92-ab81-5a4c2a9890c3"> + <property name="local_mesure_unitwidth" value="pixel"/> + <jr:columnHeader style="Table 1_CH" height="30"> + <staticText> + <reportElement x="0" y="0" width="55" height="30" uuid="3c14af84-f438-458c-90e9-76692e9671cb"> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + </reportElement> + <textElement> + <font isBold="true"/> + </textElement> + <text><![CDATA[Running VM's]]></text> + </staticText> + </jr:columnHeader> + <jr:detailCell style="Table 1_TD" height="30"> + <textField pattern="#,##0.###;(#,##0.###-)" isBlankWhenNull="true"> + <reportElement style="MEM_Runing" x="0" y="0" width="55" height="30" uuid="68c0ab1e-2189-41ac-a053-05b40e51db62"> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + </reportElement> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{mem_running}]]></textFieldExpression> + </textField> + </jr:detailCell> + </jr:column> + <jr:column width="45" uuid="a035d8a5-c6f9-4a3e-87ff-19eec093aa1e"> + <property name="local_mesure_unitwidth" value="pixel"/> + <jr:columnHeader style="Table 1_CH" height="30"> + <staticText> + <reportElement x="0" y="0" width="45" height="30" uuid="d14aeb48-d1bf-4f86-9348-a3cfac2d8fd9"> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + </reportElement> + <textElement> + <font isBold="true"/> + </textElement> + <text><![CDATA[Total Size - DC]]></text> + </staticText> + </jr:columnHeader> + <jr:detailCell style="Table 1_TD" height="30"> + <textField pattern="#,##0.###;(#,##0.###-)" isBlankWhenNull="true"> + <reportElement x="0" y="0" width="45" height="30" uuid="bd3e6a13-196d-4ec9-ae69-88f8fb3210b8"> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + </reportElement> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{dc_total_disk_size_gb}]]></textFieldExpression> + </textField> + </jr:detailCell> + </jr:column> + <jr:column width="45" uuid="635d653f-623e-468e-9fde-0f276fcc98f7"> + <property name="local_mesure_unitwidth" value="pixel"/> + <jr:columnHeader style="Table 1_CH" height="30"> + <staticText> + <reportElement x="0" y="0" width="45" height="30" uuid="5bf7d346-63ee-4200-8f9e-8fa3836208e3"> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + </reportElement> + <textElement> + <font isBold="true"/> + </textElement> + <text><![CDATA[Used - DC]]></text> + </staticText> + </jr:columnHeader> + <jr:detailCell style="Table 1_TD" height="30"> + <textField pattern="#,##0.###;(#,##0.###-)" isBlankWhenNull="true"> + <reportElement style="DiskUsed" x="0" y="0" width="45" height="30" uuid="8e4241eb-494e-41a6-9c48-f39054ef1786"> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + </reportElement> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{dc_used_disk_size_gb}]]></textFieldExpression> + </textField> + </jr:detailCell> + </jr:column> + <jr:column width="50" uuid="70fec5c7-2d21-44fa-b2be-3fb18e431643"> + <property name="local_mesure_unitwidth" value="pixel"/> + <jr:columnHeader style="Table 1_CH" height="30"> + <staticText> + <reportElement x="0" y="0" width="50" height="30" uuid="c613a0ab-6d1f-42af-bdb6-d0b869008cd0"> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + </reportElement> + <textElement> + <font isBold="true"/> + </textElement> + <text><![CDATA[Allocated -VM's]]></text> + </staticText> + </jr:columnHeader> + <jr:detailCell style="Table 1_TD" height="30"> + <textField pattern="#,##0.###;(#,##0.###-)" isBlankWhenNull="true"> + <reportElement style="DiskUsage-Allocated VM" x="0" y="0" width="50" height="30" uuid="55112594-8e4a-41dc-94c2-c6ff8e5a2ad1"> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + </reportElement> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{vms_allocated_disk_size_gb}]]></textFieldExpression> + </textField> + </jr:detailCell> + </jr:column> + <jr:column width="45" uuid="191635ea-997d-457e-83d6-40ad2006021b"> + <property name="local_mesure_unitwidth" value="pixel"/> + <jr:columnHeader style="Table 1_CH" height="30"> + <staticText> + <reportElement x="0" y="0" width="45" height="30" uuid="fd245fe5-6e8a-455e-9ecd-d6ba0c2a0f46"> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + </reportElement> + <textElement> + <font isBold="true"/> + </textElement> + <text><![CDATA[Available - DC]]></text> + </staticText> + </jr:columnHeader> + <jr:detailCell style="Table 1_TD" height="30"> + <textField pattern="#,##0.###;(#,##0.###-)" isBlankWhenNull="true"> + <reportElement x="0" y="0" width="45" height="30" uuid="e8791a1b-d407-49e6-9cee-9f2a13ce76e2"> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + </reportElement> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{dc_available_disk_size_gb}]]></textFieldExpression> + </textField> + </jr:detailCell> + </jr:column> + </jr:columnGroup> + </jr:table> + </componentElement> + <componentElement> + <reportElement x="60" y="0" width="690" height="20" uuid="3179ed18-51f8-412c-84dc-aabb5e2fd3ba"> + <property name="local_mesure_unitwidth" value="pixel"/> + <property name="com.jaspersoft.studio.unit.width" value="px"/> + <property name="local_mesure_unity" value="pixel"/> + <property name="com.jaspersoft.studio.unit.y" value="px"/> + <property name="local_mesure_unitx" value="pixel"/> + <property name="com.jaspersoft.studio.unit.x" value="px"/> + </reportElement> + <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd"> + <datasetRun subDataset="Dataset1" uuid="649e34fe-8110-453b-96d3-516a7c6c91c8"> + <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> + </datasetRun> + <jr:column width="40" uuid="6617dad5-32a9-4db1-95f7-fab8a552531b"> + <jr:detailCell style="Table 2_TD" height="20"> + <staticText> + <reportElement x="0" y="0" width="40" height="20" uuid="6b805fec-a648-47c1-829d-cf98bbf24085"/> + <textElement> + <font isBold="true"/> + </textElement> + <text><![CDATA[Totals]]></text> + </staticText> + </jr:detailCell> + </jr:column> + <jr:column width="50" uuid="4073ec58-e8b0-4a37-9f3a-52db657f2b60"> + <property name="local_mesure_unitwidth" value="pixel"/> + <jr:detailCell style="Table 2_TD" height="20"> + <textField pattern="#,##0.###;(#,##0.###-)"> + <reportElement x="0" y="0" width="50" height="20" uuid="3ac35a1f-7542-47c1-9026-a617c2fcd838"> + <property name="local_mesure_unitheight" value="pixel"/> + <property name="com.jaspersoft.studio.unit.height" value="px"/> + <property name="local_mesure_unitwidth" value="pixel"/> + </reportElement> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{number_of_hosts}]]></textFieldExpression> + </textField> + </jr:detailCell> + </jr:column> + <jr:column width="60" uuid="c009c0d7-b4ae-4caf-879d-3ec25672d27a"> + <property name="local_mesure_unitwidth" value="pixel"/> + <jr:detailCell style="Table 2_TD" height="20"> + <textField pattern="#,##0.###;(#,##0.###-)"> + <reportElement x="0" y="0" width="60" height="20" uuid="2293fa94-dad6-453a-a1d6-00aa55421b1a"> + <property name="local_mesure_unitheight" value="pixel"/> + <property name="com.jaspersoft.studio.unit.height" value="px"/> + </reportElement> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{total_configured_vms}]]></textFieldExpression> + </textField> + </jr:detailCell> + </jr:column> + <jr:column width="45" uuid="b0707579-6b4e-428b-8bcb-258a27a38516"> + <jr:detailCell style="Table 2_TD" height="20"> + <textField pattern="#,##0.###;(#,##0.###-)"> + <reportElement x="0" y="0" width="45" height="20" uuid="150a4262-363e-41ec-bb82-323f344916d7"> + <property name="local_mesure_unitheight" value="pixel"/> + <property name="com.jaspersoft.studio.unit.height" value="px"/> + </reportElement> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{num_of_running_vms}]]></textFieldExpression> + </textField> + </jr:detailCell> + </jr:column> + <jr:column width="55" uuid="0497e1fc-2261-4f36-9904-fded2b83e173"> + <property name="local_mesure_unitwidth" value="pixel"/> + <jr:detailCell style="Table 2_TD" height="20"> + <textField pattern="#,##0.###;(#,##0.###-)"> + <reportElement x="0" y="0" width="55" height="20" uuid="bc8595ce-8abc-490a-ab33-7b0c12c5979a"> + <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"/> + </reportElement> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{total_hosts_num_of_cpus}]]></textFieldExpression> + </textField> + </jr:detailCell> + </jr:column> + <jr:column width="55" uuid="3092ce41-29a0-4429-87f2-bea00d958f2a"> + <property name="local_mesure_unitwidth" value="pixel"/> + <jr:detailCell style="Table 2_TD" height="20"> + <textField pattern="#,##0.###;(#,##0.###-)"> + <reportElement x="0" y="0" width="55" height="20" uuid="de077fe2-1ab9-4123-a706-921831ecc12a"> + <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"/> + </reportElement> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{total_vms_cpu_cores}]]></textFieldExpression> + </textField> + </jr:detailCell> + </jr:column> + <jr:column width="45" uuid="d0f6ae6a-872e-494f-bf58-f3965b2c88c7"> + <property name="local_mesure_unitwidth" value="pixel"/> + <jr:detailCell style="Table 2_TD" height="20"> + <textField pattern="#,##0.###;(#,##0.###-)"> + <reportElement x="0" y="0" width="45" height="20" uuid="d1389dff-1b5c-40ba-8df2-814e2ba66367"> + <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"/> + </reportElement> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{cpu_cores_running}]]></textFieldExpression> + </textField> + </jr:detailCell> + </jr:column> + <jr:column width="50" uuid="aa8ed507-ec29-45f9-9247-0ae372e99a69"> + <property name="local_mesure_unitwidth" value="pixel"/> + <jr:detailCell style="Table 2_TD" height="20"> + <textField pattern="#,##0.###;(#,##0.###-)"> + <reportElement x="0" y="0" width="50" height="20" uuid="944bfa2c-d81e-4652-9107-20f8e50fc999"> + <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"/> + </reportElement> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{memory_size_mb}]]></textFieldExpression> + </textField> + </jr:detailCell> + </jr:column> + <jr:column width="50" uuid="5d51811c-8b89-4f97-a561-ff3ff01da84f"> + <property name="local_mesure_unitwidth" value="pixel"/> + <jr:detailCell style="Table 2_TD" height="20"> + <textField pattern="#,##0.###;(#,##0.###-)"> + <reportElement x="0" y="0" width="50" height="20" uuid="4f55738a-2ee5-4eaa-8f5a-7a48c1857509"> + <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"/> + </reportElement> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{total_vms_mem}]]></textFieldExpression> + </textField> + </jr:detailCell> + </jr:column> + <jr:column width="55" uuid="9e7894fe-6ccd-49ba-b9e8-545ed49bd09a"> + <property name="local_mesure_unitwidth" value="pixel"/> + <jr:detailCell style="Table 2_TD" height="20"> + <textField pattern="#,##0.###;(#,##0.###-)"> + <reportElement x="0" y="0" width="55" height="20" uuid="d194f65f-2175-40d7-aa75-877d44980576"> + <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"/> + </reportElement> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{mem_running}]]></textFieldExpression> + </textField> + </jr:detailCell> + </jr:column> + <jr:column width="45" uuid="0ed5a542-2700-4824-bdec-a408214ed16c"> + <property name="local_mesure_unitwidth" value="pixel"/> + <jr:detailCell style="Table 2_TD" height="20"> + <textField pattern="#,##0.###;(#,##0.###-)"> + <reportElement x="0" y="0" width="45" height="20" uuid="d1352130-5df4-4867-bc9a-7da509386e1a"> + <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"/> + <property name="local_mesure_unitx" value="pixel"/> + </reportElement> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{dc_total_disk_size_gb}]]></textFieldExpression> + </textField> + </jr:detailCell> + </jr:column> + <jr:column width="45" uuid="93df242b-ce30-4b9f-bd22-6a05ee8b71c6"> + <jr:detailCell style="Table 2_TD" height="20"> + <textField pattern="#,##0.###;(#,##0.###-)"> + <reportElement x="0" y="0" width="45" height="20" uuid="e277db8f-9c12-4a9a-9b0e-3b73b78b3ccb"> + <property name="local_mesure_unitheight" value="pixel"/> + <property name="com.jaspersoft.studio.unit.height" value="px"/> + </reportElement> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{dc_used_disk_size_gb}]]></textFieldExpression> + </textField> + </jr:detailCell> + </jr:column> + <jr:column width="50" uuid="4960bdf5-7527-483a-a97e-a56f6db31259"> + <property name="local_mesure_unitwidth" value="pixel"/> + <jr:detailCell style="Table 2_TD" height="20"> + <textField pattern="#,##0.###;(#,##0.###-)"> + <reportElement x="0" y="0" width="50" height="20" uuid="9745ad91-a0a6-4b88-8a93-22b59037b915"> + <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"/> + </reportElement> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{vms_allocated_disk_size_gb}]]></textFieldExpression> + </textField> + </jr:detailCell> + </jr:column> + <jr:column width="45" uuid="a3785d26-d64e-47b0-83ef-f48cc0a1e2d2"> + <property name="local_mesure_unitwidth" value="pixel"/> + <jr:detailCell style="Table 2_TD" height="20"> + <textField pattern="#,##0.###;(#,##0.###-)"> + <reportElement x="0" y="0" width="45" height="20" uuid="cc683054-482a-4f40-8284-2c37834de263"> + <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"/> + </reportElement> + <textElement textAlignment="Center"/> + <textFieldExpression><![CDATA[$F{dc_available_disk_size_gb}]]></textFieldExpression> + </textField> + </jr:detailCell> + </jr:column> + </jr:table> + </componentElement> + <textField> + <reportElement x="150" y="20" width="105" height="20" backcolor="#FFFFFF" uuid="4cdeea79-2c73-445b-bffc-dd6cf2fa9749"> + <property name="local_mesure_unitx" value="pixel"/> + <property name="com.jaspersoft.studio.unit.x" 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["Number of VMs"]]></textFieldExpression> + </textField> + <textField> + <reportElement x="255" y="20" width="155" height="20" backcolor="#FFFFFF" uuid="aa962971-ecf4-4fe9-b158-627f8fd6a04c"> + <property name="local_mesure_unitx" value="pixel"/> + <property name="com.jaspersoft.studio.unit.x" 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["Total CPUs"]]></textFieldExpression> + </textField> + <textField> + <reportElement x="410" y="20" width="155" height="20" backcolor="#FFFFFF" uuid="f15adfb7-5f29-4422-860a-58c09f7d3ead"> + <property name="local_mesure_unitx" value="pixel"/> + <property name="com.jaspersoft.studio.unit.x" 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["RAM in GB"]]></textFieldExpression> + </textField> + <textField> + <reportElement x="565" y="20" width="185" height="20" backcolor="#FFFFFF" uuid="d503ff7e-72db-4301-8c4e-a8e3f120d3b0"> + <property name="local_mesure_unitx" value="pixel"/> + <property name="com.jaspersoft.studio.unit.x" 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["Disk in GB"]]></textFieldExpression> + </textField> + </band> + </summary> +</jasperReport> diff --git a/packaging/ovirt-reports/resources/reports_resources/JDBC/Input_Controls/Regular_Input_Controls/.folder.xml b/packaging/ovirt-reports/resources/reports_resources/JDBC/Input_Controls/Regular_Input_Controls/.folder.xml index 4ede018..afa5676 100644 --- a/packaging/ovirt-reports/resources/reports_resources/JDBC/Input_Controls/Regular_Input_Controls/.folder.xml +++ b/packaging/ovirt-reports/resources/reports_resources/JDBC/Input_Controls/Regular_Input_Controls/.folder.xml @@ -9,4 +9,5 @@ <folder>Only_Hosts</folder> <folder>Only_Storage</folder> <folder>Only_VMs</folder> + <folder>all_dcs_with_hosts_multi_select</folder> </folder> diff --git a/packaging/ovirt-reports/resources/reports_resources/JDBC/Input_Controls/Regular_Input_Controls/all_dcs_with_hosts_multi_select/.folder.xml b/packaging/ovirt-reports/resources/reports_resources/JDBC/Input_Controls/Regular_Input_Controls/all_dcs_with_hosts_multi_select/.folder.xml new file mode 100644 index 0000000..06455dc --- /dev/null +++ b/packaging/ovirt-reports/resources/reports_resources/JDBC/Input_Controls/Regular_Input_Controls/all_dcs_with_hosts_multi_select/.folder.xml @@ -0,0 +1,10 @@ +<?xml version="1.0" encoding="UTF-8"?> +<folder exportedWithPermissions="true"> + <parent>/organizations/organization_1/reports_resources/JDBC/Input_Controls/Regular_Input_Controls</parent> + <name>all_dcs_with_hosts_multi_select</name> + <label>All Datacenters with Hosts Multi Select</label> + <description></description> + <creationDate>2015-03-22T14:16:00.359+02:00</creationDate> + <updateDate>2015-01-28T14:49:16.095+02:00</updateDate> + <resource>P_DataCenter_ID</resource> +</folder> diff --git a/packaging/ovirt-reports/resources/reports_resources/JDBC/Input_Controls/Regular_Input_Controls/all_dcs_with_hosts_multi_select/P_DataCenter_ID.xml b/packaging/ovirt-reports/resources/reports_resources/JDBC/Input_Controls/Regular_Input_Controls/all_dcs_with_hosts_multi_select/P_DataCenter_ID.xml new file mode 100644 index 0000000..adebc60 --- /dev/null +++ b/packaging/ovirt-reports/resources/reports_resources/JDBC/Input_Controls/Regular_Input_Controls/all_dcs_with_hosts_multi_select/P_DataCenter_ID.xml @@ -0,0 +1,159 @@ +<?xml version="1.0" encoding="UTF-8"?> +<inputControl exportedWithPermissions="true"> + <folder>/organizations/organization_1/reports_resources/JDBC/Input_Controls/Regular_Input_Controls/all_dcs_with_hosts_multi_select</folder> + <name>P_DataCenter_ID</name> + <version>1</version> + <label>$R{ic.dc}</label> + <description></description> + <creationDate>2015-03-22T14:16:00.359+02:00</creationDate> + <updateDate>2015-03-22T14:27:11.127+02:00</updateDate> + <type>7</type> + <mandatory>true</mandatory> + <readOnly>false</readOnly> + <visible>true</visible> + <query> + <localResource + xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" + exportedWithPermissions="false" xsi:type="query"> + <folder>/organizations/organization_1/reports_resources/JDBC/Input_Controls/Regular_Input_Controls/all_dcs_with_hosts_multi_select/P_DataCenter_ID_files</folder> + <name>Data_Centers</name> + <version>1</version> + <label>Data_Centers</label> + <description></description> + <creationDate>2015-03-22T14:27:11.127+02:00</creationDate> + <updateDate>2015-03-22T14:27:11.127+02:00</updateDate> + <language>sql</language> + <queryString>-- This query will return only datacenters that have hosts. + +SELECT DISTINCT + CAST ( datacenter_id AS varchar ), + delete_date, + CASE + WHEN delete_date IS NULL + THEN RTRIM ( CAST ( datacenter_name AS varchar ) ) + ELSE + datacenter_name + || + ' (' + || + loc_removed_on.removed_on + || + ' ' + || + to_char( + delete_date, + $P{datetimelocalepattern} + ) + || + ')' + END AS combo_name +FROM v3_5_configuration_history_datacenters + LEFT OUTER JOIN ( + SELECT DISTINCT + COALESCE ( + enum_translator_localized.value_localized, + enum_translator_default.value + ) + AS removed_on + 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{userlocale} + ) + 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 + enum_translator_default.language_code = 'en_US' + AND enum_translator_default.enum_type = 'REPORTS_REMOVED_ON' + ) + AS loc_removed_on + ON ( 0 = 0 ) +WHERE + -- Here we get only datacenters that have hosts + datacenter_id IN ( + SELECT DISTINCT datacenter_id + FROM v3_5_configuration_history_clusters + WHERE cluster_id IN ( + SELECT DISTINCT a.cluster_id + FROM v3_5_configuration_history_hosts a + ) + ) + -- Here we get the latest datacenters configuration + AND history_id IN ( + SELECT MAX ( a.history_id ) + FROM v3_5_configuration_history_datacenters a + GROUP BY a.datacenter_id + ) + -- This will determine if deleted entities will be included in the report, + -- according to the user selection for "active_hosts_select" parameter + $P!{active_hosts_select} + +UNION ALL + +-- Here we add the "None Available" to the select list, +-- in case that there are no datacenters with hosts. +-- The value is localized according to the session language. +SELECT DISTINCT + '00000000-0000-0000-0000-000000000000', + CAST ( NULL AS timestamp ), + 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{userlocale} + ) + 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_type = 'REPORTS_NONE_AVAILABLE' + AND NOT EXISTS ( + SELECT DISTINCT datacenter_id + FROM v3_5_configuration_history_datacenters + WHERE + datacenter_id IN ( + SELECT DISTINCT datacenter_id + FROM v3_5_configuration_history_clusters + WHERE cluster_id IN ( + SELECT DISTINCT a.cluster_id + FROM v3_5_configuration_history_hosts a) + ) + -- Here we get the datacenters latest configuration + AND history_id IN ( + SELECT MAX ( a.history_id ) + FROM v3_5_configuration_history_datacenters a + GROUP BY a.datacenter_id + ) + $P!{active_hosts_select} + ) +ORDER BY delete_date DESC, combo_name +</queryString> + <dataSource> + <uri>/organizations/organization_1/reports_resources/JDBC/data_sources/ovirt</uri> + </dataSource> + </localResource> + </query> + <queryVisibleColumn>combo_name</queryVisibleColumn> + <queryValueColumn>datacenter_id</queryValueColumn> +</inputControl> -- To view, visit https://gerrit.ovirt.org/39005 To unsubscribe, visit https://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Ie811404cb38b243959fcbcf8311f1e98e43f681a 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