• State Suggested Answer
  • Locked Locked
  • Replies 3 replies
  • Answers 2 answers
  • Subscribers 27 subscribers
  • Views 571 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

SAM Monitor Node Export

roberto.uriarte

Apologies if this has been answered in a separate thread, I'm not finding it if there's one.  I have several hundred nodes assigned to an application monitor and I'm trying to export that list of nodes.  I've looked around and I'm not finding an export option.  I feel it's probably gonna be something easy but I'm not finding it.

Thanks for any help.

Parents
  • 0

    If you would like to use SWQL below query will list all nodes that has a specific application assigned to it:

    ('WebTest' is the name of the application we are looking for in these examples. Change to what you need to look for.)

    SELECT
    A.Name AS [Application]
    ,A.Node.Caption AS [Server Name]
FROM Orion.APM.Application AS A
WHERE
    A.Name='WebTest'

    If you are more into SQL, this is the code for you:

    SELECT 
	A.Name AS [Application]
	,N.Caption AS [Server Name]
FROM APM_Application AS A
INNER JOIN NodesData as N ON A.NodeID=N.NodeID
WHERE 
	A.Name='WebTest'

  • 0 in reply to Seashore

    Hey Seashore, thanks for the response, I'll give it a go and report back.

Reply Children
No Data

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.