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

Reply via email to