netlogix

I changed 2 to: where Nodes.NodeID in (Select ActiveObject from AlertStatus where AlertStatus.Acknowledged <> 0 and ObjectType = 'Node' and acknowledgedtime > DATEADD(mi, -5, GETDATE())) and 3 to: where not Nodes.NodeID in (Select ActiveObject from AlertStatus where AlertStatus.Acknowledged <> 0 and ObjectType = 'Node' and…

But the account that solarwinds uses has to have the ability to run that command. The only commands I or NCM can run are show and exit. so it may attempt to run it, but it (I) don't have access so it doesn't do any thing. On my internal ASAs, that works, but that is because I can enable to 15 instead of 2 which has been…

"VM + SQL = bad" is only true if the virtual infrastructure wasn't built well enough. A lot of people have bad experience with virtualization when the infrastructure was not fully thought out. Just like if you installed a high demand SQL database server on a three to four year old server using one three 7.2K SATA disk…

+1 - we have a few places this is needed. 1) when a customer wants to export their transactions, a pop up "jquery" window (thats what the vendor calls it) displays info, I would like to validate that it contains data. 2) Kronos site uses java, I can make sure I logon, but thats it. 3) another app we give to our customers…

Just to make sure, you did configure the remote device to send in logs right? For Cisco, you could use something like: logging monitor notifications logging source-interface Loopback0 logging x.x.x.x Were x.x.x.x is the IP address or the Orion Server. Also, use "show logging" to see if switch/router is sending logs (out…

hmmm... I can't find it either... bummer I want to know now too.

It sounds like a pretty specific bug, what if, for a one time scan, you added all your possible snmp strings and not supply any windows credentials? It doesn't fix the bug, but it gets you past the stopping point. Maybe by disabling the windows (WMI) credentials, you might get 90% of the servers in. I don't know the exact…

If you are just looking for the math to be done, you could try ${SQL:Select ${AlertTriggerTime} - ${ShortTime}} Edit: hmmm thats not working... I think the variable types are wrong... need to do a cast or something... let me look at this, unless anybody else can quickly fix my mistake here. Ok, does this work: ${SQL:Select…

Oh, for 10.8.0.0 - 10.39.255.255, which might be what the original request was for, would be: "(10\.([8-9]|[1-3][0-9])\..*)" but you can not do that with a single subnet mask. If you want any other examples, I would be happy to provide them to show how regex would be better because you can do almost anything with it. if…

I changed the VMware values to unlimited, but it still is not working. I found a another error message as I was looking around: "Error while connecting to VMware device - The request failed with HTTP status 503: Service Unavailable (Failed to connect to endpoint: [class Vmacore::Http::LocalServiceSpec:00000000006816D0]…

Another thing I have seen that causes alerts not to fire is by using the alert suppression tab. The use case for that tab is confusing and should be avoided unless you *have* to use it. You don't have anything in that tab, right? (Just change the trigger condition tab to not include what in the suppression tab)

Ah, it's not about mass selecting it, it is that it does show up - right? thats a different thing, my suggestion would just make it so you don't have to click discover and check off for hundreds of nodes, but if it doesn't see the health resource under list resources, then that needs to be fixed first. Are they "Server"…

oh, the thing about the vlan, might only relate to cisco. Oh, and a universal poller would need to be used. Can they do tables? just throwing out an idea.

I have been working on something and it is working for me (somewhat). I have a SQL agent job that runs on the hour to update a custom property that has an expected average load based on the last 12 of this day (say Friday), and this hour, say 09:00, but I then add 08:00 and 10:00 to even it out a bit. I end up with 96 hour…

I run my single poller in server 2008r2 also, but I don't remember if i got any speed boost or not. my environment is small compared to byrona's (single poller and seperate DB), but it runs great (although it ran great on Server 2003 for me too). I have heard that SW is writing the new code to take advantage of 64 bit as…

whoo hooo! I can change the SSLEnabled, the hostname (I have one host name, but a different cname called "orion") and the port and viola! it works they way I want. I am just curios, what is going to happen next time I run the config wizard... is it going to set everything back? I don't really want to find out right now.

Is the Advanced SQL a Interface alert? And the Group a Node Group? If so, try: where (interfaces.Status = 0) AND ( Node.Caption in (Select ContainerMemberSnapshots.Name from ContainerMemberSnapshots inner join Containers on Containers.ContainerID = ContainerMemberSnapshots.ContainerID where Containers.Name = 'XXX…

I had an issue where my sw database maintenance (Database-Maint.exe) was failing because my temp DB couldn't grow big enough to handle the shrink process. Have you looked in "C:\Program Files (x86)\SolarWinds\Orion\swdebugMaintenance.log"?

I've wanted to do this also, so I can have a map that I designed that looks pretty, and multiple others that represent all the monitored items at that location/in that subnet. I think what I am going to do is create a dynamic group for each of those locations based on IP, then add that group to the map. (this even sets me…

I moved this to NCM - which is actually where the issue is. There is an issue with the nightly maintenance and they said it will be fixed in the next RC

The -2 should be icmp only nodes. When you use this, how does it look? SELECT DISTINCT Nodes.NodeID AS NetObjectID, Nodes.Caption AS Name, Nodes.CPULoad, Nodes.PercentMemoryUsed, DATEDIFF(ss, Nodes.LastSync, getdate())/Nodes.PollInterval As MissedPolls FROM Nodes WHERE Nodes.Status = '1' AND (Nodes.PercentMemoryUsed IS…

I think this is getting a little more complicated than it needs to be. What if you create your primary alert for "if server is down send email through primary mail" and leave that one alone, but setup another alert that is "if primary mail server is down send mail through secondary mail". Why suppress the other alert…

I also have this issue and have been trying to figure out how to fix it. I haven't opened a support ticket yet because I want to get it working right away so I reboot and the problem with that is then it is harder to troubleshoot. This started happening regularly (2-3 times a month) with the last 3-4 months. I am in the…

Why are you using AD for those users if they don't use AD except for Orion? Is it because of the grouping making the configurations of Orion simpler? If so, maybe some internal Orion user groups would be better, but I don't think Orion has that (at least not now). I see the AD auth piece just a way to off load password…

I am on 3.5 too

In my experience with other databases, this could be because the "Clustered Index" is not sequential (like the pk is guid and is set to the clustered index). And/or the primary key is the date/time the flow was generated (not flow received) and there are some flows that are getting there quicker causing a weird 'jitter'…

I am doing everything through SQL Query Manager, but you could use this. declare @StartDate datetime, @EndDate datetime -- Variable Range (30 days): -- Set @StartDate = DATEADD(Day,-30,GETDATE()) -- Set @EndDate = GetDate() -- Now -- Variable Last Month -- Set @StartDate = DATEADD(MONTH,-1,DATEADD(mm,…

I went into the alert and clicked "help with macros" and found this page.

Your ESX server are probably using root or a local user on the box, but with vCenter, you need a domain account that has read access, not the one you used to Poll ESX.

I am pretty sure it is. I know I got it, but I went from AM (Application Monitoring, exe stats through SNMP only) to APM to SAM (I know I get the upgrade with current support). It was really cheap when it was AM, and it was for all NPM nodes, but man the maintenance/support has gone up in price! But of course what it does…