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.
<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>>=</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>>=</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 > 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 > 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>
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.
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.
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.
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
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.