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 to get down application components?

I want to create a dashboard for my NOC that shows a list of down nodes, down applications, and down components of each application.

I have nodes and applications but how do I get components?

I made a powershell script that will do it by taking the url of each application and looping through them and running a query to grab the down components of each application but I want to move this to a dashboard within solarwinds instead of a powershell script.

So the dashboard should be a table with headings like "Component name --- App Name ---- Host Name ---- Status" to show all of the down/offline/unreachable components of each application.

Component Name	App Name	Node Name	Status Code
HTTPS monitor	Microsoft IIS	VM02	2

foreach ($app in $DownAppTable) {
    $appName = $DownAppTable[$DownAppTable.IndexOf($app)].AppName
    $appURL = $DownAppTable[$DownAppTable.IndexOf($app)].detailsUrl
    $id = Get-SwisData $swis "SELECT ApplicationID from Orion.APM.Application n WHERE n.Name = `'$appName`' AND n.detailsUrl = `'$appURL`'"
    $DownComponentTable += Get-SwisData -ErrorAction Ignore $swis "SELECT Name AS ComponentName,ShortName,Status,StatusDescription,AncestorDisplayNames AS HostName,DetailsUrl FROM Orion.APM.Component c WHERE c.ApplicationID = $id AND Status IN (0,2,3,12)" 
}

Find more posts tagged with

Accepted answers

ecmel

The following SWQL query should provide the list of all components that are not in "Up" state: You can change "where" clause in the query to filter them based on a specific status or any other attribute.

SELECT c.Name as [Component Name]
, c.Application.Name as [App Name]
, c.Application.Node.Caption as [Host Name]
, c.Status as [Component Status Code]
, c.StatusDescription as [Component Status]
FROM Orion.APM.Component c
WHERE c.Status<>1
ORDER BY c.Name

SteveK

to build off of ecmel has.

For components I like to include StatusOrErrorDescription from the componentalert table, so you know whats going on. I would recommend doing an exclusion for Status 1 (Up) and 27 (Disabled).

If you are using a modern dashboard, I also like to include the Status and URL/URI for Component, Application and Node/Host. That way you can use the Orion Entity format.

SELECT c.Name as [Component Name]
, c.DetailsUrl as [Component URL]
, c.Application.DetailsUrl as [App URL]
, c.Application.Status as [App Status]
, c.Application.Node.DetailsUrl as [Node URL]
, c.Application.Node.Status as [Node Status]
, c.Application.Name as [App Name]
, c.Application.Node.Caption as [Host Name]
, c.Status as [Component Status Code]
, c.ComponentALert.StatusOrErrorDescription
FROM Orion.APM.Component c
Where c.Status != 1  --Exclude Up status
    And c.Status != 27  --Exclude Disable Status
ORDER BY c.Name

All comments

ecmel

SELECT c.Name as [Component Name]
, c.Application.Name as [App Name]
, c.Application.Node.Caption as [Host Name]
, c.Status as [Component Status Code]
, c.StatusDescription as [Component Status]
FROM Orion.APM.Component c
WHERE c.Status<>1
ORDER BY c.Name

SteveK

to build off of ecmel has.

For components I like to include StatusOrErrorDescription from the componentalert table, so you know whats going on. I would recommend doing an exclusion for Status 1 (Up) and 27 (Disabled).

If you are using a modern dashboard, I also like to include the Status and URL/URI for Component, Application and Node/Host. That way you can use the Orion Entity format.

SELECT c.Name as [Component Name]
, c.DetailsUrl as [Component URL]
, c.Application.DetailsUrl as [App URL]
, c.Application.Status as [App Status]
, c.Application.Node.DetailsUrl as [Node URL]
, c.Application.Node.Status as [Node Status]
, c.Application.Name as [App Name]
, c.Application.Node.Caption as [Host Name]
, c.Status as [Component Status Code]
, c.ComponentALert.StatusOrErrorDescription
FROM Orion.APM.Component c
Where c.Status != 1  --Exclude Up status
    And c.Status != 27  --Exclude Disable Status
ORDER BY c.Name

AlabamaMadman

Both good answers.

Thank you for the help.