jp

75% of my Cisco IOS devices are reported as different from the startup configuration. There are some *really* silly bugs: One of my CatOS downloads thinks that the precommands used by NCM are part of the config: Here we have 'set length 0' and the output of this command included as part of the startup config, but there's…

Just open the orion report writer. Press New at the top left. Under "New Report", just specify Active Alerts. Name the report as you like, then hit execute SQL query. Like what you see? press file, export. You can then export to Excel.

Try adding SET NOCOUNT ON at the top of your query. As soon as report writer and database manager's query tool see a "Query OK x/y rows affected" it thinks it is done. Setting NOCOUNT will suppress the output of this and allow the query to continue processing after you declare your variables.

Just found something in advanced alerts, but it seems that Solarwinds is putting in the Controller name in for the AP name. This is the case for all of the Aruba wireless thin APs I have set up (Weird!!). It also over-alerted and sent 70 emails out in a second :)

I am having this same problem in "Me too!"

Hello =) Loving orion, but here's a few things that I'd enjoy in a future version. #1) Improved interoperability with Cirrus. My current method of exporting nodes, ips, and custom variables with csv and importing again to custom properties is not the best way to do things. #2) Threshold monitoring. I should be alerted if…

#1, and only request. Stop preventing the clipboard from working properly. I'm tired of the application *crashing* when I try to copy an item and paste it, and I'm also tired of the copy operation not actually working. Disable this functionality entirely for all Solarwinds tools.

Scott, ${SysName} may be what you're looking for. I'm looking at your post, and I make heavy use of 'config snippets' for my IOS standardization. Particularly, banners; banner exec % ------------------------------- Hostname: ${SysName} MachineType ${MachineType} Address: ${StreetAddress}, ${City}, ${Province} -…

Check out your Node Details summary view under the admin panel - try the 'preview' button - does it work there? Maybe if you remove any extra resources from the Node Details summary view? Let me know - Support worked with me on an issue on that track for the Netflow module we bought.

This is probably obsolete since NCM v5.0

I would like to see a function that would configure cirrus and orion to share the same node database. This may be difficult to juggle around, but the fact remains that I have multiple places to edit nodes and there shouldn't be that requirement. At the very minimum, the sysname, ip, and node ID should match between cirrus…

I can tell you that 1) Yes, syslogs are in the same database as the orion database, with five tables: SysLog, SysLogActions, SysLogFacilities, SysLogRules, SysLogSeverities. 2) I can't think of a way this could be supported or configured, maybe someone else has a trick but I doubt it's possible.

That's just totally odd... SNMP shouldn't be very high priority at all on anything. STP itself has to be generated by the CPU, so if the CPU is pinned somehow (SNMP Bug on the platform?), the BPDUs may not be generated. What were you polling? Did you have some inventory process pulling a full BGP table somewhere? :) The…

I used Cirrus & the ping monitor for the short time it took.

virtualu2, If you create WMF files (Vectorized?) graphics and drop them into the Icons subfolder in the Orion installation folder, you'll be able to assign these to map objects. That being said, I find it really unstable on how consistently Orion's map maker chooses to scale any icon, but if you're careful and make use of…

I'm really leaning on SQL reports, the built in reports dont' really seem to serve most of my purposes. I don't think i'm expanding any macros in here. I use the field selector (IE: Availability ->…

This works for me. Press the "No active filter" button on the custom properties editor. Add a new elementary condition, "Records where the custom field __FIELD__ "IS EMPTY"" Type in your custom property "high" on any of those objects, ctrl+c (about 8 times, clipboard is kind of screwed up on solarwinds products), then…

Sorry, everyone, I've been on Vacation and I have not been checking my forum postings. It's good that there's a support request open on this one (So I don't have to do it myself!!) To the question on the cisco merge; Add another WHERE clause below, WHERE n.Vendor="Cisco" should really help out.

I gave up again, it's easier to attack this from the sql side than anything else. Why Solarwinds doesn't ship with something like 'this' out of the box, I'll never know~ set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: <Senior, JP> -- Create date: <11/27/2009> --…

-I was using "Interface Errors <br /> Except 3548s -jp" as the description for the resource. I don't think it liked one of the html markup characters or the hyphen -. Resolved.

Added max(Events.EventTime) & grouped based on Node Caption - tested - worked! :) SELECT max(Events.EventTime) AS Event_Time, Nodes.Caption AS NodeName FROM Nodes INNER JOIN (Events INNER JOIN EventTypes Events_EventTypes ON (Events.EventType = Events_EventTypes.EventType)) ON (Nodes.NodeID = Events.NetworkNode) WHERE…

Number one is extremely valuable - smart 'parsing' of traps would be excellent. Being able to trim the fat from a massive trap with 15 varbinds is great. Although when you say 'vbData1' 'vbData2' do you mean to interpret this as tokenized output, or will we be using the actual MIB values from MIBS.cfg for interpolation?

Try disabling ICMP node polling. I had this problem too, where the node polling was way too aggrsesive and database way too slow to keep up. If this works for you, try altering the node polling interval to something higher than the default.

 This is a bit late of a reply, but I had no troubles doing this upgrade. This is information for anybody who may be searching older posts.

I use the below alert for interface errors. The ${Caption} variable expands to the full interface name - add the macro to your alert in either advanced or basic alerts under Orion. I do not suppress interface alerts when the node is down for the same requirement that you have. In the case shown below, the NOCSWITCH is also…

How about pager lines 0 ?

My biggest issue was the thwack.com 'widget' on the website slowing performance down dramatically. Removing this option really improved things for us, especially since that server has no connectivity to the internet.

Hey there. All custom properties are added as a new column in the 'Nodes' table; i.e. Nodes.StreetAddress

Scott, if you have the SQL management app(s) installed, check out the activity monitor. Find any 'running' processes that are owned by your orion database - double click on the query column and let us know what the query it's running is. This could help Support out more than me, though :)