njoylif ✭✭✭✭✭

I've seen this as a bug before but way back. I'd open a ticket if you haven't already. Try running config wiz again? maybe cmd line and use /repairpackages. Regardless, I'd open a ticket.

this will also largely depend on the system you are using. I have an old Sun X4600 and it takes about 10min to reboot. I reboot once every week on a schedule. I'm working to migrate to a [actual] new system though and don't plan on doing that scheduled reboot. if your DB server is separate from everything else, then your…

I'd love to see what you have as an example. I am going down this path. Thanks much!

I second this. it would be nice to have options to try to speed this up. I'm new to LEM, but last time I tried doing an archive, I couldn't manage via the console and it was all day before I reboot the system to kill it so I could work in it.

yes, that table is HUGE for me...about 9G. I guess that's why. If the ticket is not for NCM, I'm going to see if I can exclude NCM stuff next time in hopes I'll not have to wait for that to finish.

michal.hrncirik​, requested to join beta group. having trouble getting to site after install; bring up page and click login.

see this download from this thread <excerpt> Re: I'm new to solarwinds. The old admin quit. ">njoylif Oct 5, 2012 9:08 PM (in response to Richard Nicholson) Here you go - 2 SQL scripts, one for testing and one for updating. These will run through alertDefinitions table and replace any instance of <a@b.com> with <x@y.net>…

you should be able to actually. take a look at the canned alerts "trigger actions" for the high cpu top 10. It launches an APM and the command line args have -node=${NodeID} etc..

Sign me up for Thursdays session! Larry J Rice|RelayHealth Pharmacy|P:(404)728-3067|C:(678)984-1686

You bet! Larry J Rice|RelayHealth Pharmacy|P:(404)728-3067|C:(678)984-1686

yea, i take issue with this as well...although I'm sure it is a matter of time before those get sucked into the DB as well, like the maps....maybe. anyways, I just wrote a batch file and scheduled it. map drives, copy, disconnect drives. let me know if you want example.

Good feedback, thanks; I'll give it some thought and a shot and see what comes up. I'll have to look to see if that was going through LB or straight to web server too.

try doing this way: <b> ${SQL:SELECT * from Engines} </b>

*light bulb goes on* great info guys, thanks for sharing!!!

thanks for the response. My IPSLA/NPM is behind a firewall, but the IPSLA TCP test is from router to router connected to eachother by frame (with no ACLs in place on the frame interfaces). The SLA gets configured on the router no problem through NPM IPSLA website. does that make sense? Do I still need to open 1967 (I…

+1 :)

if you are trying to delete, there are a LOT of back end processes that run to clean everything up when deleting... not sure if quick and easy "clean" way. depending on your ultimate goal, you might be able to unmanage the interfaces using a sql query. This stops data collection (still counted in licensing)ALWAYS BACK UP…

BUMMER there are no Custom Properties - YET If you are decent w/ SQL you could add a column to the table(s) and use that in a custom SQL trigger but that would probably be wiped every upgrade/config wiz DB run...

worked like a champ!

seconded justinh's post

I second Smartd's post about IPAM/NPM and add NCM integration. "I want integration between IPAM and NPM. Clicking the IP in IPAM should take you to NPM detail record. Click IP in NPM should take you to IPAM. Addresses in NPM should be 'used" in IPAM. Also, want to track BGP AS numbers, Default gateway, DHCP server."

I do think they have some sort of caching going on for stuff like this. I had a ticket in long ago where I ended up w/ multiple instances of some cache db file I had to remove. it would be nice to be able to force update that/those cache dbs (if they do in fact exists and I'm not just making stuff up). Typically, when you…

np; 857782

yep, I know it can do crazy filtering and forward, but I need the agent to parse and send that info to LEM. Our LEM can't handle the load of RAW syslog. The agent is pegging the CPU parsing through the syslogs. Thanks for the suggestions.

another option is to create a user with restricted access (i used "autoreports") and put that in the URL like such: <http://your.server.com/orion/reportname>&AccountID=autoreport&Password=mypw4reports

ah, this is a little more tricky being the last 30 days... add something like: AND ( LTRIM(MONTH(FMC_AvailabilityByDays.datetime)) = (LTRIM(MONTH(getdate())) -1) AND DATEPART(dw, FMC_AvailabilityByDays.datetime) between 2 and 6 --- gives monday through friday AND ( --- gives btn 6a and 11p t.DateTime BETWEEN…

Having played with it more in depth, I'll go a step further and suggest: allow me to customize script (or "load script") and schedule remediation job (keeping the list of nodes that need remediated). That way, if it is or can be intrusive or highly controlled environment, you can schedule to remediate in middle of night,…

Always back your DB up before working in it.... Aslo, I always do a select first to verify my results before doing any changing queries you could also use a timestamp format, use MsgID, or even severity delete from SysLog where DateTime < [timestamp] delete from SysLog where MsgID < [messageid] delete from SysLog where…

your SNMP outstanding is 900. That is the max and generally if it stays there for too long, the system pukes b/c it can't recover from that. one thing to try is tweaking your SNMP timeouts to maybe 2 seconds and you might have this one system taxed too heavily. 8000 pollers is the max recommended by SW, it looks like you…

also, as of a few days ago, 2012 R2 is not officially supported yet...