<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/>
				<layouts>
					<layout>
						<reportPages>
							<page name="Page1">
								<style>
									<defaultStyles>
										<defaultStyle refStyle="pg"/>
									</defaultStyles>
								<CSS value="width:1500px;height:900px"/></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>Fibre Channel Port 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:10px"/></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>Affected LUN Count by SAN Path Violation</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="LUN Count/Capacity by Violation" 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>
														</v2_commonAxis>
													<v2_topLeftAxis>
														<v2_combinationChartTypes>
															<v2_bar borderColor="white" borders="show">
																<!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;/ -->
																<v2_solidPalette>
											<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#6198C5"><v2_solidColor transparency="20" color="#FCE8D2"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#A1A1AA"><v2_solidColor color="#F8BE78" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#80C1BB"><v2_solidColor color="#F29507" transparency="10"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#ECC57C"><v2_solidColor transparency="20" color="#D74F13"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#A08689"><v2_solidColor color="#BF1717" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#B6D994"><v2_solidColor color="#9C0606" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><v2_chartDataLabels labelCollisionMode="fine_stagger"/><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Violation Type"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></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:725px;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="Affected LUN Count"/><v2_legend><style><defaultStyles><defaultStyle refStyle="lg"/></defaultStyles></style><v2_legendPosition><v2_legendPreset/></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>Affected Capacity (TB) by SAN Path Violation</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="LUN Count/Capacity by Violation" name="Combination Chart15">
													<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>
														</v2_commonAxis>
													<v2_topLeftAxis>
														<v2_combinationChartTypes>
															<v2_bar borders="show" borderColor="white">
																<!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;/ -->
																<v2_solidPalette>
											<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#6198C5"><v2_solidColor transparency="20" color="#FCE8D2"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#A1A1AA"><v2_solidColor color="#F8BE78" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#80C1BB"><v2_solidColor color="#F29507" transparency="10"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#ECC57C"><v2_solidColor transparency="20" color="#D74F13"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#A08689"><v2_solidColor color="#BF1717" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#B6D994"><v2_solidColor color="#9C0606" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><v2_chartDataLabels labelCollisionMode="fine_stagger"/><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Violation Type"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></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:725px;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="Affected Capacity (TB)"/><v2_legend><style><defaultStyles><defaultStyle refStyle="lg"/></defaultStyles></style><v2_legendPosition><v2_legendPreset/></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></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>SAN Path Violation Since (Affected LUN 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="Violation Ranges" 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="Violation Age Range"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="violationRange"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
													<v2_topLeftAxis>
														<v2_combinationChartTypes>
															<v2_bar borderColor="white">
																<!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;/ -->
																<v2_solidPalette>
											<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#6198C5"><v2_solidColor transparency="20" color="#FCE8D2"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E5B09E"><v2_solidColor color="#FAD3A5" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#A1A1AA"><v2_solidColor color="#F8BE78" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#9DBFE0"><v2_solidColor color="#F6A74B" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#80C1BB"><v2_solidColor color="#F29507" transparency="10"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#C65F71"><v2_solidColor color="#E76016" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#ECC57C"><v2_solidColor transparency="20" color="#D74F13"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#A08689"><v2_solidColor color="#BF1717" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#B6D994"><v2_solidColor color="#9C0606" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><v2_chartDataLabels labelCollisionMode="fine_stagger"/><v2_conditionalSolidPalette><v2_advancedCondition><v2_conditionalCases><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#9C0606" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[Violation Ranges].[Violation Age Range] = '365+ Days'</reportCondition></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#BF1717" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[Violation Ranges].[Violation Age Range] = '180-365 Days'</reportCondition></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#D74F13" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[Violation Ranges].[Violation Age Range] = '120-180 Days'</reportCondition></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#F4931F" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[Violation Ranges].[Violation Age Range] = '90-120 Days'</reportCondition></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><reportCondition>[Violation Ranges].[Violation Age Range] = '60-90 Days'</reportCondition><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#F8BE78" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><reportCondition>[Violation Ranges].[Violation Age Range] = '&lt;=60 Days'</reportCondition><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#FCE9D2" transparency="20"/></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:725px;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="Affected LUN 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>SAN Path Violation Since (Affected Capacity (TB))</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="Violation Ranges" name="Combination Chart6">
													<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="Violation Age Range"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="violationRange"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
													<v2_topLeftAxis>
														<v2_combinationChartTypes>
															<v2_bar borderColor="white">
																<!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;/ -->
																<v2_solidPalette>
											<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#6198C5"><v2_solidColor transparency="20" color="#FCE8D2"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E5B09E"><v2_solidColor color="#FAD3A5" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#A1A1AA"><v2_solidColor color="#F8BE78" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#9DBFE0"><v2_solidColor color="#F6A74B" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#80C1BB"><v2_solidColor color="#F29507" transparency="10"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#C65F71"><v2_solidColor color="#E76016" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#ECC57C"><v2_solidColor transparency="20" color="#D74F13"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#A08689"><v2_solidColor color="#BF1717" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#B6D994"><v2_solidColor color="#9C0606" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><v2_chartDataLabels labelCollisionMode="fine_stagger"/><v2_conditionalSolidPalette><v2_advancedCondition><v2_conditionalCases><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#9C0606" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[Violation Ranges].[Violation Age Range] = '365+ Days'</reportCondition></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#BF1717" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[Violation Ranges].[Violation Age Range] = '180-365 Days'</reportCondition></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#D74F13" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[Violation Ranges].[Violation Age Range] = '120-180 Days'</reportCondition></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#F4931F" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><reportCondition>[Violation Ranges].[Violation Age Range] = '90-120 Days'</reportCondition></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><reportCondition>[Violation Ranges].[Violation Age Range] = '60-90 Days'</reportCondition><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#F8BE78" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry></v2_conditionalCase><v2_conditionalCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><reportCondition>[Violation Ranges].[Violation Age Range] = '&lt;=60 Days'</reportCondition><v2_solidPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#FCE9D2" transparency="20"/></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:725px;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="Affected Capacity (TB)"/></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>Port Error Count vs Utilization for Host</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="Port Error vs Utilization by Host" name="Combination Chart13">
																										<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="Utilization (%)"><style><dataFormat><percentFormat/></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="Port Errors"/><v2_axisLine lineColor="#E1E1E2" lineWeight="0"/><v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/></v2_xAxis>
																										<style>
																											<CSS value="width:725px;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>
																											<v2_pointPaletteEntries><v2_pointPaletteEntry><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"/>
															<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"/>
															<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"/>
															<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"/>
															<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"/>
															<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"/>
															<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"/>
															<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;amp;amp;quot;gDefaultMarker&amp;amp;amp;amp;amp;amp;amp;amp;quot;/ -->
																										<v2_category><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Switch"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers><chartNestedNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Port"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNestedNodes></chartNode></chartNodes></v2_category><XMLAttributes><XMLAttribute name="titlesExpanded" value="true" output="no"/></XMLAttributes><v2_conditionalPointPalette><v2_advancedPointCondition><v2_pointCases><v2_pointCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_pointPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#BF1717" transparency="20"/></v2_fillEffect></v2_pointPaletteEntry><reportCondition>[Port Error vs Utilization by Host].[Utilization (%)] &gt;= .75</reportCondition></v2_pointCase><v2_pointCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_pointPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#E76016" transparency="20"/></v2_fillEffect></v2_pointPaletteEntry><reportCondition>[Port Error vs Utilization by Host].[Utilization (%)] BETWEEN .5 AND .75</reportCondition></v2_pointCase><v2_pointCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><reportCondition>[Port Error vs Utilization by Host].[Utilization (%)] BETWEEN .25 AND .50</reportCondition><v2_pointPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#F8BE78" transparency="20"/></v2_fillEffect></v2_pointPaletteEntry></v2_pointCase><v2_pointCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><reportCondition>[Port Error vs Utilization by Host].[Utilization (%)] BETWEEN 0 AND .25</reportCondition><v2_pointPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#FCE9D2" transparency="20"/></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><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>Port Error Count vs Utilization for Generic Device</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="Port Error vs Utilization by Generic Device" name="Combination Chart16">
																										<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="Utilization (%)"><style><dataFormat><percentFormat/></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="Port Errors"/><v2_axisLine lineColor="#E1E1E2" lineWeight="0"/><v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/></v2_xAxis>
																										<style>
																											<CSS value="width:725px;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>
																											<v2_pointPaletteEntries><v2_pointPaletteEntry><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"/>
															<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"/>
															<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"/>
															<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"/>
															<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"/>
															<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"/>
															<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"/>
															<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;amp;amp;quot;gDefaultMarker&amp;amp;amp;amp;amp;amp;amp;amp;quot;/ -->
																										<v2_category><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Switch"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers><chartNestedNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Port"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNestedNodes></chartNode></chartNodes></v2_category><XMLAttributes><XMLAttribute name="titlesExpanded" value="true" output="no"/></XMLAttributes><v2_conditionalPointPalette><v2_advancedPointCondition><v2_pointCases><v2_pointCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_pointPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#BF1717" transparency="20"/></v2_fillEffect></v2_pointPaletteEntry><reportCondition>[Port Error vs Utilization by Generic Device].[Utilization (%)] &gt;= .75</reportCondition></v2_pointCase><v2_pointCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_pointPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#E76016" transparency="20"/></v2_fillEffect></v2_pointPaletteEntry><reportCondition>[Port Error vs Utilization by Generic Device].[Utilization (%)] BETWEEN .5 AND .75</reportCondition></v2_pointCase><v2_pointCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><reportCondition>[Port Error vs Utilization by Generic Device].[Utilization (%)] BETWEEN .25 AND .50</reportCondition><v2_pointPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#F8BE78" transparency="20"/></v2_fillEffect></v2_pointPaletteEntry></v2_pointCase><v2_pointCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><reportCondition>[Port Error vs Utilization by Generic Device].[Utilization (%)] BETWEEN 0 AND .25</reportCondition><v2_pointPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#FCE9D2" transparency="20"/></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><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Port Error Count vs Utilization for Storage</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="Port Error vs Utilization by Storage" name="Combination Chart17">
																										<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="Utilization (%)"><style><dataFormat><percentFormat/></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="Port Errors"/><v2_axisLine lineColor="#E1E1E2" lineWeight="0"/><v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/></v2_xAxis>
																										<style>
																											<CSS value="width:725px;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>
																											<v2_pointPaletteEntries><v2_pointPaletteEntry><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"/>
															<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"/>
															<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"/>
															<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"/>
															<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"/>
															<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"/>
															<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"/>
															<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;amp;amp;quot;gDefaultMarker&amp;amp;amp;amp;amp;amp;amp;amp;quot;/ -->
																										<v2_category><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Switch"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers><chartNestedNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Port"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNestedNodes></chartNode></chartNodes></v2_category><XMLAttributes><XMLAttribute name="titlesExpanded" value="true" output="no"/></XMLAttributes><v2_conditionalPointPalette><v2_advancedPointCondition><v2_pointCases><v2_pointCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_pointPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#BF1717" transparency="20"/></v2_fillEffect></v2_pointPaletteEntry><reportCondition>[Port Error vs Utilization by Storage].[Utilization (%)] &gt;= .75</reportCondition></v2_pointCase><v2_pointCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_pointPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#E76016" transparency="20"/></v2_fillEffect></v2_pointPaletteEntry><reportCondition>[Port Error vs Utilization by Storage].[Utilization (%)] BETWEEN .5 AND .75</reportCondition></v2_pointCase><v2_pointCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><reportCondition>[Port Error vs Utilization by Storage].[Utilization (%)] BETWEEN .25 AND .50</reportCondition><v2_pointPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#F8BE78" transparency="20"/></v2_fillEffect></v2_pointPaletteEntry></v2_pointCase><v2_pointCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><reportCondition>[Port Error vs Utilization by Storage].[Utilization (%)] BETWEEN 0 AND .25</reportCondition><v2_pointPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#FCE9D2" transparency="20"/></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><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>Port Error Count vs Utilization for ISL</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="Port Error vs Utilization by ISL" name="Combination Chart18">
																										<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="Utilization (%)"><style><dataFormat><percentFormat/></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="Port Errors"/><v2_axisLine lineColor="#E1E1E2" lineWeight="0"/><v2_majorGridlines lineColor="#E1E1E2" lineWeight="0"/></v2_xAxis>
																										<style>
																											<CSS value="width:725px;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>
																											<v2_pointPaletteEntries><v2_pointPaletteEntry><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"/>
															<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"/>
															<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"/>
															<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"/>
															<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"/>
															<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"/>
															<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"/>
															<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;amp;amp;quot;gDefaultMarker&amp;amp;amp;amp;amp;amp;amp;amp;quot;/ -->
																										<v2_category><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Switch"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers><chartNestedNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Port"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNestedNodes></chartNode></chartNodes></v2_category><XMLAttributes><XMLAttribute name="titlesExpanded" value="true" output="no"/></XMLAttributes><v2_conditionalPointPalette><v2_advancedPointCondition><v2_pointCases><v2_pointCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_pointPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#BF1717" transparency="20"/></v2_fillEffect></v2_pointPaletteEntry><reportCondition>[Port Error vs Utilization by ISL].[Utilization (%)] &gt;= .75</reportCondition></v2_pointCase><v2_pointCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><v2_pointPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#E76016" transparency="20"/></v2_fillEffect></v2_pointPaletteEntry><reportCondition>[Port Error vs Utilization by ISL].[Utilization (%)] BETWEEN .5 AND .75</reportCondition></v2_pointCase><v2_pointCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><reportCondition>[Port Error vs Utilization by ISL].[Utilization (%)] BETWEEN .25 AND .50</reportCondition><v2_pointPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#F8BE78" transparency="20"/></v2_fillEffect></v2_pointPaletteEntry></v2_pointCase><v2_pointCase><v2_conditionalPaletteEntryLabel><v2_automaticLabel/></v2_conditionalPaletteEntryLabel><reportCondition>[Port Error vs Utilization by ISL].[Utilization (%)] BETWEEN 0 AND .25</reportCondition><v2_pointPaletteEntry><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#FCE9D2" transparency="20"/></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>Port Count by Utilization Range</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="Utilization Ranges" name="Combination Chart10">
													<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="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>
																<!-- v2_solidPaletteRef ref=&amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;gDefaultSolid&amp;amp;amp;amp;amp;amp;amp;amp;amp;quot;/ -->
																<v2_solidPalette>
											<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#6198C5"><v2_solidColor transparency="20" color="#FCE8D2"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#9DBFE0"><v2_solidColor color="#F6A74B" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#80C1BB"><v2_solidColor color="#F29507" transparency="10"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#ECC57C"><v2_solidColor transparency="20" color="#D74F13"/></v2_fillEffect></v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#B6D994"><v2_solidColor color="#9C0606" transparency="20"/></v2_fillEffect></v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><v2_chartDataLabels labelCollisionMode="fine_stagger"/><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Port Speed"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></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:1475px;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="Count of FC Ports"/><v2_legend><style><defaultStyles><defaultStyle refStyle="lg"/></defaultStyles></style><v2_legendPosition><v2_legendPreset/></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></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="LUN Count/Capacity by Violation">
			<source>
				
			<sqlQuery name="SQL1" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT 	CASE violation.violationType
	WHEN 'EXIST_NOT_APPROVED' THEN 'Unauthorized Path'
	WHEN 'APPROVE_NOT_EXIST'  THEN 'Path Outage'
	WHEN 'NO_SPF' THEN 'Single Point of Failure'
	WHEN 'REDUNDANCY_VIOLATION' THEN 'Missing Redundancy'
	WHEN 'HOPS_VIOLATION' THEN 'Switch Hop Count'
	WHEN 'HOST_PORTS_VIOLATION' THEN 'Missing Active Host Ports'
	WHEN 'SHARE_VOLUME_SCOPE_VIOLATION'  THEN 'Unauthorized Sharing'
	WHEN 'STORAGE_PORTS_VIOLATION' THEN 'Missing Active Storage Ports'
	WHEN 'BACKEND_OUTAGE_VIOLATION'  THEN 'Virtual Volume Missing Backend Support'
	WHEN 'Hv_ACTIVE_PATH_CONFLICT_VIOLATION' THEN 'Active Path Conflict'
	WHEN 'HV_MISSING_VIRTUAL_CLUSTER_PATH_VIOLATION' THEN 'Missing Virtual Cluster Paths'
	WHEN 'HV_INCONSISTENT_LUNS_VIOLATION'  THEN 'Inconsistent LUNs'
	WHEN 'HV_MISSING_VIRTUAL_CLUSTER_NAS_PATH_VIOLATION' THEN 'Missing Virtual Cluster NAS Share'
	END AS 'Violation Type',
	COUNT(violation.volId) AS 'Affected LUN Count',
	ROUND(SUM(violation.capMB)/1024/1024, 2) AS 'Affected Capacity (TB)'
FROM 	(		
	SELECT 	dwh_inventory.violation.type AS violationType,
		dwh_inventory.volume.id volId,
		dwh_inventory.volume.capacityMB capMB
	FROM 	dwh_inventory.violation
	JOIN 	dwh_inventory.volume
	ON 	dwh_inventory.violation.volumeId = dwh_inventory.volume.id
	GROUP BY
		dwh_inventory.volume.id
	) violation
GROUP BY
	violation.violationType</sqlText>
		<mdProjectedItems><mdProjectedItem name="Violation Type"/><mdProjectedItem name="Affected LUN Count"/><mdProjectedItem name="Affected Capacity (TB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Violation Type"><expression>[SQL1].[Violation Type]</expression></dataItem><dataItem name="Affected LUN Count" aggregate="total"><expression>[SQL1].[Affected LUN Count]</expression></dataItem><dataItem name="Affected Capacity (TB)" aggregate="total"><expression>[SQL1].[Affected Capacity (TB)]</expression></dataItem></selection>
		</query><query name="Violation Ranges">
			<source>
				
			<sqlQuery name="SQL7" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT  IF(x.days &lt;= 60, '&lt;=60 Days',
	IF(x.days &lt;= 90, '60-90 Days',
	IF(x.days &lt;= 120, '90-120 Days',
	IF(x.days &lt;= 180, '120-180 Days',
	IF(x.days &lt;= 365, '180-365 Days',
	'365+ Days'))))) AS 'Violation Age Range',
	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 violationRange,
	SUM(x.volCount) AS 'Affected LUN Count',
	ROUND(SUM(x.capMB)/1024/1024,2) AS 'Affected Capacity (TB)'
FROM 	(
	SELECT 	DATE(dwh_inventory.violation.since) AS fullDate,
		DATEDIFF(CURDATE(), DATE(dwh_inventory.violation.since)) AS days,
		COUNT(DISTINCT dwh_inventory.violation.volumeId) volCount,
		dwh_inventory.volume.capacityMB capMB
	FROM 	dwh_inventory.violation
	JOIN 	dwh_inventory.volume
	ON 	dwh_inventory.violation.volumeId = dwh_inventory.volume.id
	GROUP BY
		dwh_inventory.volume.id
	) X
GROUP BY
	violationRange</sqlText>
		<mdProjectedItems><mdProjectedItem name="Violation Age Range"/><mdProjectedItem name="violationRange"/><mdProjectedItem name="Affected LUN Count"/><mdProjectedItem name="Affected Capacity (TB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Violation Age Range"><expression>[SQL7].[Violation Age Range]</expression></dataItem><dataItem name="violationRange"><expression>[SQL7].[violationRange]</expression></dataItem><dataItem name="Affected LUN Count" aggregate="total"><expression>[SQL7].[Affected LUN Count]</expression></dataItem><dataItem name="Affected Capacity (TB)" aggregate="total"><expression>[SQL7].[Affected Capacity (TB)]</expression></dataItem></selection>
		</query><query name="Port Error vs Utilization by Generic Device">
			<source>
				
			<sqlQuery name="SQL4" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT 	dwh_performance.switch_performance_for_port_hourly_fact.connectivityType AS 'Device Type',
	dwh_performance.switch_dimension.name AS 'Switch',
	dwh_performance.port_dimension.name AS 'Port',
	IFNULL(MAX(dwh_performance.switch_performance_for_port_hourly_fact.class3DiscardCount +
		dwh_performance.switch_performance_for_port_hourly_fact.frameTooLongCount +
		dwh_performance.switch_performance_for_port_hourly_fact.frameTooShortCount +
		dwh_performance.switch_performance_for_port_hourly_fact.portErrorsCrc +
		dwh_performance.switch_performance_for_port_hourly_fact.portErrorsLinkFailure +
		dwh_performance.switch_performance_for_port_hourly_fact.portErrorsTimeoutDiscardTx +
		dwh_performance.switch_performance_for_port_hourly_fact.rxLinkResets +
		dwh_performance.switch_performance_for_port_hourly_fact.signalLossCount +
		dwh_performance.switch_performance_for_port_hourly_fact.syncLossCount +
		dwh_performance.switch_performance_for_port_hourly_fact.txLinkResets), 0) AS 'Port Errors',
	ROUND(GREATEST(MAX(dwh_performance.switch_performance_for_port_hourly_fact.rxMax), 
		MAX(dwh_performance.switch_performance_for_port_hourly_fact.txMax))/100,4) AS 'Utilization (%)'
FROM 	dwh_performance.switch_performance_for_port_hourly_fact
JOIN 	dwh_performance.switch_dimension
ON 	dwh_performance.switch_performance_for_port_hourly_fact.switchTk = dwh_performance.switch_dimension.tk
JOIN 	dwh_performance.port_dimension
ON 	dwh_performance.switch_performance_for_port_hourly_fact.portTk = dwh_performance.port_dimension.tk
AND 	dwh_performance.switch_performance_for_port_hourly_fact.connectivityType = 'Generic'
GROUP BY
	dwh_performance.switch_performance_for_port_hourly_fact.connectivityType,
	dwh_performance.port_dimension.id</sqlText>
		<mdProjectedItems><mdProjectedItem name="Device Type"/><mdProjectedItem name="Switch"/><mdProjectedItem name="Port"/><mdProjectedItem name="Port Errors"/><mdProjectedItem name="Utilization (%)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Device Type"><expression>[SQL4].[Device Type]</expression></dataItem><dataItem name="Switch"><expression>[SQL4].[Switch]</expression></dataItem><dataItem name="Port"><expression>[SQL4].[Port]</expression></dataItem><dataItem name="Port Errors" aggregate="total"><expression>[SQL4].[Port Errors]</expression></dataItem><dataItem name="Utilization (%)" aggregate="average"><expression>[SQL4].[Utilization (%)]</expression></dataItem></selection>
		</query><query name="Port Error vs Utilization by Host">
			<source>
				
			<sqlQuery name="SQL8" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT 	dwh_performance.switch_performance_for_port_hourly_fact.connectivityType AS 'Device Type',
	dwh_performance.switch_dimension.name AS 'Switch',
	dwh_performance.port_dimension.name AS 'Port',
	IFNULL(MAX(dwh_performance.switch_performance_for_port_hourly_fact.class3DiscardCount +
		dwh_performance.switch_performance_for_port_hourly_fact.frameTooLongCount +
		dwh_performance.switch_performance_for_port_hourly_fact.frameTooShortCount +
		dwh_performance.switch_performance_for_port_hourly_fact.portErrorsCrc +
		dwh_performance.switch_performance_for_port_hourly_fact.portErrorsLinkFailure +
		dwh_performance.switch_performance_for_port_hourly_fact.portErrorsTimeoutDiscardTx +
		dwh_performance.switch_performance_for_port_hourly_fact.rxLinkResets +
		dwh_performance.switch_performance_for_port_hourly_fact.signalLossCount +
		dwh_performance.switch_performance_for_port_hourly_fact.syncLossCount +
		dwh_performance.switch_performance_for_port_hourly_fact.txLinkResets), 0) AS 'Port Errors',
	ROUND(GREATEST(MAX(dwh_performance.switch_performance_for_port_hourly_fact.rxMax), 
		MAX(dwh_performance.switch_performance_for_port_hourly_fact.txMax))/100,4) AS 'Utilization (%)'
FROM 	dwh_performance.switch_performance_for_port_hourly_fact
JOIN 	dwh_performance.switch_dimension
ON 	dwh_performance.switch_performance_for_port_hourly_fact.switchTk = dwh_performance.switch_dimension.tk
JOIN 	dwh_performance.port_dimension
ON 	dwh_performance.switch_performance_for_port_hourly_fact.portTk = dwh_performance.port_dimension.tk
AND 	dwh_performance.switch_performance_for_port_hourly_fact.connectivityType = 'Host'
GROUP BY
	dwh_performance.switch_performance_for_port_hourly_fact.connectivityType,
	dwh_performance.port_dimension.id</sqlText>
		<mdProjectedItems><mdProjectedItem name="Device Type"/><mdProjectedItem name="Switch"/><mdProjectedItem name="Port"/><mdProjectedItem name="Port Errors"/><mdProjectedItem name="Utilization (%)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Device Type"><expression>[SQL8].[Device Type]</expression></dataItem><dataItem name="Switch"><expression>[SQL8].[Switch]</expression></dataItem><dataItem name="Port"><expression>[SQL8].[Port]</expression></dataItem><dataItem name="Port Errors" aggregate="total"><expression>[SQL8].[Port Errors]</expression></dataItem><dataItem name="Utilization (%)" aggregate="average"><expression>[SQL8].[Utilization (%)]</expression></dataItem></selection>
		</query><query name="Port Error vs Utilization by Storage">
			<source>
				
			<sqlQuery name="SQL9" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT 	dwh_performance.switch_performance_for_port_hourly_fact.connectivityType AS 'Device Type',
	dwh_performance.switch_dimension.name AS 'Switch',
	dwh_performance.port_dimension.name AS 'Port',
	IFNULL(MAX(dwh_performance.switch_performance_for_port_hourly_fact.class3DiscardCount +
		dwh_performance.switch_performance_for_port_hourly_fact.frameTooLongCount +
		dwh_performance.switch_performance_for_port_hourly_fact.frameTooShortCount +
		dwh_performance.switch_performance_for_port_hourly_fact.portErrorsCrc +
		dwh_performance.switch_performance_for_port_hourly_fact.portErrorsLinkFailure +
		dwh_performance.switch_performance_for_port_hourly_fact.portErrorsTimeoutDiscardTx +
		dwh_performance.switch_performance_for_port_hourly_fact.rxLinkResets +
		dwh_performance.switch_performance_for_port_hourly_fact.signalLossCount +
		dwh_performance.switch_performance_for_port_hourly_fact.syncLossCount +
		dwh_performance.switch_performance_for_port_hourly_fact.txLinkResets), 0) AS 'Port Errors',
	ROUND(GREATEST(MAX(dwh_performance.switch_performance_for_port_hourly_fact.rxMax), 
		MAX(dwh_performance.switch_performance_for_port_hourly_fact.txMax))/100,4) AS 'Utilization (%)'
FROM 	dwh_performance.switch_performance_for_port_hourly_fact
JOIN 	dwh_performance.switch_dimension
ON 	dwh_performance.switch_performance_for_port_hourly_fact.switchTk = dwh_performance.switch_dimension.tk
JOIN 	dwh_performance.port_dimension
ON 	dwh_performance.switch_performance_for_port_hourly_fact.portTk = dwh_performance.port_dimension.tk
AND 	dwh_performance.switch_performance_for_port_hourly_fact.connectivityType = 'Storage'
GROUP BY
	dwh_performance.switch_performance_for_port_hourly_fact.connectivityType,
	dwh_performance.port_dimension.id</sqlText>
		<mdProjectedItems><mdProjectedItem name="Device Type"/><mdProjectedItem name="Switch"/><mdProjectedItem name="Port"/><mdProjectedItem name="Port Errors"/><mdProjectedItem name="Utilization (%)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Device Type"><expression>[SQL9].[Device Type]</expression></dataItem><dataItem name="Switch"><expression>[SQL9].[Switch]</expression></dataItem><dataItem name="Port"><expression>[SQL9].[Port]</expression></dataItem><dataItem name="Port Errors" aggregate="total"><expression>[SQL9].[Port Errors]</expression></dataItem><dataItem name="Utilization (%)" aggregate="average"><expression>[SQL9].[Utilization (%)]</expression></dataItem></selection>
		</query><query name="Port Error vs Utilization by ISL">
			<source>
				
			<sqlQuery name="SQL10" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT 	dwh_performance.switch_performance_for_port_hourly_fact.connectivityType AS 'Device Type',
	dwh_performance.switch_dimension.name AS 'Switch',
	dwh_performance.port_dimension.name AS 'Port',
	IFNULL(MAX(dwh_performance.switch_performance_for_port_hourly_fact.class3DiscardCount +
		dwh_performance.switch_performance_for_port_hourly_fact.frameTooLongCount +
		dwh_performance.switch_performance_for_port_hourly_fact.frameTooShortCount +
		dwh_performance.switch_performance_for_port_hourly_fact.portErrorsCrc +
		dwh_performance.switch_performance_for_port_hourly_fact.portErrorsLinkFailure +
		dwh_performance.switch_performance_for_port_hourly_fact.portErrorsTimeoutDiscardTx +
		dwh_performance.switch_performance_for_port_hourly_fact.rxLinkResets +
		dwh_performance.switch_performance_for_port_hourly_fact.signalLossCount +
		dwh_performance.switch_performance_for_port_hourly_fact.syncLossCount +
		dwh_performance.switch_performance_for_port_hourly_fact.txLinkResets), 0) AS 'Port Errors',
	ROUND(GREATEST(MAX(dwh_performance.switch_performance_for_port_hourly_fact.rxMax), 
		MAX(dwh_performance.switch_performance_for_port_hourly_fact.txMax))/100,4) AS 'Utilization (%)'
FROM 	dwh_performance.switch_performance_for_port_hourly_fact
JOIN 	dwh_performance.switch_dimension
ON 	dwh_performance.switch_performance_for_port_hourly_fact.switchTk = dwh_performance.switch_dimension.tk
JOIN 	dwh_performance.port_dimension
ON 	dwh_performance.switch_performance_for_port_hourly_fact.portTk = dwh_performance.port_dimension.tk
AND 	dwh_performance.switch_performance_for_port_hourly_fact.connectivityType = 'ISL'
GROUP BY
	dwh_performance.switch_performance_for_port_hourly_fact.connectivityType,
	dwh_performance.port_dimension.id</sqlText>
		<mdProjectedItems><mdProjectedItem name="Device Type"/><mdProjectedItem name="Switch"/><mdProjectedItem name="Port"/><mdProjectedItem name="Port Errors"/><mdProjectedItem name="Utilization (%)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Device Type"><expression>[SQL10].[Device Type]</expression></dataItem><dataItem name="Switch"><expression>[SQL10].[Switch]</expression></dataItem><dataItem name="Port"><expression>[SQL10].[Port]</expression></dataItem><dataItem name="Port Errors" aggregate="total"><expression>[SQL10].[Port Errors]</expression></dataItem><dataItem name="Utilization (%)" aggregate="average"><expression>[SQL10].[Utilization (%)]</expression></dataItem></selection>
		</query><query name="Utilization Ranges">
			<source>
				
			<sqlQuery name="SQL11" dataSource="dwh_performance" type="passThrough">
			<sqlText>SELECT 	x.speed AS 'Port Speed',
	x.utilizationRange AS 'Utilization Range',
	COUNT(DISTINCT x.portId) AS 'Count of FC Ports',
	x.ranking AS 'Ranking'
FROM 	(
	SELECT 	dwh_performance.switch_dimension.id switchId,
		dwh_performance.port_dimension.id AS portId,
		dwh_performance.port_dimension.speed AS speed,
		CASE 	WHEN 	ROUND(GREATEST(MAX(dwh_performance.switch_performance_for_port_hourly_fact.rxMax), MAX(dwh_performance.switch_performance_for_port_hourly_fact.txMax))/100,4) = 0
			THEN 	'0%'
			WHEN 	ROUND(GREATEST(MAX(dwh_performance.switch_performance_for_port_hourly_fact.rxMax), MAX(dwh_performance.switch_performance_for_port_hourly_fact.txMax))/100,4) BETWEEN 0 AND .25
			THEN 	'1-25%'
			WHEN 	ROUND(GREATEST(MAX(dwh_performance.switch_performance_for_port_hourly_fact.rxMax), MAX(dwh_performance.switch_performance_for_port_hourly_fact.txMax))/100,4) BETWEEN .25 AND .50
			THEN 	'25-50%'
			WHEN 	ROUND(GREATEST(MAX(dwh_performance.switch_performance_for_port_hourly_fact.rxMax), MAX(dwh_performance.switch_performance_for_port_hourly_fact.txMax))/100,4) BETWEEN .50 AND .75
			THEN 	'50-75%'
		ELSE 	'75-100%'
		END 	AS utilizationRange,
		CASE 	WHEN 	ROUND(GREATEST(MAX(dwh_performance.switch_performance_for_port_hourly_fact.rxMax), MAX(dwh_performance.switch_performance_for_port_hourly_fact.txMax))/100,4) = 0
			THEN 	0
			WHEN 	ROUND(GREATEST(MAX(dwh_performance.switch_performance_for_port_hourly_fact.rxMax), MAX(dwh_performance.switch_performance_for_port_hourly_fact.txMax))/100,4) BETWEEN 0 AND .25
			THEN 	1
			WHEN 	ROUND(GREATEST(MAX(dwh_performance.switch_performance_for_port_hourly_fact.rxMax), MAX(dwh_performance.switch_performance_for_port_hourly_fact.txMax))/100,4) BETWEEN .25 AND .50
			THEN 	2
			WHEN 	ROUND(GREATEST(MAX(dwh_performance.switch_performance_for_port_hourly_fact.rxMax), MAX(dwh_performance.switch_performance_for_port_hourly_fact.txMax))/100,4) BETWEEN .50 AND .75
			THEN 	3
		ELSE 	4
		END 	AS ranking,
		ROUND(GREATEST(MAX(dwh_performance.switch_performance_for_port_hourly_fact.rxMax), MAX(dwh_performance.switch_performance_for_port_hourly_fact.txMax))/100,4) AS utilization
	FROM 	dwh_performance.switch_performance_for_port_hourly_fact
	JOIN 	dwh_performance.switch_dimension
	ON 	dwh_performance.switch_performance_for_port_hourly_fact.switchTk = dwh_performance.switch_dimension.tk
	JOIN 	dwh_performance.port_dimension
	ON 	dwh_performance.switch_performance_for_port_hourly_fact.portTk = dwh_performance.port_dimension.tk
	GROUP BY
		dwh_performance.port_dimension.id
	) X
GROUP BY
	x.speed,
	x.utilizationRange
ORDER BY
	x.ranking</sqlText>
		<mdProjectedItems><mdProjectedItem name="Port Speed"/><mdProjectedItem name="Utilization Range"/><mdProjectedItem name="Count of FC Ports"/><mdProjectedItem name="Ranking"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Port Speed"><expression>[SQL11].[Port Speed]</expression></dataItem><dataItem name="Utilization Range"><expression>[SQL11].[Utilization Range]</expression></dataItem><dataItem name="Count of FC Ports" aggregate="total"><expression>[SQL11].[Count of FC Ports]</expression></dataItem><dataItem name="Ranking"><expression>[SQL11].[Ranking]</expression></dataItem></selection>
		</query></queries><reportName>FC Port Remediation</reportName></report>