I have tried a couple different methods, but I'm not to familiar with swql. I was able to pull certain info, but certain other queries I run in the db don't necessarily extend to the report writer. It will take me a while to get a hang of it. I want to report on the availability for last month, from business hours 7am to…
I am trying to write a query to pull all IP addresses in an instance of SolarWinds and associate it with the correct node and interface information. I can get the list of IP Addresses from the Orion.NodeIPAddresses (SWQL) / NodeIPAddresses (SQL) table. I can join that on the numeric NodeID to the Orion.Nodes (SWQL) /…
As the title says, I would like to create a report that will narrow down a specific groups of alerts (we have alerts created per customer, several of our customers have alerts configured on this server), and for each one of the customers devices narrow down what alerts can trigger and what action is taken when that alert…
Has anyone had any luck writing a report showing global protect VPN usage by users.
I can't seem to find out how to change a web-based built-in report that is setup with a table to a graph. The built-in report that I would like to change to graph is Average and Peak Traffic - Last 7 Days Does anyone know how to do this? Thanks!
Hey Guys, I recently had one of my customers ask for a report that displays all IP's associated to every device on the network. Figured I would share, there might be a canned report that accomplishes the same task, but for something this simple I just wrote my own query. (Faster than looking for the report). My customer…
We have a weekly audit report that is pulling all of our running nodes showing in Orion VIM tables that are not monitored natively in Orion. We want to replicate this functionality for our Cloud Instances. We are part way there but I am looking for a way to add in the private IP addresses that are assigned to the node. I…
Availability report for last 30 days based on the custom property with the unmanage time duration. For example in need report like Env is our custom property: Env Availability Unmanage duration A 90% 10 hours B 99% 2 hours C 10% 1 hours
Considering this report: DECLARE @StartDate DateTime DECLARE @EndDate DateTime SET @StartDate = ${FromTime} SET @EndDate = ${ToTime} SELECT Interfaces.InterfaceId, Nodes.NodeID, Nodes.Caption AS NodeName, Interfaces.Caption AS Interface_Caption, Maxbps_In90, Maxbps_Out90, Maxbps_In95, Maxbps_Out95, Maxbps_In99,…
So Solarwinds has this widget under Load Balancing called "Concurrent Connections by Virtual Server" which is great if you have any F5's in use. The only problem is, you can't filter for any virtual servers in the widget!! All you get for widget editing is to increase the number of virtual servers to display to a max of…
It looks like you're new here. Sign in or register to get started.