njoylif ✭✭✭✭✭

take a look at this content: SNMP Nodes not responding > 60 days you'll have to remove the commenting <--> to run either test or update. declare @prev60 smalldatetime=dateadd(dd,-60,getdate()) -- update nodes set community='public' -- to update remove '--' at beginning of line -- select * from nodes -- to update remove…

Interestingly, in another ticket, the case engineer indicated my index fragmentation was high based on debug. traps table was over 99% frag'd. that'll slow it down some. for whatever reason, it does not appear that the default is to have DB maintenance defrag when needed. HERE is the KB article for setting that. I'm hoping…

Most excellent. Are you looking to do it based on rules within the policy or at a policy level. right now, I can click on a given rule violation indicator and remediate and that automagically selects all the nodes in the report that failed that check. I would think that might be the way to go, just do a script per rule and…

Change the WHERE clause to match what you name the app template. Mine is "SSL Cert Exp"

sorry, misunderstood original question, and started new thread....FYI OK, wont let me post under new thread - says repeat...

D'oh. Assuming there will be other emails still in there, you might be able to use '' <emptyset> ...yea...what LadaVarga said

yes, it should still work, depending on what properties you have on the object. I set mine to tri-color and have the 4 WMFs per object. i.e. cisco.wmf, cisco-up.wmf, cisco-down.wmf, cisco-warning.wmf. You have to put them into %SW install dir%\Network Atlas\Maps\NetObjects\Scaleable\<dir name> I have found you have to put…

wierd...sounds like a bug. pls open a ticket and update forum with results. Thanks much!

my bad, you actually want decimal. check here: http://msdn.microsoft.com/en-us/library/ms187746.aspx decimal[p,s] - the s is what you need to = 2

no, that would be good to test.. this is definitely high throughput. probably 100GB/day on normal day. please let me know how to set that and I'll test it out. Thanks!

I'll do what I can - when I can - but bring it on; just may need to be patient.

Looks like the logic would give alert when App status is down no matter what, because those are in both sections...no?

actually, it looks like this works: http://<server>/orion/Login.aspx?AccountID=xxxxx&Password=yyyyyy

backing up a step; I assume you are keeping at least 30 days of detailed data in your retention settings. If not, you might want to do that. correct, to get all of that, you have to join the appropriate tables together, probably based on the componentID or statusHistoryID? depending on what tables you are trying to look…

I just ended up using a native resource and it fell off my radar. 12 is RC though. when I get a chance, I'll test and post back...though it will probably take a while.

see this post: or this:

strange...can you do a SNMP walk to be sure the device is giving you the correct interface list? Otherwise, no idea. sorry

that's one option (i script everything out to start and we enter when adding connectivity). Another thing is if a customer leaves or moves connectivity to another headend device, and our paper process is behind for deletes (which it usually is), I'd like to be able to unmanage that to keep the system usable. as soon as one…

yes, so to be clear, if I have my scan interval set for 1 hour and a host goes away, 2 scan cycles will have it showing available, right? thanks

A good way to have this work in a report is to create a stored procedure that just returns the "table" of info. the report would then call the stored procedure. This is a good way to run reports that have case statements, if/else, and other TSQL commands that SW doesn't translate

aLTeReGo, how would you filter these in where clause? thx

you need to specifically allow the source to hit it. i.e. -> snmp-server host inside 192.168.1.1 community public (or something along those lines)

yea, its never been a system limitation, my system's CPU/Memory utilization have always been nominal. not sure where the bottleneck is...perhaps bus speed? We have NPM and 2 addtl pollers all barely used (2k3 until we get 9.5 running well), SQL 2k5 EE running on Compellant SAN with no issues there, have 18000 pollers, NCM,…

Makes sense to me, since an issue with the physical would not show on the channel, but could definitely cause impact. Probably going to be personal/business preference though.

I'd have to re-install 8.1 to get screen shots. last resort. Old system: I'd copy a map with 48 interfaces from a switch "blade" and name it the next blade number in line. I'd then right click on the interface icons and select "object properties" and select the "network objects '...'" button to change what object was being…

Sure, edit application, select the one to rename and click rename per image below... note - if greyed out, you'll need to do it at the template level or in the DB directly.

Add: left join APM_ApplicationCustomProperties cp on a.ID=cp.applicationid WHERE -- if only want apps/nodes with empty email addr (if want all, just add the above left join line and nothing more.) cp.EMAddEmail is null or cp.EMAddEmail = ''

no problem. Thanks

as I'm digging deeper, you are actually using a "canned resource" and not a "report". so let me clarify a little further...you will not be able to tweak the resource as it is coded to only hit the nodes table...that would require coding the asp. the way to accomplish this would be to add a new view and have the source of…

bump. opened ticket as well. #678242 FYI