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

How do I find specific server services in the Orion database?

So I am attempting to locate the table where services for specific servers in the Orion (V3) AD database.

I understand that all services will not be in one single location.

I am operating on the assumption that they will be separated out based on the server they are running on, though I have no validation this is the case.

Ill be using power shell latter with the "swis" cmdlet to determine if certain application services are active on specified servers.

Thank you.

Find more posts tagged with

Accepted answers

kpmarcin

Hello,

You can use Orion SDK and SWQL to accomplish that.

In the {} Orion.APM -> Orion.APM.Component table, you will find status for all application components from all servers, including services and other application parameters.

SELECT ComponentID, Name, ShortName, ComponentType, ComponentEvidenceType, ApplicationID, TemplateID, ComponentName, DetailsUrl, FullyQualifiedName, UserDescription, UserNotes, ComponentOrder, ApplicationItemID, Description, Unmanaged, UnmanageFrom, UnmanageUntil, Status, StatusDescription

FROM Orion.APM.Component

This is how it looks:

I would make it cleaner by deleting few values, for example:

SELECT ComponentID, Name, ApplicationID, DetailsUrl, StatusDescription

FROM Orion.APM.Component

This is the result, with simple report for services (i.e. DHCP, Firewall) and current status:

To create a table with servers, you would need to use "ApplicationID" and cross reference it with another SWQL query.

Below you can download the SDK:

https://thwack.solarwinds.com/community/labs_tht/orion-sdk

I hope this will help you.

Kind regards,

Marcin Kazmierczak.

---

IT-Indago Ltd. - Authorized Reseller & SolarWinds Certified SCP Professional

IT-Indago – Be In Control! | Follow us on Facebook & LinkedIn

All comments

kpmarcin

Hello,

You can use Orion SDK and SWQL to accomplish that.

In the {} Orion.APM -> Orion.APM.Component table, you will find status for all application components from all servers, including services and other application parameters.

FROM Orion.APM.Component

This is how it looks:

I would make it cleaner by deleting few values, for example:

SELECT ComponentID, Name, ApplicationID, DetailsUrl, StatusDescription

FROM Orion.APM.Component

This is the result, with simple report for services (i.e. DHCP, Firewall) and current status:

To create a table with servers, you would need to use "ApplicationID" and cross reference it with another SWQL query.

Below you can download the SDK:

https://thwack.solarwinds.com/community/labs_tht/orion-sdk

I hope this will help you.

Kind regards,

Marcin Kazmierczak.

---

IT-Indago Ltd. - Authorized Reseller & SolarWinds Certified SCP Professional

IT-Indago – Be In Control! | Follow us on Facebook & LinkedIn

FormerMember

I am currently filtering another way, but how would you use ApplicationID?

I checked the Orion.Node table and didn't see it populated there.

How do I link without a shared key?

tdanner

SWIS queries support navigation properties, so you can start the query from nodes and then traverse the "Applications" and "Components" navigation properties to get to those details. Like this:

SELECT N.NodeID, N.DisplayName, N.Applications.Components.ComponentID, N.Applications.Components.Name, N.Applications.ApplicationID, N.Applications.Components.DetailsUrl, N.Applications.Components.StatusDescription

FROM Orion.Nodes N

Then if you want to filter based on some node properties, you can add an appropriate WHERE clause. Like one of these:

WHERE N.NodeID=42

WHERE N.DisplayName='my-server'

WHERE N.CustomProperties.City='Austin'