njoylif ✭✭✭✭✭

I had to run through this several times myself, b/c I thought same thing...50min is a VERY LONG time for one section...I'd love to see better progress indicators to let you know its still working. I killed it a few times before I finally just let it run and it took almost 2 hrs for that one config file to process. there…

just above 7000 total, but they should be spread across multiple pollers. I've changed the poll intervals for UDT to 180/180 and I'm still getting the banner. this is my concern about what you are working on :) So essentially, I should open a ticket?

Perhaps a vlan ACL on the switch?...very strange.

it does work properly when there is only the one sql query in the BCC and that Dept is set as CP... When both queries are in there, only one will/should ever return anything b/c Dept CP is either one of them or neither one. (list of depts). Basically, I need it to trigger if Dept is 'RHPSAS' or if it is 'DataServices'.…

I agree with jrmann1999, you can't fault SW for a vendor not following standards. from a business perspective, SW can't go chasing all non-standard equipment. Juniper is big, agreed. Definitely hit your Juniper rep up on this issue for sure. SW, in fact, has put effort into supporting Juniper natively even though they are…

I assume these variables act like macros...i.e. it has to be a column in the table the object lives in...in this case, a node. there is no alerttriggertime column in the nodes table (that I saw). at any rate, grab a column you know exists in the appropriate object's table and test that first (node -> try [Status])... which…

the more I thought about it, the more I realized there were unnecessary steps for what you need. I used IP address matching to join the tables. See content upload here: As always, back up your databases prior to any kind of customization. the script does have a commented out section that you can test the query with prior…

Most excellent. Does this have any affect on IPs that are Reserved? i.e. reserved and stays that way for 3 months before they finally get the device up and running. will that reservation change for any reason besides manual updating or the device coming online? thanks for the clarification

that should be because you are taking a count of all interfaces on a given node now. Before you were listing all interfaces per node. now, you only have 1 line per node.

excellent. glad to hear.

Ah, I got you. I will create a separate page for Non-Monitoring purposes and make that page the starter for the appropriate people. Thanks for the nested map explanation, it now makes sense why Orion has to load all of the info - to propagate status. Thanks for the info. DB is not dedicated YET and it has 4GB of RAM until…

Ok, so i went in via text editor and changed the WEBURL= section in the bottom manually and that resolved my issue. FYI Thanks

no, very good to know. SW, is there a document on this though? It would be very useful! :)

good call, that works. just use the SQL provided and format how you want it.

I would think you'd have to do it through either windows task scheduler or SQL. just run remote SQL for above statement or create stored procedure in SQL and use agent to schedule job every hour. Another option might be to have a link on the web site that makes the query and you can hit that...just thinking out loud. I…

I'm running netflow, orion, and NCM on the same DB, as well as some other app's DBs. it is 4 proc/8 core, 32 GB RAM (only using 8-10) and cpu usage is pretty low. I am connected to SAN, and we did run into problems a while ago, but it was resolved by simply configuring the SQL DB memory to utilize AWE. Test this and you…

michal.hrncirik; anything different in the current 10.7RC? Otherwise, I'll look to implement. Thanks for this.

Nothing new with the current shipping version, we are working on it. Can you not run it in compatibility mode? This worked for me...pain, but good until supported :)

Yann, I am trying to get "show IP route static" into DB and have followed the above instructions. I am also getting error - "connectivity issues discarding config file. Device IP <blah> ..." if I click on the ... it shows me the correct output (show ip route static). How do I eliminate error message so this will save to…

Thanks, but my SQL is working fine, its just how it creates the links that I'm having trouble with...

thanks for replying with info

Great! no idea on PDF link... for the subject in email report...Under the actions tab in report scheduler, edit the email and put the appropriate subject in the email subject line.

I'd also change the time from -2 to -300 or -30 or something. you are only checking for the last 2 minutes currently and to start, I'd echo KR... use like to broaden a bit... t.hostname like '%paris0%' and t.datetime > dateadd (minute, -30, sysdatetime()) and ..

works for me, thanks for the heads up. any ETA? Thanks again!

If you own both sides, that should be an option, as would using GRE tunnels over IPSEC. This would actually give you a virtual interface to monitor. That is how we handle all of the VPN that we own both sides of. 

That looks like the data sample interval. set it to every hour and see what you get.

ok, so opened ticket, determined domain login through web not worth it, as passwords don't sync when domain pw is changed (hopefully this is something being worked on). I was able to log in using NCM native administrator so I obviously had engineer password wrong :-/

Call me or shoot me an email if you like. Basically, I've created some SQL that will copy the nodeid (custom property in NCM) to npm based on IP (or you could do this via import) This allows me to move info back and forth. OBVIOUSLY, this is not supported and you should create a b/u of the DB prior. some of my stuff is in…

ok, yea we run our IPSLAs from the head end devices to we don't have to connect a ton of remote nodes to configure and manage. I guess I'll write up a feature request for groups to work this way or get something that works this way. thanks

d'oh, didn't look at web interface...old habits, etc..