<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:1500px"/></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 Remediation</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:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Virtual Machine Count by State</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:12px;font-weight:bold"/></style></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><v2_combinationChart maxHotspots="10000" refQuery="VM Count by State" name="Combination Chart9">
													<v2_combinationTypeTooltips/>
													<v2_commonAxis>
														<v2_ordinalAxis>
															<v2_axisLabels>
																<style>
																	<defaultStyles>
																		<defaultStyle refStyle="al"/>
																	</defaultStyles>
																</style>
															</v2_axisLabels>
															<v2_axisLine lineColor="#E1E1E2" lineWeight="0" majorTickMarkLocation="none"/></v2_ordinalAxis>
														<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="State"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="VM Count" sortOrder="descending"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
													<v2_topLeftAxis>
														<v2_combinationChartTypes>
															<v2_bar borders="hide" borderColor="black">
																<!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;quot;/ -->
																<v2_solidPalette>
											<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#6198C5"><v2_solidColor transparency="20" color="#913C7A"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E5B09E"><v2_solidColor color="#A35DA4" transparency="25"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#A1A1AA"><v2_solidColor color="#9C72AB" transparency="50"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#9DBFE0">
														<v2_linearGradient gradientAngle="270">
															<v2_gradientColor gradientColor="#9DBFE0" colorPosition="0"/>
															<v2_gradientColor gradientColor="#6E869D" colorPosition="100"/>
														</v2_linearGradient>
													</v2_fillEffect>
												</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#C29ACC">
														<v2_linearGradient gradientAngle="270">
															<v2_gradientColor gradientColor="#C29ACC" colorPosition="0"/>
															<v2_gradientColor gradientColor="#886C8F" colorPosition="100"/>
														</v2_linearGradient>
													</v2_fillEffect>
												</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#80C1BB">
														<v2_linearGradient gradientAngle="270">
															<v2_gradientColor gradientColor="#80C1BB" colorPosition="0"/>
															<v2_gradientColor gradientColor="#5A8783" colorPosition="100"/>
														</v2_linearGradient>
													</v2_fillEffect>
												</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#C65F71">
														<v2_linearGradient gradientAngle="270">
															<v2_gradientColor gradientColor="#C65F71" colorPosition="0"/>
															<v2_gradientColor gradientColor="#8B424F" colorPosition="100"/>
														</v2_linearGradient>
													</v2_fillEffect>
												</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#ECC57C">
														<v2_linearGradient gradientAngle="270">
															<v2_gradientColor gradientColor="#ECC57C" colorPosition="0"/>
															<v2_gradientColor gradientColor="#A58A57" colorPosition="100"/>
														</v2_linearGradient>
													</v2_fillEffect>
												</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#A08689">
														<v2_linearGradient gradientAngle="270">
															<v2_gradientColor gradientColor="#A08689" colorPosition="0"/>
															<v2_gradientColor gradientColor="#705E60" colorPosition="100"/>
														</v2_linearGradient>
													</v2_fillEffect>
												</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#B6D994">
														<v2_linearGradient gradientAngle="270">
															<v2_gradientColor gradientColor="#B6D994" colorPosition="0"/>
															<v2_gradientColor gradientColor="#7F9868" colorPosition="100"/>
														</v2_linearGradient>
													</v2_fillEffect>
												</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" leaderLines="hide" labelValueType="absolute"/><v2_conditionalSolidPalette><v2_advancedCondition><v2_conditionalCases><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#1E4A93" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[VM Count by State].[State] = 'Powered Off'</reportCondition></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#0077BF" transparency="30"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[VM Count by State].[State] = 'Suspended'</reportCondition></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#5AC0ED" transparency="40"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[VM Count by State].[State] = 'Powered On'</reportCondition></v2_conditionalCase></v2_conditionalCases></v2_advancedCondition><v2_advancedCondition><v2_conditionalCases><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#913C7A" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[VM Count by State].[State] = 'Powered Off'</reportCondition></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#A34DA4" transparency="30"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[VM Count by State].[State] = 'Suspended'</reportCondition></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#9C72AB" transparency="40"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[VM Count by State].[State] = 'Powered On'</reportCondition></v2_conditionalCase></v2_conditionalCases></v2_advancedCondition></v2_conditionalSolidPalette></v2_bar>
														</v2_combinationChartTypes>
														<v2_axis>
															<v2_axisRange>
																<v2_automaticRange/>
															</v2_axisRange>
															<v2_axisLabels>
																<style>
																	<defaultStyles>
																		<defaultStyle refStyle="al"/>
																	</defaultStyles>
																</style>
															</v2_axisLabels>
															<v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/></v2_axis>
													</v2_topLeftAxis>
													<style>
														<CSS value="width:740px;height:125px;font-family:Arial"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
													<noDataHandler>
														<contents>
															<block>
																<contents>
																	<textItem>
																		<dataSource>
																			<staticValue>No Data Available</staticValue>
																		</dataSource>
																		<style>
																			<CSS value="padding:10px 18px;"/>
																		</style>
																	</textItem>
																</contents>
															</block>
														</contents>
													</noDataHandler>
													<v2_defaultChartMeasure refDataItem="VM Count"/></v2_combinationChart>
					</contents><style><CSS value="text-align:center"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="border:1px solid #E1E1E2"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered Off Virtual Machines (Trending)</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:12px;font-weight:bold"/></style></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><v2_combinationChart maxHotspots="10000" name="Combination Chart1" refQuery="Powered-Off VM Trending">
																										<v2_combinationTypeTooltips/>
																										<v2_commonAxis>
																											<v2_ordinalAxis>
																												<v2_axisLabels>
																													<style>
																														<defaultStyles>
																															<defaultStyle refStyle="al"/>
																														</defaultStyles>
																													</style>
																												</v2_axisLabels>
																												<v2_axisLine lineColor="#E1E1E2" lineWeight="0" majorTickMarkLocation="none"/>
																											</v2_ordinalAxis>
																											<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Date"/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="dateFormat"/></sortList><style><dataFormat><dateFormat showMonths="shortName" showYears="true"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																										<v2_topLeftAxis>
																											<v2_combinationChartTypes>
																												<v2_area seriesType="stacked" lineAreaShape="smooth">
																													<v2_solidPalette>
																														<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E5B09E"><v2_solidColor color="#1E4A93" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#6198C5"><v2_solidColor color="#913C7A" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#A1A1AA">
																																	<v2_linearGradient gradientAngle="270">
																																		<v2_gradientColor gradientColor="#A1A1AA" colorPosition="0"/>
																																		<v2_gradientColor gradientColor="#717177" colorPosition="100"/>
																																	</v2_linearGradient>
																																</v2_fillEffect>
																															</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#9DBFE0">
																																	<v2_linearGradient gradientAngle="270">
																																		<v2_gradientColor gradientColor="#9DBFE0" colorPosition="0"/>
																																		<v2_gradientColor gradientColor="#6E869D" colorPosition="100"/>
																																	</v2_linearGradient>
																																</v2_fillEffect>
																															</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#C29ACC">
																																	<v2_linearGradient gradientAngle="270">
																																		<v2_gradientColor gradientColor="#C29ACC" colorPosition="0"/>
																																		<v2_gradientColor gradientColor="#886C8F" colorPosition="100"/>
																																	</v2_linearGradient>
																																</v2_fillEffect>
																															</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#80C1BB">
																																	<v2_linearGradient gradientAngle="270">
																																		<v2_gradientColor gradientColor="#80C1BB" colorPosition="0"/>
																																		<v2_gradientColor gradientColor="#5A8783" colorPosition="100"/>
																																	</v2_linearGradient>
																																</v2_fillEffect>
																															</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#C65F71">
																																	<v2_linearGradient gradientAngle="270">
																																		<v2_gradientColor gradientColor="#C65F71" colorPosition="0"/>
																																		<v2_gradientColor gradientColor="#8B424F" colorPosition="100"/>
																																	</v2_linearGradient>
																																</v2_fillEffect>
																															</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#ECC57C">
																																	<v2_linearGradient gradientAngle="270">
																																		<v2_gradientColor gradientColor="#ECC57C" colorPosition="0"/>
																																		<v2_gradientColor gradientColor="#A58A57" colorPosition="100"/>
																																	</v2_linearGradient>
																																</v2_fillEffect>
																															</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#A08689">
																																	<v2_linearGradient gradientAngle="270">
																																		<v2_gradientColor gradientColor="#A08689" colorPosition="0"/>
																																		<v2_gradientColor gradientColor="#705E60" colorPosition="100"/>
																																	</v2_linearGradient>
																																</v2_fillEffect>
																															</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#B6D994">
																																	<v2_linearGradient gradientAngle="270">
																																		<v2_gradientColor gradientColor="#B6D994" colorPosition="0"/>
																																		<v2_gradientColor gradientColor="#7F9868" colorPosition="100"/>
																																	</v2_linearGradient>
																																</v2_fillEffect>
																															</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
																													<!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;quot;/ -->
																													</v2_area>
																											</v2_combinationChartTypes>
																											<v2_axis>
																												<v2_axisRange>
																													<v2_automaticRange/>
																												</v2_axisRange>
																												<v2_axisLabels>
																													<style>
																														<defaultStyles>
																															<defaultStyle refStyle="al"/>
																														</defaultStyles>
																													</style>
																												</v2_axisLabels>
																												<v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/>
																											</v2_axis>
																										</v2_topLeftAxis>
																										<style>
																											<CSS value="width:740px;height:125px;font-family:Arial"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																										<noDataHandler>
																											<contents>
																												<block>
																													<contents>
																														<textItem>
																															<dataSource>
																																<staticValue>No Data Available</staticValue>
																															</dataSource>
																															<style>
																																<CSS value="padding:10px 18px;"/>
																															</style>
																														</textItem>
																													</contents>
																												</block>
																											</contents>
																										</noDataHandler>
																										<v2_defaultChartMeasure refDataItem="Used Capacity (TB)"><style><dataFormat><numberFormat pattern="###,###,###.## TB"/></dataFormat></style></v2_defaultChartMeasure></v2_combinationChart>
																								</contents><style><CSS value="text-align:center"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="border:1px solid #E1E1E2"/></style></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><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered Off Since (VM Count)</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:12px;font-weight:bold"/></style></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><v2_combinationChart maxHotspots="10000" refQuery="Powered-Off VM by Date Range" name="Combination Chart5">
													<v2_combinationTypeTooltips/>
													<v2_commonAxis>
														<v2_ordinalAxis>
															<v2_axisLabels>
																<style>
																	<defaultStyles>
																		<defaultStyle refStyle="al"/>
																	</defaultStyles>
																</style>
															</v2_axisLabels>
															<v2_axisLine lineColor="#E1E1E2" lineWeight="0" majorTickMarkLocation="none"/></v2_ordinalAxis>
														<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Days since Powered Off"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="poweredOffRange"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
													<v2_topLeftAxis>
														<v2_combinationChartTypes>
															<v2_bar borders="hide" borderColor="black">
																<!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;quot;/ -->
																<v2_solidPalette>
											<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#6198C5"><v2_solidColor color="#6198C5" transparency="30"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E5B09E">
														<v2_linearGradient gradientAngle="270">
															<v2_gradientColor gradientColor="#E5B09E" colorPosition="0"/>
															<v2_gradientColor gradientColor="#A07B6F" colorPosition="100"/>
														</v2_linearGradient>
													</v2_fillEffect>
												</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#A1A1AA">
														<v2_linearGradient gradientAngle="270">
															<v2_gradientColor gradientColor="#A1A1AA" colorPosition="0"/>
															<v2_gradientColor gradientColor="#717177" colorPosition="100"/>
														</v2_linearGradient>
													</v2_fillEffect>
												</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#9DBFE0">
														<v2_linearGradient gradientAngle="270">
															<v2_gradientColor gradientColor="#9DBFE0" colorPosition="0"/>
															<v2_gradientColor gradientColor="#6E869D" colorPosition="100"/>
														</v2_linearGradient>
													</v2_fillEffect>
												</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#C29ACC">
														<v2_linearGradient gradientAngle="270">
															<v2_gradientColor gradientColor="#C29ACC" colorPosition="0"/>
															<v2_gradientColor gradientColor="#886C8F" colorPosition="100"/>
														</v2_linearGradient>
													</v2_fillEffect>
												</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#80C1BB">
														<v2_linearGradient gradientAngle="270">
															<v2_gradientColor gradientColor="#80C1BB" colorPosition="0"/>
															<v2_gradientColor gradientColor="#5A8783" colorPosition="100"/>
														</v2_linearGradient>
													</v2_fillEffect>
												</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#C65F71">
														<v2_linearGradient gradientAngle="270">
															<v2_gradientColor gradientColor="#C65F71" colorPosition="0"/>
															<v2_gradientColor gradientColor="#8B424F" colorPosition="100"/>
														</v2_linearGradient>
													</v2_fillEffect>
												</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#ECC57C">
														<v2_linearGradient gradientAngle="270">
															<v2_gradientColor gradientColor="#ECC57C" colorPosition="0"/>
															<v2_gradientColor gradientColor="#A58A57" colorPosition="100"/>
														</v2_linearGradient>
													</v2_fillEffect>
												</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#A08689">
														<v2_linearGradient gradientAngle="270">
															<v2_gradientColor gradientColor="#A08689" colorPosition="0"/>
															<v2_gradientColor gradientColor="#705E60" colorPosition="100"/>
														</v2_linearGradient>
													</v2_fillEffect>
												</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#B6D994">
														<v2_linearGradient gradientAngle="270">
															<v2_gradientColor gradientColor="#B6D994" colorPosition="0"/>
															<v2_gradientColor gradientColor="#7F9868" colorPosition="100"/>
														</v2_linearGradient>
													</v2_fillEffect>
												</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Powered Off VMs"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat pattern="###,###,### VMs"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes><v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" leaderLines="hide" labelValueType="absolute"/><v2_conditionalSolidPalette><v2_advancedCondition><v2_conditionalCases><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#1E4A93" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[Powered-Off VM by Date Range].[Days since Powered Off] IN ('181-365 Days', '365+ Days')</reportCondition></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#0077BF" transparency="30"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[Powered-Off VM by Date Range].[Days since Powered Off] IN ('91-120 Days', '121-180 Days')</reportCondition></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#5AC0ED" transparency="40"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[Powered-Off VM by Date Range].[Days since Powered Off] IN ('&lt;=60 Days', '61-90 Days')</reportCondition></v2_conditionalCase></v2_conditionalCases></v2_advancedCondition><v2_advancedCondition><v2_conditionalCases><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><reportCondition>[Powered-Off VM by Date Range].[Days since Powered Off] IN ('181-365 Days', '365+ Days')</reportCondition><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#913C7A" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><reportCondition>[Powered-Off VM by Date Range].[Days since Powered Off] IN ('91-120 Days', '121-180 Days')</reportCondition><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#A35DA4" transparency="25"/></v2_fillEffect></v2_solidPaletteEntry></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><reportCondition>[Powered-Off VM by Date Range].[Days since Powered Off] IN ('&lt;=60 Days', '61-90 Days')
</reportCondition><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#9C72AB" transparency="50"/></v2_fillEffect></v2_solidPaletteEntry></v2_conditionalCase></v2_conditionalCases></v2_advancedCondition></v2_conditionalSolidPalette></v2_bar>
														</v2_combinationChartTypes>
														<v2_axis>
															<v2_axisRange>
																<v2_automaticRange/>
															</v2_axisRange>
															<v2_axisLabels>
																<style>
																	<defaultStyles>
																		<defaultStyle refStyle="al"/>
																	</defaultStyles>
																</style>
															</v2_axisLabels>
															<v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/></v2_axis>
													</v2_topLeftAxis>
													<style>
														<CSS value="width:740px;height:125px;font-family:Arial"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
													<noDataHandler>
														<contents>
															<block>
																<contents>
																	<textItem>
																		<dataSource>
																			<staticValue>No Data Available</staticValue>
																		</dataSource>
																		<style>
																			<CSS value="padding:10px 18px;"/>
																		</style>
																	</textItem>
																</contents>
															</block>
														</contents>
													</noDataHandler>
													</v2_combinationChart>
					</contents><style><CSS value="text-align:center"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="border:1px solid #E1E1E2"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered Off Since (Used Capacity)</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:12px;font-weight:bold"/></style></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents>
					<v2_combinationChart maxHotspots="10000" refQuery="Powered-Off VM by Date Range" name="Combination Chart7">
													<v2_combinationTypeTooltips/>
													<v2_commonAxis>
														<v2_ordinalAxis>
															<v2_axisLabels>
																<style>
																	<defaultStyles>
																		<defaultStyle refStyle="al"/>
																	</defaultStyles>
																</style>
															</v2_axisLabels>
															<v2_axisLine lineColor="#E1E1E2" lineWeight="0" majorTickMarkLocation="none"/></v2_ordinalAxis>
														<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Days since Powered Off"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="poweredOffRange"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
													<v2_topLeftAxis>
														<v2_combinationChartTypes>
															<v2_bar borders="hide" borderColor="black">
																<!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;quot;/ -->
																<v2_solidPalette>
											<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#6198C5"><v2_solidColor color="#6198C5" transparency="30"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E5B09E">
														<v2_linearGradient gradientAngle="270">
															<v2_gradientColor gradientColor="#E5B09E" colorPosition="0"/>
															<v2_gradientColor gradientColor="#A07B6F" colorPosition="100"/>
														</v2_linearGradient>
													</v2_fillEffect>
												</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#A1A1AA">
														<v2_linearGradient gradientAngle="270">
															<v2_gradientColor gradientColor="#A1A1AA" colorPosition="0"/>
															<v2_gradientColor gradientColor="#717177" colorPosition="100"/>
														</v2_linearGradient>
													</v2_fillEffect>
												</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#9DBFE0">
														<v2_linearGradient gradientAngle="270">
															<v2_gradientColor gradientColor="#9DBFE0" colorPosition="0"/>
															<v2_gradientColor gradientColor="#6E869D" colorPosition="100"/>
														</v2_linearGradient>
													</v2_fillEffect>
												</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#C29ACC">
														<v2_linearGradient gradientAngle="270">
															<v2_gradientColor gradientColor="#C29ACC" colorPosition="0"/>
															<v2_gradientColor gradientColor="#886C8F" colorPosition="100"/>
														</v2_linearGradient>
													</v2_fillEffect>
												</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#80C1BB">
														<v2_linearGradient gradientAngle="270">
															<v2_gradientColor gradientColor="#80C1BB" colorPosition="0"/>
															<v2_gradientColor gradientColor="#5A8783" colorPosition="100"/>
														</v2_linearGradient>
													</v2_fillEffect>
												</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#C65F71">
														<v2_linearGradient gradientAngle="270">
															<v2_gradientColor gradientColor="#C65F71" colorPosition="0"/>
															<v2_gradientColor gradientColor="#8B424F" colorPosition="100"/>
														</v2_linearGradient>
													</v2_fillEffect>
												</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#ECC57C">
														<v2_linearGradient gradientAngle="270">
															<v2_gradientColor gradientColor="#ECC57C" colorPosition="0"/>
															<v2_gradientColor gradientColor="#A58A57" colorPosition="100"/>
														</v2_linearGradient>
													</v2_fillEffect>
												</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#A08689">
														<v2_linearGradient gradientAngle="270">
															<v2_gradientColor gradientColor="#A08689" colorPosition="0"/>
															<v2_gradientColor gradientColor="#705E60" colorPosition="100"/>
														</v2_linearGradient>
													</v2_fillEffect>
												</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#B6D994">
														<v2_linearGradient gradientAngle="270">
															<v2_gradientColor gradientColor="#B6D994" colorPosition="0"/>
															<v2_gradientColor gradientColor="#7F9868" colorPosition="100"/>
														</v2_linearGradient>
													</v2_fillEffect>
												</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" leaderLines="hide" labelValueType="absolute"/><v2_conditionalSolidPalette><v2_advancedCondition><v2_conditionalCases><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#1E4A93" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[Powered-Off VM by Date Range].[Days since Powered Off] IN ('181-365 Days', '365+ Days')</reportCondition></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#0077BF" transparency="30"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[Powered-Off VM by Date Range].[Days since Powered Off] IN ('91-120 Days', '121-180 Days')</reportCondition></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#5AC0ED" transparency="40"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[Powered-Off VM by Date Range].[Days since Powered Off] IN ('&lt;=60 Days', '61-90 Days')</reportCondition></v2_conditionalCase></v2_conditionalCases></v2_advancedCondition><v2_advancedCondition><v2_conditionalCases><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><reportCondition>[Powered-Off VM by Date Range].[Days since Powered Off] IN ('181-365 Days', '365+ Days')</reportCondition><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#913C7A" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><reportCondition>[Powered-Off VM by Date Range].[Days since Powered Off] IN ('91-120 Days', '121-180 Days')</reportCondition><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#A35DA4" transparency="25"/></v2_fillEffect></v2_solidPaletteEntry></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><reportCondition>[Powered-Off VM by Date Range].[Days since Powered Off] IN ('&lt;=60 Days', '61-90 Days')
</reportCondition><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#9C72AB" transparency="50"/></v2_fillEffect></v2_solidPaletteEntry></v2_conditionalCase></v2_conditionalCases></v2_advancedCondition></v2_conditionalSolidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Used Capacity (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat pattern="###,###,###.## TB"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
														</v2_combinationChartTypes>
														<v2_axis>
															<v2_axisRange>
																<v2_automaticRange/>
															</v2_axisRange>
															<v2_axisLabels>
																<style>
																	<defaultStyles>
																		<defaultStyle refStyle="al"/>
																	</defaultStyles>
																</style>
															</v2_axisLabels>
															<v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/></v2_axis>
													</v2_topLeftAxis>
													<style>
														<CSS value="width:740px;height:125px;font-family:Arial"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
													<noDataHandler>
														<contents>
															<block>
																<contents>
																	<textItem>
																		<dataSource>
																			<staticValue>No Data Available</staticValue>
																		</dataSource>
																		<style>
																			<CSS value="padding:10px 18px;"/>
																		</style>
																	</textItem>
																</contents>
															</block>
														</contents>
													</noDataHandler>
													</v2_combinationChart></contents><style><CSS value="text-align:center"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="border:1px solid #E1E1E2"/></style></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><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>CPU Utilization Distribution (Peak up to 50%/30 Days)</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:12px;font-weight:bold"/></style></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents>
					<v2_combinationChart maxHotspots="10000" refQuery="CPU Range" name="Combination Chart12">
													<v2_combinationTypeTooltips/>
													<v2_commonAxis>
														<v2_ordinalAxis>
															<v2_axisLabels>
																<style>
																	<defaultStyles>
																		<defaultStyle refStyle="al"/>
																	</defaultStyles>
																</style>
															</v2_axisLabels>
															<v2_axisLine lineColor="#E1E1E2" lineWeight="0" majorTickMarkLocation="none"/></v2_ordinalAxis>
														<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="CPU Utilization Range"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Ranking"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
													<v2_topLeftAxis>
														<v2_combinationChartTypes>
															<v2_bar borders="hide" borderColor="black">
																<!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;quot;/ -->
																<v2_solidPalette>
											<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#A1A1AA"><v2_solidColor transparency="40" color="#6198C5"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E5B09E"><v2_solidColor color="#6198C5" transparency="0"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#6198C5"><v2_solidColor transparency="0" color="#1E4A93"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor transparency="40" color="#9C72AB"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor transparency="20" color="#A35DA4"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor transparency="0" color="#913C7A"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#971D31" transparency="60"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#971D31" transparency="40"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#971D31" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#990000" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#990000"/></v2_fillEffect></v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" leaderLines="hide" labelValueType="absolute"/><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Count of VMs"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat pattern="###,###,### VMs"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes><v2_conditionalSolidPalette><v2_advancedCondition><v2_conditionalCases><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#5AC0ED" transparency="40"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[CPU Range].[CPU Utilization Range] = '31-50%'</reportCondition></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#0077BF" transparency="30"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[CPU Range].[CPU Utilization Range] = '21-30%'</reportCondition></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#1E4A93" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[CPU Range].[CPU Utilization Range] = '1-20%'</reportCondition></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#1E4A93" transparency="10"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[CPU Range].[CPU Utilization Range] = '0%'</reportCondition></v2_conditionalCase></v2_conditionalCases></v2_advancedCondition><v2_advancedCondition><v2_conditionalCases><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#9C72AB" transparency="40"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[CPU Range].[CPU Utilization Range] = '31-50%'</reportCondition></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#A35DA4" transparency="30"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[CPU Range].[CPU Utilization Range] = '21-30%'</reportCondition></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#913C7A" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[CPU Range].[CPU Utilization Range] = '1-20%'</reportCondition></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#913C7A" transparency="10"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[CPU Range].[CPU Utilization Range] = '0%'</reportCondition></v2_conditionalCase></v2_conditionalCases></v2_advancedCondition></v2_conditionalSolidPalette></v2_bar>
														</v2_combinationChartTypes>
														<v2_axis>
															<v2_axisRange>
																<v2_automaticRange/>
															</v2_axisRange>
															<v2_axisLabels>
																<style>
																	<defaultStyles>
																		<defaultStyle refStyle="al"/>
																	</defaultStyles>
																</style>
															</v2_axisLabels>
															<v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/></v2_axis>
													</v2_topLeftAxis>
													<style>
														<CSS value="width:740px;height:125px;font-family:Arial"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
													<noDataHandler>
														<contents>
															<block>
																<contents>
																	<textItem>
																		<dataSource>
																			<staticValue>No Data Available</staticValue>
																		</dataSource>
																		<style>
																			<CSS value="padding:10px 18px;"/>
																		</style>
																	</textItem>
																</contents>
															</block>
														</contents>
													</noDataHandler>
													</v2_combinationChart></contents><style><CSS value="text-align:center"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="border:1px solid #E1E1E2"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Memory Utilization Distribution (Peak up to 50%/30 Days)</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:12px;font-weight:bold"/></style></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents>
					<v2_combinationChart maxHotspots="10000" refQuery="Memory Range" name="Combination Chart13">
													<v2_combinationTypeTooltips/>
													<v2_commonAxis>
														<v2_ordinalAxis>
															<v2_axisLabels>
																<style>
																	<defaultStyles>
																		<defaultStyle refStyle="al"/>
																	</defaultStyles>
																</style>
															</v2_axisLabels>
															<v2_axisLine lineColor="#E1E1E2" lineWeight="0" majorTickMarkLocation="none"/></v2_ordinalAxis>
														<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Memory Utilization Range"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Ranking"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
													<v2_topLeftAxis>
														<v2_combinationChartTypes>
															<v2_bar borders="hide" borderColor="black">
																<!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;quot;/ -->
																<v2_solidPalette>
											<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#A1A1AA"><v2_solidColor transparency="40" color="#6198C5"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E5B09E"><v2_solidColor color="#6198C5" transparency="0"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#6198C5"><v2_solidColor transparency="0" color="#1E4A93"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor transparency="40" color="#9C72AB"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor transparency="20" color="#A35DA4"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor transparency="0" color="#913C7A"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#971D31" transparency="60"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#971D31" transparency="40"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#971D31" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#990000" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#990000"/></v2_fillEffect></v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" leaderLines="hide" labelValueType="absolute"/><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Count of VMs"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat pattern="###,###,### VMs"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes><v2_conditionalSolidPalette><v2_advancedCondition><v2_conditionalCases><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#5AC0ED" transparency="40"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[Memory Range].[Memory Utilization Range] = '31-50%'</reportCondition></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#0077BF" transparency="30"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[Memory Range].[Memory Utilization Range] = '21-30%'</reportCondition></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#1E4A93" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[Memory Range].[Memory Utilization Range] = '1-20%'</reportCondition></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#1E4A93" transparency="10"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[Memory Range].[Memory Utilization Range] = '0%'</reportCondition></v2_conditionalCase></v2_conditionalCases></v2_advancedCondition><v2_advancedCondition><v2_conditionalCases><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#9C72AB" transparency="40"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[Memory Range].[Memory Utilization Range] = '31-50%'</reportCondition></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#A35DA4" transparency="30"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[Memory Range].[Memory Utilization Range] = '21-30%'</reportCondition></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#913C7A" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[Memory Range].[Memory Utilization Range] = '1-20%'</reportCondition></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#913C7A" transparency="10"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[Memory Range].[Memory Utilization Range] = '0%'</reportCondition></v2_conditionalCase></v2_conditionalCases></v2_advancedCondition></v2_conditionalSolidPalette></v2_bar>
														</v2_combinationChartTypes>
														<v2_axis>
															<v2_axisRange>
																<v2_automaticRange/>
															</v2_axisRange>
															<v2_axisLabels>
																<style>
																	<defaultStyles>
																		<defaultStyle refStyle="al"/>
																	</defaultStyles>
																</style>
															</v2_axisLabels>
															<v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/></v2_axis>
													</v2_topLeftAxis>
													<style>
														<CSS value="width:740px;height:125px;font-family:Arial"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
													<noDataHandler>
														<contents>
															<block>
																<contents>
																	<textItem>
																		<dataSource>
																			<staticValue>No Data Available</staticValue>
																		</dataSource>
																		<style>
																			<CSS value="padding:10px 18px;"/>
																		</style>
																	</textItem>
																</contents>
															</block>
														</contents>
													</noDataHandler>
													</v2_combinationChart></contents><style><CSS value="text-align:center"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="border:1px solid #E1E1E2"/></style></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><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>IOPS vs Latency Trending</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:12px;font-weight:bold"/></style></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><v2_combinationChart maxHotspots="10000" name="Combination Chart3" refQuery="VM Performance Trending">
																										<v2_combinationTypeTooltips/>
																										<v2_commonAxis>
																											<v2_ordinalAxis>
																												<v2_axisLabels>
																													<style>
																														<defaultStyles>
																															<defaultStyle refStyle="al"/>
																														</defaultStyles>
																													</style>
																												</v2_axisLabels>
																												<v2_axisLine lineColor="#E1E1E2" lineWeight="0" majorTickMarkLocation="none"/>
																											</v2_ordinalAxis>
																											<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Date"/></dataSource></chartTextItem></chartContents><style><dataFormat><dateFormat showYears="false" pattern="MM/dd"/></dataFormat></style></chartNodeMember></chartNodeMembers><chartNestedNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Time"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNestedNodes></chartNode></chartNodes></v2_commonAxis>
																										<v2_topLeftAxis>
																											<v2_combinationChartTypes>
																												<v2_area seriesType="stacked" lineAreaShape="smooth">
																													<v2_solidPalette>
																														<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E5B09E"><v2_solidColor color="#1E4A93" transparency="50"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#6198C5"><v2_solidColor color="#913C7A" transparency="50"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#A1A1AA">
																																	<v2_linearGradient gradientAngle="270">
																																		<v2_gradientColor gradientColor="#A1A1AA" colorPosition="0"/>
																																		<v2_gradientColor gradientColor="#717177" colorPosition="100"/>
																																	</v2_linearGradient>
																																</v2_fillEffect>
																															</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#9DBFE0">
																																	<v2_linearGradient gradientAngle="270">
																																		<v2_gradientColor gradientColor="#9DBFE0" colorPosition="0"/>
																																		<v2_gradientColor gradientColor="#6E869D" colorPosition="100"/>
																																	</v2_linearGradient>
																																</v2_fillEffect>
																															</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#C29ACC">
																																	<v2_linearGradient gradientAngle="270">
																																		<v2_gradientColor gradientColor="#C29ACC" colorPosition="0"/>
																																		<v2_gradientColor gradientColor="#886C8F" colorPosition="100"/>
																																	</v2_linearGradient>
																																</v2_fillEffect>
																															</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#80C1BB">
																																	<v2_linearGradient gradientAngle="270">
																																		<v2_gradientColor gradientColor="#80C1BB" colorPosition="0"/>
																																		<v2_gradientColor gradientColor="#5A8783" colorPosition="100"/>
																																	</v2_linearGradient>
																																</v2_fillEffect>
																															</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#C65F71">
																																	<v2_linearGradient gradientAngle="270">
																																		<v2_gradientColor gradientColor="#C65F71" colorPosition="0"/>
																																		<v2_gradientColor gradientColor="#8B424F" colorPosition="100"/>
																																	</v2_linearGradient>
																																</v2_fillEffect>
																															</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#ECC57C">
																																	<v2_linearGradient gradientAngle="270">
																																		<v2_gradientColor gradientColor="#ECC57C" colorPosition="0"/>
																																		<v2_gradientColor gradientColor="#A58A57" colorPosition="100"/>
																																	</v2_linearGradient>
																																</v2_fillEffect>
																															</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#A08689">
																																	<v2_linearGradient gradientAngle="270">
																																		<v2_gradientColor gradientColor="#A08689" colorPosition="0"/>
																																		<v2_gradientColor gradientColor="#705E60" colorPosition="100"/>
																																	</v2_linearGradient>
																																</v2_fillEffect>
																															</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#B6D994">
																																	<v2_linearGradient gradientAngle="270">
																																		<v2_gradientColor gradientColor="#B6D994" colorPosition="0"/>
																																		<v2_gradientColor gradientColor="#7F9868" colorPosition="100"/>
																																	</v2_linearGradient>
																																</v2_fillEffect>
																															</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
																													<!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;quot;/ -->
																													<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Average IOPS"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat pattern="###,###,### IOPS"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_area>
																											</v2_combinationChartTypes>
																											<v2_axis>
																												<v2_axisRange>
																													<v2_automaticRange/>
																												</v2_axisRange>
																												<v2_axisLabels>
																													<style>
																														<defaultStyles>
																															<defaultStyle refStyle="al"/>
																														</defaultStyles>
																													</style>
																												</v2_axisLabels>
																												<v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/>
																											</v2_axis>
																										</v2_topLeftAxis>
																										<style>
																											<CSS value="width:740px;height:125px;font-family:Arial"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																										<noDataHandler>
																											<contents>
																												<block>
																													<contents>
																														<textItem>
																															<dataSource>
																																<staticValue>No Data Available</staticValue>
																															</dataSource>
																															<style>
																																<CSS value="padding:10px 18px;"/>
																															</style>
																														</textItem>
																													</contents>
																												</block>
																											</contents>
																										</noDataHandler>
																										<v2_topRightAxis><v2_axis>
																												<v2_axisRange>
																													<v2_automaticRange/>
																												</v2_axisRange>
																												<v2_axisLabels>
																													<style>
																														<defaultStyles>
																															<defaultStyle refStyle="al"/>
																														</defaultStyles>
																													</style>
																												</v2_axisLabels>
																												<v2_majorGridlines lineColor="#E1E1E2" lineWeight="0" lineStyle="dash"/>
																											</v2_axis>
																											<v2_combinationChartTypes><v2_area borderColor="black" lineAreaShape="smooth" seriesType="stacked"><v2_solidPalette>
																														<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#1E4A93" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#913C7A" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry>
																																<v2_fillEffect defaultColor="#839862">
																																	<v2_linearGradient gradientAngle="0">
																																		<v2_gradientColor colorPosition="0" gradientColor="#839862"/>
																																		<v2_gradientColor colorPosition="100" gradientColor="#6C7F56"/>
																																	</v2_linearGradient>
																																</v2_fillEffect>
																															</v2_solidPaletteEntry><v2_solidPaletteEntry>
																																<v2_fillEffect defaultColor="#B7C873">
																																	<v2_linearGradient gradientAngle="0">
																																		<v2_gradientColor colorPosition="0" gradientColor="#B7C873"/>
																																		<v2_gradientColor colorPosition="100" gradientColor="#AFB885"/>
																																	</v2_linearGradient>
																																</v2_fillEffect>
																															</v2_solidPaletteEntry><v2_solidPaletteEntry>
																																<v2_fillEffect defaultColor="#8484A8">
																																	<v2_linearGradient gradientAngle="0">
																																		<v2_gradientColor colorPosition="0" gradientColor="#8484A8"/>
																																		<v2_gradientColor colorPosition="100" gradientColor="#525E7E"/>
																																	</v2_linearGradient>
																																</v2_fillEffect>
																															</v2_solidPaletteEntry><v2_solidPaletteEntry>
																																<v2_fillEffect defaultColor="#C0CCED">
																																	<v2_linearGradient gradientAngle="0">
																																		<v2_gradientColor colorPosition="0" gradientColor="#C0CCED"/>
																																		<v2_gradientColor colorPosition="100" gradientColor="#B0C2E5"/>
																																	</v2_linearGradient>
																																</v2_fillEffect>
																															</v2_solidPaletteEntry><v2_solidPaletteEntry>
																																<v2_fillEffect defaultColor="#8C5580">
																																	<v2_linearGradient gradientAngle="0">
																																		<v2_gradientColor colorPosition="0" gradientColor="#8C5580"/>
																																		<v2_gradientColor colorPosition="100" gradientColor="#794067"/>
																																	</v2_linearGradient>
																																</v2_fillEffect>
																															</v2_solidPaletteEntry><v2_solidPaletteEntry>
																																<v2_fillEffect defaultColor="#C789BC">
																																	<v2_linearGradient gradientAngle="0">
																																		<v2_gradientColor colorPosition="0" gradientColor="#C789BC"/>
																																		<v2_gradientColor colorPosition="100" gradientColor="#BB72BC"/>
																																	</v2_linearGradient>
																																</v2_fillEffect>
																															</v2_solidPaletteEntry><v2_solidPaletteEntry>
																																<v2_fillEffect defaultColor="#D5BAEF">
																																	<v2_linearGradient gradientAngle="0">
																																		<v2_gradientColor colorPosition="0" gradientColor="#D5BAEF"/>
																																		<v2_gradientColor colorPosition="100" gradientColor="#C29FD1"/>
																																	</v2_linearGradient>
																																</v2_fillEffect>
																															</v2_solidPaletteEntry><v2_solidPaletteEntry>
																																<v2_fillEffect defaultColor="#83683F">
																																	<v2_linearGradient gradientAngle="0">
																																		<v2_gradientColor colorPosition="0" gradientColor="#83683F"/>
																																		<v2_gradientColor colorPosition="100" gradientColor="#604926"/>
																																	</v2_linearGradient>
																																</v2_fillEffect>
																															</v2_solidPaletteEntry><v2_solidPaletteEntry>
																																<v2_fillEffect defaultColor="#DCB05A">
																																	<v2_linearGradient gradientAngle="0">
																																		<v2_gradientColor colorPosition="0" gradientColor="#DCB05A"/>
																																		<v2_gradientColor colorPosition="100" gradientColor="#C09C52"/>
																																	</v2_linearGradient>
																																</v2_fillEffect>
																															</v2_solidPaletteEntry><v2_solidPaletteEntry>
																																<v2_fillEffect defaultColor="#F4DF9E">
																																	<v2_linearGradient gradientAngle="0">
																																		<v2_gradientColor colorPosition="0" gradientColor="#F4DF9E"/>
																																		<v2_gradientColor colorPosition="100" gradientColor="#E4CF87"/>
																																	</v2_linearGradient>
																																</v2_fillEffect>
																															</v2_solidPaletteEntry><v2_solidPaletteEntry>
																																<v2_fillEffect defaultColor="#5F8A8C">
																																	<v2_linearGradient gradientAngle="0">
																																		<v2_gradientColor colorPosition="0" gradientColor="#5F8A8C"/>
																																		<v2_gradientColor colorPosition="100" gradientColor="#537579"/>
																																	</v2_linearGradient>
																																</v2_fillEffect>
																															</v2_solidPaletteEntry><v2_solidPaletteEntry>
																																<v2_fillEffect defaultColor="#96C4B2">
																																	<v2_linearGradient gradientAngle="0">
																																		<v2_gradientColor colorPosition="0" gradientColor="#96C4B2"/>
																																		<v2_gradientColor colorPosition="100" gradientColor="#89B0A0"/>
																																	</v2_linearGradient>
																																</v2_fillEffect>
																															</v2_solidPaletteEntry><v2_solidPaletteEntry>
																																<v2_fillEffect defaultColor="#CBE8E7">
																																	<v2_linearGradient gradientAngle="0">
																																		<v2_gradientColor colorPosition="0" gradientColor="#CBE8E7"/>
																																		<v2_gradientColor colorPosition="100" gradientColor="#BDD6D5"/>
																																	</v2_linearGradient>
																																</v2_fillEffect>
																															</v2_solidPaletteEntry><v2_solidPaletteEntry>
																																<v2_fillEffect defaultColor="#AE6564">
																																	<v2_linearGradient gradientAngle="0">
																																		<v2_gradientColor colorPosition="0" gradientColor="#AE6564"/>
																																		<v2_gradientColor colorPosition="100" gradientColor="#875352"/>
																																	</v2_linearGradient>
																																</v2_fillEffect>
																															</v2_solidPaletteEntry><v2_solidPaletteEntry>
																																<v2_fillEffect defaultColor="#D88C6F">
																																	<v2_linearGradient gradientAngle="0">
																																		<v2_gradientColor colorPosition="0" gradientColor="#D88C6F"/>
																																		<v2_gradientColor colorPosition="100" gradientColor="#C47D61"/>
																																	</v2_linearGradient>
																																</v2_fillEffect>
																															</v2_solidPaletteEntry><v2_solidPaletteEntry>
																																<v2_fillEffect defaultColor="#E3C9B0">
																																	<v2_linearGradient gradientAngle="0">
																																		<v2_gradientColor colorPosition="0" gradientColor="#E3C9B0"/>
																																		<v2_gradientColor colorPosition="100" gradientColor="#D2B2A5"/>
																																	</v2_linearGradient>
																																</v2_fillEffect>
																															</v2_solidPaletteEntry><v2_solidPaletteEntry>
																																<v2_fillEffect defaultColor="#848484">
																																	<v2_linearGradient gradientAngle="0">
																																		<v2_gradientColor colorPosition="0" gradientColor="#848484"/>
																																		<v2_gradientColor colorPosition="100" gradientColor="#555555"/>
																																	</v2_linearGradient>
																																</v2_fillEffect>
																															</v2_solidPaletteEntry><v2_solidPaletteEntry>
																																<v2_fillEffect defaultColor="#a4a4a4">
																																	<v2_linearGradient gradientAngle="0">
																																		<v2_gradientColor colorPosition="0" gradientColor="#a4a4a4"/>
																																		<v2_gradientColor colorPosition="100" gradientColor="#909090"/>
																																	</v2_linearGradient>
																																</v2_fillEffect>
																															</v2_solidPaletteEntry><v2_solidPaletteEntry>
																																<v2_fillEffect defaultColor="#C7C7C7">
																																	<v2_linearGradient gradientAngle="0">
																																		<v2_gradientColor colorPosition="0" gradientColor="#C7C7C7"/>
																																		<v2_gradientColor colorPosition="100" gradientColor="#c1c1c1"/>
																																	</v2_linearGradient>
																																</v2_fillEffect>
																															</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
																													<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Average Latency"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat pattern="###,###,###.#ms"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_area></v2_combinationChartTypes></v2_topRightAxis><XMLAttributes><XMLAttribute name="titlesExpanded" value="true" output="no"/></XMLAttributes><v2_legend><style><defaultStyles><defaultStyle refStyle="lg"/></defaultStyles></style><v2_legendTitle refQuery="VM Performance Trending"><v2_chartTextContents><v2_automaticText/></v2_chartTextContents><style><defaultStyles><defaultStyle refStyle="lx"/></defaultStyles></style></v2_legendTitle><v2_legendPosition><v2_legendPreset legendPositionPreset="bottom"/></v2_legendPosition></v2_legend></v2_combinationChart>
																								</contents><style><CSS value="text-align:center"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="border:1px solid #E1E1E2"/></style></tableCell><tableCell><contents/><style><CSS value="width:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Average IOPS vs Average Latency by Virtual Machine (30 Days)</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:12px;font-weight:bold"/></style></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><v2_bubbleChart maxHotspots="10000" changeShapeByCategory="false" refQuery="VM Performance Stats" name="Combination Chart11">
																										<v2_basicTooltips/>
																										<v2_bubbleSizing>
																											<v2_bubbleMinMax minBubbleSize="8px" maxBubbleSize="12px"/></v2_bubbleSizing>
																										<v2_yAxis>
																											<v2_axisRange>
																												<v2_automaticRange/>
																											</v2_axisRange>
																											<v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/>
																											<v2_axisLabels>
																												<style>
																													<defaultStyles>
																														<defaultStyle refStyle="al"/>
																													</defaultStyles>
																												</style>
																											</v2_axisLabels>
																											<v2_chartMeasure refDataItem="Average IOPS"><style><dataFormat><numberFormat pattern="###,###,### IOPS"/></dataFormat></style></v2_chartMeasure></v2_yAxis>
																										<v2_xAxis>
																											<v2_axisRange>
																												<v2_automaticRange/>
																											</v2_axisRange>
																											
																											<v2_axisLabels>
																												<style>
																													<defaultStyles>
																														<defaultStyle refStyle="al"/>
																													</defaultStyles>
																												</style>
																											</v2_axisLabels>
																											<v2_chartMeasure refDataItem="Average Latency"><style><dataFormat><numberFormat pattern="###,###,###.#ms"/></dataFormat></style></v2_chartMeasure><v2_axisLine lineColor="#E1E1E2" lineWeight="0"/><v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/></v2_xAxis>
																										<style>
																											<CSS value="width:740px;height:125px;font-family:Arial"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																										<noDataHandler>
																											<contents>
																												<block>
																													<contents>
																														<textItem>
																															<dataSource>
																																<staticValue>No Data Available</staticValue>
																															</dataSource>
																															<style>
																																<CSS value="padding:10px 18px;"/>
																															</style>
																														</textItem>
																													</contents>
																												</block>
																											</contents>
																										</noDataHandler>
																										<v2_pointPalette markerBorders="hide">
																											<v2_pointPaletteEntries><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#6198C5"><v2_solidColor transparency="20" color="#913C7A"/></v2_fillEffect></v2_pointPaletteEntry><v2_pointPaletteEntry><v2_fillEffect defaultColor="#E5B09E"><v2_solidColor color="#A35DA4" transparency="25"/></v2_fillEffect></v2_pointPaletteEntry><v2_pointPaletteEntry><v2_fillEffect defaultColor="#A1A1AA"><v2_solidColor color="#9C72AB" transparency="50"/></v2_fillEffect></v2_pointPaletteEntry><v2_pointPaletteEntry><v2_fillEffect defaultColor="#9DBFE0">
														<v2_linearGradient gradientAngle="270">
															<v2_gradientColor gradientColor="#9DBFE0" colorPosition="0"/>
															<v2_gradientColor gradientColor="#6E869D" colorPosition="100"/>
														</v2_linearGradient>
													</v2_fillEffect></v2_pointPaletteEntry><v2_pointPaletteEntry><v2_fillEffect defaultColor="#C29ACC">
														<v2_linearGradient gradientAngle="270">
															<v2_gradientColor gradientColor="#C29ACC" colorPosition="0"/>
															<v2_gradientColor gradientColor="#886C8F" colorPosition="100"/>
														</v2_linearGradient>
													</v2_fillEffect></v2_pointPaletteEntry><v2_pointPaletteEntry><v2_fillEffect defaultColor="#80C1BB">
														<v2_linearGradient gradientAngle="270">
															<v2_gradientColor gradientColor="#80C1BB" colorPosition="0"/>
															<v2_gradientColor gradientColor="#5A8783" colorPosition="100"/>
														</v2_linearGradient>
													</v2_fillEffect></v2_pointPaletteEntry><v2_pointPaletteEntry><v2_fillEffect defaultColor="#C65F71">
														<v2_linearGradient gradientAngle="270">
															<v2_gradientColor gradientColor="#C65F71" colorPosition="0"/>
															<v2_gradientColor gradientColor="#8B424F" colorPosition="100"/>
														</v2_linearGradient>
													</v2_fillEffect></v2_pointPaletteEntry><v2_pointPaletteEntry><v2_fillEffect defaultColor="#ECC57C">
														<v2_linearGradient gradientAngle="270">
															<v2_gradientColor gradientColor="#ECC57C" colorPosition="0"/>
															<v2_gradientColor gradientColor="#A58A57" colorPosition="100"/>
														</v2_linearGradient>
													</v2_fillEffect></v2_pointPaletteEntry><v2_pointPaletteEntry><v2_fillEffect defaultColor="#A08689">
														<v2_linearGradient gradientAngle="270">
															<v2_gradientColor gradientColor="#A08689" colorPosition="0"/>
															<v2_gradientColor gradientColor="#705E60" colorPosition="100"/>
														</v2_linearGradient>
													</v2_fillEffect></v2_pointPaletteEntry><v2_pointPaletteEntry><v2_fillEffect defaultColor="#B6D994">
														<v2_linearGradient gradientAngle="270">
															<v2_gradientColor gradientColor="#B6D994" colorPosition="0"/>
															<v2_gradientColor gradientColor="#7F9868" colorPosition="100"/>
														</v2_linearGradient>
													</v2_fillEffect></v2_pointPaletteEntry></v2_pointPaletteEntries></v2_pointPalette>
																										<!-- v2_pointPaletteRef ref=&amp;amp;amp;amp;amp;amp;quot;gDefaultMarker&amp;amp;amp;amp;amp;amp;quot;/ -->
																										<v2_category><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Virtual Machine"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_category><v2_bubbleMeasure refDataItem="Average IOPS"/><XMLAttributes><XMLAttribute name="titlesExpanded" value="true" output="no"/></XMLAttributes><v2_conditionalPointPalette><v2_advancedPointCondition><v2_pointCases><v2_pointCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><reportCondition>[VM Performance Stats].[Average Latency] &gt; 75</reportCondition><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor transparency="20" color="#CF2128"/></v2_fillEffect></v2_pointPaletteEntry></v2_pointCase><v2_pointCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><reportCondition>[VM Performance Stats].[Average Latency] BETWEEN 21 AND 75</reportCondition><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#1E4A93" transparency="20"/></v2_fillEffect></v2_pointPaletteEntry></v2_pointCase><v2_pointCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><reportCondition>[VM Performance Stats].[Average Latency] &lt;= 20</reportCondition><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor transparency="50" color="#6198C5"/></v2_fillEffect></v2_pointPaletteEntry></v2_pointCase></v2_pointCases></v2_advancedPointCondition></v2_conditionalPointPalette></v2_bubbleChart>
					</contents><style><CSS value="text-align:center"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="border:1px solid #E1E1E2"/></style></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><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>IOPS Distribution (Peak/30 Days)</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:12px;font-weight:bold"/></style></textItem></contents><style><CSS value="padding-top:5px;padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents>
					<v2_combinationChart maxHotspots="10000" refQuery="IOPS Range" name="Combination Chart14">
													<v2_combinationTypeTooltips/>
													<v2_commonAxis>
														<v2_ordinalAxis>
															<v2_axisLabels>
																<style>
																	<defaultStyles>
																		<defaultStyle refStyle="al"/>
																	</defaultStyles>
																</style>
															</v2_axisLabels>
															<v2_axisLine lineColor="#E1E1E2" lineWeight="0" majorTickMarkLocation="none"/></v2_ordinalAxis>
														<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="IOPS Range"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="Ranking"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
													<v2_topLeftAxis>
														<v2_combinationChartTypes>
															<v2_bar borders="hide" borderColor="black">
																<!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;quot;/ -->
																<v2_solidPalette>
											<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#A1A1AA"><v2_solidColor transparency="40" color="#6198C5"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E5B09E"><v2_solidColor color="#6198C5" transparency="0"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#6198C5"><v2_solidColor transparency="0" color="#1E4A93"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor transparency="40" color="#9C72AB"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor transparency="20" color="#A35DA4"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor transparency="0" color="#913C7A"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#971D31" transparency="60"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#971D31" transparency="40"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#971D31" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#990000" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#990000"/></v2_fillEffect></v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" leaderLines="hide" labelValueType="absolute"/><v2_conditionalSolidPalette><v2_advancedCondition><v2_conditionalCases><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#AA342C" transparency="10"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[IOPS Range].[IOPS Range] = '1000+'</reportCondition></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#5AC0ED" transparency="30"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[IOPS Range].[IOPS Range] = '501-1000'</reportCondition></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor transparency="30" color="#5AC0ED"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[IOPS Range].[IOPS Range] = '101-500'</reportCondition></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#5AC0ED" transparency="30"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[IOPS Range].[IOPS Range] = '1-100'</reportCondition></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#1E4A93" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[IOPS Range].[IOPS Range] = '0'</reportCondition></v2_conditionalCase></v2_conditionalCases></v2_advancedCondition><v2_advancedCondition><v2_conditionalCases><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><reportCondition>[IOPS Range].[IOPS Range] = '1000+'</reportCondition><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor transparency="20" color="#AA342C"/></v2_fillEffect></v2_solidPaletteEntry></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><reportCondition>[IOPS Range].[IOPS Range] = '501-1000'</reportCondition><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor transparency="40" color="#A35DA4"/></v2_fillEffect></v2_solidPaletteEntry></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><reportCondition>[IOPS Range].[IOPS Range] = '101-500'</reportCondition><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor transparency="40" color="#A35DA4"/></v2_fillEffect></v2_solidPaletteEntry></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><reportCondition>[IOPS Range].[IOPS Range] = '1-100'</reportCondition><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#A35DA4" transparency="40"/></v2_fillEffect></v2_solidPaletteEntry></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><reportCondition>[IOPS Range].[IOPS Range] = '0'</reportCondition><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#1E4A93" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry></v2_conditionalCase></v2_conditionalCases></v2_advancedCondition></v2_conditionalSolidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Used (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat pattern="###,###,###.## TB"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
														</v2_combinationChartTypes>
														<v2_axis>
															<v2_axisRange>
																<v2_automaticRange/>
															</v2_axisRange>
															<v2_axisLabels>
																<style>
																	<defaultStyles>
																		<defaultStyle refStyle="al"/>
																	</defaultStyles>
																</style>
															</v2_axisLabels>
															<v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/></v2_axis>
													</v2_topLeftAxis>
													<style>
														<CSS value="width:1490px;height:125px;font-family:Arial"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
													<noDataHandler>
														<contents>
															<block>
																<contents>
																	<textItem>
																		<dataSource>
																			<staticValue>No Data Available</staticValue>
																		</dataSource>
																		<style>
																			<CSS value="padding:10px 18px;"/>
																		</style>
																	</textItem>
																</contents>
															</block>
														</contents>
													</noDataHandler>
													</v2_combinationChart></contents><style><CSS value="text-align:center"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="border:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table></contents>
								</pageBody>
							</page>
						</reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" value="true" output="no"/><XMLAttribute name="listSeparator" value="," output="no"/><XMLAttribute name="RS_modelModificationTime" value="2016-01-14T14:24:37.854Z" output="no"/></XMLAttributes><queries><query name="Powered-Off VM Trending">
			<source>
				
			<sqlQuery name="SQL1" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT 	DATE_FORMAT(dwh_inventory.hv_virtual_machine.powerStateChangeTime, '%m/%Y') AS 'Date',
	DATE_FORMAT(dwh_inventory.hv_virtual_machine.powerStateChangeTime, '%Y/%m') AS dateFormat,
	ROUND(SUM(dwh_inventory.hv_virtual_machine.usedCapacityMB)/1024/1024, 2) as 'Used Capacity (TB)' 
FROM 	dwh_inventory.hv_virtual_machine
WHERE 	dwh_inventory.hv_virtual_machine.powerState = 'poweredOff'
AND 	DATE(dwh_inventory.hv_virtual_machine.powerStateChangeTime) IS NOT NULL 
GROUP BY 
	DATE_FORMAT(dwh_inventory.hv_virtual_machine.powerStateChangeTime, '%Y/%m')</sqlText>
		<mdProjectedItems><mdProjectedItem name="Date"/><mdProjectedItem name="dateFormat"/><mdProjectedItem name="Used Capacity (TB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Date"><expression>[SQL1].[Date]</expression></dataItem><dataItem name="dateFormat"><expression>[SQL1].[dateFormat]</expression></dataItem><dataItem name="Used Capacity (TB)" aggregate="total"><expression>[SQL1].[Used Capacity (TB)]</expression></dataItem></selection>
		</query><query name="Powered-Off VM by Date Range">
			<source>
				
			<sqlQuery name="SQL2" dataSource="dwh_inventory" type="passThrough">
			<sqlText>
SELECT  IF(x.days &lt;= 60, '&lt;=60 Days',
	IF(x.days &lt;= 90, '61-90 Days',
	IF(x.days &lt;= 120, '91-120 Days',
	IF(x.days &lt;= 180, '121-180 Days',
	IF(x.days &lt;= 365, '181-365 Days',
	'365+ Days'))))) AS 'Days since Powered Off',
	IF(x.days &lt;= 60, 0,
	IF(x.days &lt;= 90, 1,
	IF(x.days &lt;= 120, 2,
	IF(x.days &lt;= 180, 3,
	IF(x.days &lt;= 365, 4,
	5))))) AS poweredOffRange,
	SUM(x.vmCount) AS 'Powered Off VMs',
	ROUND(SUM(x.usedMB)/1024/1024,2) AS 'Used Capacity (TB)',
	SUM(x.memoryGB) AS 'Memory (GB)',
	SUM(x.vCPU) AS 'vCPU Count'
FROM 	(
	SELECT 	DATE(dwh_inventory.hv_virtual_machine.powerStateChangeTime) AS fullDate,
		DATEDIFF(CURDATE(), DATE(dwh_inventory.hv_virtual_machine.powerStateChangeTime)) AS days,
		COUNT(DISTINCT dwh_inventory.hv_virtual_machine.id) vmCount,
		SUM(dwh_inventory.hv_virtual_machine.usedCapacityMB) usedMB,
		ROUND(SUM(dwh_inventory.hv_virtual_machine.memory)/1024,0) AS memoryGB,
		SUM(dwh_inventory.hv_virtual_machine.processors) AS vCPU
	FROM 	dwh_inventory.hv_virtual_machine
	WHERE 	dwh_inventory.hv_virtual_machine.powerState = 'poweredOff'
	AND 	DATE(dwh_inventory.hv_virtual_machine.powerStateChangeTime) IS NOT NULL 
	GROUP BY 
		fullDate
	) X
GROUP BY
	poweredOffRange</sqlText>
		<mdProjectedItems><mdProjectedItem name="Days since Powered Off"/><mdProjectedItem name="poweredOffRange"/><mdProjectedItem name="Powered Off VMs"/><mdProjectedItem name="Used Capacity (TB)"/><mdProjectedItem name="Memory (GB)"/><mdProjectedItem name="vCPU Count"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Days since Powered Off"><expression>[SQL2].[Days since Powered Off]</expression></dataItem><dataItem name="poweredOffRange"><expression>[SQL2].[poweredOffRange]</expression></dataItem><dataItem name="Powered Off VMs" aggregate="total"><expression>[SQL2].[Powered Off VMs]</expression></dataItem><dataItem name="Used Capacity (TB)" aggregate="total"><expression>[SQL2].[Used Capacity (TB)]</expression></dataItem><dataItem name="Memory (GB)" aggregate="total"><expression>[SQL2].[Memory (GB)]</expression></dataItem><dataItem name="vCPU Count" aggregate="total"><expression>[SQL2].[vCPU Count]</expression></dataItem></selection>
		</query><query name="VM Count by State">
			<source>
				
			<sqlQuery name="SQL3" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT 	CASE 	WHEN 	dwh_inventory.hv_virtual_machine.powerState = 'poweredOff'
		THEN 	'Powered Off'
		WHEN 	dwh_inventory.hv_virtual_machine.powerState = 'poweredOn'
		AND 	dwh_inventory.hv_virtual_machine.guestState = 'notRunning'
		THEN 	'Suspended'
		ELSE 	'Powered On'
	END 	AS State,
	COUNT(*) AS 'VM Count'
FROM 	dwh_inventory.hv_virtual_machine
GROUP BY
	State</sqlText>
		<mdProjectedItems><mdProjectedItem name="State"/><mdProjectedItem name="VM Count"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="State"><expression>[SQL3].[State]</expression></dataItem><dataItem name="VM Count" aggregate="total"><expression>[SQL3].[VM Count]</expression></dataItem></selection>
		</query><query name="VM Performance Trending">
			<source>
				
			<sqlQuery name="SQL4" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT 	dwh_performance.date_dimension.fullDate AS 'Date',
	dwh_performance.time_dimension.hourDateTime AS 'Time',
	ROUND(AVG(dwh_performance.vm_hourly_performance_fact.totalIops),0) AS 'Average IOPS',
	ROUND(AVG(dwh_performance.vm_hourly_performance_fact.totalThroughput),0) AS 'Average Throughput',
	CEIL(AVG(dwh_performance.vm_hourly_performance_fact.totalResponseTime)) AS 'Average Latency',
	ROUND(AVG(dwh_performance.vm_hourly_performance_fact.cpuUtilization)/100,4) AS 'Average CPU (%)',
	ROUND(AVG(dwh_performance.vm_hourly_performance_fact.memoryUtilization)/100,4) AS 'Average Memory (%)'
FROM 	dwh_performance.vm_hourly_performance_fact
JOIN 	dwh_performance.date_dimension
ON 	dwh_performance.vm_hourly_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_hourly_performance_fact
							JOIN dwh_performance.date_dimension
							ON dwh_performance.vm_hourly_performance_fact.dateTk = dwh_performance.date_dimension.tk
							) - INTERVAL 7 DAY
JOIN 	dwh_performance.time_dimension
ON 	dwh_performance.vm_hourly_performance_fact.timeTk = dwh_performance.time_dimension.tk
GROUP BY
	dwh_performance.date_dimension.fullDate,
	dwh_performance.time_dimension.hourDateTime
</sqlText>
		<mdProjectedItems><mdProjectedItem name="Date"/><mdProjectedItem name="Time"/><mdProjectedItem name="Average IOPS"/><mdProjectedItem name="Average Throughput"/><mdProjectedItem name="Average Latency"/><mdProjectedItem name="Average CPU (%)"/><mdProjectedItem name="Average Memory (%)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Date"><expression>[SQL4].[Date]</expression></dataItem><dataItem name="Time" aggregate="none" rollupAggregate="none"><expression>[SQL4].[Time]</expression></dataItem><dataItem name="Average IOPS" aggregate="average"><expression>[SQL4].[Average IOPS]</expression></dataItem><dataItem name="Average Throughput"><expression>[SQL4].[Average Throughput]</expression></dataItem><dataItem name="Average Latency" aggregate="average"><expression>[SQL4].[Average Latency]</expression></dataItem></selection>
		</query><query name="VM Performance Stats">
			<source>
				
			<sqlQuery name="SQL5" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT 	dwh_performance.vm_dimension.name AS 'Virtual Machine',
	ROUND(AVG(dwh_performance.vm_daily_performance_fact.totalIops),0) AS 'Average IOPS',
	ROUND(MAX(dwh_performance.vm_daily_performance_fact.totalThroughputMax),0) AS 'Average Throughput',
	ROUND(AVG(dwh_performance.vm_daily_performance_fact.totalResponseTime), 0) AS 'Average Latency',
	ROUND(AVG(dwh_performance.vm_daily_performance_fact.cpuUtilization)/100,4) AS 'Average CPU (%)',
	ROUND(AVG(dwh_performance.vm_daily_performance_fact.memoryUtilization)/100,4) AS 'Average Memory (%)'
FROM 	dwh_performance.vm_daily_performance_fact
JOIN 	dwh_performance.vm_dimension
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_performance.vm_dimension.id</sqlText>
		<mdProjectedItems><mdProjectedItem name="Virtual Machine"/><mdProjectedItem name="Average IOPS"/><mdProjectedItem name="Average Throughput"/><mdProjectedItem name="Average Latency"/><mdProjectedItem name="Average CPU (%)"/><mdProjectedItem name="Average Memory (%)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Virtual Machine"><expression>[SQL5].[Virtual Machine]</expression></dataItem><dataItem name="Average IOPS" aggregate="average"><expression>[SQL5].[Average IOPS]</expression></dataItem><dataItem name="Average Throughput"><expression>[SQL5].[Average Throughput]</expression></dataItem><dataItem name="Average Latency" aggregate="average"><expression>[SQL5].[Average Latency]</expression></dataItem><dataItem name="Average CPU (%)"><expression>[SQL5].[Average CPU (%)]</expression></dataItem><dataItem name="Average Memory (%)"><expression>[SQL5].[Average Memory (%)]</expression></dataItem></selection>
		</query><query name="IOPS Range">
			<source>
				
			<sqlQuery name="SQL6" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT 	x.iopsRange AS 'IOPS Range',
	COUNT(DISTINCT x.vmId) AS 'Count of VMs',
	ROUND(SUM(x.usedGB)/1024, 2) AS 'Used (TB)',
	x.ranking AS 'Ranking'
FROM 	(
	SELECT 	dwh_performance.vm_dimension.id vmId,
		dwh_performance.vm_dimension.name AS vm,
		CASE 	WHEN 	MAX(dwh_performance.vm_daily_performance_fact.totalIopsMax) = 0
			THEN 	'0'
			WHEN 	MAX(dwh_performance.vm_daily_performance_fact.totalIopsMax) BETWEEN 0 AND 100
			THEN 	'1-100'
			WHEN 	MAX(dwh_performance.vm_daily_performance_fact.totalIopsMax) BETWEEN 100 AND 500
			THEN 	'101-500'
			WHEN 	MAX(dwh_performance.vm_daily_performance_fact.totalIopsMax) BETWEEN 500 AND 1000
			THEN 	'501-1000'
		ELSE 	'1000+'
		END 	AS iopsRange,
		CASE 	WHEN 	MAX(dwh_performance.vm_daily_performance_fact.totalIopsMax) = 0
			THEN 	0
			WHEN 	MAX(dwh_performance.vm_daily_performance_fact.totalIopsMax) BETWEEN 0 AND 100
			THEN 	1
			WHEN 	MAX(dwh_performance.vm_daily_performance_fact.totalIopsMax) BETWEEN 100 AND 500
			THEN 	2
			WHEN 	MAX(dwh_performance.vm_daily_performance_fact.totalIopsMax) BETWEEN 500 AND 1000
			THEN 	3
		ELSE 	4
		END 	AS ranking,
		MAX(dwh_performance.vm_daily_performance_fact.totalIopsMax) AS peakIops,
		dwh_inventory.hv_virtual_machine.usedCapacityMB/1024 AS usedGB
	FROM 	dwh_performance.vm_daily_performance_fact
	JOIN 	dwh_performance.vm_dimension
	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
	JOIN 	dwh_inventory.hv_virtual_machine
	ON 	dwh_performance.vm_dimension.id = dwh_inventory.hv_virtual_machine.id
	AND 	dwh_performance.vm_dimension.latest = 1
	GROUP BY
		dwh_performance.vm_dimension.id
	HAVING
		MAX(dwh_performance.vm_daily_performance_fact.totalIopsMax) IS NOT NULL
	) X
GROUP BY
	x.iopsRange
ORDER BY
	x.ranking</sqlText>
		<mdProjectedItems><mdProjectedItem name="IOPS Range"/><mdProjectedItem name="Count of VMs"/><mdProjectedItem name="Used (TB)"/><mdProjectedItem name="Ranking"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="IOPS Range"><expression>[SQL6].[IOPS Range]</expression></dataItem><dataItem name="Used (TB)" aggregate="total"><expression>[SQL6].[Used (TB)]</expression></dataItem><dataItem name="Ranking"><expression>[SQL6].[Ranking]</expression></dataItem></selection>
		</query><query name="CPU Range">
			<source>
				
			<sqlQuery name="SQL8" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT 	x.cpuRange AS 'CPU Utilization Range',
	COUNT(DISTINCT x.vmId) AS 'Count of VMs',
	x.ranking AS 'Ranking'
FROM 	(
	SELECT 	dwh_performance.vm_dimension.id vmId,
		dwh_performance.vm_dimension.name AS vm,
		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 cpuRange,
		CASE 	WHEN 	MAX(dwh_performance.vm_daily_performance_fact.maxOfAvgCpuUtilization) = 0
			THEN 	0
			WHEN 	MAX(dwh_performance.vm_daily_performance_fact.maxOfAvgCpuUtilization) BETWEEN 1 AND 20
			THEN 	1
			WHEN 	MAX(dwh_performance.vm_daily_performance_fact.maxOfAvgCpuUtilization) BETWEEN 20 AND 30
			THEN 	2
			WHEN 	MAX(dwh_performance.vm_daily_performance_fact.maxOfAvgCpuUtilization) BETWEEN 30 AND 50
			THEN 	3
		END 	AS ranking,
		MAX(dwh_performance.vm_daily_performance_fact.totalIopsMax) AS peakIops
	FROM 	dwh_performance.vm_daily_performance_fact
	JOIN 	dwh_performance.vm_dimension
	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_performance.vm_dimension.id
	HAVING
		MAX(dwh_performance.vm_daily_performance_fact.maxOfAvgCpuUtilization) &lt;= 50
	AND
		cpuRange IS NOT NULL 
	) X
GROUP BY
	x.cpuRange
ORDER BY
	x.ranking</sqlText>
		<mdProjectedItems><mdProjectedItem name="CPU Utilization Range"/><mdProjectedItem name="Count of VMs"/><mdProjectedItem name="Ranking"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="CPU Utilization Range"><expression>[SQL8].[CPU Utilization Range]</expression></dataItem><dataItem name="Count of VMs" aggregate="total"><expression>[SQL8].[Count of VMs]</expression></dataItem><dataItem name="Ranking"><expression>[SQL8].[Ranking]</expression></dataItem></selection>
		</query><query name="Memory Range">
			<source>
				
			<sqlQuery name="SQL9" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT 	x.memoryRange AS 'Memory Utilization Range',
	COUNT(DISTINCT x.vmId) AS 'Count of VMs',
	x.ranking AS 'Ranking'
FROM 	(
	SELECT 	dwh_performance.vm_dimension.id vmId,
		dwh_performance.vm_dimension.name AS vm,
		CASE 	WHEN 	MAX(dwh_performance.vm_daily_performance_fact.maxOfAvgMemoryUtilization) = 0
			THEN 	'0%'
			WHEN 	MAX(dwh_performance.vm_daily_performance_fact.maxOfAvgMemoryUtilization) BETWEEN 0 AND 20
			THEN 	'1-20%'
			WHEN 	MAX(dwh_performance.vm_daily_performance_fact.maxOfAvgMemoryUtilization) BETWEEN 20 AND 30
			THEN 	'21-30%'
			WHEN 	MAX(dwh_performance.vm_daily_performance_fact.maxOfAvgMemoryUtilization) BETWEEN 30 AND 50
			THEN 	'31-50%'
		END 	AS memoryRange,
		CASE 	WHEN 	MAX(dwh_performance.vm_daily_performance_fact.maxOfAvgMemoryUtilization) = 0
			THEN 	0
			WHEN 	MAX(dwh_performance.vm_daily_performance_fact.maxOfAvgMemoryUtilization) BETWEEN 1 AND 20
			THEN 	1
			WHEN 	MAX(dwh_performance.vm_daily_performance_fact.maxOfAvgMemoryUtilization) BETWEEN 20 AND 30
			THEN 	2
			WHEN 	MAX(dwh_performance.vm_daily_performance_fact.maxOfAvgMemoryUtilization) BETWEEN 30 AND 50
			THEN 	3
		END 	AS ranking,
		MAX(dwh_performance.vm_daily_performance_fact.totalIopsMax) AS peakIops
	FROM 	dwh_performance.vm_daily_performance_fact
	JOIN 	dwh_performance.vm_dimension
	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_performance.vm_dimension.id
	HAVING
		MAX(dwh_performance.vm_daily_performance_fact.maxOfAvgMemoryUtilization) &lt;= 50
	AND
		memoryRange IS NOT NULL 
	) X
GROUP BY
	x.memoryRange
ORDER BY
	x.ranking</sqlText>
		<mdProjectedItems><mdProjectedItem name="Memory Utilization Range"/><mdProjectedItem name="Count of VMs"/><mdProjectedItem name="Ranking"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Memory Utilization Range"><expression>[SQL9].[Memory Utilization Range]</expression></dataItem><dataItem name="Count of VMs" aggregate="total"><expression>[SQL9].[Count of VMs]</expression></dataItem><dataItem name="Ranking"><expression>[SQL9].[Ranking]</expression></dataItem></selection>
		</query></queries><reportName>VM Infrastructure Remediation</reportName></report>