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

Looking for a SWQL to get a list of Applications assigned on nodes specifically to know what components have been "Override" has been set

sredmond

We are interested in inventorying assigned applications and know what components have the Override set.

We want to know which components have been overrridden

thanks

Find more posts tagged with

Accepted answers

All comments

brscott

There's a couple ways to look at it. The easiest way would look something like this:

report with custom table and a custom swql as the datasource:

SWQL:

select c.ComponentID, c.ComponentName, c.Application.Name as ApplicationName, c.Application.node.Caption as Node, cs.Key from Orion.APM.Component C Join Orion.APM.ComponentSetting cs on cs.ComponentID = c.ComponentID

NOTE: you can add the field cs.value to see the value of the override

In the report: group by Node, then ApplicationName, then ComponentName

See if that gets the information you are looking for.

sredmond

Excellent and thank you.

brscott

Here is a slightly more advanced version. This shows all SAM monitors even if they don't have any values overwritten from the template. It shows the template name. It shows the group name if they are assigned to a group instead of the node. I excluded AppInisight monitors because I have a lot of them and they added a lot of length to the report.

Select
    a.node.Caption as Node, 
    a.node.DetailsUrl as _LinkFor_Node,
    a.Node.Status as NodeStatus,
    a.Node.ChildStatus as NodeChildStatus,
    a.Template.DisplayName as Template, 
    g.DisplayName as AssignedToGroup,
    a.Name as ApplicationName, 
    a.DetailsUrl as _LinkFor_ApplicationName,
    a.Status as ApplicationStatus,
    a.Components.ComponentName, 
    cs.Key, 
    Case  
        When length(cs.Value) > 100 then concat( substring( cs.Value, 1, 97 ), '...' )
        Else cs.value
    End as Value
From Orion.APM.Application A 
Left Join Orion.APM.ComponentSetting cs on cs.ComponentID = a.Components.ComponentID 
Left Join Orion.Groups g on g.ContainerID = a.PrimaryGroupID
Where 
    ( cs.Key is null or cs.Key not in ( '__CredentialSetId', '__DataTransformEnabled', '__DataTransformCheckedRadioButton', '__DataTransformCommonFormulaIndex', '__DataTransformCommonFormulaOptions', '__UserDescription', '__UserNotes', '_BB_CanBeDisabled' ) )
   and A.template.Name not like 'AppInsight%'
Order by a.Name