I need to create a report that will return a list of all servers being monitored. As an example if the server name convention was like myserver.fqdn.tld

JayJay_BillsFan

I am trying to build a query in Solar Winds that will tell me all the server names that are configured for monitoring in it's database. 

mesverrum

Don't even need anything fancy for that, the built in report writer would do fine.  Select the object as Nodes, the column to display would be Caption.  There you go.

If you want to get more elaborate you can also add the dns name as a second column, but not all nodes report their dns names so I would rely on caption as the primary.