I see plenty of nice SWQL examples out on Thwack, here is an easy way to turn one of those into a report.
First create or download your SWQL Query from Thwack
Here is a simple one we can use as a sample
SELECT TOP 1000 IPAddress, Caption
FROM Orion.Nodes
From the main Orion page click Reports – All Reports – Manage Reports
Click Create New Report
Close the ‘Getting Started With Reports’ page if it shows up
On the Add Content page select Custom Table then click Select and Continue
On the Add Content Page choose Selection method: Advanced Database Query (SWQL, SWQL) from the pulldown
Select Query Type SWQL
Paste the query into the box - SELECT TOP 1000 IPAddress, Caption
FROM Orion.Nodes
Click Add to Layout
On the Edit Resource Custom Table for Datasource 1 screen fill in any Title and Subtitle information you want then click Add column
Place a checkmark next to all columns you want to add to your report then click Add Column
On the Edit Resource: re-order columns by dragging them into the order you prefer (if needed)
Click Submit
On the Add Report screen enter report width (if needed) Title, Footer and then click Next
On the Preview screen click Next
On the Properties screen click Next
On the Schedule Report screen click Next
On the Add Report screen click Submit
Locate and then click on your report to view it
