adamras

DISREGARD MESSAGE

I got almost exactly what I need with the following! SELECT department, Nodes.Caption AS NodeName, Events.EventTime AS Event_Time, Nodes."System" AS System FROM nodes JOIN events on nodes.nodeid = events.networknode WHERE (EventTime BETWEEN 40236 AND 40258 ) AND ( (CONVERT(Char, EventTime, 108)< '0700') OR (CONVERT(Char,…

Well, it didn't error out. That's awesome! Thank you. It gave me data from Feb 20 - 26th. From what I have learned from you and Scottd over the last few days, I believe what this query is doing is pulling data from last month, determined by the -1. Also things that are less than 6:00 am and more than 4:00 pm which was…

Sedmo, I am trying to determine what I need to put at the start. In the following query I had just copied what I had in the last one I was using in hopes that it would be what I need. SELECT Nodes.Caption AS NodeName, Events.EventTime AS Event_Time WHERE (EventTime BETWEEN…

Thank you. I was lookin' at it, knowing that something was missing but I couldn't determine it. As you can probably ascertain, my SQL skills are bad, at best. I am takin' all of this as a "teach a man to fish" kinda thing. So your patience is appreciated. so what I did was added: SELECT Nodes.Caption AS NodeName,…

Awesome! Thank you for posting that. I'm happy to hear that it's all fixed up now.

This is what is spit out: Msg 156, Level 15, State 1, Line 1 Incorrect syntax near the keyword 'WHERE'.

Currently, I am using a program called "DiffDoc" It's not the greatest out there but it's not too bad. Free to try cheap to buy. 

bump! I am having the same issue with my 2600 Sorta seems like it's not going into enable mode. I see that it's not executing "enable" from SWTelnetDebug.txt Here is my session-trace [1/28/2010 12:21:04 PM] -----------------NCM 5.5 SP1------------------- [1/28/2010 12:21:04 PM] Login Attempts: 1 [1/28/2010 12:21:04 PM]…

what information did they give you? I know that this is a month old, but I think it would be helpful to everyone if you could let us know what they said. I had this issue this morning, I simply stopped and started the service. Easy Peasy, but I don't think my resolution is going to work for everyone. So knowing what they…

What we're going to end up doing is exporting the data one day and have it be our fixed variable. We'll be exporting it to excel. And then monthly or quarterly we'll export the data and run a diff compare on the 2 and ta da! The data I need. It's too bad this feature isn't built in. But that's cool. We will find a way!

Time wizard.. denied! haha Yea, I am looking for events that took place between 5pm and 7am and also another report (though it would be cool to have it in the same one) of events that happened between 7:01 and 4:59

I finally just got a chance to use this and it worked perfectly! Thank you so much.

o.. good news we think. A couple months ago I had discovered that there were a lot of error on the swdebugMaintenance.log file in regards to our Wireless tables. They were as follows: 2010-01-29 02:29:13,807 [1] ERROR SolarWinds.Data.DatabaseMaintenance.StandardTableHandlerDAL - Failed to execute procedure:…

bump.. I have added ${Nodes.Custom_Email} to the To: field in my email alert. When I test it I get the error: Error sending email for alert TEST ALERT OF YYC-FWMGMT. - The specified string is not in the form required for an e-mail address. In the custom field I have a single email address that I know works. Any ideas?…

Good morning, I am curious if this was solved or if I should still be creating a ticket as I am having the same issue.

Thank you very much!

Thanks Denny!

Thank you! that's perfect! I knew it was something small.

and this show how helpful it is to read old posts before posting one of your own! exactly what I was looking for. Thanks

Hey Andy, Thanks for the reply. I am aware that there are countless http based bandwidth testers out there. I am looking for a client side tool. As in something I can install on my laptop and connect to different networks ie. corporate wired or Free wireless and not have to go to a website. I believe that I have found ine…

scottd.... Thank you so much! This is exactly what I need. Easy to configure and makes sense. I really appreciate the assistance!

Hey there marie No answer as of yet. Thanks for checkin' in though :)

Thanks, Martin!

I am struggling to find where this is. I would like to rehash this post as I would like to have my custom properties be displayed in a differnt order than alphabetical on the webpage. I am hoping someone can help me out here. Thanks in advance.

Thank you for your reply and your answer. If you're able, please move this thread to the appropriate location. I made this ticket in the morning and i wasn't all with it. Sorry about that.

Thank you for the reply, guys. I know how to make maps no problem and the same thing with making views. What I am trying to accomplish is; I have 4 switches, all of which are the same type of device. I would like each of these to have their own view, not shared with each other.

Thanks for the reply. The thing I need to change on all of them the address that shows the alerts are coming from. By default it's nobody@nobody.com and I need to change that. I hope that is specific enough. Let me know if you need more.

For report writer to be able to send to a file.. not just email or to print. It's been requested by your customers since 2006.. it's now 2010.. where is this feature??

Hey! Thanks for the reply. I would be happy to give you some more information. You're right, the "Escalation_Severity" defines the criticality of the Node. There is a certain time frame that I am looking for. it'll be in the "last month" context. Something I am confused about is the EventTime BETWEEN 40223 and 40254 Are…