Hi all, I have been my companies SolarWinds admin for the last two plus years. I started at the demo phase all the way through install and administration. It has been a long a at times frustrating ride but I have enjoyed every second of it. I can no longer put off the fact that I need to throw myself into learning SWQL. Where do I start, and please pretend like you are speaking to a small child. Thanks!!!
I have the same request. And I appreciate all of the tips and links to other posts on the forum...but is that really all there is? There's no class, or guide, or video provided by Solarwinds??
Download the SDK from the link someone else posted, and get the SWQL Studio. This makes it easier to create queries because it shows you the fields in the different tables.
SQL knowledge is great to have, very close to SWQL.
One great feature of SWQL over SQL is the built in JOIN's. They look a bit link little chain links in SWQL Studio, below you can see it where the first one is "AccessPoints"
Look for other SWQL queries out there, I have quite a few posted, and have fun playing. Nothing you can do in SWQL Studio can hurt your database, so don't worry!
These are some great posts @cwjohnson3rd
Do you have SQL experience? While the two are not identical, the query structure is the same.
One annoying thing -- outside of SQL or SWQL -- is that you must know what fields in what table(s) from the Orion database you need to query. That means you need to be familiar with the database structure itself. That structure has, in the past, changed from version to version, and differs between what you use in SQL and SWQL. Figuring out what to query has been the most challenging thing for me.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.