scottd

Adam, Try this instead... I have also included some time variables i like to use that will make it eaiser to select the first of the month or the first of the year so you can modify the query as needed. the query as it stands will list 2 columns; Month and Average Availability for example, March 2010 | 100.00%. Or you…

Reboots are stored in the Events table, EventType 14. You should be able to write this report in Report Writer using an Event Log report.

You can do this in the DB manager or SQL Server. Depending on what your conditions are for setting the 'UnPluggable' attribute, a simple example is pasted below. You would need to change the 'Where' portion of the statement to meet your requirements. I used InterfaceType = 6 as a simple example. Update Interfaces Set…

One option would be disable the alert for rebooting during the unmanaged period. I have a few SQL jobs for just this reason. For example, If the Exchange group of servers is scheduled to have maintenance performed at a specific time. I just go into SQL Server and set my schedules to disable the alerts at the start of…

Wilson, volume space is recorded in bytes. Try this configuration below and see if it does what you are asking. The sample below is an alert condition for Windows fixed disk's nodes having 1 GB or less space remaining. And the message can be configured like; and the mail you receive will look like; This works in our shop…

Lee, Check page 255 in the SolarWinds Administrator Guide. There is several ways of doing this. thanks,

You should be able to build a dts package or use the export wizard on your SQL server to do that. If you are not sure how to do this, you may want to tap one of your DBA's on the shoulder...

In our implementation, we are catching traps without the corresponding MIBs in the DB. We even alert on them...

If you are using the 'has changed' condition, it probably will not work. 'has changed' translates into SQL like this in the DB; (Nodes.Application = Nodes.Application and ((select count(*) from AlertValueChanges where TableName = 'Nodes' and FieldName = 'LastBoot') > 0) and (NodeID in (select NodeID from AlertValueChanges…

You could setup an alert for these 2 devices that launches a bat file that deletes the entry from the events table via sqlcmd. If your DB server is seperate from your orion box, you would the need the sql client utilities installed on your orion box to execute sqlcmd. Or you could setup an sql job to run the same query…

rcampbell, You could also use the native windows tool 'evntwin' to send events in the form of a trap to Orion and then alert on the trap. Nothing additional to install(it's already there waiting to be used) and it works real good. I prefer this to installing something else on a server.

I have seen this error once and it had nothing to do with the 3 items listed. It had everything to do with my local IE instance being in a crappy state. I opened a new IE session while the hung one was still running and was able to browse all Orion pages. Strange thing about it was, in the hung instance, i could browse…

Hey Jim, I feel your pain 'sort of' as i used to look at some of your charts for our SBU(Lighting Systems) and say "how could we be using 238% RX and 110%TX?"... :) Thanks, Scott Dykes Tampa Electric Company

The AlertLog table should have this information in the following columns... LogDateTime, Message And this query should get the information for you... Select LogDateTime, Message From AlertLog Where LogDateTime Between DATEADD(Hour, -24, GETDATE()) and GETDATE()

Jason, you will need to set up alert escalation. There is a tab in your email EMail/Page Action.

SQL code can handle this... For adding spaces you can use + SPACE(x) +. x=number of spaces to use. For your carriage returns you can use + CHAR(13) +. CHAR(13) = carriage return In my example message you can see how they would be used. Below is the message format in SolarWinds; And below is the email message received;…

Could it be possible that your orion boxes are being backed up with netbackup(or something similar) during that time? We have this issue with some of our fairly busy non-orion servers. CPU, memory, and response time may spike during backups on these boxes. This may not be your issue, but its something to check out...

I too believe that SW should switch focus to producing a good solid product and get away from so much new development. New development is important but should not be more important than stablizing what you have already created. Although this could divide the SolarWinds audience because larger compaines usually aim for a…

Your detail stat retention is doing it. 60 days is a lot of details to hold on to. We only retain 7 days of detail and some times that seems like too much...

I have used Argent before and i didnt care for it too much. The interface is a bit clunky and non-intuitive. It does do a bunch of the same stuff that Solarwinds does. But i prefer SolarWinds because it is intuitive and easy to customize in many different ways...

Helinut, If you post a screenshot of your trigger conditions and a brief description of what you want to accomplish, someone will be able to assist you. Otherwise, you have not posted enough information to get a reliable answer. The only checkmark i know about is the one to enable/disable the alert.

Hmmm, I dont believe that information is located in the Events table(Flapping Interfaces). I may be wrong but, it sounds like you are after some syslog information, and that would be stored in the SysLog table. This query will return a list of HostNames that had flapping interfaces(2 or more), with the Severity of…

The alert is firing because of your last condition. If Node Name is equal to any of those listed, fire the alert. As long as those nodes are in your DB the alert will keep firing. They do not need to meet any other condition the way you have it set up.

Lesk, I believe this will do what you are asking and you dont have to know SQL if you use my query. Native SolarWinds tools can handle this well... Create an Advanced SQL report in Report Writer. Paste the query below into the report under the SQL tab. This will build your basic report with the current active alerts. Save…

You could also use the Alert Suppression tab to say Supress if <node> is not up. Just another way to write your alert if you wish...

This is one way you can do it; ${SQL:Select Substring ('${Caption}',1,3) AS Caption} This thread may help you as well.

I think the AlertActions table is for basic alerts, and the other tables mentioned are for advanced alerts. I believe you can get the message you are after by adding this to the select portion of the statement; ActionDefinitions.Parameter2 AS Message Is this the message you are looking for?

bd, You can do this in Excel by setting up a SQL server connection and connecting to the Orion db table AlertDefinitions. This will bring the whole table into Excel. If you dont want the entire table, you can edit your connection so you may plug in a query to get the colums you are after(or you could hide columns in…

Try entering a username and password that you created in orion, using the password that is stored in orion. Not sure if you are using AD auth or not... It doesnt seem to be used by Network Atlas.