• State Suggested Answer
  • Locked Locked
  • Replies 13 replies
  • Answers 1 answer
  • Subscribers 18 subscribers
  • Views 3682 views
  • Users 0 members are here
Options
Related
This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

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

zkahl

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

Parents
  • 0

    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.

    Fullscreen High+Node+Utilization+Report.xml Download 
    <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>

  • 0 in reply to KMSigma.SWI

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

  • 0 in reply to KMSigma.SWI

    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!

  • 0 in reply to zkahl

    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.

  • 0 in reply to KMSigma.SWI

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

  • 0 in reply to zkahl

    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.

  • 0 in reply to KMSigma.SWI

    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

  • 0 in reply to zkahl

    This sounds awesome, any chance of sharing this query for the Modern Dashboard?

  • 0 in reply to SW_United

    If you want a Modern Dashboard Widget for your Poller Table you could do something like these:

    SELECT
[E].ServerName AS [Poller], -- List the Name of your Polling Enginers
[E].Elements AS [Element_Count] -- The Total Element Count of each Polling Engine
FROM Orion.Engines [E]
LEFT JOIN Orion.Nodes [N] ON [E].ServerName = [N].Caption -- This JOIN enables you to use WHERE Filters
WHERE [E].Elements <> '0' -- Removes Polling Engines that are empty or not in use
AND [N].CustomProperties.ApplicationRole = 'SWI - Polling Engine' -- Filter by Custom Property (Remove or Adjust accordingly)

    OR If you don't have many APE's you could use a KPI Widget and then you can set Thresholds for Warn/Crit levels.

  • 0 in reply to SW_United

    Let me see see if I can find it.  I will look later this evening.

  • 0 in reply to SW_United

    Solarwinds Capacity Planning query

    SELECT Engines.ServerName AS ServerName, Engines.PollingCompletion AS Polling, ((Engines.Elements *100) / 22700)  AS Perc_of_Max,

    Nodes.PercentMemoryUsed, Nodes.CpuLoad, EnvironmentalOverview.CPUinfo AS CPUs, EnvironmentalOverview.RAMinfo as RAM,

    Engines.Elements AS Elements, Engines.Nodes AS Nodes

     

    FROM Engines

     

    INNER JOIN Nodes ON Engines.ServerName=Nodes.Caption

    INNER JOIN EnvironmentalOverview ON Engines.ServerName=EnvironmentalOverview.HostName

     

    ORDER BY Perc_of_Max DESC

Reply Children
No Data

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification Media Vault Link Accounts
About THWACK Blogs For Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2024 SolarWinds Worldwide, LLC. All Rights Reserved.