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 Query HTML Tag Formatting

I'm trying to get the USER field in this query to be blue and bold. It shows correctly in the preview, but then tells me there is a problem with the USER column when trying to save it. I have HTML tags enabled for that column as well.

SELECT CONCAT('', TOSTRING(UserName), '

Find more posts tagged with

SWQL

Accepted answers

All comments

adam.beedell

What's the error? And is this is a Custom Table resource? (or Custom Query?) on a classic dashboard

What you're trying to do is totally possible

nickburns186

Custom query on classic. That's just it, the error is vague. Just says problem with column.

dunky2k

Remove the part you have that is defined AS [User] in your swql statement, just leave that part off.

When the query runs it will create the Username field instead.

Now in your table name definition below, change the Display Name field to User and this will show as that on your Table rather than Username.

nickburns186

Thanks. Just tried taking out AS [User] it throws an invalid syntax error.

adam.beedell

You're missing the closing ">" in the user column

nickburns186

Are you saying where I have circled below? If so I did try that.

dunky2k

Sorry, don't know what i was talking about earlier, this is what we use and it seems to work fine for us.

SELECT [data].[OrionNode].[DisplayName] AS [DisplayName],
concat('<p style="color:red">', TOSTRING([data].[RemoteAccessSessions].[UserName]), '</p>') as [Username],
toLocal([data].[RemoteAccessSessions].[ConnectedTime]) AS [Connection Time],
toLocal([data].[RemoteAccessSessions].[DisconnectedTime]) AS [Disconnect Time],
[data].[RemoteAccessSessions].[InTotalBytes] AS [Total Bytes In],
[data].[RemoteAccessSessions].[OutTotalBytes] AS [Total Bytes Out],
[data].[RemoteAccessSessions].[RasProtocol] AS [RasProtocol],
[data].[RemoteAccessSessions].[ClientInfo] AS [ClientInfo],
[data].[InstanceSiteId] AS [InstanceSiteId]
FROM orion.asa.node AS data
where [data].[RemoteAccessSessions].[EncryptionAlgorithm] = 1
and ([data].[RemoteAccessSessions].[NodeId] = 1422 or [data].[RemoteAccessSessions].[NodeId] = 1424)
and [data].[RemoteAccessSessions].[DisconnectedTime] is null

nickburns186

Appreciate it.