Custom Table to show how long a node has been down for

Following.

You need to use the "_IconFor" method I think. 

In this case I think you want to do this:

select distinct NodeID, Caption AS NodeName, StatusLED AS [_IconFor_NodeName], Criticality...

Although you might need to put "Caption" instead of "NodeName", but I think this is right...

Here is another article that explains it a bit...

How to insert the status icon for interfaces into SWQL resource

You might also consider using the information in this resource to show which nodes are down, when they went down, when they came back up, and how long they were down.  I implemented it this morning in a minute and quite suddenly had some great new actionable information to work with.

Node Downtime with Duration and Minimum Length Filtering

On the page where you select such columns to display on the table did you hit the drop down for the "details page link" and status icon?  I feel like that would clear it up.  No changes to the query itself should be needed, but over the last few years the general direction has been to move away from custom sql tables in favor of custom SWQL queries like mentioned in the other replies because it is a bit easier to make them look good and they waste less screen real estate.

I tried the details link and status icon in the drop down your referencing. Unfortunately i think because this is a SQL statement and not a SWQL statement those drop downs don't apply

Shouldn't make a difference on a custom table widget, I'll fire this up in my lab and post a screen shot of whatever it takes to get it set back up.

This do not work. I get an error

Ok i could have sworn i tried the link details option before. But i tried it again and it works. I the LED still doesn't work.

Oh, you didn't say you were in a Report Writer, from the SWQL you posted I was assuming you were just adding it as a "Custom Query" resource to a page. 

A good way to help you figure out stuff like this is to go look at other reports.  In this case I'd recommend something like the "Web-based" version of the "Current Status of Each Node" report.   If you go in there, you'll see the "STATUS LED" is set up similar to yours, but instead of /path/{0}.gif, they have /Orion/images/StatusIcons/{0} (with no .gif afterwards).

HTH!

This is in a Custom Table widget using SQL option. Not SWQL.