SWQL Study Group for the complete novice - thoughts?

Hey Stuard.

I have done some work and with SWIS/SWQL/Solarwinds API.  Some of the basic queries are pretty easy.  I really struggled  when I got to more advanced queries with joins and finding the right tables to query data.  The SWIS syntax is of course similar to SQL but it's a bit tricky IMO.  We have a pretty big Solarwinds environment so our sales manager at the time connected me up with a guy named Tim who works in some product development group with Solarwinds.  I am pretty sure he still works there and has amazing knowledge of SWiS.   Every use case I or one of my customers came up with he helped me build the queries.  I have a few queries like querying WPM status, poller status, and maintenance status that I use as key point indicators.  I am using a scheduled workflow now and sending the results in as metrics to Wavefront.  One of my counterparts in the NOC got Tim to help him build some metric queries for Cisco ASA.  If you want to shoot me an email in Thwack as a reminder, I wouldn't mind setting up some type of technical blog that documents some of the knowledge Tim gave me.  I need to remove any references we may have to internal server names, etc.  Personally we don't use the SWQL tool very much but mostly use Powershell ISE.  We are getting ready to help one of our data lake customers setup SWQL queries using the Python SWIS module.

Hey Stuard.

I have done some work and with SWIS/SWQL/Solarwinds API.  Some of the basic queries are pretty easy.  I really struggled  when I got to more advanced queries with joins and finding the right tables to query data.  The SWIS syntax is of course similar to SQL but it's a bit tricky IMO.  We have a pretty big Solarwinds environment so our sales manager at the time connected me up with a guy named Tim who works in some product development group with Solarwinds.  I am pretty sure he still works there and has amazing knowledge of SWiS.   Every use case I or one of my customers came up with he helped me build the queries.  I have a few queries like querying WPM status, poller status, and maintenance status that I use as key point indicators.  I am using a scheduled workflow now and sending the results in as metrics to Wavefront.  One of my counterparts in the NOC got Tim to help him build some metric queries for Cisco ASA.  If you want to shoot me an email in Thwack as a reminder, I wouldn't mind setting up some type of technical blog that documents some of the knowledge Tim gave me.  I need to remove any references we may have to internal server names, etc.  Personally we don't use the SWQL tool very much but mostly use Powershell ISE.  We are getting ready to help one of our data lake customers setup SWQL queries using the Python SWIS module.

wlouisharris2000 - firstly, apologies for a slow response. As with routermonkey, THWACK decided to have an off-day on its notifications.

Anyway, consider this a notification that I will drop you an eMail in a moment :)

The real basic stuff I am OK with now, but as you say, it is when management turn up and ask for X&Y and knowing how to do 'involved/complaicted' JOINS, or advanced filtering or even where to start looking for the data in the DB. I would also take any info on your usage of Powershell or Python with SolarWinds, as those, AIUI, are the two big scripting tools used to automate 'stuff'.

BTW - I can't send you an email/message as either THWACK isn't allowing it or your settings have it restricted.

To send Direct/Private Messages via THWACK, you need to be friends first.

Thanks Kevin - I have requested a friendship as well but in case he doesn't see it (setting disabled or something) also opted to reply here :)