<report xmlns="http://developer.cognos.com/schemas/report/11.0/" useStyleVersion="10" expressionLocale="en-us">
				<modelPath>/content/folder[@name=&apos;Packages&apos;]/package[@name=&apos;Inventory&apos;]/model[@name=&apos;model&apos;]</modelPath>
				<drillBehavior/>
				<layouts>
					<layout>
						<reportPages>
							<page name="Page1">
								<style>
									<defaultStyles>
										<defaultStyle refStyle="pg"/>
									</defaultStyles>
								</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;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;padding-left:24px;background-color:#6198C5"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Operational Health - FC Port Errors</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:24px;color:#333333"/></style></textItem></contents><style><CSS value="padding-left:24px;height:36px;background-color:#FBFBFB"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>*Note: Data will only fill in when a threshold has been crossed. Threshold policies can be found at the bottom of the page.</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:12px;color:gray"/></style></textItem></contents><style><CSS value="padding-left:24px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><list horizontalPagination="true" name="List1" refQuery="Query1" rowsPerPage="20000">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;font-family:Arial;font-size:12px;color:#333333;border:1px solid #E1E1E2"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:center;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Switch"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Switch"/></dataSource></textItem></contents><listColumnRowSpan refDataItem="Switch"/></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:center;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Port"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Port"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:center;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Port Latency"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Port Latency"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:center;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="BB Credit Zero Rx Warning"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="BB Credit Zero Rx Warning"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:center;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="BB Credit Zero Tx Warning"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="BB Credit Zero Tx Warning"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:center;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Policy: Slow Drain Device"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Policy: Slow Drain Device"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:center;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Class 3 Discard"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Class 3 Discard"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:center;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Loss of Sync/Signal"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Loss of Sync/Signal"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:center;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Timeout Discard"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Timeout Discard"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:center;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Link Reset"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Link Reset"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:center;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Frame Too Long/Short"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Frame Too Long/Short"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:center;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="CRC Errors"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="CRC Errors"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="text-align:center;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Link Failure"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;border:1px solid #E1E1E2"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Link Failure"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns><listGroups><listGroup refDataItem="Switch"/></listGroups></list></contents></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:50%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>FC Performance Policies</staticValue></dataSource></textItem></contents><style><CSS value="padding-left:5px;padding-top:5px;font-family:Arial;font-size:12px;color:#333333;font-weight:bold;border:1px solid #E1E1E2"/></style></tableCell><tableCell><contents/><style><CSS value="font-family:Arial;font-size:12px;color:#333333;border:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:5px"/></style></tableCell><tableCell><contents/><style><CSS value="height:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Port Latency</staticValue></dataSource></textItem></contents><style><CSS value="padding-left:5px;font-family:Arial;font-size:12px;color:#333333;font-weight:bold;padding-top:2.5px;padding-bottom:2.5px;border:1px solid #E1E1E2"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>BB Credit Zero Ms Tx &gt; 0</staticValue></dataSource></textItem></contents><style><CSS value="font-family:Arial;font-size:12px;color:#333333;padding-left:5px;border:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>BB Credit Zero Rx Warning</staticValue></dataSource></textItem></contents><style><CSS value="padding-left:5px;font-family:Arial;font-size:12px;color:#333333;font-weight:bold;padding-top:2.5px;padding-bottom:2.5px;border:1px solid #E1E1E2"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>BB Credit Zero Rx &gt; 1,000,000</staticValue></dataSource></textItem></contents><style><CSS value="font-family:Arial;font-size:12px;color:#333333;padding-left:5px;border:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>BB Credit Zero Tx Warning</staticValue></dataSource></textItem></contents><style><CSS value="padding-left:5px;font-family:Arial;font-size:12px;color:#333333;font-weight:bold;padding-top:2.5px;padding-bottom:2.5px;border:1px solid #E1E1E2"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>BB Credit Zero Tx &gt; 1,000,000</staticValue></dataSource></textItem></contents><style><CSS value="font-family:Arial;font-size:12px;color:#333333;padding-left:5px;border:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Policy: Slow Drain Device</staticValue></dataSource></textItem></contents><style><CSS value="padding-left:5px;font-family:Arial;font-size:12px;color:#333333;font-weight:bold;padding-top:2.5px;padding-bottom:2.5px;border:1px solid #E1E1E2"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>BB Credit Zero Rx &gt; 1,000,000 and BB Credit Zero Ms Tx &gt; 0</staticValue></dataSource></textItem></contents><style><CSS value="font-family:Arial;font-size:12px;color:#333333;padding-left:5px;border:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Class 3 Discard</staticValue></dataSource></textItem></contents><style><CSS value="padding-left:5px;font-family:Arial;font-size:12px;color:#333333;font-weight:bold;padding-top:2.5px;padding-bottom:2.5px;border:1px solid #E1E1E2"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Class 3 Discard Count &gt; 0</staticValue></dataSource></textItem></contents><style><CSS value="font-family:Arial;font-size:12px;color:#333333;padding-left:5px;border:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Loss of Sync/Signal</staticValue></dataSource></textItem></contents><style><CSS value="padding-left:5px;font-family:Arial;font-size:12px;color:#333333;font-weight:bold;padding-top:2.5px;padding-bottom:2.5px;border:1px solid #E1E1E2"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Loss of Sync/Signal Count &gt; 0</staticValue></dataSource></textItem></contents><style><CSS value="font-family:Arial;font-size:12px;color:#333333;padding-left:5px;border:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Timeout Discard</staticValue></dataSource></textItem></contents><style><CSS value="padding-left:5px;font-family:Arial;font-size:12px;color:#333333;font-weight:bold;padding-top:2.5px;padding-bottom:2.5px;border:1px solid #E1E1E2"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Timeout Discard &gt; 0</staticValue></dataSource></textItem></contents><style><CSS value="font-family:Arial;font-size:12px;color:#333333;padding-left:5px;border:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Link Reset</staticValue></dataSource></textItem></contents><style><CSS value="padding-left:5px;font-family:Arial;font-size:12px;color:#333333;font-weight:bold;padding-top:2.5px;padding-bottom:2.5px;border:1px solid #E1E1E2"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Link Resets &gt; 0</staticValue></dataSource></textItem></contents><style><CSS value="font-family:Arial;font-size:12px;color:#333333;padding-left:5px;border:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Frame Too Long/Short</staticValue></dataSource></textItem></contents><style><CSS value="padding-left:5px;font-family:Arial;font-size:12px;color:#333333;font-weight:bold;padding-top:2.5px;padding-bottom:2.5px;border:1px solid #E1E1E2"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Frame too Long/Short Count &gt; 0</staticValue></dataSource></textItem></contents><style><CSS value="font-family:Arial;font-size:12px;color:#333333;padding-left:5px;border:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>CRC Errors</staticValue></dataSource></textItem></contents><style><CSS value="padding-left:5px;font-family:Arial;font-size:12px;color:#333333;font-weight:bold;padding-top:2.5px;padding-bottom:2.5px;border:1px solid #E1E1E2"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>CRC Errors &gt; 0</staticValue></dataSource></textItem></contents><style><CSS value="font-family:Arial;font-size:12px;color:#333333;padding-left:5px;border:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Link Failure</staticValue></dataSource></textItem></contents><style><CSS value="padding-left:5px;padding-bottom:5px;font-family:Arial;font-size:12px;color:#333333;font-weight:bold;padding-top:2.5px;border:1px solid #E1E1E2"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Link Failures &gt; 0</staticValue></dataSource></textItem></contents><style><CSS value="padding-bottom:5px;font-family:Arial;font-size:12px;color:#333333;padding-left:5px;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/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell></tableCells></tableRow></tableRows></table></contents>
								</pageBody>
							<pageFooter><contents><table>
											<tableRows>
												<tableRow>
													<tableCells>
														<tableCell>
															<contents>
																
															<image>
			<dataSource>
				<staticValue>/reporting/sanscreen/images/netapp_logo.png</staticValue>
			</dataSource>
		<style><CSS value="width:90px;height:36px"/></style></image></contents>
															<style>
																<CSS value="vertical-align:middle;text-align:left;width:30%"/>
															</style>
														</tableCell>
														<tableCell>
															<contents>
																<textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
															</contents>
															<style>
																<CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
															</style>
														</tableCell>
														<tableCell>
															<contents>
																
															<textItem><dataSource><staticValue>OnCommand Insight 7.1. © 2014-15 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
															<style>
																<CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
															</style>
														</tableCell>
													</tableCells>
												</tableRow>
											</tableRows>
											<style>
												<defaultStyles>
													<defaultStyle refStyle="tb"/>
												</defaultStyles>
												<CSS value="border-collapse:collapse;width:100%;height:32px"/>
											</style>
										</table></contents><style><CSS value="padding:10px 15px 10px 15px;background-color:#FBFBFB"/></style></pageFooter></page>
						</reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" value="true" output="no"/><XMLAttribute name="listSeparator" value="," output="no"/><XMLAttribute name="RS_modelModificationTime" value="2015-04-14T12:20:59.758Z" output="no"/></XMLAttributes><reportName>Operational Health - FC Port Errors</reportName><classStyles><classStyle name="ls"><CSS value="border-collapse:collapse"/></classStyle><classStyle name="lt"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-left-style:none;background-color:white;color:black;text-align:left;font-weight:bold;border-bottom:1.5pt solid black"/></classStyle><classStyle name="lc"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="lm"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="lh"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="lf"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="ih"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="if"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="is"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="oh"><CSS value="border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="of"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle><classStyle name="os"><CSS value="background-image:none;border-top-style:none;border-right-style:none;border-bottom-style:none;border-left-style:none;background-color:white;color:black"/></classStyle></classStyles><queries><query name="Query1"><source><sqlQuery name="SQL1" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT	x.switchName AS &apos;Switch&apos;,
	x.portName AS &apos;Port&apos;,
	IF(x.bbCreditZeroMsTx &gt; 0, x.bbCreditZeroMsTx, NULL) AS &apos;Port Latency&apos;,
	IF(x.bbCreditZeroRx &gt; 1000000, x.bbCreditZeroRx, NULL) AS &apos;BB Credit Zero Rx Warning&apos;,
	IF(x.bbCreditZeroTx &gt; 1000000, x.bbCreditZeroTx, NULL) AS &apos;BB Credit Zero Tx Warning&apos;,
	IF(x.bbCreditZeroRx &gt; 1000000 AND x.bbCreditZeroMsTx &gt; 0, &apos;Yes&apos;, &apos;No&apos;) AS &apos;Slow Drain Device&apos;,
	IF(x.class3DiscardCount &gt; 0, x.class3DiscardCount, NULL) AS &apos;Class 3 Discard&apos;,
	IF(x.signalLossCount &gt; 0 OR x.syncLossCount &gt; 0, CONCAT(x.signalLossCount, &apos; Signal Loss Count; &apos;,x.syncLossCount, &apos; Sync Loss Count&apos;) , NULL) AS &apos;Loss of Sync/Signal&apos;,
	IF(x.portErrorsTimeoutDiscardTx &gt; 0, x.portErrorsTimeoutDiscardTx, NULL) AS &apos;Timeout Discard&apos;,
	IF(x.linkResets &gt; 0, x.linkResets, NULL) AS &apos;Link Reset&apos;,
	IF(x.frameTooLongCount &gt; 0, x.frameTooLongCount, NULL) AS &apos;Frame Too Long/Short&apos;,
	IF(x.portErrorsCrc &gt; 0, x.portErrorsCrc, NULL) AS &apos;CRC Errors&apos;,
	IF(x.portErrorsLinkFailure &gt; 0, x.portErrorsLinkFailure, NULL) AS &apos;Link Failure&apos;
FROM 	(
	SELECT 	dwh_performance.switch_dimension.name switchName,
		dwh_performance.port_dimension.name portName,
		dwh_performance.port_dimension.tk portTk,
		MAX(dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroMsTx) bbCreditZeroMsTx,
		MAX(dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroRx) bbCreditZeroRx,
		MAX(dwh_performance.switch_performance_for_port_hourly_fact.bbCreditZeroTx) bbCreditZeroTx,
		MAX(dwh_performance.switch_performance_for_port_hourly_fact.class3DiscardCount) class3DiscardCount,
		MAX(dwh_performance.switch_performance_for_port_hourly_fact.signalLossCount) signalLossCount,
		MAX(dwh_performance.switch_performance_for_port_hourly_fact.syncLossCount) syncLossCount,
		MAX(dwh_performance.switch_performance_for_port_hourly_fact.portErrorsTimeoutDiscardTx) portErrorsTimeoutDiscardTx,
		MAX(dwh_performance.switch_performance_for_port_hourly_fact.portErrorsLinkFailure) portErrorsLinkFailure,
		MAX(dwh_performance.switch_performance_for_port_hourly_fact.rxLinkResets + dwh_performance.switch_performance_for_port_hourly_fact.txLinkResets) linkResets,
		MAX(dwh_performance.switch_performance_for_port_hourly_fact.portErrorsCrc) portErrorsCrc,
		MAX(dwh_performance.switch_performance_for_port_hourly_fact.frameTooLongCount + dwh_performance.switch_performance_for_port_hourly_fact.frameTooShortCount) frameTooLongCount
	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.switch_dimension.name,
		dwh_performance.port_dimension.tk
	) X
GROUP BY
	x.switchName,
	x.portTk</sqlText>
		<mdProjectedItems><mdProjectedItem name="Switch"/><mdProjectedItem name="Port"/><mdProjectedItem name="Port Latency"/><mdProjectedItem name="BB Credit Zero Rx Warning"/><mdProjectedItem name="BB Credit Zero Tx Warning"/><mdProjectedItem name="Slow Drain Device"/><mdProjectedItem name="Class 3 Discard"/><mdProjectedItem name="Loss of Sync/Signal"/><mdProjectedItem name="Timeout Discard"/><mdProjectedItem name="Link Reset"/><mdProjectedItem name="Frame Too Long/Short"/><mdProjectedItem name="CRC Errors"/><mdProjectedItem name="Link Failure"/></mdProjectedItems></sqlQuery></source><selection><dataItem name="Switch"><expression>[SQL1].[Switch]</expression></dataItem><dataItem name="Port"><expression>[SQL1].[Port]</expression></dataItem><dataItem name="Port Latency"><expression>[SQL1].[Port Latency]</expression></dataItem><dataItem name="BB Credit Zero Rx Warning"><expression>[SQL1].[BB Credit Zero Rx Warning]</expression></dataItem><dataItem name="BB Credit Zero Tx Warning"><expression>[SQL1].[BB Credit Zero Tx Warning]</expression></dataItem><dataItem name="Policy: Slow Drain Device"><expression>[SQL1].[Slow Drain Device]</expression></dataItem><dataItem name="Class 3 Discard"><expression>[SQL1].[Class 3 Discard]</expression></dataItem><dataItem name="Loss of Sync/Signal"><expression>[SQL1].[Loss of Sync/Signal]</expression></dataItem><dataItem name="Timeout Discard"><expression>[SQL1].[Timeout Discard]</expression></dataItem><dataItem name="Link Reset"><expression>[SQL1].[Link Reset]</expression></dataItem><dataItem name="Frame Too Long/Short"><expression>[SQL1].[Frame Too Long/Short]</expression></dataItem><dataItem name="CRC Errors"><expression>[SQL1].[CRC Errors]</expression></dataItem><dataItem name="Link Failure"><expression>[SQL1].[Link Failure]</expression></dataItem></selection></query></queries></report>