netlogix

This isn't all that pretty, but try: Nodes.Caption, DateAdd(Hour,DATEDIFF(Hour,GETUTCDATE(),GETDATE()),Nodes.UnmanageFrom) as UnmanageFrom, DateAdd(Hour,DATEDIFF(Hour,GETUTCDATE(),GETDATE()),Nodes.UnmanageUntil) as UnmanageUntil, Nodes.StatusDescription

SELECT Top 1000 LogDateTime, [Message] FROM [AlertLog] inner join AlertDefinitions on AlertDefinitions.AlertDefID = AlertLog.AlertDefID Where ActionType = 'EMail' and AlertDefinitions.AlertName = '<YOUR_ALERT_NAME>'

That's what I figured, but I figure I ought to ask just in case.

I have vCenter 4.1 and I don't think I am getting this, except when the service account I am using gets locked out (thanks to others who can't check the status of the caps lock and refuse to copy/paste out of the password management DB they should be using). But after that happens, I have to change to a different user and…

Assumptions: you just setup dependencies, your alert is if node status = down, reset is if no longer true. If those assumptions were right, you would just need to change the reset to node status = up. If the assumptions are not right, what is your trigger and reset conditions?

Thank you for your post... I was going to just upgrade today and see what happens. I guess I ought to do a little more research and planning so I don't hit your issues. (Sorry you were the guinea pig, but thank you...) If you have the time, can you share a little more detail? What I am assuming is that NCM had one IP (the…

Yipes!@!@$!$^@!#@% I wouldn't expect that! The Guest's node entry is removed from orion! OUCH! I hope thats not expected! I don't want to try it... maybe I'll build a new box and try it, but I don't know when I'd find the time. Can anybody else test this?

I don't think there is yet, but: "User Audit Trail Tracking * Ability to determine who did what and when in the Orion system. e.g. add node, delete node, add interface etc." I hope that will have that... I hope everything *changed* is added to the audit log.

Assuming the field you want to filter on is DateTime: DateTime BETWEEN DATEADD(MONTH,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0)) AND DATEADD(s,-1,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0))

look in <...>\SolarWinds\Orion\swdebugMaintenance.log and look for error messages. The system may be having an issue rolling up stats, I only say this because I had that happen once because the sql drive ran out of space. To be sure, check out what table is your biggest hog (like mark said). (This screen shot was when my…

I haven't messed with this script but I found it while I was reading though some posts. This work? Does that work?

I would say raid 5 on F... Logs on E take away the reasoning for Raid 10 for the DB, plus if you had 4 disks in raid 10, then you would only have read speed of 2, but with raid 5, it would go up to 3. (6 disks would be 3 -> 5, etc). Server 2008 R2 is 64bit, make sure to install 64bit SQL and a good amount of RAM (> 4GB).…

You could change the alert so it isn't active when the nodes are changed back to managed. (Time of Day tab), or if that doesn't work, you could just not send the email at that time of day. (Trigger actions, action definition, time of day tab). Not the best ways of doing it, but it might work to stop the email.

Is the alert that is triggering a reboot alert? There is a known bug with 10.1 that will trigger false reboot alerts, but it is fixed in 10.1.2 (which is a release candidate status right now). If it isn't what is the alert on? It shouldn't re-trigger after a reboot of the orion server.

Have you looked at this? I think the key you are missing is the empty trigger Where ANY of the following are true Where ALL of the following are true N_MUTE is not equal to YES ALERT_CPU is empty CPU_LOAD is greater than 90 Where ALL of the following are true N_MUTE is not equal to YES ALERT_CPU is not empty the field…

you might also want to make the status as "not up" just in case the status get changed to administratively down. Also, I would add Node Status equal up so you don't get the message when the node is down or communication to the node is down. (That what I have for my alert)

ahthomas, did you ever get your problem fixed? My discoveries stopped completing. They run, just stop at 9X% and time out (even for 1 node and 2 hour timeout). It looks like is doing things and everything is chugging along nicely, but just never finishes. I don't have the drop down to choose a poller, so that's not it for…

Looks like your first step got set to 1/2 sec as it's "typical" speed, but the player is getting closer to 4 seconds on the initial step; do you feel 4 seconds is "ok" for the first step? I always edit the "typical" to something more realistic than the recorder set. I suggest you edit the transaction assignment and set…

True, a 32 bit process running on a 64bit processor can only use 3gb of RAM. But if you open task manager on your orion server, you could see 10 or more solarwinds 32bit processes, so the solarwinds applications could use 30gb of RAM (I actually doubt that, but that would be the logic). So the upgrade to 64bit is worth it…

I set up separate alerts, but I had to use a custom SQL trigger and added: (Not Nodes.NodeID in ( Select ActiveObject from AlertStatus where AlertDefID = '<ALERT ID OF THE OTHER ALERT>' and State = 2 )) and that made it so only one alert could be active at a time... not all that clean, but functional. I wish solarwinds…

APM integrates seamlessly with NPM (unlike NCM). You don't need to do anything. APM requires NPM up and running and uses the same DB and Users and has no distinguishable lines separating it from NPM. You will probably get mad about how bad the NCM integration is (I am - added NCM to my NPM+APM server)

jbruyet, what version are you using? I think the pooling thing is already in effect for 10.x, so a SL500 is for total elements (vol + int + node <= 500).

Have you tried downloading a trial copy of SW's LAN Surveyor and see if that maps the ports out right? I worked with support once and they had me use that to see if it could get the topology (i think they jacked the technology/logic out of that to add to Orion). If it won't get the topology, then there is something weird…

You could create a separate alert that has a reset time of an hour (in alert open the Reset Condition tab change the "Do not reset ..." to 1 hour - if the radio button is set to reset when no longer true, you'll have to change that and set the reset trigger to something like status = up). That alert will stay triggered…

There is an MS tool you can check to see if parts are enabled "Exctrlst.exe". You could also use the MS tool - "WMIDiag.vbs" Also try "wbemtest.exe" - if you can't get that to connect to the server locally, then Orion can't use WMI. Then try running from the Orion server connecting to the exchange server.

maybe there isn't enough space in tempdb to drop the table. Like the day/days it's trying to drop contains a lot of data and it won't do it. you could either truncate the tables (if you don't care about the data), increase the size of tempdb, or manually clear smaller parts of the table. (of course that's all assuming that…

does this get it for you? SELECT [CustomPollerStatus].[Status], CustomPollers.MIB FROM [CustomPollerAssignment] inner join CustomPollers on CustomPollers.CustomPollerID = CustomPollerAssignment.CustomPollerID inner join CustomPollerStatus on CustomPollerStatus.CustomPollerAssignmentID =…

I have this problem too, but I never did anything about it. The problem is the IP address switched and you are always polling the active node with the IP you are using. I was thinking about finding a way to poll the serial number through some OID and alert when it's not the primary serial number.

you can install/configure snmp on esxi 4.1, I use this as a batch file on a PC with the cli installed. @echo off Set /p VI_USERNAME=Enter User: Set /p VI_PASSWORD=Enter Password: cls Set /p CommunityString=Enter Community String: cd /d "C:\Program Files (x86)\VMware\VMware vSphere CLI\bin" Set /p HostNameOrIP=Enter Host…

Have you setup an alert that will tell you when it reboots? (Note: a restart of the SNMP service will show up as a reboot)