dgsmith80 · Monitoring Engineer · ✭✭✭✭✭

SELECT DISTINCT [N].CustomProperties.Team AS [Team] --Update with the CustomProperty Name of your choice. ,COUNT ([N].NodeID) AS [Quantity] FROM Orion.Nodes AS [N] WHERE [N].Status = '2' --Update with the Status you require 1 for Up, 2 for Down etc GROUP BY [N].CustomProperties.Team --Update to match the CP used above.

The problem is that this means the Nodes are not viewable to those accounts with the account restriction. I have a similar issue in my environment in that the users want to be able to view the entire environment, but I don't want to give any of them Edit Nodes rights to Nodes they don't look after. The way I got around…

Agreed - Sadly none of the Dashboard KPI or Pie Chart widgets allows individual hyperlinks per measurement only per widget. I would upvote a FR if one was created ;)

I do something similar for one of my Mod-Dashboards which shows Down Nodes per Team I went with a Pie Chart rather than the KPI Widget as it was just easier.

To clarify though - The answer is No. You can't manually clear a warning. You can adjust thresholds to remove the warning from that device (which Ben suggests), but if the specific metric is above the said threshold it will be in a warning or critical state and you can't just clear that. Don't forget that Warning /…

I read the OP as meaning that in a Custom Query widget you can select the "Number of Rows Per Page" option to say 50. That means your Widget will display 50 entries per page on your Dashboard BUT with the "Enable Search" option you could still search for any number of devices from the full query. The "Search" function in a…

I would argue this isn't currently possible because the Modern Dashboard Tables are not paginated. It is a full list that you scroll down. So you can run the query as it is and set the widget size so that it only shows the first 50 entries, then when a user searches it will query the full table but will still be able to…

It's really only limited by your own HTML coding ability I guess :P

Hi Tom, I use both Custom HTML and Custom Query to display text. Custom HTML is by far the better option if you want formatting in your message but if you just want a few lines of text you can use a Custom Query. If you give us an idea of what exactly it is you want to display we might be able to help provide a better…

As the error indicates you can't export Data that is not in a Table to CSV so if you have charts or anything like that in your report you won't be able to export to CSV.

You can see in this example I have the widget showing the devices that are UnManaged and the time/date they are set for along with who did that. We also use a Custom Property for Maintenance Notes which in this example was populated by some scripts we use to automatically unmanage nodes down after X days.

Hi @"ramana.ls", Can you give an example of the type of information that you're trying to extract into the report? I have custom reports based around Audit information which is used by my Operations team because they don't have Admin access to see the Audit information on Node details or Message Center. They don't have any…

This is something my team are currently working on as we have a massive gap in terms of Maintenance Scheduling. Like @"mesverrum" I only have a small team so I'm all about self-service and automation where possible, while at the same time not giving the entire staff team admin-level access. We currently have all staff with…

Not 100%. The list from your screenshot is the Discovered Interfaces. When SolarWinds scan's your device it discovers ALL possible Interfaces on that device based on the MIB Table. It catalogues them all regardless of which ones you go on to actively import and monitor. The Yellow highlighted ones are just the ones it…

Hi @"planglois" so when you run a discovery SolarWinds will automatically scan for and detect all possible interfaces on that device as it is scanning the OID at the Node level and building an IFINDEX Table. Notice how SolarWinds doesn't show the status of those interfaces? So it could be that they were not Online? The…

Yum, Firstly congratulations and I, of course, wish you the very best of success with your new endeavours, our loss is most defiantly your new companies gain. I still remember when you first joined the THWACK team - what an amazing journey it's been. I just want to say Thank you for all the hard work and dedication you…

If you open the XML up or import it then you will find the SWQL inside: SELECT n.Caption ,n.NodeID AS [Node] ,n.Interfaces.InterfaceID AS [Interfaces] ,n.Volumes.VolumeID AS [Volumes] ,n.Applications.Components.ComponentID AS [Components] FROM Orion.Nodes n

We have a dedicated dashboard in our Tools View which our team use as part of Daily Checks: It uses the below SWQL SELECT TOLOCAL(ST.EventTime) AS [Start Time] ,TOLOCAL(ET.EventTime) AS [Finish Time] ,CONCAT(--Downtime formatted (CASE WHEN (SECONDDIFF(ST.EventTime,ISNULL(ET.EventTime, GETUTCDATE()))/60/60) >= 1 --Hours…

Robert - These all moved to Log Viewer now.

Do you mean devices your not monitoring within SolarWinds? Log Viewer is Node-based, so for every log that SW receives it needs to tie that message to a NodeID. If your node isn't monitored in SW it will drop the packet and tell you that you have messages from an unknown source. Goto Settings > All Settings > Log and Event…

Hi @"Chris-S" - So the dependencies table in SolarWinds will simply cause the Child Members to change the status to Unreachable. When you use the Custom Property for the Node Selection criteria of your Alert that is just telling the alert which Nodes "Could" trigger this alert. The node still needs to meet the specifics of…

Hi @"amoss24" I just wondered if your able to explain how you setup the clear rule and used it as a reset condition for your alert? I have similar scenario in my client for things like OSPF & BGP Resets, where they want an alert to trigger on Down, but want it to Reset on Up etc. At the moment I've got a fairly complicated…

There is no way to do this, the dropdown comes directly from the Engines table. One of my customers has 20+ APE's and they don't use the Primary for anything other than some static devices were monitoring. However any of the power users that can add nodes always end up adding to the Primary Server. There are two things you…

As a premier support customer, I would argue that the cost, while heavy is very worthwhile for the right environments. I'm a massive fan of "Don't knock it till you've tried it. I think if you already think the response time from support is slow, putting a pressure on them to respond in a certain timescale is going to…

One of my colleagues edited it slightly to comply with our corporate palette scheme. document.addEventListener('DOMContentLoaded',function(){ setTimeout(function(){ var el = document.querySelector('sw-evaluation-banner'); el.innerHTML="<div class='sw-eval-mode' style='background-color:#E6A000; position: relative; z-index:…

Proof this is still working in 2019.4. My use case is a little different but it does the job.

Good Luck

I think that is the original version of your software, which you are trying to download from the Licence page. I logged onto the Solarwinds support page and downloaded the upgrade and it was called: Orion 9.1 - SP3 - Find it under: http://www.solarwinds.com/support Could anyone please confirm if this is the correct file…

Thanks for the posts guys, much appreciated. bberry - The answer depends on if your Database is stored on a seperate SQL Server. If like me your SQL DB is on the same server as your Orion software then you simply need 1 CAL for the server itself. If you have a SQL Server running the databases and 1 or more servers running…

Ok - Maybe mesverrum​ will be able to shed some light as the original code is his.