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

SWQL - ServiceNow Incident Number Hyperlink

The ServiceNow Incident widget has a link when you click on the incident number it opens ServiceNow to the selected ticket number. Unfortunately the ServiceNow Incident widget doesn't contain all the information I need, so I've created a SWQL query with everything I need on it. The problem is creating this hyperlink for the IncidentNumber column.

SELECT

ToLocal(s.LastTriggerTime) AS [Date]

,s.IncidentNumber AS [Ticket#]

,o.RelatedNodeCaption

,s.State

,s.AssignedTo

,s.Description

,s.IncidentUrl

FROM Orion.ServiceNow.AlertIncident s

JOIN Orion.AlertObjects o ON o.AlertObjectID = s.AlertObjectID

JOIN Orion.Nodes n ON n.NodeID = o.RelatedNodeId

WHERE s.State IN ('New','Work in Progress')

I tried adding

,'https://<ServicNow URL>/nav_to.do?uri=incident.do?sys_id:' + ToString(s.IncidentNumber) AS [_LinkFor_Ticket#]

but there's no Details Page Link option under "Add display settings" drop-down list. I also tried "Allow HTML tags" checkbox. Neither option gives me a hyperlink option.

Find more posts tagged with

Accepted answers

mesverrum

The custom table resource does not support the use of the _linkfor_ and _iconfor_syntax. You would need to fully build out the HTML and then check the box in the custom table to allow HTML in your column. something like concat('<a href="https://<ServiceNow URL>/nav_to.do?uri=%2Fincident.do%3Fsys_id%',ToString(s.IncidentNumber),'">Incident ',ToString(s.IncidentNumber),'</a>') as Ticket

All comments

s-bolyard

Fixed the link to the correct URL. This query works perfectly using the Custom Query widget, but not in the Custom Table widget. There's got to be something in the column that I need to change, but I'm stumpted.

,'https://<ServiceNow URL>/nav_to.do?uri=%2Fincident.do%3Fsys_id%' + ToString(s.IncidentNumber) AS [_LinkFor_Ticket#]

i_like_eggs

nice work, i am planning a Servicenow integration ill be sure to bookmark

mesverrum

s-bolyard

Thanks for the feedback. Worked great!

s-bolyard

Good luck. The integration with SolarWinds is pretty good. One other thing I had to change was the URL. It wasn't taking me to the incident number, just opening ServiceNow's home page. I changed it to:

concat('<a href="https://<ServiceNOW URL>/nav_to.do?uri=incident.do?sys_id=',ToString(s.IncidentNumber),'">Incident ',ToString(s.IncidentNumber),'</a>') as [Ticket]

Works great with mesverrum's suggestion.

s-bolyard

Sorry to bug you again. Last question I promise. I tried to follow the same format to concatenate to a SolarWinds page.

,concat('<a href="">thwack.solarwinds.com/.../NodeDetails.aspx ',ToString(o.RelatedNodeCaption),'</a>') as [Device Name]

When I check the Allow HTML tags and submit, I get the below message. ls there something in the concat string that I'm doing wrong?