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

Clean up data from query on dashboard? Also - fetch data from other table?

Hello, folks.

I am starting to play with dashboards. I've found the data I want (which is basically "show me the top 20 most full hard drives on our servers").

I've got the data I needed using a widget and the visual query builder.

The question I have is how do I get the results to be returned as "93%" instead of "93.1183676295"?

Same question for "disk space available" - how do I get the results to display as "21.2 GB" instead of "21175294"?

Last question - I can't seem to locate where I can get the Node Name of the device that has the full hard drive. When I select the Orion.Volume row type, there's no entity I can see that is the parent node name (in other words "which server has a full hard drive?"). The best I can come up with is FullName, which comes out as "DeviceName-c:\DriveLabel DriveSerial"

Find more posts tagged with

Accepted answers

WinterSoldier

Hi,

Here's the query that might help you.

SELECT V.Node.Caption AS [Hostname]
      ,V.Caption AS [Volume]
      ,V.Type AS [VolumeType]
      ,V.Status AS [VolumeStatus]
      ,V.StatusIcon AS [VolumeStatusIcon]
      ,ROUND(V.VolumePercentUsed,0) as PercentageUsed -- (Removed decimals)
      ,V.DetailsURL AS [VolumeUrl]
      ,V.Node.Status AS [NodeStatus]
      ,V.Node.StatusIcon AS [NodeStatusIcon]
      ,V.Node.DetailsURL AS [NodeUrl]
FROM Orion.Volumes AS V

JOIN Orion.Nodes AS N ON N.NodeID = V.NodeID

WHERE V.UnManaged = 'False'
  AND V.Node.UnManaged = 'False'
  AND V.VolumePercentUsed > 85

You can modify where condition based on your requirements.

All comments

WinterSoldier

Hi,

Here's the query that might help you.

SELECT V.Node.Caption AS [Hostname]
      ,V.Caption AS [Volume]
      ,V.Type AS [VolumeType]
      ,V.Status AS [VolumeStatus]
      ,V.StatusIcon AS [VolumeStatusIcon]
      ,ROUND(V.VolumePercentUsed,0) as PercentageUsed -- (Removed decimals)
      ,V.DetailsURL AS [VolumeUrl]
      ,V.Node.Status AS [NodeStatus]
      ,V.Node.StatusIcon AS [NodeStatusIcon]
      ,V.Node.DetailsURL AS [NodeUrl]
FROM Orion.Volumes AS V

JOIN Orion.Nodes AS N ON N.NodeID = V.NodeID

WHERE V.UnManaged = 'False'
  AND V.Node.UnManaged = 'False'
  AND V.VolumePercentUsed > 85

You can modify where condition based on your requirements.

adam.beedell

Bookmark this link it's what you want https://github.com/solarwinds/OrionSDK/wiki/SWQL-Functions

CONCAT and ROUND are the functions that let you clean up data (also "/1024/1024/1024 AS [column name]" etc for moving from bytes to KB to MB to GB etc)

JOIN accesses other tables. But usually you'll want to open SWQL Studio, add an alias to the FROM section (From orion.nodes N) then type "n."and look at the autocompletes, then "{whateveryouwanttojoin}." to grab data from related auto-joined tables. Other ways to do this exist but it's a good workflow.