I learned SQL a long time ago. Many of my monitors and reports have used SQL scripts I have written. Is there a tool to convert these to SWQL? Is there any advantage to running a SWQL script rather than a SQL script?
The advantage to using SWQL over SQL is that SolarWinds maintains that SWQL scripts will continue to work with SQL schema changes over time. SQL tables can and do change with releases, which can break scripts.
The other main advantage of SWQL is the ability to skip JOINS using navigation properties. Decreasing JOINs - the Power of Navigation Properties - Orion SDK - The Orion Platform - THWACK (solarwinds.com)
I am not aware of a tool that will do the conversion, I use the SWQL studio to redo scripts as I run across them.
