Create a report for router availability

Need help in creating a report to show router availability, need to include average availability, system up time, time device went offline (if applicable) and time device came back online - i have managed to get as far as - Average availability, Status description & system up time (days - which is displaying incorrect information when a node is down it stating for example systems up time (days) 1440 ????

thanks in advance 

Parents
  • What about this report and then just filtering it for your specific device type?

  • Thank you for this - how do i get it just to pick up the correct device type ?

  • ideally i need an entry in the swql for current node status, and system uptime

    somewhere in with this:-

    Nodes].DetailsUrl
    , [Nodes].VendorInfo.Icon
    , [ResponseTime].Day
    , [ResponseTime].Availability
    , [Downtime].MinutesDown
    , [Downtime].CalcAvailability
    , [Events].RebootCount

  • and i cant add any more columns- its swql format 

  • this was my original request - Need help in creating a report to show router availability, need to include average availability, system up time, time device went offline (if applicable) and time device came back online, reboot events, currrent node status 

  • Any help on this would be appreciated 

  • Hi Jason, I think the reason nobody has replied is that what you are asking isn't an easy task, in fact, I would wager that the combination of those fields might be impossible due to the nature of the difference between Average Availability vs Individual Events

    I tried loading the report on my own platform and it doesn't even work, which is a little frustrating. Can you extract both reports from your environment and upload them here so I can take a better look at the code? I can't promise anything, but I'll take a look.

  • Please see below codes 

    ITEM+-+H&B+Stores+Currently+Down.xml
    <Report xmlns="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models" xmlns:i="http://www.w3.org/2001/XMLSchema-instance"><Category>Current Node Status</Category><Configs xmlns:a="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Data"><a:ConfigurationData i:type="b:TableConfiguration" xmlns:b="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Tables"><a:DisplaySubTitle/><a:DisplayTitle>Down Nodes</a:DisplayTitle><a:RefId>83af32cd-b56a-4c71-bb13-bb7b2e047aa4</a:RefId><b:Columns><b:TableColumn><b:CellStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:CellStyle><b:DataColumnName i:nil="true"/><b:DisplayName>VendorIcon</b:DisplayName><b:Field xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"><c:DataTypeInfo><a:ApplicationType i:nil="true"/><a:DataType><a:Data>System.String</a:Data></a:DataType><a:DeclType>Text</a:DeclType><a:DefaultAggregation>NotSpecified</a:DefaultAggregation><a:DefaultDataUnitId i:nil="true"/><a:DefaultTransformId i:nil="true"/><a:Description/><a:IsFavorite>false</a:IsFavorite><a:IsFilterBy>false</a:IsFilterBy><a:IsGroupBy>false</a:IsGroupBy><a:IsInherited>false</a:IsInherited><a:IsManaged>true</a:IsManaged><a:IsStatistic>false</a:IsStatistic><a:PreviewValue>9.gif</a:PreviewValue><a:Units/><a:UtcTimeIsInLocalTime>false</a:UtcTimeIsInLocalTime></c:DataTypeInfo><c:DisplayName>VendorIcon</c:DisplayName><c:NavigationPath i:nil="true"/><c:OwnerDisplayName>Node</c:OwnerDisplayName><c:RefID><c:Data>Orion.Nodes|VendorIcon</c:Data></c:RefID></b:Field><b:FixedWidth i:nil="true"/><b:HeaderStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:HeaderStyle><b:IsHTMLTagsAllowed>false</b:IsHTMLTagsAllowed><b:IsHidden>true</b:IsHidden><b:PercentWidth i:nil="true"/><b:Presenters i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Presentation"/><b:PropertyName>Node/VendorIcon</b:PropertyName><b:RefId>55c67b36-4a41-6094-541a-b568f236c2b6</b:RefId><b:Summary><b:Calculation>NotSpecified</b:Calculation><b:CellStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/></b:Summary><b:TransformId/><b:ValidRange>NotSpecified</b:ValidRange></b:TableColumn><b:TableColumn><b:CellStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:CellStyle><b:DataColumnName i:nil="true"/><b:DisplayName>NODE</b:DisplayName><b:Field xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"><c:DataTypeInfo><a:ApplicationType i:nil="true"/><a:DataType><a:Data>System.String</a:Data></a:DataType><a:DeclType>Text</a:DeclType><a:DefaultAggregation>NotSpecified</a:DefaultAggregation><a:DefaultDataUnitId i:nil="true"/><a:DefaultTransformId i:nil="true"/><a:Description/><a:IsFavorite>false</a:IsFavorite><a:IsFilterBy>true</a:IsFilterBy><a:IsGroupBy>true</a:IsGroupBy><a:IsInherited>false</a:IsInherited><a:IsManaged>true</a:IsManaged><a:IsStatistic>false</a:IsStatistic><a:PreviewValue>csrepark2a.corp.hollandandbarrett.net</a:PreviewValue><a:Units/><a:UtcTimeIsInLocalTime>false</a:UtcTimeIsInLocalTime></c:DataTypeInfo><c:DisplayName>Caption</c:DisplayName><c:NavigationPath i:nil="true"/><c:OwnerDisplayName>Node</c:OwnerDisplayName><c:RefID><c:Data>Orion.Nodes|Caption</c:Data></c:RefID></b:Field><b:FixedWidth i:nil="true"/><b:HeaderStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:HeaderStyle><b:IsHTMLTagsAllowed>false</b:IsHTMLTagsAllowed><b:IsHidden>false</b:IsHidden><b:PercentWidth i:nil="true"/><b:Presenters xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Presentation"><c:PresenterRef><c:PresenterId>orion.core.link.entity</c:PresenterId><c:Values><a:ContextValue><a:Name>EnabledTooltips</a:Name><a:Value>on</a:Value></a:ContextValue></c:Values></c:PresenterRef><c:PresenterRef><c:PresenterId>orion.core.image.vendor.watermark</c:PresenterId><c:Values><a:ContextValue><a:Name>imageformat</a:Name><a:Value>/netperfmon/images/vendors/{0}</a:Value></a:ContextValue></c:Values></c:PresenterRef></b:Presenters><b:PropertyName>Node/Caption</b:PropertyName><b:RefId>4967623f-fbd2-fa33-4436-8daf0549f850</b:RefId><b:Summary><b:Calculation>NotSpecified</b:Calculation><b:CellStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/></b:Summary><b:TransformId/><b:ValidRange>NotSpecified</b:ValidRange></b:TableColumn><b:TableColumn><b:CellStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:CellStyle><b:DataColumnName i:nil="true"/><b:DisplayName>IP Address</b:DisplayName><b:Field xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"><c:DataTypeInfo><a:ApplicationType>Core.IPAddress</a:ApplicationType><a:DataType><a:Data>System.String</a:Data></a:DataType><a:DeclType>Text</a:DeclType><a:DefaultAggregation>NotSpecified</a:DefaultAggregation><a:DefaultDataUnitId i:nil="true"/><a:DefaultTransformId i:nil="true"/><a:Description/><a:IsFavorite>false</a:IsFavorite><a:IsFilterBy>true</a:IsFilterBy><a:IsGroupBy>true</a:IsGroupBy><a:IsInherited>false</a:IsInherited><a:IsManaged>true</a:IsManaged><a:IsStatistic>false</a:IsStatistic><a:PreviewValue>10.201.119.132</a:PreviewValue><a:Units/><a:UtcTimeIsInLocalTime>false</a:UtcTimeIsInLocalTime></c:DataTypeInfo><c:DisplayName>IP Address</c:DisplayName><c:NavigationPath i:nil="true"/><c:OwnerDisplayName>Node</c:OwnerDisplayName><c:RefID><c:Data>Orion.Nodes|IPAddress</c:Data></c:RefID></b:Field><b:FixedWidth i:nil="true"/><b:HeaderStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:HeaderStyle><b:IsHTMLTagsAllowed>false</b:IsHTMLTagsAllowed><b:IsHidden>false</b:IsHidden><b:PercentWidth i:nil="true"/><b:Presenters i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Presentation"/><b:PropertyName>Node/IP Address</b:PropertyName><b:RefId>27968fbe-0799-057f-a05b-d779862ea492</b:RefId><b:Summary><b:Calculation>NotSpecified</b:Calculation><b:CellStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/></b:Summary><b:TransformId/><b:ValidRange>NotSpecified</b:ValidRange></b:TableColumn><b:TableColumn><b:CellStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:CellStyle><b:DataColumnName i:nil="true"/><b:DisplayName>Status LED</b:DisplayName><b:Field xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"><c:DataTypeInfo><a:ApplicationType>System.Status.LED</a:ApplicationType><a:DataType><a:Data>System.String</a:Data></a:DataType><a:DeclType>Text</a:DeclType><a:DefaultAggregation>NotSpecified</a:DefaultAggregation><a:DefaultDataUnitId i:nil="true"/><a:DefaultTransformId i:nil="true"/><a:Description/><a:IsFavorite>false</a:IsFavorite><a:IsFilterBy>false</a:IsFilterBy><a:IsGroupBy>false</a:IsGroupBy><a:IsInherited>false</a:IsInherited><a:IsManaged>true</a:IsManaged><a:IsStatistic>false</a:IsStatistic><a:PreviewValue>Up.gif</a:PreviewValue><a:Units/><a:UtcTimeIsInLocalTime>false</a:UtcTimeIsInLocalTime></c:DataTypeInfo><c:DisplayName>StatusLED</c:DisplayName><c:NavigationPath i:nil="true"/><c:OwnerDisplayName>Node</c:OwnerDisplayName><c:RefID><c:Data>Orion.Nodes|StatusLED</c:Data></c:RefID></b:Field><b:FixedWidth i:nil="true"/><b:HeaderStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:HeaderStyle><b:IsHTMLTagsAllowed>false</b:IsHTMLTagsAllowed><b:IsHidden>true</b:IsHidden><b:PercentWidth i:nil="true"/><b:Presenters xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Presentation"><c:PresenterRef><c:PresenterId>orion.core.image.status</c:PresenterId><c:Values><a:ContextValue><a:Name>imageFormat</a:Name><a:Value>/orion/images/statusicons/small-{0}</a:Value></a:ContextValue></c:Values></c:PresenterRef></b:Presenters><b:PropertyName>Node/StatusLED</b:PropertyName><b:RefId>0ceb2071-1a7a-eb4e-ca1f-caf2e56c8c1b</b:RefId><b:Summary><b:Calculation>NotSpecified</b:Calculation><b:CellStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/></b:Summary><b:TransformId/><b:ValidRange>NotSpecified</b:ValidRange></b:TableColumn><b:TableColumn><b:CellStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:CellStyle><b:DataColumnName i:nil="true"/><b:DisplayName>Status</b:DisplayName><b:Field xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"><c:DataTypeInfo><a:ApplicationType>Core.NodeStatus</a:ApplicationType><a:DataType><a:Data>System.Int32</a:Data></a:DataType><a:DeclType>Enumerated</a:DeclType><a:DefaultAggregation>NotSpecified</a:DefaultAggregation><a:DefaultDataUnitId i:nil="true"/><a:DefaultTransformId i:nil="true"/><a:Description/><a:IsFavorite>false</a:IsFavorite><a:IsFilterBy>true</a:IsFilterBy><a:IsGroupBy>true</a:IsGroupBy><a:IsInherited>false</a:IsInherited><a:IsManaged>true</a:IsManaged><a:IsStatistic>false</a:IsStatistic><a:PreviewValue>Up</a:PreviewValue><a:Units/><a:UtcTimeIsInLocalTime>false</a:UtcTimeIsInLocalTime></c:DataTypeInfo><c:DisplayName>Status</c:DisplayName><c:NavigationPath i:nil="true"/><c:OwnerDisplayName>Node</c:OwnerDisplayName><c:RefID><c:Data>Orion.Nodes|Status</c:Data></c:RefID></b:Field><b:FixedWidth i:nil="true"/><b:HeaderStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:HeaderStyle><b:IsHTMLTagsAllowed>false</b:IsHTMLTagsAllowed><b:IsHidden>false</b:IsHidden><b:PercentWidth i:nil="true"/><b:Presenters xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Presentation"><c:PresenterRef><c:PresenterId>orion.core.image.status.watermark</c:PresenterId><c:Values><a:ContextValue><a:Name>watermarkSource</a:Name><a:Value>Column</a:Value></a:ContextValue></c:Values></c:PresenterRef></b:Presenters><b:PropertyName>Node/Status</b:PropertyName><b:RefId>f3b7bfe9-dd40-6a11-2154-a3563fc532ee</b:RefId><b:Summary><b:Calculation>NotSpecified</b:Calculation><b:CellStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/></b:Summary><b:TransformId>orion.transformer.nodestatus.shortdescription</b:TransformId><b:ValidRange>NotSpecified</b:ValidRange></b:TableColumn><b:TableColumn><b:CellStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:CellStyle><b:DataColumnName i:nil="true"/><b:DisplayName>AssetTag</b:DisplayName><b:Field xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"><c:DataTypeInfo><a:ApplicationType i:nil="true"/><a:DataType><a:Data>System.String</a:Data></a:DataType><a:DeclType>Text</a:DeclType><a:DefaultAggregation>NotSpecified</a:DefaultAggregation><a:DefaultDataUnitId i:nil="true"/><a:DefaultTransformId i:nil="true"/><a:Description>The role of the network device</a:Description><a:IsFavorite>false</a:IsFavorite><a:IsFilterBy>true</a:IsFilterBy><a:IsGroupBy>true</a:IsGroupBy><a:IsInherited>false</a:IsInherited><a:IsManaged>false</a:IsManaged><a:IsStatistic>false</a:IsStatistic><a:PreviewValue>Servers</a:PreviewValue><a:Units/><a:UtcTimeIsInLocalTime>true</a:UtcTimeIsInLocalTime></c:DataTypeInfo><c:DisplayName>AssetTag</c:DisplayName><c:NavigationPath>CustomProperties</c:NavigationPath><c:OwnerDisplayName>Nodes Custom Properties</c:OwnerDisplayName><c:RefID><c:Data>Orion.NodesCustomProperties|AssetTag|CustomProperties</c:Data></c:RefID></b:Field><b:FixedWidth i:nil="true"/><b:HeaderStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:HeaderStyle><b:IsHTMLTagsAllowed>false</b:IsHTMLTagsAllowed><b:IsHidden>false</b:IsHidden><b:PercentWidth i:nil="true"/><b:Presenters i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Presentation"/><b:PropertyName>Nodes Custom Properties/AssetTag</b:PropertyName><b:RefId>0d910c25-e86d-ee45-9735-ae8dd9d69589</b:RefId><b:Summary><b:Calculation>NotSpecified</b:Calculation><b:CellStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/></b:Summary><b:TransformId/><b:ValidRange>NotSpecified</b:ValidRange></b:TableColumn><b:TableColumn><b:CellStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:CellStyle><b:DataColumnName i:nil="true"/><b:DisplayName>City</b:DisplayName><b:Field xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"><c:DataTypeInfo><a:ApplicationType i:nil="true"/><a:DataType><a:Data>System.String</a:Data></a:DataType><a:DeclType>Text</a:DeclType><a:DefaultAggregation>NotSpecified</a:DefaultAggregation><a:DefaultDataUnitId i:nil="true"/><a:DefaultTransformId i:nil="true"/><a:Description>City where the Node is located</a:Description><a:IsFavorite>false</a:IsFavorite><a:IsFilterBy>true</a:IsFilterBy><a:IsGroupBy>true</a:IsGroupBy><a:IsInherited>false</a:IsInherited><a:IsManaged>false</a:IsManaged><a:IsStatistic>false</a:IsStatistic><a:PreviewValue>Nuneaton</a:PreviewValue><a:Units/><a:UtcTimeIsInLocalTime>true</a:UtcTimeIsInLocalTime></c:DataTypeInfo><c:DisplayName>City</c:DisplayName><c:NavigationPath>CustomProperties</c:NavigationPath><c:OwnerDisplayName>Nodes Custom Properties</c:OwnerDisplayName><c:RefID><c:Data>Orion.NodesCustomProperties|City|CustomProperties</c:Data></c:RefID></b:Field><b:FixedWidth i:nil="true"/><b:HeaderStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:HeaderStyle><b:IsHTMLTagsAllowed>false</b:IsHTMLTagsAllowed><b:IsHidden>false</b:IsHidden><b:PercentWidth i:nil="true"/><b:Presenters i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Presentation"/><b:PropertyName>Nodes Custom Properties/City</b:PropertyName><b:RefId>cbeacc89-7649-396d-7dba-ca3eca5c58d9</b:RefId><b:Summary><b:Calculation>NotSpecified</b:Calculation><b:CellStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/></b:Summary><b:TransformId/><b:ValidRange>NotSpecified</b:ValidRange></b:TableColumn><b:TableColumn><b:CellStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:CellStyle><b:DataColumnName i:nil="true"/><b:DisplayName>Stores</b:DisplayName><b:Field xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"><c:DataTypeInfo><a:ApplicationType i:nil="true"/><a:DataType><a:Data>System.Boolean</a:Data></a:DataType><a:DeclType>Boolean</a:DeclType><a:DefaultAggregation>NotSpecified</a:DefaultAggregation><a:DefaultDataUnitId i:nil="true"/><a:DefaultTransformId i:nil="true"/><a:Description/><a:IsFavorite>false</a:IsFavorite><a:IsFilterBy>true</a:IsFilterBy><a:IsGroupBy>true</a:IsGroupBy><a:IsInherited>false</a:IsInherited><a:IsManaged>false</a:IsManaged><a:IsStatistic>false</a:IsStatistic><a:PreviewValue>False</a:PreviewValue><a:Units/><a:UtcTimeIsInLocalTime>true</a:UtcTimeIsInLocalTime></c:DataTypeInfo><c:DisplayName>Stores</c:DisplayName><c:NavigationPath>CustomProperties</c:NavigationPath><c:OwnerDisplayName>Nodes Custom Properties</c:OwnerDisplayName><c:RefID><c:Data>Orion.NodesCustomProperties|Stores|CustomProperties</c:Data></c:RefID></b:Field><b:FixedWidth i:nil="true"/><b:HeaderStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:HeaderStyle><b:IsHTMLTagsAllowed>false</b:IsHTMLTagsAllowed><b:IsHidden>false</b:IsHidden><b:PercentWidth i:nil="true"/><b:Presenters i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Presentation"/><b:PropertyName>Nodes Custom Properties/Stores</b:PropertyName><b:RefId>678db582-adcb-5763-4fd2-3c81cb456c06</b:RefId><b:Summary><b:Calculation>NotSpecified</b:Calculation><b:CellStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/></b:Summary><b:TransformId/><b:ValidRange>NotSpecified</b:ValidRange></b:TableColumn><b:TableColumn><b:CellStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:CellStyle><b:DataColumnName i:nil="true"/><b:DisplayName>% Packet Loss</b:DisplayName><b:Field xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"><c:DataTypeInfo><a:ApplicationType i:nil="true"/><a:DataType><a:Data>System.Single</a:Data></a:DataType><a:DeclType>Float</a:DeclType><a:DefaultAggregation>NotSpecified</a:DefaultAggregation><a:DefaultDataUnitId i:nil="true"/><a:DefaultTransformId i:nil="true"/><a:Description/><a:IsFavorite>false</a:IsFavorite><a:IsFilterBy>false</a:IsFilterBy><a:IsGroupBy>false</a:IsGroupBy><a:IsInherited>false</a:IsInherited><a:IsManaged>false</a:IsManaged><a:IsStatistic>false</a:IsStatistic><a:PreviewValue>0 %</a:PreviewValue><a:Units>%</a:Units><a:UtcTimeIsInLocalTime>false</a:UtcTimeIsInLocalTime></c:DataTypeInfo><c:DisplayName>% Packet Loss</c:DisplayName><c:NavigationPath>Stats</c:NavigationPath><c:OwnerDisplayName>Node Current Statistics</c:OwnerDisplayName><c:RefID><c:Data>Orion.NodesStats|PercentLoss|Stats</c:Data></c:RefID></b:Field><b:FixedWidth i:nil="true"/><b:HeaderStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:HeaderStyle><b:IsHTMLTagsAllowed>false</b:IsHTMLTagsAllowed><b:IsHidden>false</b:IsHidden><b:PercentWidth i:nil="true"/><b:Presenters xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Presentation"><c:PresenterRef><c:PresenterId>orion.core.text.numericformat</c:PresenterId><c:Values><a:ContextValue><a:Name>NumericFormat</a:Name><a:Value>{0} %</a:Value></a:ContextValue></c:Values></c:PresenterRef></b:Presenters><b:PropertyName>Node Current Statistics/% Packet Loss</b:PropertyName><b:RefId>39c9729c-72fe-531f-dd50-a3be6903c7a2</b:RefId><b:Summary><b:Calculation>NotSpecified</b:Calculation><b:CellStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/></b:Summary><b:TransformId/><b:ValidRange>NotSpecified</b:ValidRange></b:TableColumn><b:TableColumn><b:CellStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:CellStyle><b:DataColumnName i:nil="true"/><b:DisplayName>Last Boot</b:DisplayName><b:Field xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"><c:DataTypeInfo><a:ApplicationType i:nil="true"/><a:DataType><a:Data>System.DateTime</a:Data></a:DataType><a:DeclType>DateTime</a:DeclType><a:DefaultAggregation>NotSpecified</a:DefaultAggregation><a:DefaultDataUnitId i:nil="true"/><a:DefaultTransformId i:nil="true"/><a:Description/><a:IsFavorite>false</a:IsFavorite><a:IsFilterBy>false</a:IsFilterBy><a:IsGroupBy>false</a:IsGroupBy><a:IsInherited>false</a:IsInherited><a:IsManaged>true</a:IsManaged><a:IsStatistic>false</a:IsStatistic><a:PreviewValue>29/05/2020 10:29:00</a:PreviewValue><a:Units/><a:UtcTimeIsInLocalTime>false</a:UtcTimeIsInLocalTime></c:DataTypeInfo><c:DisplayName>Last Boot</c:DisplayName><c:NavigationPath i:nil="true"/><c:OwnerDisplayName>Node</c:OwnerDisplayName><c:RefID><c:Data>Orion.Nodes|LastBoot</c:Data></c:RefID></b:Field><b:FixedWidth i:nil="true"/><b:HeaderStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:HeaderStyle><b:IsHTMLTagsAllowed>false</b:IsHTMLTagsAllowed><b:IsHidden>false</b:IsHidden><b:PercentWidth i:nil="true"/><b:Presenters i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Presentation"/><b:PropertyName>Node/Last Boot</b:PropertyName><b:RefId>fce3d9f1-8dea-4482-7101-7337e41524fe</b:RefId><b:Summary><b:Calculation>NotSpecified</b:Calculation><b:CellStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/></b:Summary><b:TransformId/><b:ValidRange>NotSpecified</b:ValidRange></b:TableColumn><b:TableColumn><b:CellStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:CellStyle><b:DataColumnName i:nil="true"/><b:DisplayName>Percent Down</b:DisplayName><b:Field xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"><c:DataTypeInfo><a:ApplicationType>Core.Percent</a:ApplicationType><a:DataType><a:Data>System.Double</a:Data></a:DataType><a:DeclType>Float</a:DeclType><a:DefaultAggregation>Average</a:DefaultAggregation><a:DefaultDataUnitId i:nil="true"/><a:DefaultTransformId i:nil="true"/><a:Description/><a:IsFavorite>false</a:IsFavorite><a:IsFilterBy>false</a:IsFilterBy><a:IsGroupBy>false</a:IsGroupBy><a:IsInherited>false</a:IsInherited><a:IsManaged>false</a:IsManaged><a:IsStatistic>true</a:IsStatistic><a:PreviewValue i:nil="true"/><a:Units/><a:UtcTimeIsInLocalTime>false</a:UtcTimeIsInLocalTime></c:DataTypeInfo><c:DisplayName>Percent Down</c:DisplayName><c:NavigationPath>ResponseTimeHistory</c:NavigationPath><c:OwnerDisplayName>Response Time History</c:OwnerDisplayName><c:RefID><c:Data>Orion.ResponseTime|PercentDown|ResponseTimeHistory</c:Data></c:RefID></b:Field><b:FixedWidth i:nil="true"/><b:HeaderStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:HeaderStyle><b:IsHTMLTagsAllowed>false</b:IsHTMLTagsAllowed><b:IsHidden>false</b:IsHidden><b:PercentWidth i:nil="true"/><b:Presenters xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Presentation"><c:PresenterRef><c:PresenterId>orion.core.text.numericformat</c:PresenterId><c:Values><a:ContextValue><a:Name>NumericFormat</a:Name><a:Value>{0:0.00} %</a:Value></a:ContextValue></c:Values></c:PresenterRef></b:Presenters><b:PropertyName>Response Time History/Percent Down</b:PropertyName><b:RefId>7b631b98-c46c-d982-7ae1-5909535c3f57</b:RefId><b:Summary><b:Calculation>Average</b:Calculation><b:CellStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/></b:Summary><b:TransformId/><b:ValidRange>NotSpecified</b:ValidRange></b:TableColumn><b:TableColumn><b:CellStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:CellStyle><b:DataColumnName i:nil="true"/><b:DisplayName>Description</b:DisplayName><b:Field xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"><c:DataTypeInfo><a:ApplicationType i:nil="true"/><a:DataType><a:Data>System.String</a:Data></a:DataType><a:DeclType>Text</a:DeclType><a:DefaultAggregation>NotSpecified</a:DefaultAggregation><a:DefaultDataUnitId i:nil="true"/><a:DefaultTransformId i:nil="true"/><a:Description/><a:IsFavorite>false</a:IsFavorite><a:IsFilterBy>true</a:IsFilterBy><a:IsGroupBy>false</a:IsGroupBy><a:IsInherited>true</a:IsInherited><a:IsManaged>false</a:IsManaged><a:IsStatistic>false</a:IsStatistic><a:PreviewValue i:nil="true"/><a:Units/><a:UtcTimeIsInLocalTime>false</a:UtcTimeIsInLocalTime></c:DataTypeInfo><c:DisplayName>Description</c:DisplayName><c:NavigationPath>VendorInfo</c:NavigationPath><c:OwnerDisplayName>Vendors</c:OwnerDisplayName><c:RefID><c:Data>Orion.Vendors|Description|VendorInfo</c:Data></c:RefID></b:Field><b:FixedWidth i:nil="true"/><b:HeaderStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:HeaderStyle><b:IsHTMLTagsAllowed>false</b:IsHTMLTagsAllowed><b:IsHidden>false</b:IsHidden><b:PercentWidth i:nil="true"/><b:Presenters i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Presentation"/><b:PropertyName>Vendors/Description</b:PropertyName><b:RefId>ce2b7f90-4509-f755-1f56-4e16398ad939</b:RefId><b:Summary><b:Calculation>NotSpecified</b:Calculation><b:CellStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/></b:Summary><b:TransformId/><b:ValidRange>NotSpecified</b:ValidRange></b:TableColumn><b:TableColumn><b:CellStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:CellStyle><b:DataColumnName i:nil="true"/><b:DisplayName>Timestamp</b:DisplayName><b:Field xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"><c:DataTypeInfo><a:ApplicationType i:nil="true"/><a:DataType><a:Data>System.DateTime</a:Data></a:DataType><a:DeclType>DateTime</a:DeclType><a:DefaultAggregation>NotSpecified</a:DefaultAggregation><a:DefaultDataUnitId i:nil="true"/><a:DefaultTransformId i:nil="true"/><a:Description/><a:IsFavorite>false</a:IsFavorite><a:IsFilterBy>false</a:IsFilterBy><a:IsGroupBy>false</a:IsGroupBy><a:IsInherited>true</a:IsInherited><a:IsManaged>false</a:IsManaged><a:IsStatistic>true</a:IsStatistic><a:PreviewValue i:nil="true"/><a:Units/><a:UtcTimeIsInLocalTime>false</a:UtcTimeIsInLocalTime></c:DataTypeInfo><c:DisplayName>Timestamp</c:DisplayName><c:NavigationPath>ResponseTimeHistory</c:NavigationPath><c:OwnerDisplayName>Response Time History</c:OwnerDisplayName><c:RefID><c:Data>Orion.ResponseTime|ObservationTimestamp|ResponseTimeHistory</c:Data></c:RefID></b:Field><b:FixedWidth i:nil="true"/><b:HeaderStyle xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><c:BackgroundColor i:nil="true"/><c:Borders i:nil="true"/><c:DisplayName i:nil="true"/><c:Font i:nil="true"/><c:Padding i:nil="true"/><c:RefId>00000000-0000-0000-0000-000000000000</c:RefId><c:TextAlign>Left</c:TextAlign><c:ZebraBackgroundColor i:nil="true"/></b:HeaderStyle><b:IsHTMLTagsAllowed>false</b:IsHTMLTagsAllowed><b:IsHidden>true</b:IsHidden><b:PercentWidth i:nil="true"/><b:Presenters i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Presentation"/><b:PropertyName>Response Time History/Timestamp</b:PropertyName><b:RefId>946da8dc-7b56-566d-3fb9-d1b22ee14756</b:RefId><b:Summary><b:Calculation>NotSpecified</b:Calculation><b:CellStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/></b:Summary><b:TransformId/><b:ValidRange>NotSpecified</b:ValidRange></b:TableColumn></b:Columns><b:DefaultStyle i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"/><b:Filter xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"><c:Expression i:nil="true"/><c:Limit><c:Count i:nil="true"/><c:Mode>ShowAll</c:Mode><c:OrionServerIDsToIgnore i:nil="true"/><c:Percentage i:nil="true"/></c:Limit></b:Filter><b:Indents/><b:Sorts xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"/><b:SummarizeMode>NoDataSummarization</b:SummarizeMode><b:TimeField xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"><c:DataTypeInfo i:nil="true"/><c:DisplayName i:nil="true"/><c:NavigationPath i:nil="true"/><c:OwnerDisplayName i:nil="true"/><c:RefID><c:Data>Orion.ResponseTime|ObservationTimestamp|ResponseTimeHistory</c:Data></c:RefID></b:TimeField></a:ConfigurationData></Configs><DataSources xmlns:a="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"><a:DataSource><a:CommandText/><a:DynamicSelectionType>Advanced</a:DynamicSelectionType><a:EntityUri xmlns:b="http://schemas.microsoft.com/2003/10/Serialization/Arrays"/><a:Filter><a:Child><a:Expr><a:Child><a:Expr><a:Child><a:Expr><a:Child i:nil="true"/><a:NodeType>Field</a:NodeType><a:Value>Orion.Nodes|Vendor</a:Value></a:Expr><a:Expr><a:Child i:nil="true"/><a:NodeType>Constant</a:NodeType><a:Value>Cisco</a:Value></a:Expr></a:Child><a:NodeType>Operator</a:NodeType><a:Value>=</a:Value></a:Expr><a:Expr><a:Child><a:Expr><a:Child i:nil="true"/><a:NodeType>Field</a:NodeType><a:Value>Orion.Nodes|Vendor</a:Value></a:Expr><a:Expr><a:Child i:nil="true"/><a:NodeType>Constant</a:NodeType><a:Value>Meraki Networks, Inc.</a:Value></a:Expr></a:Child><a:NodeType>Operator</a:NodeType><a:Value>=</a:Value></a:Expr></a:Child><a:NodeType>Operator</a:NodeType><a:Value>OR</a:Value></a:Expr><a:Expr><a:Child><a:Expr><a:Child><a:Expr><a:Child i:nil="true"/><a:NodeType>Field</a:NodeType><a:Value>Orion.Nodes|Status</a:Value></a:Expr><a:Expr><a:Child i:nil="true"/><a:NodeType>Constant</a:NodeType><a:Value>0</a:Value></a:Expr></a:Child><a:NodeType>Operator</a:NodeType><a:Value>=</a:Value></a:Expr><a:Expr><a:Child><a:Expr><a:Child i:nil="true"/><a:NodeType>Field</a:NodeType><a:Value>Orion.Nodes|Status</a:Value></a:Expr><a:Expr><a:Child i:nil="true"/><a:NodeType>Constant</a:NodeType><a:Value>2</a:Value></a:Expr></a:Child><a:NodeType>Operator</a:NodeType><a:Value>=</a:Value></a:Expr></a:Child><a:NodeType>Operator</a:NodeType><a:Value>OR</a:Value></a:Expr></a:Child><a:NodeType>Operator</a:NodeType><a:Value>AND</a:Value></a:Filter><a:MasterEntity>orion.nodes</a:MasterEntity><a:Name>Stores</a:Name><a:NetObjectId/><a:RefId>6a357000-c37c-4cc3-82ba-a1a04a91fe2d</a:RefId><a:Type>Dynamic</a:Type></a:DataSource><a:DataSource><a:CommandText/><a:DynamicSelectionType>Simple</a:DynamicSelectionType><a:EntityUri xmlns:b="http://schemas.microsoft.com/2003/10/Serialization/Arrays"/><a:Filter><a:Child><a:Expr><a:Child><a:Expr><a:Child i:nil="true"/><a:NodeType>Field</a:NodeType><a:Value>Orion.Nodes|Vendor</a:Value></a:Expr><a:Expr><a:Child i:nil="true"/><a:NodeType>Constant</a:NodeType><a:Value>Meraki Networks, Inc.</a:Value></a:Expr></a:Child><a:NodeType>Operator</a:NodeType><a:Value>=</a:Value></a:Expr><a:Expr><a:Child><a:Expr><a:Child i:nil="true"/><a:NodeType>Field</a:NodeType><a:Value>Orion.Nodes|Vendor</a:Value></a:Expr><a:Expr><a:Child i:nil="true"/><a:NodeType>Constant</a:NodeType><a:Value>Cisco 887</a:Value></a:Expr></a:Child><a:NodeType>Operator</a:NodeType><a:Value>STARTWITH</a:Value></a:Expr></a:Child><a:NodeType>Operator</a:NodeType><a:Value>OR</a:Value></a:Filter><a:MasterEntity>orion.nodes</a:MasterEntity><a:Name>Datasource 2</a:Name><a:NetObjectId/><a:RefId>98ba3abf-62c5-499e-871d-55e49d96289e</a:RefId><a:Type>Dynamic</a:Type></a:DataSource></DataSources><Description>Displays all Store Router Nodes that are currently Down</Description><Footer xmlns:a="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Layout"><a:CustomText>© SolarWinds Worldwide, LLC. All Rights Reserved.</a:CustomText><a:ShowCustomText>true</a:ShowCustomText><a:ShowPageNumber>true</a:ShowPageNumber><a:ShowTimestamp>true</a:ShowTimestamp><a:Visible>true</a:Visible></Footer><Header xmlns:a="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Layout"><a:Logo>iVBORw0KGgoAAAANSUhEUgAAAHcAAAB3CAMAAAAO5y+4AAAA0lBMVEUHV0z////8//8AVEkFWUzT4N8HV05JamMAVkoAT0SawzYATkH+/vzv9PQzZlsASz0AQzlxko+etK9RcWu4wsHL2tZ5m5IIVlAATDv//P8AQjIEWkoAU0SitbMAT0lpiIQAVjydyDKTvjoAV0Iwbj5SgUFnlkJtoEFtnkdfjUxFfjwiZEBBbGUqXVZbj0aKvD98rEkpZks6dkFcmD93rTcASVOewUOJvkwKVFWPu0+gykZYkkIAQUWSyD6Vv0lwo1YAMyTo+/hiin81b0iKpKFNeW2k34kZAAAGFklEQVRoge1Ya3uiOBTmkqaAIr05wSamRNpqpRV0Ourg1rm08///0p4ErKKtdMd9Zj9s3i9qMLyc23tOMAwNDQ0NDQ0NDQ0NDQ0NDQ0NjT8IhFDx+YdpsWE4yEGY4D/LSx3MXc5ih/w7N3Rs23beWrQ3FzCPr29u+4O7YcLJlqvtLezc7U3a+/Pz85aNKveyH2DxuHQoNQhyolHqeSL3vDzNxkz6GuPyOm6dV3D8ELoY1aSB3fJN0zw6qf6vcQGL1n1hMUGUT2bC89LR8/j5c094Extt8LpHZgWW374KWU0WOC2/aZr+Nm/btEzzuHAYNqJhCrSPLqcx/XLdmz5dozWt0TgyrVc0m03JfdRi9fY2JW8lKMALOC7sxfF46QkxCxCOCSGNkfD6DJF5jDGhhb3wkJ1mCbNjdizTOmZ4n6vBXkvxVlbBBNhb8iL+WYZ26FCKsROTxPNmEaHxFxtRaXTBu+FnALiQ7Q3xR3hpz/O8ryE8QHIzYSTJvV6Co9HjwMDUKXg7VvuiRNsHiwHdcF+IP8BLrqdgb+bCF8jpxV/g5xllGUT8KXZQyWteXQYlGmeWsto4kNeeQPl4gwbiA/js9Z+EeHSTJXwX31jBC44+ddGKJ3hR/v7kHsbrKN6+i3gGn540fsjHijeNy/gCb2N1C0SJrxwdHMgrbRMzbih7PfDvLFbfe708eoPXQRzKoWNeHMiLmLQzj+bG9VJI4ixxMGKTu+Q2T6CMt3kNFFzI7e1D/YwnU6jfxTxmz/1eOruJEJQmnvMoTV2yy4uR25YRP9Rew+ajJ89bJo6N3JPABc2glPNwuBTfbGOTt2zR9MFXmdao4ZU6KXVvDXhga82LaXw3heKJbCn3lBIejBdZKkT+TNBKN4BXgiKEL7tKPtC+vlTyfg8quGxv2IspmgeTJShlwrFBORv2cxnnqRg0DLyqo6vvlwW+0wuzSOcavYL/+Gdb8DfspTwa9rNHSOQ0cShfLBWrEE9ZpDqxK4PSOWqX8AvR9Jm9TzeKPvgWSl5KIJBF+Xj5zIlHYuop9IacYNvY1edi97m7V5/tlr+7aYMXknMA9glvmkPj9Ua0NxVQtwK+90buRj+q7u10Q7a389fay4ZSrcRymIyvs7wf5V+H42SSSd0SC4bes7euAxe8u/s6ZXypK53sPSXcwDa/Hcb9MSQXj2RbEHliGGVedaq3gN0/WvYeixWv5V+dVnG0spcpcRYLjuTkzB3SmFMpYZMn+Ti3zCjzyuxerXDatkAlpV7tKaTCXv+SVRC+1i/vqxxKZCANCtWLYvkETjyT6490rc8nbgl2ef9DufDKfX/It0u92lzDxchU8D7K9E3jWF4gSM4Xcn52QtWbUrzmZRRRCRBR90F5vX3y/qhTp5N2JisoBSHavI5w0ZsembPbjwBBV9rr7znU1PGyhVB+RhURQJh9lbzZO7zsp+K9d36bl0xUz71hldMJchI5c+Uj/jav/UvyWgfwokj13KzaS+MvC0/1ZLzX3tbv88b8TqnipHJaQjSVXujz1Vy3xRt2zeZh8cUkVpGE0YaUqUXnlH+W2pkndK1XMNcZqhPCUuPekqeGdmDQXcaP8UJxXEPvkT0vXp3DEHtWqrFg8QbvZWOF8NcPWGiaL3taQ+28Qal7J0sJJKt8+JjCIA9NYhDSlb1AfPZphRfQK8vqNP0H+yBeMu/L/iNGHCQBuJ0oVZoRl3NN0X+rLUXqRu2cUzfXOXwhW7244zDGUByqgKevlfV2/zXPgpq+X3tOiag7lNUkbhuEzpMZGJ8P4GQ2f5e3aVqfAvqBOWeX13w9hxKKqZ1kuWRLwiE0BNG7ceFMurZ3G373Yd/wrHaddrvdn1v/sn/B4svrTwx1yG7g7C3S7EnRQ8a8vtdhV90KXk7vcVD7jgPFYRjsjAb2SRCGG3shg+L4JutBZi8Hzw2YVtH6wO+G1WnU/cCbFZmSaDfdVbtDm7/x3GCNZDiaRMyZk2LcLq456PUJoLYlPvCGS1Hu8sIK3hI5uB3CZE4wMaoZg1ZCtUY97z8G/rOv69a0/w2vhoaGhoaGhoaGhoaGhoaGxv8YfwMlBqfwne/5EgAAAABJRU5ErkJggg==</a:Logo><a:SubTitle>Displays all Nodes that are currently Down</a:SubTitle><a:Title>ITEM - H&amp;B Stores Currently Down</a:Title><a:Visible>true</a:Visible></Header><LimitationCategory>Default Folder</LimitationCategory><ModuleTitle i:nil="true"/><Name>ITEM - H&amp;B Stores Currently Down</Name><OrionFeatureName i:nil="true"/><PageLayout xmlns:a="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Layout"><a:Height>0</a:Height><a:Orientation i:nil="true"/><a:PublishingType>web</a:PublishingType><a:Size i:nil="true"/><a:Units i:nil="true"/><a:Width>1200</a:Width></PageLayout><ReportGuid>4e1bf7e1-e273-4bdd-af00-c9bf20253a2f</ReportGuid><Sections xmlns:a="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Layout"><a:Section><a:BorderStyle xmlns:b="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><b:Bottom i:nil="true"/><b:Color i:nil="true"/><b:Left i:nil="true"/><b:Right i:nil="true"/><b:Top i:nil="true"/></a:BorderStyle><a:Columns><a:SectionColumn><a:BorderStyle xmlns:b="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Styles"><b:Bottom i:nil="true"/><b:Color i:nil="true"/><b:Left i:nil="true"/><b:Right i:nil="true"/><b:Top i:nil="true"/></a:BorderStyle><a:Cells><a:SectionCell><a:Config i:nil="true" xmlns:b="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Data"/><a:ConfigId>83af32cd-b56a-4c71-bb13-bb7b2e047aa4</a:ConfigId><a:DataSelectionRefId>6a357000-c37c-4cc3-82ba-a1a04a91fe2d</a:DataSelectionRefId><a:DisplayName>Custom Table</a:DisplayName><a:RefId>5c5cdd24-eb69-4d31-bd21-1cda257176fe</a:RefId><a:RenderProvider>SolarWinds.Reporting,Table</a:RenderProvider><a:TimeframeRefId>39213bc1-05d1-4168-898a-52d9d97967df</a:TimeframeRefId></a:SectionCell></a:Cells><a:ColumnGutter i:nil="true"/><a:PercentWidth>100</a:PercentWidth><a:PixelWidth i:nil="true"/><a:RefId>7357eb45-2584-47cd-9178-a0011cb64c1c</a:RefId><a:Subtitle/><a:Title/></a:SectionColumn></a:Columns><a:RefId>7514ffb6-083d-48f3-92e8-f9431bad5e4b</a:RefId></a:Section></Sections><TimeFrames xmlns:a="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Timing"><a:TimeFrame><a:DisplayName>Past Hour</a:DisplayName><a:IsStatic>false</a:IsStatic><a:RefId>81450dea-f7eb-4368-b605-6dd904e6f9af</a:RefId><a:Relative><a:NamedTimeFrame>PastHour</a:NamedTimeFrame><a:Unit>Hour</a:Unit><a:UnitCount>1</a:UnitCount></a:Relative><a:Static i:nil="true"/></a:TimeFrame><a:TimeFrame><a:DisplayName>Past Hour</a:DisplayName><a:IsStatic>false</a:IsStatic><a:RefId>2546d9f0-7ed8-4e23-91df-6e2bd07ec32c</a:RefId><a:Relative><a:NamedTimeFrame>PastHour</a:NamedTimeFrame><a:Unit>Hour</a:Unit><a:UnitCount>1</a:UnitCount></a:Relative><a:Static i:nil="true"/></a:TimeFrame><a:TimeFrame><a:DisplayName>Last 24 Hours</a:DisplayName><a:IsStatic>false</a:IsStatic><a:RefId>16e87767-48d4-4f7d-9dd1-8b75828fe6f7</a:RefId><a:Relative><a:NamedTimeFrame>Last24Hours</a:NamedTimeFrame><a:Unit>Hour</a:Unit><a:UnitCount>24</a:UnitCount></a:Relative><a:Static i:nil="true"/></a:TimeFrame><a:TimeFrame><a:DisplayName>Past Hour</a:DisplayName><a:IsStatic>false</a:IsStatic><a:RefId>eca158fb-78d0-4bd1-8ae5-0050527ee2fa</a:RefId><a:Relative><a:NamedTimeFrame>PastHour</a:NamedTimeFrame><a:Unit>Hour</a:Unit><a:UnitCount>1</a:UnitCount></a:Relative><a:Static i:nil="true"/></a:TimeFrame><a:TimeFrame><a:DisplayName>Past Hour</a:DisplayName><a:IsStatic>false</a:IsStatic><a:RefId>ae48134f-f6a5-410a-bf3f-28eab7b46588</a:RefId><a:Relative><a:NamedTimeFrame>PastHour</a:NamedTimeFrame><a:Unit>Hour</a:Unit><a:UnitCount>1</a:UnitCount></a:Relative><a:Static i:nil="true"/></a:TimeFrame><a:TimeFrame><a:DisplayName>Last 24 Hours</a:DisplayName><a:IsStatic>false</a:IsStatic><a:RefId>b90f1c05-5e92-4064-876f-09fdb6d8453b</a:RefId><a:Relative><a:NamedTimeFrame>Last24Hours</a:NamedTimeFrame><a:Unit>Hour</a:Unit><a:UnitCount>24</a:UnitCount></a:Relative><a:Static i:nil="true"/></a:TimeFrame><a:TimeFrame><a:DisplayName>Past Hour</a:DisplayName><a:IsStatic>false</a:IsStatic><a:RefId>b2f9e78f-86f6-4242-ab9b-2c8cc85e4976</a:RefId><a:Relative><a:NamedTimeFrame>PastHour</a:NamedTimeFrame><a:Unit>Hour</a:Unit><a:UnitCount>1</a:UnitCount></a:Relative><a:Static i:nil="true"/></a:TimeFrame><a:TimeFrame><a:DisplayName>Last 24 Hours</a:DisplayName><a:IsStatic>false</a:IsStatic><a:RefId>c93115e3-4513-4dd5-beb9-690801b83934</a:RefId><a:Relative><a:NamedTimeFrame>Last24Hours</a:NamedTimeFrame><a:Unit>Hour</a:Unit><a:UnitCount>24</a:UnitCount></a:Relative><a:Static i:nil="true"/></a:TimeFrame><a:TimeFrame><a:DisplayName>Today</a:DisplayName><a:IsStatic>false</a:IsStatic><a:RefId>39213bc1-05d1-4168-898a-52d9d97967df</a:RefId><a:Relative><a:NamedTimeFrame>Today</a:NamedTimeFrame><a:Unit>Day</a:Unit><a:UnitCount>1</a:UnitCount></a:Relative><a:Static i:nil="true"/></a:TimeFrame></TimeFrames></Report>

  • SELECT [Nodes].Caption
         , [Nodes].DetailsUrl
         , [Nodes].VendorInfo.Icon
         , [ResponseTime].Day
         , [ResponseTime].Availability
         , [Downtime].MinutesDown
         , [Downtime].CalcAvailability
         , [Events].RebootCount
    -- To add Node Custom Properties use:
    -- , [Node].CustomProperties.<Custom Property Name>
    FROM Orion.Nodes AS [Nodes]
    INNER JOIN (
         SELECT [RT].NodeID
              , DateTrunc('day', [RT].DATETIME) AS [Day]
              , AVG([RT].Availability * 1.0) AS Availability
         FROM Orion.ResponseTime AS [RT]
         GROUP BY DateTrunc('day', [RT].DATETIME)
              , [RT].NodeID
         ) AS [ResponseTime]
         ON [Nodes].NodeID = [ResponseTime].NodeID
    INNER JOIN (
         SELECT [DT].NodeId
              , DateTrunc('day', [DT].DateTimeUntil) AS [Day]
              , SUM([DT].TotalDurationMin) AS [MinutesDown]
              , ((1.0 - (SUM([DT].TotalDurationMin) / 1440.0)) * 100.0) AS [CalcAvailability]
         FROM Orion.NetObjectDowntime AS [DT]
         INNER JOIN Orion.StatusInfo AS [SI]
              ON [DT].STATE = [SI].StatusId
                   AND [SI].StatusName = 'Down' -- Where the status is 'Down' (not 'Critical', 'Warning', etc.)
         WHERE [DT].EntityType = 'Orion.Nodes' -- Only show me nodes
              AND [DT].DateTimeUntil IS NOT NULL --Indicates that it's no longer down
         GROUP BY DateTrunc('day', [DT].DateTimeUntil)
              , [DT].NodeId
         ) AS [Downtime]
         ON [ResponseTime].NodeId = [Downtime].NodeID
              AND [ResponseTime].Day = [Downtime].Day
    RIGHT JOIN (
         SELECT [E].Nodes.NodeID
              , COUNT([E].EventID) AS [RebootCount]
              , DATETRUNC('day', [E].EventTime) AS [Day]
         FROM Orion.Events AS [E]
         WHERE [E].EventTypeProperties.Name = 'Node rebooted'
         -- AND [E].Nodes.CustomProperties.<Custom Property Name> = <Custom Property Value>
         GROUP BY DATETRUNC('day', [E].EventTime)
              , [E].Nodes.NodeID
         ) AS [Events]
         ON [ResponseTime].NodeID = [Events].NodeID
              AND [ResponseTime].Day = [Events].Day
    WHERE [Nodes].ObjectSubType <> 'ICMP'
         -- Required for Orion Reports
         AND [ResponseTime].Day BETWEEN ${ FromTime}
              AND ${ ToTime}
                   -- To filter on Node Custom Properties add
                   -- AND [Node].CustomProperties.<Custom Property Name> = <Custom Property Value>
         AND [Nodes].Vendor IN (
              'Cisco'
              , 'Meraki Networks, Inc.'
              )
    

Reply
  • SELECT [Nodes].Caption
         , [Nodes].DetailsUrl
         , [Nodes].VendorInfo.Icon
         , [ResponseTime].Day
         , [ResponseTime].Availability
         , [Downtime].MinutesDown
         , [Downtime].CalcAvailability
         , [Events].RebootCount
    -- To add Node Custom Properties use:
    -- , [Node].CustomProperties.<Custom Property Name>
    FROM Orion.Nodes AS [Nodes]
    INNER JOIN (
         SELECT [RT].NodeID
              , DateTrunc('day', [RT].DATETIME) AS [Day]
              , AVG([RT].Availability * 1.0) AS Availability
         FROM Orion.ResponseTime AS [RT]
         GROUP BY DateTrunc('day', [RT].DATETIME)
              , [RT].NodeID
         ) AS [ResponseTime]
         ON [Nodes].NodeID = [ResponseTime].NodeID
    INNER JOIN (
         SELECT [DT].NodeId
              , DateTrunc('day', [DT].DateTimeUntil) AS [Day]
              , SUM([DT].TotalDurationMin) AS [MinutesDown]
              , ((1.0 - (SUM([DT].TotalDurationMin) / 1440.0)) * 100.0) AS [CalcAvailability]
         FROM Orion.NetObjectDowntime AS [DT]
         INNER JOIN Orion.StatusInfo AS [SI]
              ON [DT].STATE = [SI].StatusId
                   AND [SI].StatusName = 'Down' -- Where the status is 'Down' (not 'Critical', 'Warning', etc.)
         WHERE [DT].EntityType = 'Orion.Nodes' -- Only show me nodes
              AND [DT].DateTimeUntil IS NOT NULL --Indicates that it's no longer down
         GROUP BY DateTrunc('day', [DT].DateTimeUntil)
              , [DT].NodeId
         ) AS [Downtime]
         ON [ResponseTime].NodeId = [Downtime].NodeID
              AND [ResponseTime].Day = [Downtime].Day
    RIGHT JOIN (
         SELECT [E].Nodes.NodeID
              , COUNT([E].EventID) AS [RebootCount]
              , DATETRUNC('day', [E].EventTime) AS [Day]
         FROM Orion.Events AS [E]
         WHERE [E].EventTypeProperties.Name = 'Node rebooted'
         -- AND [E].Nodes.CustomProperties.<Custom Property Name> = <Custom Property Value>
         GROUP BY DATETRUNC('day', [E].EventTime)
              , [E].Nodes.NodeID
         ) AS [Events]
         ON [ResponseTime].NodeID = [Events].NodeID
              AND [ResponseTime].Day = [Events].Day
    WHERE [Nodes].ObjectSubType <> 'ICMP'
         -- Required for Orion Reports
         AND [ResponseTime].Day BETWEEN ${ FromTime}
              AND ${ ToTime}
                   -- To filter on Node Custom Properties add
                   -- AND [Node].CustomProperties.<Custom Property Name> = <Custom Property Value>
         AND [Nodes].Vendor IN (
              'Cisco'
              , 'Meraki Networks, Inc.'
              )
    

Children
No Data