robertlj

You may want to use cursors to solve this problem. See http://msdn.microsoft.com/en-us/library/ms180169.aspx In their example, they use a while loop and print a result. You would like to concatenate the strings in the loop and use the result in a select clause for your report.

I think Orion is being too helpful by defaulting this. I could be using this query for something that Orion does not expect. I could be doing a query ABOUT a node, instead of on a node. In this case my database server would not be ${HOSNAME}, but I could use ${HOSTNAME} or ${NodeID) within the query to decide my result.

I would like the ability to generate an alert based on a trap (OID or other rule). This can cause the node that sent the trap to change color (yellow,red). I would like to be able to reset the alert if I recive a trap (slighly different OID or other criteria) AFTER the trap that generated the original alert. I would like…

I would like the tag field to be shown in the trap page or message center. I would also like to be able to filter based on the tag. I would like a report on traps without having to use SQL. Not that I mind sql, its just that you add additional functionallity with your GUIl. I would like to be able to be able to acknoledge…

You can call an external program. a vbscript or .exe. Anything that can insert rows into the database. You will need to know how to log into the database. Execute the following sample query. INSERT INTO [SolarWindsOrion].[dbo].[Events] ([EventTime] ,[NetworkNode],[NetObjectID],[NetObjectID2],[EventType],[Message],…

This was fixed in a later version of Orion. The sender was time incorrectly as well.