SAM Monitor Node Export

Question

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.

roberto.uriarte · Answer

And I found how to export them. I had already added a widget to one of my dashboard and I just have to bring up that page and I was able to just copy/paste the entire page and futz with it in XLS. I'm thinking there's a way to run an SQL query but who has time.

Seashore · Answer

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'