SolarWinds THWACK
THWACK
  • Sign In
  • Search
  • Product Forums
    • Observability
      • SolarWinds Observability
      • Hybrid Cloud Observability
      •  
      • DevOps
    • The Orion Platform
      • Forum
      • Scalability Engines (HA, APE, AWS)
      • Enterprise Operations Console (EOC)
      • Orion SDK
      • Alert Lab
      • Report Lab
    • Network Management
      • Network Performance Monitor (NPM)
      • NetFlow Traffic Analyzer (NTA)
      • Network Configuration Manager (NCM)
      • IP Address Manager (IPAM)
      • User Device Tracker (UDT)
      • VoIP & Network Quality Manager (VNQM)
      • Log Analyzer
      • Engineer’s Toolset
      • Network Topology Mapper (NTM)
      • Kiwi CatTools
      • Kiwi Syslog Server
      • ipMonitor
    • Systems Management
      • Server & Application Monitor (SAM)
      • Virtualization Manager (VMAN)
      • Storage Resource Monitor (SRM)
      • Server Configuration Monitor (SCM)
      • SolarWinds Backup
      • Web Performance Monitor (WPM)
    • Database Management
      • Database Performance Analyzer (DPA)
      • SQL Sentry
      • Database Performance Monitor (DPM)
      • Database Mapper
      • Task Factory
    • Application Management
      • AppOptics
      • Loggly
      • Papertrail
      • Pingdom
      •  
      • New on THWACK DevOps
    • IT Security
      • Access Rights Manager (ARM)
      • Identity Monitor
      • Security Event Manager (SEM)
      • Patch Manager
      • Serv-U FTP & MFT
    • IT Service Management
      • SolarWinds Service Desk (SWSD)
      • Web Help Desk (WHD)
      • DameWare Remote Support (DRS)
      • DameWare Remote Everywhere (DRE)
      • DameWare Mini Remote Control (MRC)
  • Resources
    • THWACK Command Center
    • DevOps
    • What We're Working On
    • Blogs
      • Community Announcements
      • Product Blog
      • Monitoring Central
      • Geek Speak
      •  
      • New on THWACK DevOps
    • THWACK Tech Tips
    • TechPod
    • Support
      • Success Center
      • Documentation
      • Submit a Support Ticket
      • Customer Portal
      • Renew Maintenance
    • Community Groups
      • New To THWACK
      • Federal & Government
      • User Experience
      • EMEA Group
      • Japan Group
  • Events, Missions, & Musings
    • Events
      • THWACK Livecast
      • THWACK Livecast Archive
      • SolarWinds Lab
      • SolarWinds Lab Archive
      • THWACKcamp 2022 On Demand
      • SolarWinds User Groups
      • SolarWinds Events Calendar
    • Missions & Contests
      • Monthly Mission: What Killed Your Productivity?
      • THWACK 101
    • Musings
      • Water Cooler
      • Geek Tank
      • IT Tech Jobs/Careers
      • Monitoring for Managers
    •  
      •  
  • Content Exchange
    • The Orion Platform
      • Alerts
      • Custom HTML
      • Custom Queries
      • Modern Dashboards
      • Reports
      • Scripts
    • Network Performance Monitor
      • Device Pollers
      • Universal Device Pollers (UnDP)
    • Network Configuration Manager
      • Config Change Scripts
      • Device Templates
      • Firmware Upgrade Templates
      • Policy Documents
    • Server & Application Monitor
      • API Pollers
      • Application Monitor Templates
    • Server Configuration Monitor
      • Policies
      • Profiles
    • Database Performance Analyzer
      • Custom Alerts
      • Custom Metrics
      • Custom Queries
    • Web Help Desk
      • Style Sheets
  • Academy
    • Newsroom
    • Forums
      • Classroom Discussions
      • SolarWinds Certified Professional (SCP)
    • Training & Certification
  • Free Tools & Trials
  • Store
The Orion Platform
  • Content Exchange
  • More
The Orion Platform
Custom Queries Node application component assigned credentials SWQL query
  • Tags
  • More
  • Cancel
Options
  • View all
  • Previous
  • Next
  • View slideshow
  • More
  • Cancel
fileName

Node application component assigned credentials SWQL query

Update 04/20/2022... re-wrote the SQL query into a SWQL query, the file to download is the SWQL query but I'll keep both versions available here for reference.

SWQL:

SELECT
	 n.NodeID
	,n.Caption AS [DisplayName]
	,n.SysName AS [Hostname]
	,n.IP_Address AS [IP Address]
	,n.ObjectSubType AS [Monitoring Method]
	,a.ID as ApplicationID
	,a.Name as [Application]
	,c.ComponentID as ComponentId
	,c.Name as Component
	,cts.Value as TemplateCredId
	,cs.[Value] as OverridenCredId
	,cred.Name as CredName
FROM Orion.APM.Component AS c
INNER JOIN Orion.APM.Application AS a ON a.ID = c.ApplicationID
INNER JOIN Orion.Nodes AS n ON a.NodeID = n.NodeID
LEFT JOIN Orion.APM.ComponentSetting AS cs ON cs.ComponentID = c.ComponentID AND cs.[Key] = '__CredentialSetId'
LEFT JOIN Orion.APM.ComponentTemplate AS ct ON ct.ID = c.TemplateID
LEFT JOIN Orion.APM.ComponentTemplateSetting AS cts ON cts.ComponentTemplateID = ct.ID AND cts.[Key] = '__CredentialSetId'
LEFT JOIN Orion.Credential AS cred ON cred.ID = ISNULL(cs.Value, cts.Value)
WHERE cred.Name IS NOT NULL

SQL:

SELECT
	 n.NodeID
	,n.Caption AS [DisplayName]
	,n.SysName AS [Hostname]
	,n.IP_Address AS [IP Address]
	,n.ObjectSubType AS [Monitoring Method]
	,a.ID as ApplicationID
	,a.Name as [Application]
	,c.ID as ComponentId
	,c.Name as Component
	,cts.Value as TemplateCredId
	,cs.[Value] as OverridenCredId
	,cred.Name as CredName
FROM SolarWindsOrion.dbo.APM_Component AS c
INNER JOIN SolarWindsOrion.dbo.APM_Application AS a ON a.ID = c.ApplicationID
INNER JOIN SolarWindsOrion.dbo.Nodes AS n ON a.NodeID = n.NodeID
INNER JOIN SolarWindsOrion.dbo.NodesCustomProperties AS cp ON cp.NodeID = n.NodeID
LEFT JOIN SolarWindsOrion.dbo.APM_ComponentSetting AS cs ON cs.ComponentID = c.ID AND cs.[Key] = '__CredentialSetId'
LEFT JOIN SolarWindsOrion.dbo.APM_ComponentTemplate AS ct ON ct.ID = c.TemplateID
LEFT JOIN SolarWindsOrion.dbo.APM_ComponentTemplateSetting AS cts ON cts.ComponentTemplateID = ct.ID AND cts.[Key] = '__CredentialSetId'
LEFT JOIN SolarWindsOrion.dbo.Credential AS cred ON cred.ID = ISNULL(cs.Value, cts.Value)
WHERE cred.Name IS NOT NULL

  • applications
  • credential
  • sam
  • Component
  • Server & Application Monitor (SAM)
  • credentials
sum_giais
sum_giais
  • 17 Feb 2022
  • 18 Downloads
  • Share
  • More
  • Cancel
Anonymous

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 190,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.

SolarWinds Customer Success Center Certification SolarWinds Lab Link Accounts
About THWACK Blogs Federal & Government Edit Settings Free Tools & Trials
Legal Documents Terms of Use Privacy California Privacy Rights Security Information
©2021 SolarWinds Worldwide, LLC. All Rights Reserved.