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

Application report by node and Custom property

I am struggling to create a report on our Applications that's filtered by Node and a Custom property (Environment = Production). I see an Availably report (displaying Prod and Non-Prod) which is a start but its not what I am looking for.

Any help would be greatly appreciated!!

Find more posts tagged with

Accepted answers

All comments

planglois

What do you want to see on that report?

impalaguy

Something like this:

Looks to be super easy to do but I am struggling. Doesn't help i struggle with SWQL/SQL.

Thanks!

planglois

Try something like this:

SELECT TOP 1000 
    a.NodeID,
    n.Caption,    
    a.ApplicationID, 
    a.Name as ApplicationName, 
    a.DetailsUrl, 
    a.Status, 
    a.StatusDescription,
    cp.Mode  --Change accordingly with Custom Property name
FROM Orion.APM.Application a
INNER JOIN Orion.Nodes n ON n.NodeID = a.NodeID
INNER JOIN Orion.NodesCustomProperties cp on a.NodeID = cp.NodeID
ORDER BY Caption

You will find extra columns, to help you to populate the report with hyperlinks if needed. If you don't care about them, they can be removed from the query.

Ensure you change the "cp.Mode" line to the exact Custom Property Name (i.e cp.Environment).

KMSigma.SWI

You can also do it without JOINS using Navigation Properties.

SELECT TOP 1000 [Application].NodeID
     , [Application].Node.Caption AS [Caption]
     , [Application].Node.DetailsUrl AS [Caption_URL]
     , [Application].ApplicationID
     , [Application].Name AS ApplicationName
     , [Application].DetailsUrl AS [Application_URL]
     , [Application].Status
     , [Application].StatusDescription
     , [Application].Node.CustomProperties.CustomerName
--, cp.Mode  --Change accordingly with Custom Property name
FROM Orion.APM.Application AS [Application]
--INNER JOIN Orion.Nodes n ON n.NodeID = a.NodeID
--INNER JOIN Orion.NodesCustomProperties cp on a.NodeID = cp.NodeID
WHERE [Application].Node.CustomProperties.CustomerName = 'ACME Bird Seed'
ORDER BY [Application].Node.Caption