rossw

I have one polling engine. I can reproduce the problem. I will open new ticket. Thanks, Ross Warren

Tom, Devices are failing on key. I can confirm it is NOT fixed in 3.5.1. Replicated the problem yesterday. Thanks, Ross Warren

Chris, I was just trying to figure out how to to this today. I would love to be able to use this functionality sooner than later. I need to parse out some iDirect Traps for our operations folks. Thanks, Ross Warren 

This still seems to be an issue in IP SLA 3.5.1? Verified that 15 char works and 16 char doesnt. Any fix? Thanks, Ross Warren

Has this been addresses? I would really like to be able to see IP SLA operation latency on the map. Thanks, Ross Warren SCP

Yes. I would like to take that data into a table like the example. Ross Warren

Could you share a screen shot easily? I was planning on doing this 100% Solarwinds :) Thanks, Ross Warren

jainsworth, I do the same cut and paste procedure that Don details above. I know for a fact that Visio isnt on either of my servers. Ross Warren

I think moderation has stopped.. or the moderator is on top of things today. My last 2 posts were up. Very quickly. Ross Warren

Matt, Did you ever figure this out? -Ross

After working on this code for my own work a couple months ago, my boss asked for a list of active alerts and what devices are alerted on. This SQL code proved very handy. Had the spreadsheet to him in 10 minutes. -Ross

Anyone else try this code? Ross Warren

Here Folks, Try this out. Comments, cleanup always welcome. Need to load this in SQL Enterprise Manager, doesnt seem to work in Solarwinds Report Writer. Still trying to figure that out. Ross Warren -- -- Active Alert Report (active-alerts.sql) -- Copyrighted: 07/22/05, Ross Warren(ross.warren@segoviaip.com) and Andre…

I just finished up the code to do this. I shared it with support this morning. I will post here shortly. PropertyID was the key! Ross Warren

Brandon, We are currently demoing Packet Design's Route Explorer. I dont think Solarwinds has any product in this field or the depth they can provide, can you help me out? Can I get MPLS/VRF route visibility ? Thanks, Ross Warren

Josh, Thanks for the News on v8! Is IPv6 support planned for v8? I have a couple Military networks that are going to start requiring IPv6. I doubt that they themselves will be ready by their own deadlines, but I would like our stuff to be ahead of the game if possible. Also, Put Segovia on the Beta Testing Program. Ross…

I asked support the same question: "Thank you for contacting SolarWinds. At this time there isn't a way to change the default SNMP polling port from within our software. This is a good feature request and has been forwarded to our Development team. Please let us know if you need further assistance." Ross Warren

Kim, I haven’t been back to report writer to get the query to work. I will try to get it done this week. Enterprise Manager should be on your local machine if you aren’t using remote database. Here are some answers (kinda) Sort of 2/3 (from resources in the forum) SELECT TOP 25 StartTime.EventTime, Nodes.Caption,…

Kim, Any luck? Ross Warren

Kim, Take a look at this post/thread. www2.solarwinds.net/.../topic.asp

Thanks for the info. I now see the Reverse DNS field. How can I get them to populate? I tried "Rediscover" but that didnt repopulate the field. Ross Warren

We dont really use report writer anymore. We have created our own clustered DB server that takes in data from or satellite modems, Remedy, Cisco call manager and Solarwinds and runs reports with Crystal Reports and Sharepoint. The problem with my query and report writer is the use of the temp table. If some one (smarter)…

This still doesnt run in Report Writer. Ugggh.

Had some Errors and incorrect reporting. My DBA and I fixed these up. This is for September and is keyed of Interfaces.Service = 'backbone'. I have started using Interfaces.Service to help us define different reports.. Such as 'Internet' or 'backbone' or 'Customer' etc. IF exists (SELECT * FROM dbo.sysobjects where id =…

SUMTABLE is just a temp table that gets build to aggregate data. Mine just started to fail after upgrading to 7.8.. Must check into. Ross Warren

Steve, You need to do a custom property called service. Was an idea i gleamed from the Yahoo Charts thread. Ross W

Yes. I cant get it to run in Report Writer either. Still working on it. Will Share when I do. Yes SQL Enterprize manager is what I use. Ross Warren

A slight update: I changed the calculation to availability, not unavailability. Also made the output show all the interfaces.service = 'Internet' not just the interfaces that show up in events. Got to show those 100%s!!!!.. IF exists (SELECT * FROM dbo.sysobjects where id = object_id(N'[dbo].[SUMTABLE]')) DROP TABLE…

Interface availability based on Zoran's start. With Percentage. NOTE: I use the custom property Interfaces.Service = "Internet" to define my circuits. Thanks Yahoo chart guy! IF exists (SELECT * FROM dbo.sysobjects where id = object_id(N'[dbo].[SUMTABLE]')) DROP TABLE SUMTABLE SELECT…

This is very close.. Not quite in percentages yet. IF exists (SELECT * FROM dbo.sysobjects where id = object_id(N'[dbo].[SUMTABLE]')) DROP TABLE SUMTABLE SELECT CONVERT(DateTime,LTRIM(MONTH(EventTime)) + '/07/' + LTRIM(YEAR(EventTime)),101) AS SummaryMonth, EventTime, Interfaces.Caption, NetObjectID, DATEDIFF(MINUTE,…