netlogix

yeah, I had to create around 50 and I didn't like it either, but thats what I did. A scripting interface would have been nice.

That query is a little long for me, what about: Trigger: Where ( Left(IP_Address,9) in ('10.120.4.','10.218.0.','10.218.1.','10.218.2.','10.218.3.','10.218.4.','10.218.5.','10.218.6.','10.218.7.','10.218.8.','10.218.9.') or Left(IP_Address,10) in ('10.218.10.','10.218.11.','10.218.12.','10.218.13.') ) AND (DEVUATLIVE IS…

you could use SQL like this: Use NetPerfMon UPDATE [ActionDefinitions] SET [ActionDefinitions].[Target] = cast(REPLACE(cast([ActionDefinitions].[Target] as varchar(500)),'SMTPServer:1.1.1.1','SMTPServer:2.2.2.2') as Text) FROM [ActionDefinitions] Where [ActionDefinitions].[Target] like '%SMTPServer:1.1.1.1%'

Be careful with that method, if a node belongs to more than one group, then the field will only show one group (the last one retrieved by "select Name from Containers where Containers.ContainerID = (select ContainerMemberDefinitions.ContainerID from ContainerMemberDefinitions where Entity = 'Orion.Nodes' and Nodes.NodeID =…

If you use this sql: 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') Then it…

but you still need to provide Statistic Data, right? and that is only a numeric. You can put things in the message, but that isn't compared, just displayed, right? You can also query SQL through a batch file using sqlcmd (if you have sql tools installed). The only thing I could come up with is using NCM to do it because it…

I don't know if this helps get you on track, but here is an MS article on linked servers: sp_addlinkedsrvlogin (Transact-SQL)

you add the resource called "Custom HTML". (like the map resource or a cpu graph, etc)

You could add "or is null" in.

if you have a way to import a reg file, create one like this (the [-HKEY...] deletes the key first): Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SNMP\Parameters\RFC1156Agent] "sysContact"="MIS Department - (123) 123-1234" "sysLocation"="1324 Main St, Beverly Hills, CA 90210"…

Reheindel - You said server 2008 - 2008 R2 or 2008? in my opinion, stay away from server 2008. I have had nothing but problems with that OS, but 2008 R2 has been great and I have NPM 10.2(RC) and NCM 6.1 running on it. (had 2008 R2 since NPM 10.0) Also, I don't know if you were/are planning on it, but if at all possible,…

We have upgraded and have had no problems.

I didn't do an avg or the avg's, so it was a little weird, I think this one is better: JOIN CPULoadByDays ON CPULoadByDays.NodeID = Nodes.NodeID WHERE CPULoadByDays.DateTime >= dateadd(dd, -5, datediff(dd, 0, getdate())) GROUP by Nodes.NodeID, Nodes.Caption having AVG(CPULoadByDays.AvgLoad) > 25

I believe it lets the MS OS take care of the name cache. And I think thats another reason Orion tends towards using IP (so there isn't any worry of the OS being dumb with name resolution).

if your environment is small and you want to keep SQL on the same box, you can configure the SQL server to only take 512/768/1024 MB though SQL management studio, properties of the server, memory, set maximum. But that could make SQL run a little slower.

I don't either... its in the long list of things for me to do, but who can find the time. so in other words, I get the same bark, but mine is working... Are you sure you put the settings in every where? it needs to be put in on the windows machine running vCenter, and each ESXi machine (well you can avoid the ESXi ones if…

wait, did you just get Kiwi to move syslog out of the Orion Database and off the Orion server? I just started on that! I am amazed at how many logs per hour are coming in! I wish Orion had a counter like Kiwi's. Let me know if you find any thing you can pass along, I'll do the same. If thats not what your doing, never mind…

I'm not sure how you checked for interfaces, but using the "List Resources" doesn't show interfaces that "disappeared". To find that interface and remove it, you need to go to Manage Nodes and expand the the + next to the node and look there for a down/unknown interface.

oh, and ${SQL:select replace(${vbData1},"Service Transition - ",""} but I am not sure if "${SQL:" works with trap alerts.

What modules do you own? I figure NPM, but do you have APM? With APM, most definitely! With only NPM, I have seen post about people doing it and it looked complicated, but I have never tried it because I have APM and it is super easy and more featured. you could always demo APM before buying it (if you don't own it) on a…

for me, a SQL server's hostname will be MS###DB#, where ### is location and # is a sequential number. I could write a filter that is name not like MS___DB_. And exchange database is MS###XB# and CAS MS___XC_ and the IP are within a certain range.

I turned SNMP off on the iLO's. so I dont get anything.

I copied and pasted you SQL into a report for me and it works, I also added Interfaces.InterfaceName like '%loop% (for loopback adapters) - I am out or ideas. Anyone else? SW staff?

If you have filled the Custom field with the IP addresses, then it is that simple. What Custom fields did you create? Did you put the IP addresses in the fields manually? if so, then just ${Node.Interface_IP_Address} works for a custom node property named "Interface_IP_Address", but if you created a property called…

This might not be fully solarwinds supported, but I was looking at the indexes on that table and the clustered index is, IMHO, on a silly column. I took clustered off "IX_NetworkNode" and added it to "IX_EventTime" which just makes way more sense. Then rebuilt the indexes on that table and it seam a little peppier to me.

In the syslog rule, does it also run ConfigAutoDownload.exe

Is there some syslog rule that might being doing something dumb with it? If it's showing up in the buffer then that mean "notification" level should be good... I would say do a network capture if you can, that way you can isolate it to either Orion "misplacing" it or if it's the router not sending it. I like to do yes/no…

Another PRO for WMI is that it grabs the "Avg. Disk sec/Transfer", "Disk queue length", "Total Disk IOPS", and "Disk Allocation Failures" for volumes - never seen anything in "Disk Allocation Failures", but that a good thing right? I am not sure what version added that, but I was messing around with adding the new graphs…

Are you using HTML emails? if so try you need to replace the inner "{" and "}" with "@" like this: ${SQL:Select Floor(Convert(float,(Convert(datetime,'$@Year@-$@MM@-$@DD@ $@HH@:$@Minute@:$@Second@ $@AM/PM@')-Convert(datetime,'$@AlertTriggerTime@'))))@ days and $@SQL:Select Convert(time,Convert(datetime,'$@Year@-$@MM@-$@DD@…

10.0, the maps should be in the DB, I know for sure with 10.2. Views, yes. if you created any reports, you need to copy those. I agree with NRMS upgrade on the old server then migrate, but you could do both, it *might* work, but you might be walking into trouble doing it that way.