bourlis ✭✭✭✭✭

Hi Alanaraki, I think your problem is the 'and' statement where there should be 'where' statement. Also, you may want to try using the status number than status description. Lastly, you don't need a 'join' statement in this SWQL query. See below for an example, this is how I would do it in my environment. SELECT n.Caption…

Yes, you can do that. In fact, last year we took 500 nodes from our SWOSH instance and we're going to do just that. However, at the last moment we chose to do a fresh built just to prevent "gremlin" migration from one system to the other. I don't know the cost or if it's functionally feasible in your environment, but you…

There's lots of different ways to tackle it, but here's my suggestion, do a litness test in SWQL Studio. You can test it all day long in a controlled environment that's not service impatching. Create a custom property called 'Alert_on_Test'. This will be used as an analog for testing that'll replace the node status. Now in…

If you have a newish version of SolarWinds, no you do not need Network Atlas. In fact, keeps saying Network Atlas will be retired in the near future.

Yes it does. The line in the sand, if you will, is when SolarWinds introduced the reoccurring scheduled maintenance. With that came several new tables, which I'm calling out in my query.

Nice! Now that's thinking way outside of the box!!! Thank you!

If I understand correctly, your SolarWinds is sending out 600+ node down alerts when you reboot your SolarWinds server? If this is correct the problem is most likely the node down trigger condition for the 600 servers. I would double check the scope of alert and make sure that it's not set to All Object in my environment.…

Your question is too vague and too vast same time. You might want to start over but more focused. Like this: How do I configure a high interface utilization alert for a Cisco device in SolarWinds? <or… but not both»> How do I configure a Cisco device to send SNMP traps for STP root change and how to I setup SolarWinds to…

I actually do something like this right now. Here's what I have setup I setup a foundation trigger item. This could be a site naming standard, IP address range, a single custom property, or multiple custom properties like floor, comm-room/data center row. This is an example of an alert that I have setup. Trigger Condition…

I don't know how far you are on your journey, but I shared a modern dashboard for suppressed alerts that you might want to look at. Global Suppressed Alerts Dashboard - THWACK I also posted to this thread where I supplied info on a Node Details widget that shows the start|end dates of the muted|unmanaged node "Nodes…

I often get error like this, but the dashboard gets uploaded anyway. Have you searched for the new dashboard yet? Just in case here's the SWQL query. SELECT n.Caption AS [System Name] , CASE when s.ScheduleTask.ScheduleType is NULL then '' ELSE s.ScheduleTask.ScheduleType END as [Schedule Type] , CASE when…

I often get errors like this, but the dashboard gets uploaded anyway. I would go to manage dashboards and search for your new dashboard. If it's not there then here's the SWQL query: SELECT n.Caption AS [System Name] , CASE when s.ScheduleTask.ScheduleType is NULL then '' ELSE s.ScheduleTask.ScheduleType END as [Schedule…

Hi WinterSoldier, Here's the SolarWinds KB article on how to upload/download dashboards into SolarWinds. https://documentation.solarwinds.com/en/success_center/orionplatform/content/core-fusion-dashboard-import-export.htm The assumption to this KB article is that you have SWQL Studio installed. If you do, then all you need…

Oh man, too many to list! My head is spinning! Here' a small list of my wish list. I'm sure more wishes will pop into my head throughout the day. RBAC Advanced auditing paired with self-health stats. I want to know the 3 W's - who, what & when. I want to know the possible ramifications, for example if a server is deleted,…

KNW316, I ran into a similar issue after I upgraded. My fix was to completely rebuild the modern dashboard. My new dashboard is more streamline and supplies more information that reflects the new scheduled & reoccurring suppression. Take a look here Global Suppressed Alerts Dashboard - THWACK. You can download it and…

Hi, List Resources log reports can be found in C:\ProgramData\SolarWinds\Discovery Engine\DiscoveryresultsDump.txt , DiscoveryState.log.txt, & OrionDiscoveryJob.log.txt. If you have additional polling engines, you'll need to check the logs on the corresponding polling engine. Also, here's a neat SWQL query I built for…

Hi rafaelPISE4, Can you supply any details, like the type of server, is the SNMP v3 settings in an application or in the OS itself, what's the error message, edited example of your SNMP settings? When I first implemented SNMPv3, whenever I ran into a wall I always rolled back to the simplest version of SNMPv3 and worked up…

PLZ, PLZ PLZ, implement this! We're in the designing stage of building a PowerShell script that will do this, based on a custom property. I would much rather have this inherently by SW. Now, if SW really wants to go for the gold here's the next generation goal. Implement NickOD's & terryk's idea (obviously). Add a…

Also, you might want to run this as report, SWQL Studio query or a moder dashboard view. This query looks for enabled alerts that change the CP's. Case in point we have alerts that dynamically populate CP's based on a couple manually entered CP's. SELECT a.Name as [Alert Definition Name] , a.Description as [Alert…

I have a SW Admin Aduit Modern Dashboard, that I use to track things like this. My query pretty much matches Lofstrand's but I'm auditing more than changes. I want to see who adds and deletes CP's too. Here's my query: SELECT top 2000 tostring(tolocal(a.TimeLoggedUtc)) as [Time Audit] , a.AccountID as [Edited By] ,…

I upgraded last week & I have 4 web servers too. I'm assuming you're running through a load balancer, if so did you already do this fix? I ran into this issue after upgrading, but its a known issue and it was a fairly easy fix. SolarWinds Web Console Shows RejectURL=true When Accessed Through Load Balancer FQDN after…

To be 100% honest I don't worry that much about if all the systems being detected pre-install on the update tool. I figure I can always download the installers and install them after the main polling engine is upgraded. I mainly focus on the post installation and making sure all of the polling engines are up and operating…

I upgraded last week. I ran into some issues pre-upgrade, and a few issues post upgrade. However, in all fairness, I believe my issues were with our environment and not with SolarWinds itself. Pre-upgrade - We have 4 additional web servers, HA main polling servers and 14 additional polling engines. The upgrade guild said…

Hi patriot, I have 2 options for you, but these are made with some assumptions of your environment. Your data equipment is Cisco. You have NCM. There's a service account that SW NCM uses to collect config data. If these assumptions are correct, then you can use this SWQL query in a classic widget to show CDP neighbors.…

martian_monster, Food for thought, you can combine both your SWQL queries into one SWQL and save from dashboard real estate. If you choose to do this then simply use this query: SELECT n.NodeID , n.VirtualMachine.VirtualMachineID as VMID , n.Caption AS NodeName , AVG(n.CPULoadHistory.AvgLoad) as AvgCPU FROM Orion.Nodes n…

Yes we've done that but it's not a smooth process and it takes a while, especially if you have a lot of nodes to do. What I've done recently, and it much cleaner than your suggestion, is to change the management from agent based to WMI based and then changing it back to agent based. This is actually much cleaner than your…

For the life of me I don't understand my Solarwinds wants me to drink my Ovaltine..... but ok.

i think there are several enhancement requests like this, I know for a fact that I've created on as this is a major issue for me too. As a stop-gap here's a a couple small SQL report that you can use that might help you till something better comes along. It doesn't cover everything, but something is better than nothing.…

completed

On the surface I like this idea and I see where your coming from, however there's a couple issues with this request in it's current form that would need to be addressed. * Logging - Solarwinds does a horrible job in logging who does what at the admin level. Who disabled global alerting would have to be logged. This is even…