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

Selecting Nested linked Tables SWQL

I really think I need to learn SQL and how to do Joins....

I know I can do this...

SELECT NodeID,IPAddress, I.Interfaces.CaptionFROM Orion.Nodes I

But I know the Interfaces table has linked tables. Like Availability, Errors. How can I Select things out oh those?Can I do nested things like

Select I.Interfaces.B.Avaliability.WeightFrom Orion.Nodes I I.Interfaces.B

Or something Similar? What I'm trying to do is Get all unknown Windows_OS applications, But I also Want the Components status for each applications, and the error msg. I have 3 SWQL query's that gets it in 3 parts, but nothing that returns it all. I'm trying to get NodeID, Caption, IP_address, App name, App ID, Componet names, component IDs, and the Errors. I'm fine with the components even being in it's own rows.

Thanks,

Levi

Find more posts tagged with

SWQL

orion sdk

Accepted answers

All comments

shadycuz

So it's really simple... I think. This worked.

SELECT NodeID,IPAddress, I.Interfaces.Availability.WeightFROM Orion.Nodes IWhere Caption LIKE '%snow%'

tdanner

You are close. Your second query would be written like this:

Select N.Interfaces.Availability.Weight  From Orion.Nodes N

(Careful - interface availability is a history table. Selecting from it with no TOP or WHERE clause may produce a huge result set.)

shadycuz

It would be great if each component name was on its own row, but this is still great.

SELECT NodeID, I.Applications.ApplicationID, IPAddress ,I.Applications.Name, I.Applications.StatusDescription,I.Applications.Components.ComponentName, I.Applications.Components.ComponentAlert.ComponentMessageFROM Orion.Nodes IWHERE I.Applications.Status = 0AND I.Applications.Name = 'Windows_OS'

shadycuz

We posted at the same time, I ran it with a LIKE filter that only returns like 30 or 40 nodes... and I still got back almost a 1000 rows.