Now that we’ve covered the main navigation portion of SWQL Studio, let’s build your first query. Scroll down the object explorer until you find the Orion namespace, expand it, right-click on Orion.Nodes, and choose Generate Select Statement.
This will open a new query in the tabbed query editor and pre-populate it will all properties (but not Inherited Properties) for the Orion.Nodes entity.
This is a huge block of text because most monitoring in the SolarWinds Platform is based around the idea of a Node as the “parent” for related entities). If you have a working knowledge of T-SQL, this will look familiar. We are selecting all the properties for the first 1000 records from the Orion.Nodes entity.
Saving the Results
If you need the results of a query, right-click in the top left (blank) box of the results pane and select Save as CSV.
Saving a Query
If you have a query you’d like to save for later use, the recommendation is to save it as a “.swql” file. This makes locating them easier. If you have a query you’d like to share with others, you can upload it to the THWACK community’s Custom Queries gallery.