Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Is there a way to use the output of a SWQL query in a Hyperlink?

I can add a node's IP address to a custom HTML link by using ${ipaddress} in the HTML, is there a way to get a group of IP addresses based off a custom property as part of a HTML link?

For example, I am wanting to have a URL that will have all the IP addresses for every node at the Site custom property...

${N=SWQL;M=SELECT TOP 10 N.IPaddress FROM Orion.NodesCustomProperties NC JOIN Orion.Nodes N on N.nodeid=NC.NodeID WHERE NC.Site like '${NC.Site}' }

Find more posts tagged with

Accepted answers

All comments

mesverrum

I'm having a hard time with visualizing what you are shooting for,

is it a long string like

http://something.com/111.222.333.444+555.666.777.888

or is it a table with lots of links like?

http://something.com/111.222.333.444

http://something.com/555.666.777.888

hjarriell

Yes, Long string like either of the two examples below:

http://something.com/10.11.12.13 10.11.12.14 10.11.12.15/Webcameras

http:://something.com/10.11.12.13 OR 10.11.12.14 OR 10.11.12.15/Webcameras

Where it is getting the list of IPs from a query of all the nodes with the same site custom property as the node the url was clicked.

mesverrum

SWQL doesn't have any function to concat separate rows into a single long one, this can be done in plain sql using a for xml path function, search around on thwack and you'll find examples where people have used them to make strings