adding a second DetailsURL in a Custom Resource

mburgeso

I'm looking for the SQL syntax for adding a second DetailsURL in a Custom Resource.

The SQL spinet below works for the Node link but I need to provide the Volumes.Caption as a URL link as well:

SELECT TOP 20

Nodes.Caption AS NodeName,

'/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N:'+CAST(Nodes.NodeID as varchar(256)) as 'DetailsURL',

Volumes.Caption AS DiskName,

Volumes.VolumeSize AS VolumeSize,

Any advice?

dgsmith80

I know there are a few ways to do this, and my SQL is not up to par yet, but this is what I would try:

Select'<img src="/orion/images/statusicons/Small-'+n.StatusLED+'"/>' +'<a href="thwack.solarwinds.com/.../View.aspx as varchar)+'">'+n.Caption+'</>' [Node],'<a href="thwack.solarwinds.com/.../View.aspx as varchar)+'">'+v.Caption+'</>' [DiskName],v.VolumeSize AS VolumeSizeFROM Volumes vINNER JOIN Nodes n on n.NodeID = v.NodeIDWHERE v.VolumeType LIKE 'Fixed Disk'

Should look something like this:

There is most likely a better way of doing this via SWQL which could use the [_linkfor_Node] and [_linkfor_DiskName] but I'm still learning SWQL!