We are using an API query to pull historical CPU/memory historical data for a select group of servers. The query works as expected for detail and hourly stats, but the data only retrieves as far back as the hourly stats are kept (100 days in our environment). We would like to include the daily stats as well which go back a…
hi, I'd like to write some custom script (PS or Python) that would be exposed over Solarwinds rest api so other systems could use it. Is this possible? br
I prepared a modern dashboard and I wanted to add it to the noc account I opened solarwinds. When I look at the noc account, it gives the following error
Situation: Using the SWQL Graphical Query Builder to get Average CPU status by Hour for a Table. The day I created it, it looked good, but I noticed the next day the same data was there. Then I looked at the dates on the SWQL builder and it was from the previous day. The SWQL code it outputted was for a single hour on a…
All, I am looking for some SWQL/SQL code that can pull out the following information from the database. Columns Include: * Server Name * IP Address * CPUs * RAM amount * C:\ Percentage Used * E:\ Percentage Used * and all other volumes on the server
All, I am looking for some SWAL/SQL code that can pull out the following information from the database. Columns Include: Device Name IP Address Make Model Serial Number Temperature Fahrenheit and Celsius
Dears Thansk for the wonderful community What is the query we can fetch the active alerts on weekly basis , ? kind of historical data Thanks for your response.
So I am green to SQL and SWQL. Im trying to build a custom report which looks at each Virtual Machine and returns some values. The report generates data but two of these values return Bytes and not GB. I would like to convert them to GB. Is there a quick way to convert the Freespace, and Capacity? SELECT…
Hello, help me get "the bar" of the indicator next to the percentage of memory, as shown in this photo and show the percentage but with the following query I get the following: SELECT n.Caption, n.NodeiD, n.PercentMemoryUsed, n.CPULoad, '/Orion/images/StatusIcons/Small-' + n.StatusIcon AS [_IconFor_Caption] FROM…
Hello everyone, I have been running into an issue with creating a custom report that contains certain information from AppInsight SQL server in a table format. I used to be able to do this before the SW compromise but apparently this option is not available to be presented in table but in a chart with make the report to be…
It looks like you're new here. Sign in or register to get started.