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.

I need a report of total RAM and Percent Memory Used

I would need a simple report of the total RAM size a node has and also the "Percent Memory Used". This could also be a widget in a custom view.

It would be great f that could be combined with a WMI filter: SELECT * FROM Win32_ComputerSystem WHERE (Manufacturer  = "Red Hat") AND (Model = "KVM")

Thank you for your help :)

  • Hi 

    If you are monitoring the nodes already you have that information in Orion so the report is simple. (WMI filters can only be used on Windows machines and only when you query the node itself for info. Not doable or needed here.

    Is this what you after?

    If so import below report to your Orion and you have the report.

    <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:TableConfiguration" xmlns:b="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Tables"><a:DisplaySubTitle/><a:DisplayTitle>Custom Table</a:DisplayTitle><a:RefId>1905ee3e-a9c9-45ef-b128-55a4597da0f0</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>Caption</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>tmgssesql003</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 i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Presentation"/><b:PropertyName>Node/Caption</b:PropertyName><b:RefId>cbca633f-1b34-2ef9-67ec-9c0cb3310490</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>Total Memory</b:DisplayName><b:Field xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"><c:DataTypeInfo><a:ApplicationType>Core.Bytes.1024</a:ApplicationType><a:DataType><a:Data>System.Single</a:Data></a:DataType><a:DeclType>Integer</a:DeclType><a:DefaultAggregation>NotSpecified</a:DefaultAggregation><a:DefaultDataUnitId>core.bytes.1024</a:DefaultDataUnitId><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>96,00 GB</a:PreviewValue><a:Units>B</a:Units><a:UtcTimeIsInLocalTime>false</a:UtcTimeIsInLocalTime></c:DataTypeInfo><c:DisplayName>Total Memory</c:DisplayName><c:NavigationPath>Stats</c:NavigationPath><c:OwnerDisplayName>Node Current Statistics</c:OwnerDisplayName><c:RefID><c:Data>Orion.NodesStats|TotalMemory|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.dataunit</c:PresenterId><c:Values><a:ContextValue><a:Name>UnitPrefixId</a:Name><a:Value>core.bytes.1024</a:Value></a:ContextValue><a:ContextValue><a:Name>UnitSuffixIn</a:Name><a:Value>B</a:Value></a:ContextValue><a:ContextValue><a:Name>UnitSuffixOut</a:Name><a:Value/></a:ContextValue><a:ContextValue><a:Name>DecimalPlaces</a:Name><a:Value>2</a:Value></a:ContextValue></c:Values></c:PresenterRef></b:Presenters><b:PropertyName>Node Current Statistics/Total Memory</b:PropertyName><b:RefId>f05e2e6e-92c0-f1c0-8b0f-01c217df1415</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 Memory Used</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.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>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>94 %</a:PreviewValue><a:Units>%</a:Units><a:UtcTimeIsInLocalTime>false</a:UtcTimeIsInLocalTime></c:DataTypeInfo><c:DisplayName>Percent Memory Used</c:DisplayName><c:NavigationPath>Stats</c:NavigationPath><c:OwnerDisplayName>Node Current Statistics</c:OwnerDisplayName><c:RefID><c:Data>Orion.NodesStats|PercentMemoryUsed|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/Percent Memory Used</b:PropertyName><b:RefId>8dbc5f60-ec85-88ff-3347-9555e297f031</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 i:nil="true" xmlns:c="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"/></a:ConfigurationData></Configs><DataSources xmlns:a="http://schemas.datacontract.org/2004/07/SolarWinds.Reporting.Models.Selection"><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|MachineType</a:Value></a:Expr><a:Expr><a:Child i:nil="true"/><a:NodeType>Constant</a:NodeType><a:Value>Red Hat</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>AND</a:Value></a:Filter><a:MasterEntity>orion.nodes</a:MasterEntity><a:Name>RedHat Nodes</a:Name><a:NetObjectId/><a:RefId>00a34f4a-92e9-479b-834b-4640714ec172</a:RefId><a:Type>Dynamic</a:Type></a:DataSource></DataSources><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/><a:Title>Test Report - Red hat</a:Title><a:Visible>true</a:Visible></Header><LimitationCategory>Default Folder</LimitationCategory><ModuleTitle i:nil="true"/><Name>Test Report - Red hat</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>960</a:Width></PageLayout><ReportGuid>4862a5c8-ad2d-46fc-a1c4-34c2426175b2</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>1905ee3e-a9c9-45ef-b128-55a4597da0f0</a:ConfigId><a:DataSelectionRefId>00a34f4a-92e9-479b-834b-4640714ec172</a:DataSelectionRefId><a:DisplayName>Custom Table</a:DisplayName><a:RefId>1dc0ebad-3337-4d4f-8e53-7e00f28b9262</a:RefId><a:RenderProvider>SolarWinds.Reporting,Table</a:RenderProvider><a:TimeframeRefId>ffffffff-ffff-ffff-ffff-ffffffffffff</a:TimeframeRefId></a:SectionCell></a:Cells><a:ColumnGutter i:nil="true"/><a:PercentWidth>100</a:PercentWidth><a:PixelWidth i:nil="true"/><a:RefId>a4b1ae8c-b55b-4626-bfaf-b67f008775bb</a:RefId><a:Subtitle/><a:Title/></a:SectionColumn></a:Columns><a:RefId>533169af-7a94-413a-9480-225d9b5ff6e6</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>c15d81d0-2e42-4437-b129-324d3ba622fe</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></TimeFrames></Report>

  • Thank you, but sadly that does not work. The Nodes are Windows VMs. Only the hypervisor declares them as "Manufacturer"  "RedHat" in WMI.

    Since I need only the VMs of this hypervisor,  tried to make a new dynamic query for your report with the MAC address starting with 7C:4C:58, but I cant select the MAC addess. Then I tried to bind it to Vendor = Windows and get the error that "is not compatible with resource configuration"

  • Ehh, They are windows servers but hypervisior say they are RedHat!?!

    Ok, so it's the VM's you want the report on then, not the nodes? They are different objects in Orion. Do you have VMAN also or just the "basic" virtualization monitoring?

  • It's Sale HC3 Hypervisor, there is no plugin for Solarwinds. As I said, I can identify the nodes with the WMI query or with the MAC starting with 7C:4C:58. For Solarwinds these nodes look like any other Windows Node. But unlike VMWare, Scale HC3 does not show me the total RAM of all VMs and we need to monitor that.

  • Ok, understand now. But you monitor the servers as nodes, don't you get the total RAM there?

  • Thats exactly my problem: I can only get the "Percent Memory Used". I just don't find the total RAM. That's why I seek help here since it looks so easy but there is no report I can use and I could not build a report since I did not find the total RAM as value.

  • Ok, do you see volumes on the nodes within Orion? If so do you there have a volume called "Physical Memory"? If not, when you do a list resources on the node do you see something like below? There we have memory on two places:

    Wonder what memory info we got in orion so we can create the report.

  • These are "normal" Windows Nodes, so yes, I see the "Physical Memory". I also see "Memory forecasts" etc. I just can't build a report with the very simple Total RAM a node has assigned.