netlogix

Well they closed my ticket and said it will be addressed in 10.2.1

I'd be happy to apply a "beta" fix with a buddy drop if you want a tester.

With the SNMP timeout setting, you may need to put it in "HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\SolarWinds.Net\SWNetPerfMon\Settings" if your Orion server is 64bit.

so, I think the way for you to work is: ${SQL:Select Floor(Convert(float,(Convert(datetime,'${DD}/${MM}/${Year} ${HH}:${Minute}:${Second} ${AM/PM}')-Convert(datetime,'${AlertTriggerTime}'))))} days and ${SQL:Select Convert(time,Convert(datetime,'${DD}/${MM}/${Year} ${HH}:${Minute}:${Second} ${AM/PM}') -…

weird, what version are you using? Do you have SAM, or just NPM? (I think you need SAM to do this).

this works, if you monitor with WMI instead of SNMP.

I don't know if this helps, but you can do more of a wild card thing i.e.: inner join Nodes on Interfaces.NodeID = Nodes.nodeID where (interfaces.Status = 2) AND ( Nodes.Caption in (Select ContainerMemberSnapshots.Name from ContainerMemberSnapshots inner join Containers on Containers.ContainerID =…

I got an alert like that to and have been thinking about it. I came up with this: ${SQL:Select Floor(Convert(float,(Convert(datetime,'${Year}-${MM}-${DD} ${HH}:${Minute}:${Second} ${AM/PM}')-Convert(datetime,'${AlertTriggerTime}'))))} I also tested it up to 23:59:59 and it returned 0. I had a different one that would…

That looks like it is having an issue with converting the date. I think it is something to do with the difference in date format. yours is dd.mm.yyyy, and mine is mm.dd.yyyy. So I think your SQL server is complaining that it can't find a month 26. There has to be a way to handle the difference in date format. I will look…

I opened a case too: Case #292773 - "Trap Type changed to a Generic name"

are each of those assigned to all the servers? That would end up being 67,000 assignments, but that still shouldn't be 60gb of data in those tables. Are there errors in ProgramData\Solarwinds\Logs\Orion\swdebugMaintenance.log? If so, that's probably why support gave you the scripts, but the maintinance still might not be…

yeah, when I click log out, it removes every setting from the settings table for my name. But I don't know if that is by design or not... If I see it for any other reason I'll let you know.

Something like: SELECT TOP 1000 * FROM [NetPerfMon].[dbo].[APM_CurrentComponentStatus] where Availability = 1 and (PercentCPU is null or PercentMemory is null or PercentVirtualMemory is null)

Not sure if you had grabbed from my last post, but I edited it with a different sql script that you would have to run a few time till it cleared things up. Before, it could try to do too much for one statement and fill the trans log (your current issue). This one only delete 5000 traps at a time, you might be able to…

ok, so it could be: insert into settings ([SettingID],[Name],[Description],[Units],[Minimum],[Maximum],[CurrentValue],[DefaultValue]) values ('SWNetPerfMon-Settings-Response Time Retry Count','Response Time Retry Count','Maximum ping attempts before placing a node in the state of warning.','','1','20','4','1') Thank you…

I think the biggest draw back of Orion is also it's advantage. Orion can do almost anything, but it is very basic until you get it fully set up and customized, but it comes out of the box with very little setup. Although, it could be overwhelming if you had to set it all up right when you got it. But it is a little…

You may also want to see if there is a specific trap that is filling the log and setup a trap rule that drops/deletes the event upon arrival. you can use this to try to find what is so noisy: SELECT [IPAddress],[TrapType], COUNT(*) as countof FROM [NetPerfMon].[dbo].[Traps] inner join [NetPerfMon].[dbo].[TrapVarbinds] on…

If it is *really* important you could, through APM, create a script that would use Power Shell and pull the info like this guy did: blogs.vmware.com/.../monitoring-esx-hardware-with-powershell.html Not very pretty, but possible with a bit of tinkering.

ah, good, that should work just fine, if you open sql tools , what do you get if you use: select Convert(float,(Convert(datetime,'2012-10-02 10:22:20 AM')-Convert(datetime,'2/10/2012 10:08:19 AM'))), Convert(time,Convert(datetime,'2012-10-02 10:22:20 AM') - Convert(datetime,'2/10/2012 10:08:19 AM')) I get: 235.009733796296…

How do you get the switch to send these snmp traps? Is it one of the default ones, or do you need to enable it?

Get the volumes monitored. Either go to each node and click list resources and check off the volumes you want, or run a discovery (either against your subnets or a list of IPs/hostnames) and import them that way..

about how long till the next release. (what Month or Quarter or Year) I ask because it feels like last week we got 9.5 (I know it wasn't).

NPM 10.1 has more features, but doesn't have the volume monitoring nor the CIM/WBEM for the CPU, Temp, Power Supply monitoring. It did add a lot of features and is a good step in the right direction.

the easiest way I know to check if the right process is listening is to open a cmd prompt on the server and use: netstat -ano | find "514" | find "UDP" then use taskmgr to find what pid is using that port, this case is 8744 G:\>netstat -ano | find "514" | find "UDP" UDP 0.0.0.0:514 *:* 8744 If that looks good, check for a…

good call! I guess I shouldn't be trying to think late at night. I must have upgraded on 10/4 because I don't have any "SNMPv2-MIB:snmpTraps.7" prior to that and it has much fewer count of entries and post it has much less varity of Trap Types (mostly SNMPv2-MIB:snmpTraps.7). Post upgrade I have 932,671…

I would also suggest you do the raid 10 like mcdridea said (the RAID10 will have better performance for Orion because it is mostly write, but the RAID 5 would be better if there were gonna be a lot of sequential reads). If your database grows to 550gb, there is something wrong! You either won't be able to poll that many…

you might want to look at what snmp traps are coming into the server and start writing drop rules for some of the noisy pointless traps (or find the source and fix them if it is a valid problem generating the noise). One of the ones I started to drop was Domain Authentication Failures for the domain and some BES noise that…

I don't know if this helps, but here are all my distinct traptypes and OIDs. SELECT Distinct TrapType, OIDValue FROM [Traps] inner join TrapVarbinds on TrapVarbinds.TrapID = traps.TrapID where OIDName = 'snmpTrapEnterprise' order by TrapType, OIDValue TrapType OIDValue BLACKBERRYSERVERMIB-SMIV2:components.15.120.20.2…

I have seen, if you use APM, it shows the load of a single processor for a SQL process. What I mean is; NPM showed the node around 20%, but APM showed the SQL process at 98%. When I investigated further, I found a single query in SQL was pegging one (of eight) core. Do you have APM setup?

Ok, here is what I have now: ${SQL:Select datediff(day, Convert(datetime,'${AlertTriggerTime}'),Convert(datetime,'${Time}'))} days and ${SQL:Select Convert(time,Convert(datetime,'${Time}') - Convert(datetime,'${AlertTriggerTime}'))} It's a bit ugly, but I can't think of a better way without some type of extensive "if then…