<report xmlns="http://developer.cognos.com/schemas/report/11.0/" useStyleVersion="10" expressionLocale="en-us">
				<modelPath>/content/folder[@name='Packages']/package[@name='Inventory']/model[@name='model']</modelPath>
				<drillBehavior modelBasedDrillThru="true"/>
				<layouts>
					<layout>
						<reportPages>
							<page name="Page1">
								<style>
									<defaultStyles>
										<defaultStyle refStyle="pg"/>
									</defaultStyles>
								<CSS value="width:1024px"/></style>
								<pageBody>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pb"/>
										</defaultStyles>
									</style>
									<contents><HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;color:white;font-weight:bold"/></style></textItem></contents><style><CSS value="background-color:#6198C5;height:24px;padding-left:24px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Virtual Machine Performance Stats - CPU Utilization Distribution</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:24px;color:#333333"/></style></textItem></contents><style><CSS value="height:36px;padding-left:24px;background-color:#FBFBFB"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:15px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:50%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>CPU Utilization Range: </staticValue></dataSource><style><CSS value="font-family:Arial;font-size:12px;color:#333333;font-weight:bold"/></style></textItem></contents></tableCell><tableCell><contents><selectValue refQuery="Prompt" autoSubmit="true" parameter="All CPU Utilization Ranges"><style><CSS value="font-family:Arial;font-size:12px;color:#333333"/></style><useItem refDataItem="CPU Utilization Range"><displayItem refDataItem="CPU Utilization Range"/></useItem></selectValue></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:2.5px"/></style></tableCell><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>vCluster: </staticValue></dataSource><style><CSS value="font-family:Arial;font-size:12px;color:#333333;font-weight:bold"/></style></textItem></contents></tableCell><tableCell><contents><selectValue refQuery="Prompt" autoSubmit="true" parameter="All vClusters"><style><CSS value="font-family:Arial;font-size:12px;color:#333333"/></style><useItem refDataItem="vCluster"><displayItem refDataItem="vCluster"/></useItem></selectValue></contents></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><list horizontalPagination="true" name="List1" refQuery="Report" rowsPerPage="25000">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#333333;text-align:center;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="CPU Utilization Range"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#333333;text-align:center;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="CPU Utilization Range"/></dataSource></textItem></contents><listColumnRowSpan refDataItem="CPU Utilization Range"/></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#333333;text-align:center;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="vCluster"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#333333;text-align:center;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="vCluster"/></dataSource></textItem></contents><listColumnRowSpan refDataItem="vCluster"/></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#333333;text-align:center;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="ESX Host"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#333333;text-align:center;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="ESX Host"/></dataSource></textItem></contents><listColumnRowSpan refDataItem="ESX Host"/></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#333333;text-align:center;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Virtual Machine"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#333333;text-align:center;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Virtual Machine"/></dataSource></textItem></contents><listColumnRowSpan refDataItem="Virtual Machine"/></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#333333;text-align:center;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Peak CPU (%)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#333333;text-align:center;border:1px solid #E1E1E2"/><dataFormat><percentFormat decimalSize="2"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Peak CPU (%)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#333333;text-align:center;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="vCPU"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#333333;text-align:center;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="vCPU"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#333333;text-align:center;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Allocated (GB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#333333;text-align:center;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Allocated (GB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#333333;text-align:center;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Used (GB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="font-family:Arial;font-size:12px;color:#333333;text-align:center;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Used (GB)"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns><listGroups><listGroup refDataItem="CPU Utilization Range"><listFooter><listRows><listRow><rowCells><rowCell colSpan="4"><contents><textItem><dataSource><dataItemValue refDataItem="CPU Utilization Range"/></dataSource></textItem><textItem><dataSource><staticValue> - </staticValue></dataSource></textItem><textItem><dataSource><staticValue>Total</staticValue></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="of"/></defaultStyles><CSS value="background-color:silver;font-family:Arial;font-size:12px;color:#333333;border:1px solid #E1E1E2"/></style></rowCell><rowCell><contents/><style><defaultStyles><defaultStyle refStyle="of"/></defaultStyles><CSS value="background-color:silver;border:1px solid #E1E1E2"/></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total(vCPU)"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="os"/></defaultStyles><CSS value="background-color:silver;font-family:Arial;font-size:12px;color:#333333;text-align:center;border:1px solid #E1E1E2"/></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total(Allocated (GB))"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="os"/></defaultStyles><CSS value="background-color:silver;font-family:Arial;font-size:12px;color:#333333;text-align:center;border:1px solid #E1E1E2"/></style></rowCell><rowCell colSpan="1"><contents><textItem><dataSource><dataItemValue refDataItem="Total(Used (GB))"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="os"/></defaultStyles><CSS value="background-color:silver;font-family:Arial;font-size:12px;color:#333333;text-align:center;border:1px solid #E1E1E2"/></style></rowCell></rowCells></listRow></listRows></listFooter></listGroup><listGroup refDataItem="vCluster"><listFooter><listRows><listRow><rowCells><rowCell colSpan="3"><contents><textItem><dataSource><dataItemValue refDataItem="vCluster"/></dataSource></textItem><textItem><dataSource><staticValue> - </staticValue></dataSource></textItem><textItem><dataSource><staticValue>Total</staticValue></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="of"/></defaultStyles><CSS value="background-color:silver;font-family:Arial;font-size:12px;color:#333333;border:1px solid #E1E1E2"/></style></rowCell><rowCell><contents/><style><defaultStyles><defaultStyle refStyle="of"/></defaultStyles><CSS value="background-color:silver;border:1px solid #E1E1E2"/></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total(vCPU)"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="os"/></defaultStyles><CSS value="background-color:silver;font-family:Arial;font-size:12px;color:#333333;text-align:center;border:1px solid #E1E1E2"/></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total(Allocated (GB))"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="os"/></defaultStyles><CSS value="background-color:silver;font-family:Arial;font-size:12px;color:#333333;text-align:center;border:1px solid #E1E1E2"/></style></rowCell><rowCell colSpan="1"><contents><textItem><dataSource><dataItemValue refDataItem="Total(Used (GB))"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="os"/></defaultStyles><CSS value="background-color:silver;font-family:Arial;font-size:12px;color:#333333;text-align:center;border:1px solid #E1E1E2"/></style></rowCell></rowCells></listRow></listRows></listFooter></listGroup><listGroup refDataItem="ESX Host"><listFooter><listRows><listRow><rowCells><rowCell colSpan="2"><contents><textItem><dataSource><dataItemValue refDataItem="ESX Host"/></dataSource></textItem><textItem><dataSource><staticValue> - </staticValue></dataSource></textItem><textItem><dataSource><staticValue>Total</staticValue></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="of"/></defaultStyles><CSS value="background-color:silver;font-family:Arial;font-size:12px;color:#333333;border:1px solid #E1E1E2"/></style></rowCell><rowCell><contents/><style><defaultStyles><defaultStyle refStyle="of"/></defaultStyles><CSS value="background-color:silver;border:1px solid #E1E1E2"/></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total(vCPU)"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="os"/></defaultStyles><CSS value="background-color:silver;font-family:Arial;font-size:12px;color:#333333;text-align:center;border:1px solid #E1E1E2"/></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total(Allocated (GB))"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="os"/></defaultStyles><CSS value="background-color:silver;font-family:Arial;font-size:12px;color:#333333;text-align:center;border:1px solid #E1E1E2"/></style></rowCell><rowCell colSpan="1"><contents><textItem><dataSource><dataItemValue refDataItem="Total(Used (GB))"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="os"/></defaultStyles><CSS value="background-color:silver;font-family:Arial;font-size:12px;color:#333333;text-align:center;border:1px solid #E1E1E2"/></style></rowCell></rowCells></listRow></listRows></listFooter></listGroup><listGroup refDataItem="Virtual Machine"/></listGroups><listOverallGroup><listFooter><listRows><listRow><rowCells><rowCell colSpan="4"><contents><textItem><dataSource><staticValue>Overall</staticValue></dataSource></textItem><textItem><dataSource><staticValue> - </staticValue></dataSource></textItem><textItem><dataSource><staticValue>Total</staticValue></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="if"/></defaultStyles><CSS value="background-color:silver;font-family:Arial;font-size:12px;color:#333333;border:1px solid #E1E1E2"/></style></rowCell><rowCell><contents/><style><defaultStyles><defaultStyle refStyle="if"/></defaultStyles><CSS value="background-color:silver;border:1px solid #E1E1E2"/></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total(vCPU)"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="is"/></defaultStyles><CSS value="background-color:silver;font-family:Arial;font-size:12px;color:#333333;text-align:center;border:1px solid #E1E1E2"/></style></rowCell><rowCell><contents><textItem><dataSource><dataItemValue refDataItem="Total(Allocated (GB))"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="is"/></defaultStyles><CSS value="background-color:silver;font-family:Arial;font-size:12px;color:#333333;text-align:center;border:1px solid #E1E1E2"/></style></rowCell><rowCell colSpan="1"><contents><textItem><dataSource><dataItemValue refDataItem="Total(Used (GB))"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="is"/></defaultStyles><CSS value="background-color:silver;font-family:Arial;font-size:12px;color:#333333;text-align:center;border:1px solid #E1E1E2"/></style></rowCell></rowCells></listRow></listRows></listFooter></listOverallGroup></list></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="border:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="border:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table></contents>
								</pageBody>
							<pageFooter><contents><table>
											<tableRows>
												<tableRow>
													<tableCells>
														<tableCell>
															<contents>
																
															<image>
			<dataSource>
				<staticValue>/reporting/sanscreen/images/netapp_logo.png</staticValue>
			</dataSource>
		<style><CSS value="width:90px;height:36px"/></style></image></contents>
															<style>
																<CSS value="vertical-align:middle;text-align:left;width:30%"/>
															</style>
														</tableCell>
														<tableCell>
															<contents>
																<textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
															</contents>
															<style>
																<CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
															</style>
														</tableCell>
														<tableCell>
															<contents>
																
															<textItem><dataSource><staticValue>OnCommand Insight 7.1. © 2014-15 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
															<style>
																<CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
															</style>
														</tableCell>
													</tableCells>
												</tableRow>
											</tableRows>
											<style>
												<defaultStyles>
													<defaultStyle refStyle="tb"/>
												</defaultStyles>
												<CSS value="border-collapse:collapse;width:100%;height:32px"/>
											</style>
										</table></contents><style><CSS value="padding:10px 15px 10px 15px;background-color:#FBFBFB"/></style></pageFooter></page>
						</reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" value="true" output="no"/><XMLAttribute name="listSeparator" value="," output="no"/><XMLAttribute name="RS_modelModificationTime" value="2015-04-14T12:20:59.758Z" output="no"/></XMLAttributes><reportName>Virtual Machine Performance Stats - CPU Utilization Distribution</reportName><classStyles><classStyle name="ls"><CSS value="border-collapse:collapse"/></classStyle><classStyle name="lt"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-left-style:none;background-color:white;color:black;text-align:left;font-weight:bold;border-bottom:1.5pt solid black"/></classStyle><classStyle name="lc"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="lm"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="lh"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="lf"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="ih"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="if"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="is"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="oh"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="of"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="os"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle></classStyles><queries><query name="Report"><source><sqlQuery name="SQL1" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT 	CASE 	WHEN 	MAX(dwh_performance.vm_daily_performance_fact.maxOfAvgCpuUtilization) = 0
			THEN 	'0%'
			WHEN 	MAX(dwh_performance.vm_daily_performance_fact.maxOfAvgCpuUtilization) BETWEEN 0 AND 20
			THEN 	'1-20%'
			WHEN 	MAX(dwh_performance.vm_daily_performance_fact.maxOfAvgCpuUtilization) BETWEEN 20 AND 30
			THEN 	'21-30%'
			WHEN 	MAX(dwh_performance.vm_daily_performance_fact.maxOfAvgCpuUtilization) BETWEEN 30 AND 50
			THEN 	'31-50%'
	END 	AS 'CPU Utilization Range',
	dwh_inventory.hv_server.clusterName AS 'vCluster',
	dwh_inventory.host.name AS 'ESX Host',
	dwh_inventory.hv_virtual_machine.name AS 'Virtual Machine',
	dwh_inventory.hv_virtual_machine.processors AS 'vCPU',
	ROUND(dwh_inventory.hv_virtual_machine.provisionedCapacityMB/1024,2) AS 'Allocated (GB)',
	ROUND(dwh_inventory.hv_virtual_machine.usedCapacityMB/1024,2) AS 'Used (GB)',
	ROUND(MAX(dwh_performance.vm_daily_performance_fact.maxOfAvgCpuUtilization)/100,4) AS 'Peak CPU (%)'
FROM 	dwh_inventory.hv_server
JOIN 	dwh_inventory.host
ON 	dwh_inventory.hv_server.hostId = dwh_inventory.host.id
JOIN 	dwh_inventory.hv_virtual_machine
ON 	dwh_inventory.host.id = dwh_inventory.hv_virtual_machine.hostId
JOIN 	dwh_performance.vm_dimension
ON 	dwh_inventory.hv_virtual_machine.id = dwh_performance.vm_dimension.id
AND 	dwh_performance.vm_dimension.latest = 1
JOIN	dwh_performance.vm_daily_performance_fact
ON 	dwh_performance.vm_daily_performance_fact.vmTk = dwh_performance.vm_dimension.tk
AND 	dwh_performance.vm_dimension.latest = 1
JOIN 	dwh_performance.date_dimension
ON 	dwh_performance.vm_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
AND 	dwh_performance.date_dimension.fullDate &gt;= (	SELECT MAX(dwh_performance.date_dimension.fullDate) 
								FROM dwh_performance.vm_daily_performance_fact
								JOIN dwh_performance.date_dimension
								ON dwh_performance.vm_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
								) - INTERVAL 30 DAY
GROUP BY
	dwh_inventory.hv_server.clusterName,
	dwh_inventory.host.name,
	dwh_inventory.hv_virtual_machine.name
HAVING
	MAX(dwh_performance.vm_daily_performance_fact.maxOfAvgCpuUtilization) &lt;= 50</sqlText>
		<mdProjectedItems><mdProjectedItem name="CPU Utilization Range"/><mdProjectedItem name="vCluster"/><mdProjectedItem name="ESX Host"/><mdProjectedItem name="Virtual Machine"/><mdProjectedItem name="vCPU"/><mdProjectedItem name="Allocated (GB)"/><mdProjectedItem name="Used (GB)"/><mdProjectedItem name="Peak CPU (%)"/></mdProjectedItems></sqlQuery></source><selection><dataItem name="CPU Utilization Range"><expression>[SQL1].[CPU Utilization Range]</expression></dataItem><dataItem name="vCluster"><expression>[SQL1].[vCluster]</expression></dataItem><dataItem name="ESX Host"><expression>[SQL1].[ESX Host]</expression></dataItem><dataItem name="Virtual Machine"><expression>[SQL1].[Virtual Machine]</expression></dataItem><dataItem name="vCPU"><expression>[SQL1].[vCPU]</expression></dataItem><dataItem name="Allocated (GB)"><expression>[SQL1].[Allocated (GB)]</expression></dataItem><dataItem name="Used (GB)"><expression>[SQL1].[Used (GB)]</expression></dataItem><dataItem name="Peak CPU (%)"><expression>[SQL1].[Peak CPU (%)]</expression></dataItem><dataItemListSummary refDataItem="vCPU" aggregateMethod="total" name="Total(vCPU)"/><dataItemListSummary refDataItem="Allocated (GB)" aggregateMethod="total" name="Total(Allocated (GB))"/><dataItemListSummary refDataItem="Used (GB)" aggregateMethod="total" name="Total(Used (GB))"/></selection><detailFilters><detailFilter use="optional"><filterExpression>[CPU Utilization Range] =?All CPU Utilization Ranges?</filterExpression></detailFilter><detailFilter use="optional"><filterExpression>[vCluster] = ?All vClusters?</filterExpression></detailFilter></detailFilters></query><query name="Prompt"><source><sqlQuery name="SQL1" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT 	CASE 	WHEN 	MAX(dwh_performance.vm_daily_performance_fact.maxOfAvgCpuUtilization) = 0
			THEN 	'0%'
			WHEN 	MAX(dwh_performance.vm_daily_performance_fact.maxOfAvgCpuUtilization) BETWEEN 0 AND 20
			THEN 	'1-20%'
			WHEN 	MAX(dwh_performance.vm_daily_performance_fact.maxOfAvgCpuUtilization) BETWEEN 20 AND 30
			THEN 	'21-30%'
			WHEN 	MAX(dwh_performance.vm_daily_performance_fact.maxOfAvgCpuUtilization) BETWEEN 30 AND 50
			THEN 	'31-50%'
	END 	AS 'CPU Utilization Range',
	dwh_inventory.hv_server.clusterName AS 'vCluster',
	dwh_inventory.host.name AS 'ESX Host',
	dwh_inventory.hv_virtual_machine.name AS 'Virtual Machine',
	dwh_inventory.hv_virtual_machine.processors AS 'vCPU',
	ROUND(dwh_inventory.hv_virtual_machine.provisionedCapacityMB/1024,2) AS 'Allocated (GB)',
	ROUND(dwh_inventory.hv_virtual_machine.usedCapacityMB/1024,2) AS 'Used (GB)',
	ROUND(MAX(dwh_performance.vm_daily_performance_fact.maxOfAvgCpuUtilization)/100,4) AS 'Peak CPU (%)'
FROM 	dwh_inventory.hv_server
JOIN 	dwh_inventory.host
ON 	dwh_inventory.hv_server.hostId = dwh_inventory.host.id
JOIN 	dwh_inventory.hv_virtual_machine
ON 	dwh_inventory.host.id = dwh_inventory.hv_virtual_machine.hostId
JOIN 	dwh_performance.vm_dimension
ON 	dwh_inventory.hv_virtual_machine.id = dwh_performance.vm_dimension.id
AND 	dwh_performance.vm_dimension.latest = 1
JOIN	dwh_performance.vm_daily_performance_fact
ON 	dwh_performance.vm_daily_performance_fact.vmTk = dwh_performance.vm_dimension.tk
AND 	dwh_performance.vm_dimension.latest = 1
JOIN 	dwh_performance.date_dimension
ON 	dwh_performance.vm_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
AND 	dwh_performance.date_dimension.fullDate &gt;= (	SELECT MAX(dwh_performance.date_dimension.fullDate) 
								FROM dwh_performance.vm_daily_performance_fact
								JOIN dwh_performance.date_dimension
								ON dwh_performance.vm_daily_performance_fact.dateTk = dwh_performance.date_dimension.tk
								) - INTERVAL 30 DAY
GROUP BY
	dwh_inventory.hv_server.clusterName,
	dwh_inventory.host.name,
	dwh_inventory.hv_virtual_machine.name
HAVING
	MAX(dwh_performance.vm_daily_performance_fact.maxOfAvgCpuUtilization) &lt;= 50</sqlText>
		<mdProjectedItems><mdProjectedItem name="CPU Utilization Range"/><mdProjectedItem name="vCluster"/><mdProjectedItem name="ESX Host"/><mdProjectedItem name="Virtual Machine"/><mdProjectedItem name="vCPU"/><mdProjectedItem name="Allocated (GB)"/><mdProjectedItem name="Used (GB)"/><mdProjectedItem name="Peak CPU (%)"/></mdProjectedItems></sqlQuery></source><selection><dataItem name="CPU Utilization Range"><expression>[SQL1].[CPU Utilization Range]</expression></dataItem><dataItem name="vCluster"><expression>[SQL1].[vCluster]</expression></dataItem></selection></query></queries></report>