amandil

This would be a fantastic idea! We are full steam ahead moving into AWS here.

Just want to jump in and +1 this request. This issue is becoming more common for us and may lead us to other tools.

Still looks to be working! Any idea why this way works and not the simpler ways? Is it just the way the SQL server is configured? Also how did you become a alert guru? I take it you have an SQL background?

Awesome, just did a quick test and got 0 days and 00:02:59.2770000 Looks good. Ill let you know how it goes over a few days of real use. Thank you!

Unfortunately no. MACRO SQL ERROR - Incorrect syntax near 'Router'. days and MACRO SQL ERROR - Incorrect syntax near 'Router'. My alert name has router in it so I guess that's where something is wrong. Example alert name: Dalbora Router Status.

OK here we are. I copied and pasted your code in as is. The alert generates this: Select Floor(Convert(float,(Convert(datetime,'26/10/2012 09:16:26 AM')-Convert(datetime,'26/10/2012 9:13:25 AM')))) Select Convert(time,Convert(datetime,'26/10/2012 09:16:26 AM') - Convert(datetime,'26/10/2012 9:13:25 AM')) -- MACRO SQL ERROR…

Something must be broken. This: ${SQL:Select Floor(Convert(float,(Convert(datetime,'${DD}/${MM}/${Year} ${HH}:${Minute}:${Second} ${AM/PM}')-Convert(datetime,'${AlertTriggerTime}'))))} ${SQL:Select Convert(time,Convert(datetime,'${DD}/${MM}/${Year} ${HH}:${Minute}:${Second} ${AM/PM}') -…

Thanks. I voted. Now at 3

Just did a test in the AM. Nether.. ${SQL:Select Floor(Convert(float,(Convert(datetime,'${DD}/${MM}/${Year} ${HH}:${Minute}:${Second} ')-Convert(datetime,'${AlertTriggerTime}'))))} days and ${SQL:Select Convert(time,Convert(datetime,'${DD}/${MM}/${Year} ${HH}:${Minute}:${Second}') -…

Hi netlogix, This was working for a while but now it is coming up with "MACRO SQL ERROR - The conversion of a varchar data type to a datetime data type resulted in an out-of-range value" again. Any chance we can do some more troubleshooting?

Awesome! Your new query seems to work as expected. Thank you so much for you assistance! I still think SolarWinds should have a built in function for displaying downtime....

Thanks. I'll give it a go now. We always write date as 3/10/2012 - d/m/yyyy

We get.. 235.009733796296 00:14:01.0000000 as well. Ahh. Nope. Aussie here ${DD}/${MM}/${Year} ${HH}:${Minute}:${Second} ${AM/PM} returns: 03/10/2012 01:12:09 PM

Testing by changing the IP to something non existent on a node. Results are: 2012-10-02 10:22:20 AM and 2/10/2012 10:08:19 AM

I can see through DB manager that the Trigger Time Stamp looks like this: 27/09/2012 5:17:11 PM Does that help? Not sure how to find out the ${Year}-${MM}-${DD} ${HH}:${Minute}:${Second} ${AM/PM} details?

Hey solarnewbi, Did you get this sorted? I'm after the same question?

Hey netlogix, Sorry to be a newb but how do I get the pre-convert values? I poped in the code in your post and even tried: ${SQL:Select Floor(Convert(float,(Convert(datetime,'${Year}-${MM}-${DD} ${HH}:${Minute}:${Second} ${AM/PM}')-Convert(datetime,'${AlertTriggerTime}'))) But it just displays that as text?

Mine spits out the downtime in minute's. I don't beleive the simulate feature gives a proper figure for downtime.

Hey netlogix, No i'm just on plain text..

Anyone ever find a good solution for this?

Hi, On 11.5 I just use the new built in method: ${N=Alerting;M=DownTime}

Guessing these was no easy fix for this?

I seem to be having the same issue. Would love to know what you find!

I asked this question in a new thread and netlogix provided his query which works great. http://thwack.solarwinds.com/thread/50929

Nope. I don't have any of these anymore. But pretty sure I worked around it by setting up another set of pollers and another custom tab with the graphs labeled correctly. Thankfully we don't have any ADSL services anymore

One more bump..

Hey netlogix, This was working for abit but now displays the error: MACRO SQL ERROR - The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. days and MACRO SQL ERROR - The conversion of a varchar data type to a datetime data type resulted in an out-of-range value. any idea?

Hi RichT, Have you ever seen the router report this data backwards. IE.. adslAtucCurrAttainableRate reports the upstream data and adslAturCurrAttainableRate reports the downstream data? I had this working on our Cisco 877's but seems to be reported backwards on the new C880 models the ISP is using... Do you think it's me…

BUMP.. I guess this is a really strange one.

Thank you that does the trick! The first answer that comes up when you Google this gives an answer that no longer seems to work.