jamison.jennings ✭✭✭✭✭

I fat-fingered the 30th...can that be forgiven?

I'm no DBA either but have found that taking a SQL querying class has really helped my skills as a SolarWinds administrator to get those off the wall report requests completed. Our DBA's are really great at helping us figure out what is going on or what's wrong and most times even quicker than SW support can respond.

I had issues as well.

I was in college typing a paper in the library with WP (I didn't know computers then), I hit some button and everything I was working on appeared to be gone. No one in the library could help me. I'm out to dinner later that night with friends and telling my sad story about my paper when one of them says, "I have a PC at…

How does SW draw the winner? (Hey, it worked last week!)

I get this message when trying to remove the Main Pool. The crossed out server is the original server and is the standby and has been shutdown. I also tried when it was still online and got the same error. Any suggestions?

I fear upgrades, even though the lab upgrade was successful, production always seems to have hiccups. I fear when SA's perform "remediation" that breaks SW functionality. Even though I walk in the valley of silicon, I shall fear no evil.

bump, bump, bump, bump

Well, as a Federal customer.....we're waiting "official approval" for Windows Server 2016 before we can upgrade to all the yummy goodness.

SolarWinds

There's an application on the Orion Server called Orion Universal Device Poller. You will need to RDP into the server, open this app, and check the UnDP(s) for that setting if they are showing up on the page but not applied to the node.

On your Orion server, open Orion Universal Device Poller. Right click on the UnDP(s) Click Web Display Make sure the "Do not show this poller if it is not assigned' box IS checked.

@krishnamishra0786 You can put any of the SQL queries that I supplied into an Orion Report writer "Advanced SQL" report.

Create a report at the EOC level, that will also work across all Instances.

Since different UnDP's could have different values, I don't know if you can have a "Universal" alert for all UnDP's....maybe one Universal alert per Named UnDP. e.g. I have a UnDP for an environmental device that returns Temp....I would create an alert for that Temp UnDP but I wouldn't want that alert to cover another UnDP…

https://www.youtube.com/watch?v=jz0WlnuY-nI

Then you have it easy. I didn't get prompted to reboot until I got up in the NPM 12, but that may have to do with open files at the time. Just follow the upgrade path and you should be fine. If it were me, I would upgrade EOC first before upgrading the Orion Platform.

Green LED is for Nodes status only I believe.

SWQL: Select N.Caption, N.IP_Address, N.Interfaces.PhysicalAddress from orion.Nodes N SQL: SELECT N.Caption, N.Ip_Address, I.PhysicalAddress FROM [dbo].[Interfaces] I Join dbo.nodes N on I.NodeID=N.NodeID

I'd suggest using the "Tags" feature to organize the ones you use in your Org.... That helped me.

If you want to see Node1 and Node2 IN the resource box use Caption='Node1' OR Caption='Node2' If you want everything in the resource box except Node1 and Node2 use Caption<>'Node1' OR Caption<>'Node2'

How about the magnifying glass on the top banner on the right, in between your username and the help link?

Settings SAM Settings Manage Templates Create New Template continue as before.

-1 for me for getting it wrong. -10 for SolarWinds for not cleaning up the database when they deprecate tables.

It's been sent up to dev. One note to add is that I also have a 10.7 install with no nodes in it yet and it takes long time to open as well. So there goes all the database bloat theories.

Like you have already found, 'Hardware' doesn't exist in the the database with the values you are looking for. SolarWinds is making the determination for that field in the Nodes Details resource box if the node exists in 'VIM_VirtualMachines' Like this: Select Caption, CASE when NodeID in (select NodeID from…

Depending on the value returned.... WHERE CustomPollerStatusTable.Rate ...

You will need to upgrade EOC to work with the current versions of your other products. You can do it before the other upgrades. Do you have any additional pollers or webservers?

The Node won't change status, the UnDP should though.

Dobbs​ query returns the correct results. I tested on a node with 32 CPU's.