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
Store

Custom SWQL query is [_LabelFor_ColumnName] a thing?

Hello all,

I'm looking to create a Custom SWQL Query that pulls in interface bps data and sorts the bps column as a number rather then a string. I'm wondering if there is a magic [_ItemFor_ColumnName] like [_LinkFor_Node] or [_IconFor_Node] does. Currently using CONCAT causes the column to be sorted as a string and that's not what I'm looking for as that'll but outputs in Mbps between outputs that are Kbps in the sorting order since it's going off the first character 9 rather than the numbers. I hope that makes sense.

Thank you,

Doug.

Find more posts tagged with

Accepted answers

All comments

wluther

@dkeyser, unfortunately, I don't believe there is a cool formatting prefix for that, but that sounds like a feature request I'd sure vote for.

In regards to sorting your SWQL query output, you should be able to sort by the actual column/field values (pre-concat), even if you're displaying something else entirely. Try that and see if it works for you, then let us know how it goes.

Thank you,

-Will

wluther

Not in a spot to test anything for real, but a quick mock up should get the point across.

SELECT
InterfaceCaption
,CONCAT('Meow', 'Arf', 'Moo - ', InBps) AS [InBandwidth]
FROM The.Land.Of.Interfaces
ORDER BY InBps

dkeyser

Thank you for the reply!

I'm doing just what you discribed above but it's still sorting it as a string and not by the number it's concatenating to the string. In the image below you can see it's sorted Descending and it's mixing up the values due to string sort.

dkeyser

I did put in a feature request. thwack.solarwinds.com/.../addition-of-a-_labelfor_columnname-option-in-swql-in-hopes-it-fixes-sorting-of-number-and-string-concatenations

shuth

A workaround could potentially be to use your Custom SWQL in a Custom Table without CONCAT'ing the data units, and have the table autoformat the data.

Downside is you'll have the extra header etc.

wluther

@dkeyser I think it is because you are actually clicking the column header to sort. If you use the ORDER BY in the SWQL, then the results should already be sorted without needing to click the header to sort.

I do the same thing with last boot and uptime. I have my last boot column in case someone wants to click the header to sort by time, otherwise, my SWQL query has an ORDER BY to sort it how I want it by default.