Looking for report that shows Orion Servers Elements, CPU & Memory usage.

Would like to graph this and possible plot on dashboard.  I have one for CPU/Memory and have non graph for Elements, but looking to have them on same graph. Save me some time if someone already has this.  

Zak

  • Do you just mean something like this?

    If not, it would actually be best if you could provide a doodle of what you are thinking about if if you want it as a dashboard, a report, or something else (like widgets on a Node Details page).  Screenshots would be best if you can.

    High+Node+Utilization+Report.xml
    <Report xmlns="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
         <Category>Custom</Category>
         <Configs xmlns:a="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Data">
              <a:ConfigurationData i:type="b:ChartConfiguration" xmlns:b="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Charts">
                   <a:DisplaySubTitle/>
                   <a:DisplayTitle>High CPU/Memory</a:DisplayTitle>
                   <a:RefId>4270afea-4b92-4623-8030-44f05d7890bb</a:RefId>
                   <b:CaptionField 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>KMSORION01v</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:CaptionField>
                   <b:CustomDataGroupingEnabled>true</b:CustomDataGroupingEnabled>
                   <b:DataAggregation>Average</b:DataAggregation>
                   <b:KeyField xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection">
                        <c:DataTypeInfo>
                             <a:ApplicationType i:nil="true"/>
                             <a:DataType>
                                  <a:Data>System.Int32</a:Data>
                             </a:DataType>
                             <a:DeclType>Integer</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>false</a:IsInherited>
                             <a:IsManaged>true</a:IsManaged>
                             <a:IsStatistic>false</a:IsStatistic>
                             <a:PreviewValue>1</a:PreviewValue>
                             <a:Units/>
                             <a:UtcTimeIsInLocalTime>false</a:UtcTimeIsInLocalTime>
                        </c:DataTypeInfo>
                        <c:DisplayName>Node ID</c:DisplayName>
                        <c:NavigationPath i:nil="true"/>
                        <c:OwnerDisplayName>Node</c:OwnerDisplayName>
                        <c:RefID>
                             <c:Data>Orion.Nodes|NodeID</c:Data>
                        </c:RefID>
                   </b:KeyField>
                   <b:LeftAxis>
                        <b:DataSeries>
                             <b:DataSeriesConfiguration>
                                  <b:Aggregate>NotSpecified</b:Aggregate>
                                  <b:AggregateMode>Standard</b:AggregateMode>
                                  <b:ColorMode>Standard</b:ColorMode>
                                  <b:CustomAggregate i:nil="true"/>
                                  <b:CustomColorHexValue i:nil="true"/>
                                  <b:DisplayName>CPU Load (%) on</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.Int16</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>1 %</a:PreviewValue>
                                            <a:Units>%</a:Units>
                                            <a:UtcTimeIsInLocalTime>false</a:UtcTimeIsInLocalTime>
                                       </c:DataTypeInfo>
                                       <c:DisplayName>Average CPU Load</c:DisplayName>
                                       <c:NavigationPath>CPULoadHistory</c:NavigationPath>
                                       <c:OwnerDisplayName>CPU / Memory History</c:OwnerDisplayName>
                                       <c:RefID>
                                            <c:Data>Orion.CPULoad|AvgLoad|CPULoadHistory</c:Data>
                                       </c:RefID>
                                  </b:Field>
                                  <b:Id>Orion.CPULoad|AvgLoad|CPULoadHistory_0_0</b:Id>
                                  <b:Show95thPercentile>false</b:Show95thPercentile>
                                  <b:ShowTrendLine>false</b:ShowTrendLine>
                                  <b:TimeField 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>9/28/2021 6:23:41 PM</a:PreviewValue>
                                            <a:Units/>
                                            <a:UtcTimeIsInLocalTime>false</a:UtcTimeIsInLocalTime>
                                       </c:DataTypeInfo>
                                       <c:DisplayName>Timestamp</c:DisplayName>
                                       <c:NavigationPath>CPULoadHistory</c:NavigationPath>
                                       <c:OwnerDisplayName>CPU / Memory History</c:OwnerDisplayName>
                                       <c:RefID>
                                            <c:Data>Orion.CPULoad|ObservationTimestamp|CPULoadHistory</c:Data>
                                       </c:RefID>
                                  </b:TimeField>
                             </b:DataSeriesConfiguration>
                        </b:DataSeries>
                        <b:DisplayName>CPU Load (%)</b:DisplayName>
                        <b:ScaleMax>0</b:ScaleMax>
                        <b:SeriesType>Line</b:SeriesType>
                        <b:ShowSumOfDataSeries>false</b:ShowSumOfDataSeries>
                        <b:TimeField i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"/>
                        <b:Unit>%</b:Unit>
                   </b:LeftAxis>
                   <b:Limit xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection">
                        <c:Count i:nil="true"/>
                        <c:Mode>ShowAll</c:Mode>
                        <c:OrionServerIDsToIgnore i:nil="true"/>
                        <c:Percentage i:nil="true"/>
                   </b:Limit>
                   <b:Order>Descending</b:Order>
                   <b:OrionServerIDsToIgnore i:nil="true"/>
                   <b:RightAxis>
                        <b:DataSeries>
                             <b:DataSeriesConfiguration>
                                  <b:Aggregate>NotSpecified</b:Aggregate>
                                  <b:AggregateMode>Standard</b:AggregateMode>
                                  <b:ColorMode>Standard</b:ColorMode>
                                  <b:CustomAggregate i:nil="true"/>
                                  <b:CustomColorHexValue i:nil="true"/>
                                  <b:DisplayName>Memory Load (%) on</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>76.3595886230469 %</a:PreviewValue>
                                            <a:Units>%</a:Units>
                                            <a:UtcTimeIsInLocalTime>false</a:UtcTimeIsInLocalTime>
                                       </c:DataTypeInfo>
                                       <c:DisplayName>Average Percent Memory Used</c:DisplayName>
                                       <c:NavigationPath>CPULoadHistory</c:NavigationPath>
                                       <c:OwnerDisplayName>CPU / Memory History</c:OwnerDisplayName>
                                       <c:RefID>
                                            <c:Data>Orion.CPULoad|AvgPercentMemoryUsed|CPULoadHistory</c:Data>
                                       </c:RefID>
                                  </b:Field>
                                  <b:Id>Orion.CPULoad|AvgPercentMemoryUsed|CPULoadHistory_0_1</b:Id>
                                  <b:Show95thPercentile>false</b:Show95thPercentile>
                                  <b:ShowTrendLine>false</b:ShowTrendLine>
                                  <b:TimeField 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>9/28/2021 6:23:41 PM</a:PreviewValue>
                                            <a:Units/>
                                            <a:UtcTimeIsInLocalTime>false</a:UtcTimeIsInLocalTime>
                                       </c:DataTypeInfo>
                                       <c:DisplayName>Timestamp</c:DisplayName>
                                       <c:NavigationPath>CPULoadHistory</c:NavigationPath>
                                       <c:OwnerDisplayName>CPU / Memory History</c:OwnerDisplayName>
                                       <c:RefID>
                                            <c:Data>Orion.CPULoad|ObservationTimestamp|CPULoadHistory</c:Data>
                                       </c:RefID>
                                  </b:TimeField>
                             </b:DataSeriesConfiguration>
                        </b:DataSeries>
                        <b:DisplayName>Memory Load (%)</b:DisplayName>
                        <b:ScaleMax>0</b:ScaleMax>
                        <b:SeriesType>Line</b:SeriesType>
                        <b:ShowSumOfDataSeries>false</b:ShowSumOfDataSeries>
                        <b:TimeField i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"/>
                        <b:Unit>%</b:Unit>
                   </b:RightAxis>
                   <b:SampleIntervalInMinutes>15</b:SampleIntervalInMinutes>
                   <b:SecondarySortRecordsBy/>
                   <b:SortRecordsBy 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.Int16</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>1 %</a:PreviewValue>
                             <a:Units>%</a:Units>
                             <a:UtcTimeIsInLocalTime>false</a:UtcTimeIsInLocalTime>
                        </c:DataTypeInfo>
                        <c:DisplayName>Average CPU Load</c:DisplayName>
                        <c:NavigationPath>CPULoadHistory</c:NavigationPath>
                        <c:OwnerDisplayName>CPU / Memory History</c:OwnerDisplayName>
                        <c:RefID>
                             <c:Data>Orion.CPULoad|AvgLoad|CPULoadHistory</c:Data>
                        </c:RefID>
                   </b:SortRecordsBy>
                   <b:TooltipPositioningEnabled>false</b:TooltipPositioningEnabled>
              </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 i:nil="true"/>
                                            <a:NodeType>Field</a:NodeType>
                                            <a:Value>Orion.CPULoad|AvgLoad|CPULoadHistory</a:Value>
                                       </a:Expr>
                                       <a:Expr>
                                            <a:Child i:nil="true"/>
                                            <a:NodeType>Constant</a:NodeType>
                                            <a:Value>80</a:Value>
                                       </a:Expr>
                                  </a:Child>
                                  <a:NodeType>Operator</a:NodeType>
                                  <a:Value>&gt;=</a:Value>
                             </a:Expr>
                             <a:Expr>
                                  <a:Child>
                                       <a:Expr>
                                            <a:Child i:nil="true"/>
                                            <a:NodeType>Field</a:NodeType>
                                            <a:Value>Orion.CPULoad|AvgPercentMemoryUsed|CPULoadHistory</a:Value>
                                       </a:Expr>
                                       <a:Expr>
                                            <a:Child i:nil="true"/>
                                            <a:NodeType>Constant</a:NodeType>
                                            <a:Value>80</a:Value>
                                       </a:Expr>
                                  </a:Child>
                                  <a:NodeType>Operator</a:NodeType>
                                  <a:Value>&gt;=</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>All Nodes with High Utilization</a:Name>
                   <a:NetObjectId/>
                   <a:RefId>a8c1572b-1fed-4ffd-a4c5-faef4ef3f79a</a:RefId>
                   <a:Type>Dynamic</a:Type>
              </a:DataSource>
         </DataSources>
         <Description>Show nodes with &gt; 80% CPU or Memory Consumption</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>standard</a:Logo>
              <a:SubTitle>Show nodes with &gt; 80% CPU or Memory Consumption</a:SubTitle>
              <a:Title>High Node Utilization Report</a:Title>
              <a:Visible>true</a:Visible>
         </Header>
         <LimitationCategory>Default Folder</LimitationCategory>
         <ModuleTitle i:nil="true"/>
         <Name>High Node Utilization Report</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>1800</a:Width>
         </PageLayout>
         <ReportGuid>9947bf0a-e8ce-4ff8-bed5-3458d6a522f3</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>4270afea-4b92-4623-8030-44f05d7890bb</a:ConfigId>
                                       <a:DataSelectionRefId>a8c1572b-1fed-4ffd-a4c5-faef4ef3f79a</a:DataSelectionRefId>
                                       <a:DisplayName>Custom Chart</a:DisplayName>
                                       <a:RefId>000b5780-ee03-439e-9672-ab19de9ad767</a:RefId>
                                       <a:RenderProvider>SolarWinds.Orion.Web.Reporting,ReportChart</a:RenderProvider>
                                       <a:TimeframeRefId>2e33054d-88d3-42ca-9573-8011fb4592aa</a:TimeframeRefId>
                                  </a:SectionCell>
                             </a:Cells>
                             <a:ColumnGutter i:nil="true"/>
                             <a:PercentWidth>100</a:PercentWidth>
                             <a:PixelWidth i:nil="true"/>
                             <a:RefId>942adcb7-6b13-43ce-b2cd-70226bc77852</a:RefId>
                             <a:Subtitle/>
                             <a:Title/>
                        </a:SectionColumn>
                   </a:Columns>
                   <a:RefId>3d42adee-06b8-412d-9621-a6e42e72f4f5</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>fd566b4d-7387-4257-a734-66d64c6b8b48</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>2e33054d-88d3-42ca-9573-8011fb4592aa</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>
         </TimeFrames>
    </Report>

  • Yes, that is close.  I have this but want to add Element count per server also to same graph.

  • Yeah - can't have more than 2 things per chart with report-based charting.  You could have a second chart (or table) that shows the element count (not sure what exactly you mean here), but my gut tells me that would have to be custom SWQL.

  • That is what I am trying to do, from what I can find only Custom SQL for elements but was seeing if someone has away of plotting on same graph.   I will see what I can do an maybe 2nd chart if only way.  Thanks for looking!

  • That's the beauty of the web-based report writer, you can keep adding report objects to it.  What exactly do you mean by "element count"?  Maybe I can add it to the previous report.

  • I made this, but was hoping to get Orion to graph this.  Elements, meant number of elements Poller is monitoring. 

  • This is from the Engines table?  There's no historical data to show there, so it wouldn't be a graph.  Could make a nice chart in a Modern Dashboard though.

  • Yeah, that is what I did.  Added this query in a dashboard.  But I don't think the widget exists of what I wanted to do.  Thanks for checking