The most recent content from our members.
Team, To display events summary on the custom widgets as the Top 10 events should display in CST time zone, I have created the below script but its not working. Please someone help on this. Thanks SELECT TOP 10 DATEADD(hour, -6, E.EventTime) AS [Time of Event], E.EventTypeProperties.Name AS [Event], E.Message AS [Message],…
I am trying to get the hardware information in my nodes report. How do I get that? Any suggestions or ideas please? Here's the below screenshot which displays hardware information of any node on the node details page. Whether it is virtually hosted or a physical one. I was working on SWQL which gets the list of all the VMs…
Hi everyone, I’m trying to monitor interface health by calculating error and discard percentages in SolarWinds — specifically to alert when: InErrors%, OutErrors% InDiscards%, OutDiscards% are greater than 1%. I created a SWQL query to calculate these percentages using packet counters like unicast/non-unicast packets.…
As of 2025.2, we can now create recurring maintenance schedules for our nodes and alerts on daily, weekly, or monthly frequencies and assign them accordingly. However, there is no easy way for a user to view which nodes have upcoming maintenance or even just the assigned schedule definition. Through my own efforts in SWQL,…
Looking to have Solarwinds to run data export reports that capture all interfaces that are administratively up, but operationally down for more than X days? I need to have this include ports that have not been used since before the last switch reload, so that it specifically does not use "last used date/time" by the date…
I just noticed where I can fill in a "Reason" field for when putting a node Maintenance mode to mute alerts or stop managing the node. I'd like to include that field value in some of my custom SWQL queries. Where is it exposed via SWQL so I can find it using SWQL Studio?
I love using SWQL for modern dashboard, classic dashboard widgets, alerts & reports but i hate having to switch back and forth between SWQL Studio and SolarWinds. So this feature request is to bring SWQL Studio into SolarWinds Platform/ SWOSH. This is kind of do-able when building modern dashboards, so why not bring it in…
Posting an idea that was shared by josh.haberman: "...It would be nice to have a Visual Studio Code extension for SWQL. Ideally it would be nice to duplicate the capabilities of SWQL Studio in VScode but, even a simple linting capability would be great. My main push for this is that I use a Chromebook full time at work…
Hey All, I’m new to SolarWinds reporting and would like to create a report with the following information: * Node Name * Start of Downtime * End of Downtime * Duration I only need the report to cover the last 7 days. From my research, it seems that Orion.AlertStatus might be the best table to pull the required information.…
The Orion.VIM.VirtualMachines table doesn't show the current VM status. For example, on the VIM main page /Orion/VIM/Summary.aspx?view=VIM+Summary, the machine is in Guest Status Critical, but in the cell Overallall Status, it's green. How can I get the current value?
It looks like you're new here. Sign in or register to get started.