• State Not Answered
  • Locked Locked
  • Replies 1 reply
  • Subscribers 17 subscribers
  • Views 606 views
  • Users 0 members are here
Options
Related
This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

SWQL query to pull SAM Components

SolarWindNoob

I am trying to get a list of how many SQL experience monitors we have and what the SQL command are associated with them. Is there a SWQL query I can use or build to get this. 

  • 0

    Cooked this SWQL query up in my lab just now

    SELECT 
c.Application.Node.Caption as Node
, c.Application.Name as App
, c.Name as Component
, cs.[Key] as [key]
, es.Setting as script
FROM Orion.APM.ExternalSetting es
join orion.apm.ComponentSetting cs on cs.Value = es.id and cs.[key] = 'ScriptBody'
join orion.apm.Component c on c.ComponentID = cs.ComponentID

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 200,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 Customer Portal
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.