I'll second that. With the SWQL language being custom, it's very frustrating to write something in SWQL Studio and not be able to just copy and paste to a resource (or vice-versa). I feel like I don't see the same differences when refining SQL queries in SQL Management Studio and building a report, etc.
3 of 3 people found this helpful
Quite often it's simply a missing ORDER BY clause. In this case, simply do this:
SELECT ROUND(SUM(VolumeSpaceUsed)/1099511627776, 1) AS TOTAL_TB
FROM Orion.Volumes V
INNER JOIN Orion.Nodes N ON (N.NodeID = V.NodeID)
INNER JOIN Orion.NodesCustomProperties NC ON (N.NodeID = NC.NodeID)
WHERE MachineType LIKE '%Window%'
ORDER BY TOTAL_TB
And it should work. Something to do with SWQL needing this in order to do the "Row Windows" properly. You can find a more detailed explanation by searching if you want. All I know is it usually works for me!!
that helps in the short run, thanks Craig! I guess I will have to start thread or something for Custom SWQL Reference Posts....