This report provides summary information about the SNMP availability registered during a defined period for the monitored Cisco Nexus. Jalasoft Xian Network Manager collects data for this report (using the SNMP availability rule included in the Jalasoft Xian NM plug-in for Cisco Nexus).
| Accessibility | Public |
| Visible | True |
Home
<Report ID="Jalasoft.Xian.OpsMgr2007MP.Report.CiscoNexus.SNMPAvailability.1_Stat.Summary" Accessibility="Public" Target="ThirdParty_Cisco!Jalasoft.Xian.Common.Elements.ThirdParty.Cisco.JsXCiscoNexusSnmpDeviceElement" Visible="true">
<ParameterBlock xmlns="http://schemas.microsoft.com/mom/reporting/2007/ReportParameterSettings" columns="2">
<Controls>
<Control type="Microsoft.SystemCenter.DataWarehouse.Report.ParameterControl.RelativeDateTimePicker" rowSpan="3" columnSpan="1">
<ReportParameters>
<ReportParameter name="TimeZone" binding="TimeZone"/>
<ReportParameter name="TimeZoneName" binding="TimeZoneName"/>
<ReportParameter name="StartDate_BaseType" binding="StartDate_BaseType"/>
<ReportParameter name="StartDate" binding="StartDate_BaseValue"/>
<ReportParameter name="StartDate_OffsetType" binding="StartDate_OffsetType"/>
<ReportParameter name="StartDate_OffsetValue" binding="StartDate_OffsetValue"/>
<ReportParameter name="EndDate_BaseType" binding="EndDate_BaseType"/>
<ReportParameter name="EndDate" binding="EndDate_BaseValue"/>
<ReportParameter name="EndDate_OffsetType" binding="EndDate_OffsetType"/>
<ReportParameter name="EndDate_OffsetValue" binding="EndDate_OffsetValue"/>
</ReportParameters>
</Control>
</Controls>
</ParameterBlock>
<Definition>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<DataSources>
<DataSource Name="DataWarehouseMain">
<DataSourceReference>Data Warehouse Main</DataSourceReference>
</DataSource>
</DataSources>
<BottomMargin>1in</BottomMargin>
<RightMargin>1in</RightMargin>
<PageWidth>11in</PageWidth>
<ReportParameters>
<ReportParameter Name="StartDate">
<DataType>DateTime</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>Start Date</Prompt>
</ReportParameter>
<ReportParameter Name="EndDate">
<DataType>DateTime</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>End Date</Prompt>
</ReportParameter>
<ReportParameter Name="TimeZone">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>Time Zone</Prompt>
</ReportParameter>
<ReportParameter Name="TimeZoneName">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>TimeZoneName</Prompt>
</ReportParameter>
<ReportParameter Name="StartDate_BaseType">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>StartDate_BaseType</Prompt>
</ReportParameter>
<ReportParameter Name="StartDate_OffsetType">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>StartDate_OffsetType</Prompt>
</ReportParameter>
<ReportParameter Name="StartDate_OffsetValue">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>StartDate_OffsetValue</Prompt>
</ReportParameter>
<ReportParameter Name="EndDate_BaseType">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>EndDate_BaseType</Prompt>
</ReportParameter>
<ReportParameter Name="EndDate_OffsetType">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>EndDate_OffsetType</Prompt>
</ReportParameter>
<ReportParameter Name="EndDate_OffsetValue">
<DataType>String</DataType>
<AllowBlank>true</AllowBlank>
<Prompt>EndDate_OffsetValue</Prompt>
</ReportParameter>
<ReportParameter Name="PluginName">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>Jalasoft Xian NM plugin for Cisco Nexus</Value>
</Values>
</DefaultValue>
</ReportParameter>
<ReportParameter Name="DeviceType">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>Jalasoft.Xian.Common.Elements.ThirdParty.Cisco.JsXCiscoNexusSnmpDeviceElement;</Value>
</Values>
</DefaultValue>
</ReportParameter>
<ReportParameter Name="NodeType">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>Jalasoft.Xian.Common.Elements.ThirdParty.Cisco.JsXCiscoNexusSnmpDeviceElement;</Value>
</Values>
</DefaultValue>
</ReportParameter>
<ReportParameter Name="Counter">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>SNMP availability (1)</Value>
</Values>
</DefaultValue>
</ReportParameter>
<ReportParameter Name="RuleName">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>SNMP availability</Value>
</Values>
</DefaultValue>
</ReportParameter>
<ReportParameter Name="RuleSystemName">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>Jalasoft.Xian.SmartManagementPacks.CiscoNexus.DW.SNMPAvailability.1.1</Value>
</Values>
</DefaultValue>
</ReportParameter>
<ReportParameter Name="States">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>2</Value>
</Values>
</DefaultValue>
</ReportParameter>
<ReportParameter Name="deviceId">
<DataType>String</DataType>
<DefaultValue>
<Values>
<Value>0</Value>
</Values>
</DefaultValue>
<Prompt>deviceId</Prompt>
<Hidden>true</Hidden>
</ReportParameter>
</ReportParameters>
<rd:DrawGrid>true</rd:DrawGrid>
<InteractiveWidth>11in</InteractiveWidth>
<rd:GridSpacing>0.05in</rd:GridSpacing>
<rd:SnapToGrid>true</rd:SnapToGrid>
<Body>
<ReportItems>
<List Name="NoDataList">
<Left>0.7in</Left>
<DataSetName>ReportDataEx</DataSetName>
<Top>2.65in</Top>
<NoRows>There is no data available for this report. This may occur when there is no relevant data available for collection, this report depends on data generated by the Xian Network Manager SNMP availability rule, included in the Jalasoft Xian NM plug-in for Cisco Nexus.</NoRows>
<ZIndex>4</ZIndex>
<Visibility>
<Hidden>=iif(CountRows()>0,true,false)</Hidden>
</Visibility>
<Width>7.6in</Width>
<Style>
<TextAlign>Center</TextAlign>
</Style>
<Height>2in</Height>
</List>
<Table Name="tblStatus">
<Footer>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="txtNA">
<ZIndex>5</ZIndex>
<Style>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>N/A: Not available</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="textbox1">
<rd:DefaultName>textbox1</rd:DefaultName>
<ZIndex>4</ZIndex>
<Style>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value/>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="Status1">
<rd:DefaultName>textbox2</rd:DefaultName>
<ZIndex>3</ZIndex>
<Style>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value/>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="Status0">
<rd:DefaultName>textbox2</rd:DefaultName>
<ZIndex>3</ZIndex>
<Style>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value/>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.25in</Height>
</TableRow>
</TableRows>
</Footer>
<Left>0.15in</Left>
<DataSetName>ReportDataEx</DataSetName>
<Top>2.65in</Top>
<TableGroups>
<TableGroup>
<Grouping Name="tblStatus_Group1">
<GroupExpressions>
<GroupExpression>=Fields!DeviceRowId.Value</GroupExpression>
</GroupExpressions>
</Grouping>
</TableGroup>
</TableGroups>
<ZIndex>3</ZIndex>
<Visibility>
<Hidden>=IIF(CountRows()>0,false,true)</Hidden>
</Visibility>
<Width>4.29837in</Width>
<Details>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox4">
<rd:DefaultName>textbox4</rd:DefaultName>
<ZIndex>2</ZIndex>
<Action>
<Drillthrough>
<ReportName>Jalasoft.Xian.OpsMgr2007MP.Report.CiscoNexus.SNMPAvailability.1_Stat.Aggregated</ReportName>
<Parameters>
<Parameter Name="StartDate">
<Value>=Parameters!StartDate.Value</Value>
</Parameter>
<Parameter Name="EndDate">
<Value>=Parameters!EndDate.Value</Value>
</Parameter>
<Parameter Name="Device">
<Value>=Fields!DeviceRowId.Value</Value>
</Parameter>
<Parameter Name="TimeZone">
<Value>=Parameters!TimeZone.Value</Value>
</Parameter>
<Parameter Name="TimeZoneName">
<Value>=Parameters!TimeZoneName.Value</Value>
</Parameter>
<Parameter Name="StartDate_BaseType">
<Value>=Parameters!StartDate_BaseType.Value</Value>
</Parameter>
<Parameter Name="StartDate_OffsetType">
<Value>=Parameters!StartDate_OffsetType.Value</Value>
</Parameter>
<Parameter Name="StartDate_OffsetValue">
<Value>=Parameters!StartDate_OffsetValue.Value</Value>
</Parameter>
<Parameter Name="EndDate_BaseType">
<Value>=Parameters!EndDate_BaseType.Value</Value>
</Parameter>
<Parameter Name="EndDate_OffsetType">
<Value>=Parameters!EndDate_OffsetType.Value</Value>
</Parameter>
<Parameter Name="EndDate_OffsetValue">
<Value>=Parameters!EndDate_OffsetValue.Value</Value>
</Parameter>
</Parameters>
</Drillthrough>
</Action>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!DeviceDisplayName.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Chart Name="chtStatus">
<Legend>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<Position>RightCenter</Position>
</Legend>
<Subtype>PercentStacked</Subtype>
<Title>
<Style/>
</Title>
<CategoryAxis>
<Axis>
<Title/>
<MajorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<Min>0</Min>
<Margin>true</Margin>
</Axis>
</CategoryAxis>
<PointWidth>0</PointWidth>
<ThreeDProperties>
<Rotation>30</Rotation>
<Inclination>30</Inclination>
<Shading>Simple</Shading>
<WallThickness>50</WallThickness>
</ThreeDProperties>
<DataSetName>ReportData</DataSetName>
<SeriesGroupings>
<SeriesGrouping>
<StaticSeries>
<StaticMember>
<Label>Available</Label>
</StaticMember>
<StaticMember>
<Label>Not available</Label>
</StaticMember>
</StaticSeries>
</SeriesGrouping>
</SeriesGroupings>
<PlotArea>
<Style>
<BackgroundColor>White</BackgroundColor>
</Style>
</PlotArea>
<ValueAxis>
<Axis>
<Title/>
<MajorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MajorGridLines>
<MinorGridLines>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</MinorGridLines>
<Min>0</Min>
<Margin>true</Margin>
<Scalar>true</Scalar>
</Axis>
</ValueAxis>
<ZIndex>1</ZIndex>
<Type>Bar</Type>
<Palette>SemiTransparent</Palette>
<ChartData>
<ChartSeries>
<DataPoints>
<DataPoint>
<DataValues>
<DataValue>
<Value>=Sum(Fields!Status1.Value)</Value>
</DataValue>
</DataValues>
<DataLabel/>
<Style>
<BackgroundColor>DarkSeaGreen</BackgroundColor>
<BackgroundGradientEndColor>Green</BackgroundGradientEndColor>
<BackgroundGradientType>TopBottom</BackgroundGradientType>
</Style>
<Marker>
<Size>6pt</Size>
</Marker>
</DataPoint>
</DataPoints>
</ChartSeries>
<ChartSeries>
<DataPoints>
<DataPoint>
<DataValues>
<DataValue>
<Value>=Sum(Fields!Status0.Value)</Value>
</DataValue>
</DataValues>
<DataLabel/>
<Style>
<BackgroundColor>Red</BackgroundColor>
<BackgroundGradientEndColor>IndianRed</BackgroundGradientEndColor>
<BackgroundGradientType>TopBottom</BackgroundGradientType>
</Style>
<Marker>
<Size>6pt</Size>
</Marker>
</DataPoint>
</DataPoints>
</ChartSeries>
</ChartData>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BackgroundColor>White</BackgroundColor>
</Style>
</Chart>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TxtStatus1">
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Code.FormatNumber(Fields!Status1.Value,"#0.0", "%")</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TxtStatus0">
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Code.FormatNumber(Fields!Status0.Value,"#0.0", "%")</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.25in</Height>
</TableRow>
</TableRows>
<Grouping Name="table1_Details_Group">
<GroupExpressions>
<GroupExpression>=Fields!NodeRowId.Value</GroupExpression>
</GroupExpressions>
</Grouping>
</Details>
<Style>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
</Style>
<Header>
<TableRows>
<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="textbox3">
<rd:DefaultName>textbox3</rd:DefaultName>
<ZIndex>8</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BackgroundColor>Gray</BackgroundColor>
<Color>White</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<UserSort>
<SortExpression>=Fields!DeviceDisplayName.Value</SortExpression>
<SortExpressionScope>tblStatus_Group1</SortExpressionScope>
</UserSort>
<Value>=First(Fields!ManagedEntityTypeDefaultName.Value, "DeviceTypeDisplayName")</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="lblStatus">
<ZIndex>7</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BackgroundColor>Gray</BackgroundColor>
<Color>White</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value/>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="lblStatus1">
<ZIndex>6</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BackgroundColor>Gray</BackgroundColor>
<Color>White</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Available</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="lblStatus0">
<ZIndex>6</ZIndex>
<Style>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
<TextAlign>Center</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>DimGray</Default>
</BorderColor>
<BackgroundColor>Gray</BackgroundColor>
<Color>White</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>Not available</Value>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
<Height>0.35in</Height>
</TableRow>
</TableRows>
<RepeatOnNewPage>true</RepeatOnNewPage>
</Header>
<TableColumns>
<TableColumn>
<Width>2.1in</Width>
</TableColumn>
<TableColumn>
<Width>1.65in</Width>
</TableColumn>
<TableColumn>
<Width>0.55in</Width>
</TableColumn>
<TableColumn>
<Width>0.55in</Width>
</TableColumn>
</TableColumns>
<Height>0.85in</Height>
</Table>
<Rectangle Name="recReportDetails">
<ReportItems>
<Textbox Name="txtTargetCounter">
<Left>1.95in</Left>
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.45in</Top>
<ZIndex>10</ZIndex>
<Style>
<TextAlign>Left</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>=Count(Fields!DeviceRowId.Value, "SelectedObjectList") & " " & "element(s) found"</Value>
</Textbox>
<Image Name="imgSeparator">
<Sizing>Fit</Sizing>
<MIMEType/>
<Top>0.95in</Top>
<ZIndex>9</ZIndex>
<Source>External</Source>
<Style/>
<Value>../gradient_portrait.gif</Value>
</Image>
<List Name="lstTargetDevices">
<ReportItems>
<Textbox Name="txtTargetNames">
<Left>1.95in</Left>
<CanShrink>true</CanShrink>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Value>=Fields!DeviceDisplayName.Value</Value>
</Textbox>
</ReportItems>
<DataSetName>SelectedObjectList</DataSetName>
<Top>0.65in</Top>
<ZIndex>8</ZIndex>
<Visibility>
<ToggleItem>lbTargetlDeviceList</ToggleItem>
<Hidden>true</Hidden>
</Visibility>
<Style>
<BackgroundColor>Gainsboro</BackgroundColor>
</Style>
<DataInstanceElementOutput>NoOutput</DataInstanceElementOutput>
<Height>0.2in</Height>
</List>
<Textbox Name="lblSeparator3">
<Left>1.85in</Left>
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.45in</Top>
<ZIndex>7</ZIndex>
<Width>0.1in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>:</Value>
</Textbox>
<Textbox Name="lbTargetlDeviceList">
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.45in</Top>
<ZIndex>6</ZIndex>
<Width>1.85in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>Target Devices List</Value>
</Textbox>
<Textbox Name="txtGeneratedAt">
<Left>1.95in</Left>
<DataElementOutput>Output</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.05in</Top>
<ZIndex>5</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<CanGrow>true</CanGrow>
<DataElementName>Created</DataElementName>
<Height>0.2in</Height>
<Value>=Code.GetGeneratedAtTime(Parameters!TimeZoneName.Value)</Value>
</Textbox>
<Textbox Name="lblSeparator2">
<Left>1.85in</Left>
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.25in</Top>
<ZIndex>4</ZIndex>
<Width>0.1in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>:</Value>
</Textbox>
<Textbox Name="lblSeparator1">
<Left>1.85in</Left>
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.05in</Top>
<ZIndex>3</ZIndex>
<Width>0.1in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>:</Value>
</Textbox>
<Textbox Name="lblGeneratedAt">
<Left>0.2in</Left>
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.05in</Top>
<ZIndex>2</ZIndex>
<Width>1.65in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>Generated At</Value>
</Textbox>
<Textbox Name="txtReportStartEnd">
<Left>1.95in</Left>
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.25in</Top>
<ZIndex>1</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>=Code.SelectedDateValue(Parameters!StartDate.Value,Parameters!StartDate_BaseType.Value,Parameters!StartDate_OffsetType.Value,Parameters!StartDate_OffsetValue.Value) &" - "& Code.SelectedDateValue(Parameters!EndDate.Value,Parameters!EndDate_BaseType.Value,Parameters!EndDate_OffsetType.Value,Parameters!EndDate_OffsetValue.Value)</Value>
</Textbox>
<Textbox Name="lblReportStartEnd">
<Left>0.2in</Left>
<DataElementOutput>NoOutput</DataElementOutput>
<CanShrink>true</CanShrink>
<Top>0.25in</Top>
<Width>1.65in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>Report Start - End Time</Value>
</Textbox>
</ReportItems>
<Top>1.413in</Top>
<ZIndex>2</ZIndex>
<Height>1in</Height>
</Rectangle>
<Rectangle Name="rectangle2">
<ReportItems>
<Textbox Name="lblReportDescription">
<DataElementOutput>NoOutput</DataElementOutput>
<Top>0.3in</Top>
<ZIndex>2</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<VerticalAlign>Middle</VerticalAlign>
<Color>DimGray</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>Description</Value>
</Textbox>
<Textbox Name="txtReportTitle">
<Left>0.2in</Left>
<DataElementOutput>Output</DataElementOutput>
<Top>0.05in</Top>
<ZIndex>1</ZIndex>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontWeight>700</FontWeight>
<FontSize>11pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<DataElementStyle>ElementNormal</DataElementStyle>
<CanGrow>true</CanGrow>
<DataElementName>Title</DataElementName>
<Height>0.25in</Height>
<Value>Device availability - SNMP availability - Summary</Value>
</Textbox>
<Rectangle Name="recDescription">
<ReportItems>
<Textbox Name="txtReportDescription">
<Left>0.2in</Left>
<DataElementOutput>NoOutput</DataElementOutput>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.2in</Height>
<Value>This report provides summary information about the SNMP availability registered during a defined period for the monitored Cisco Nexus. Jalasoft Xian Network Manager collects data for this report (using the SNMP availability rule included in the Jalasoft Xian NM plug-in for Cisco Nexus).</Value>
</Textbox>
</ReportItems>
<Top>0.6in</Top>
<Visibility>
<ToggleItem>lblReportDescription</ToggleItem>
<Hidden>true</Hidden>
</Visibility>
<Style>
<BackgroundColor>Gainsboro</BackgroundColor>
</Style>
</Rectangle>
</ReportItems>
<Top>0.563in</Top>
<ZIndex>1</ZIndex>
<Style>
<BackgroundColor>Gainsboro</BackgroundColor>
</Style>
<Height>0.85in</Height>
</Rectangle>
<Image Name="imgReportHeader">
<Sizing>Fit</Sizing>
<MIMEType/>
<Source>External</Source>
<Style/>
<Height>0.563in</Height>
<Value>ReportHeaderLandscape.jpg</Value>
</Image>
</ReportItems>
<Height>6.05in</Height>
</Body>
<rd:ReportID>35a17b5f-7553-4dd3-8658-df45b62c3e23</rd:ReportID>
<LeftMargin>1in</LeftMargin>
<DataSets>
<DataSet Name="ReportDataEx">
<Query>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
<CommandText>EXEC SC_JSXIO_GetSummarizedStatusData_SP @StartDate, @EndDate , @DeviceType , @Counter , @States , @NodeType, @deviceId, @DWRuleName</CommandText>
<QueryParameters>
<QueryParameter Name="@StartDate">
<Value>=Code.GetNewTimeZone(Code.SelectedDateValue(Parameters!StartDate.Value,Parameters!StartDate_BaseType.Value,Parameters!StartDate_OffsetType.Value,Parameters!StartDate_OffsetValue.Value),Parameters!TimeZoneName.Value)</Value>
</QueryParameter>
<QueryParameter Name="@EndDate">
<Value>=Code.GetNewTimeZone(Code.SelectedDateValue(Parameters!EndDate.Value,Parameters!EndDate_BaseType.Value,Parameters!EndDate_OffsetType.Value,Parameters!EndDate_OffsetValue.Value),Parameters!TimeZoneName.Value)</Value>
</QueryParameter>
<QueryParameter Name="@DeviceType">
<Value>=Parameters!DeviceType.Value</Value>
</QueryParameter>
<QueryParameter Name="@Counter">
<Value>=Parameters!Counter.Value</Value>
</QueryParameter>
<QueryParameter Name="@States">
<Value>=Parameters!States.Value</Value>
</QueryParameter>
<QueryParameter Name="@NodeType">
<Value>=Parameters!NodeType.Value</Value>
</QueryParameter>
<QueryParameter Name="@deviceId">
<Value>=Parameters!deviceId.Value</Value>
</QueryParameter>
<QueryParameter Name="@DWRuleName">
<Value>=Parameters!RuleSystemName.Value</Value>
</QueryParameter>
</QueryParameters>
<DataSourceName>DataWarehouseMain</DataSourceName>
</Query>
<Fields>
<Field Name="DeviceRowId">
<DataField>DeviceRowId</DataField>
</Field>
<Field Name="DeviceDisplayName">
<DataField>DeviceDisplayName</DataField>
</Field>
<Field Name="NodeRowId">
<DataField>NodeRowId</DataField>
</Field>
<Field Name="NodeDisplayName">
<DataField>NodeDisplayName</DataField>
</Field>
<Field Name="Status1">
<DataField>Status1</DataField>
</Field>
<Field Name="Status0">
<DataField>Status0</DataField>
</Field>
</Fields>
</DataSet>
<DataSet Name="EntityList">
<Query>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
<CommandText>SELECT [ManagedEntityTypeSystemName], [ManagedEntityTypeRowId] FROM vManagedEntityType</CommandText>
<DataSourceName>DataWarehouseMain</DataSourceName>
</Query>
<Fields>
<Field Name="ManagedEntityTypeSystemName">
<rd:TypeName>System.String</rd:TypeName>
<DataField>ManagedEntityTypeSystemName</DataField>
</Field>
<Field Name="ManagedEntityTypeRowId">
<rd:TypeName>System.Int32</rd:TypeName>
<DataField>ManagedEntityTypeRowId</DataField>
</Field>
</Fields>
</DataSet>
<DataSet Name="SelectedObjectList">
<Query>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
<CommandText>EXEC SC_JSXIO_EnumerateNodes_SP @DeviceType, @DeviceType</CommandText>
<QueryParameters>
<QueryParameter Name="@DeviceType">
<Value>=Parameters!DeviceType.Value</Value>
</QueryParameter>
</QueryParameters>
<DataSourceName>DataWarehouseMain</DataSourceName>
</Query>
<Fields>
<Field Name="DeviceRowId">
<rd:TypeName>System.Int32</rd:TypeName>
<DataField>DeviceRowId</DataField>
</Field>
<Field Name="DeviceDisplayName">
<rd:TypeName>System.String</rd:TypeName>
<DataField>DeviceDisplayName</DataField>
</Field>
<Field Name="NodeRowId">
<rd:TypeName>System.Int32</rd:TypeName>
<DataField>NodeRowId</DataField>
</Field>
<Field Name="NodeDisplayName">
<rd:TypeName>System.String</rd:TypeName>
<DataField>NodeDisplayName</DataField>
</Field>
</Fields>
</DataSet>
<DataSet Name="DateRange">
<Query>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
<CommandText>SELECT * FROM SC_JSXIO_GetDateRange_F(7)</CommandText>
<DataSourceName>DataWarehouseMain</DataSourceName>
</Query>
<Fields>
<Field Name="BeginDate">
<rd:TypeName>System.DateTime</rd:TypeName>
<DataField>BeginDate</DataField>
</Field>
<Field Name="EndDate">
<rd:TypeName>System.DateTime</rd:TypeName>
<DataField>EndDate</DataField>
</Field>
</Fields>
</DataSet>
<DataSet Name="DeviceTypeDisplayName">
<Query>
<rd:UseGenericDesigner>true</rd:UseGenericDesigner>
<CommandText>DECLARE @DeviceTypeAux VARCHAR(MAX)
SET @DeviceTypeAux = SUBSTRING(@DeviceType,1,CHARINDEX(';',@DeviceType)-1)
SELECT [ManagedEntityTypeDefaultName] FROM vManagedEntityType WHERE [ManagedEntityTypeSystemName] LIKE @DeviceTypeAux</CommandText>
<QueryParameters>
<QueryParameter Name="@DeviceType">
<Value>=Parameters!DeviceType.Value</Value>
</QueryParameter>
</QueryParameters>
<DataSourceName>DataWarehouseMain</DataSourceName>
</Query>
<Fields>
<Field Name="ManagedEntityTypeDefaultName">
<rd:TypeName>System.String</rd:TypeName>
<DataField>ManagedEntityTypeDefaultName</DataField>
</Field>
</Fields>
</DataSet>
</DataSets>
<Author>Jalasoft Corporation</Author>
<Code>
private function FirstDayMonth() As DateTime
return DateAdd("d",-Today.Day()+1,Today())
end function
private function FirstDayQuarter() As DateTime
return DateAdd("q",DATEDIFF("q",FirstDayYear(),Now()),FirstDayYear())
end function
private function FirstDayYear() As DateTime
return DateAdd("m",-Today.Month()+1,FirstDayMonth())
end function
public function SelectedDateValue(aSpecificDateTime, aBaseType, aOffsetType, aOffsetValue) As DateTime
Dim specificDateTime As DateTime
Dim hours As Integer
Dim minutes As Integer
select case aBaseType
case "Fixed"
return aSpecificDateTime
case "Today"
specificDateTime = Today()
case "Sunday"
specificDateTime = DateAdd("d",1-Weekday(Today()),Today())
case "Monday"
specificDateTime = DateAdd("d",2-Weekday(Today()),Today())
case "Tuesday"
specificDateTime = DateAdd("d",3-Weekday(Today()),Today())
case "Wednesday"
specificDateTime = DateAdd("d",4-Weekday(Today()),Today())
case "Thursday"
specificDateTime = DateAdd("d",5-Weekday(Today()),Today())
case "Friday"
specificDateTime = DateAdd("d",6-Weekday(Today()),Today())
case "Saturday"
specificDateTime = DateAdd("d",7-Weekday(Today()),Today())
case "FirstDayMonth"
specificDateTime = FirstDayMonth()
case "LastDayMonth"
specificDateTime = DateAdd("d",-1,DateAdd("m",1,FirstDayMonth()))
case "FirstDayQuarter"
specificDateTime = FirstDayQuarter()
case "LastDayQuarter"
specificDateTime = DateAdd("d",-1,DateAdd("q",1,FirstDayQuarter()))
case "FirstDayYear"
specificDateTime = FirstDayYear()
case "LastDayYear"
specificDateTime = DateAdd("m",11,DateAdd("d",30,FirstDayYear()))
end select
hours = Hour(aSpecificDateTime)
minutes = Minute(aSpecificDateTime)
if (aOffsetType = "None")
return DateAdd("n",minutes,DateAdd("h",hours,specificDateTime))
else
if (aBaseType = "LastDayMonth" AND aOffsetType = "Month")
specificDateTime = DateAdd("d",-1,DateAdd("m",aOffsetValue+1,FirstDayMonth()))
else if (aBaseType = "LastDayQuarter" AND aOffsetType = "Quarter")
specificDateTime = DateAdd("d",-1,DateAdd("q",aOffsetValue+1,FirstDayQuarter()))
else
specificDateTime = DateAdd(DateTimeType(aOffsetType),aOffsetValue,specificDateTime)
end if
end if
return DateAdd("n",minutes,DateAdd("h",hours,specificDateTime))
end function
private function DateTimeType(aOffsetType) As String
select case aOffsetType
case "Day"
return "d"
case "Week"
return "ww"
case "Month"
return "m"
case "Quarter"
return "q"
case "Year"
return "yyyy"
end select
end function
public function GetGeneratedAtTime(aTimeZone) As String
Dim hours As Integer
Dim minutes As Integer
Dim diffUtcServerTime As Integer
hours = System.TimeZone.CurrentTimeZone.GetUtcOffset(DateTime.Now).Hours
minutes = System.TimeZone.CurrentTimeZone.GetUtcOffset(DateTime.Now).Minutes
diffUtcServerTime = hours * 60
if (hours > 0)
diffUtcServerTime = diffUtcServerTime + minutes
else
diffUtcServerTime = diffUtcServerTime - minutes
end if
return DateAdd("n",(diffUtcServerTime *(-1)) + GetTimeZoneMinutesDiff(aTimeZone), Now())
end function
public function GetTimeZoneMinutesDiff(aTimeZone) As Integer
Dim minutes As Integer
if (Mid(aTimeZone,5,1) = ")")
return 0
else
minutes = CInt(Mid(aTimeZone,6,2))*60 + CInt(Mid(aTimeZone,9,2))
return CInt(Mid(aTimeZone,5,1) + CStr(minutes))
end if
end function
public function GetNewTimeZone(aSelectedDate, aTimeZone) As DateTime
return DateAdd("n",GetTimeZoneMinutesDiff(aTimeZone)*(-1), aSelectedDate)
end function
public function FormatNumber(fieldValue, formatString, unit) as string
if (fieldValue is Nothing)
FormatNumber = "N/A"
else
FormatNumber = Format(fieldValue,formatString) & " " & unit
end if
end function</Code>
<Width>9in</Width>
<InteractiveHeight>8.5in</InteractiveHeight>
<Language>en-US</Language>
<PageFooter>
<ReportItems>
<Textbox Name="lblPageNumber">
<Left>7.1in</Left>
<Top>0.13125in</Top>
<ZIndex>1</ZIndex>
<Width>1.7in</Width>
<Style>
<TextAlign>Right</TextAlign>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<Color>DimGray</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.1875in</Height>
<Value>="Page " & Globals.PageNumber & "/" & Globals.TotalPages</Value>
</Textbox>
<Textbox Name="lblJalasoft">
<Left>0.1in</Left>
<Top>0.15in</Top>
<Action>
<Hyperlink>http://www.jalasoft.com</Hyperlink>
</Action>
<Width>1.1in</Width>
<Style>
<PaddingLeft>2pt</PaddingLeft>
<PaddingBottom>2pt</PaddingBottom>
<FontFamily>Tahoma</FontFamily>
<FontSize>8pt</FontSize>
<Color>DimGray</Color>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
</Style>
<CanGrow>true</CanGrow>
<Height>0.1875in</Height>
<Value>Jalasoft Corporation</Value>
</Textbox>
</ReportItems>
<Height>0.45in</Height>
<PrintOnLastPage>true</PrintOnLastPage>
<PrintOnFirstPage>true</PrintOnFirstPage>
</PageFooter>
<TopMargin>1in</TopMargin>
<PageHeight>8.5in</PageHeight>
</Report>
</Definition>
</Report>