cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

SolarWinds Lab Episode #91 – Customizing the Orion Platform With the SolarWinds API and SWQL

Community Manager

September 16, 2020

In this follow up to "Orion SDK 101: Intro to PowerShell and Orion API," Kevin M. Sparenberg, technical content manager for Community, will continue with his deep dive into the SolarWinds Query Language (SWQL). Kevin will show you how to represent existing data from within your monitoring ecosystem using traditional elements (e.g., reports, widgets, etc.) and in the new, modern dashboards, as well. A working knowledge of basic T-SQL queries is highly recommended.

In this session, you’ll learn:

  • How to get started with dashboards
  • What makes a good or bad dashboard
  • How to build your own widgets
  • How to execute proper dashboard research, design, and implementation
  • Where to find more help

 

Additional Resources

THWACK Report Lab

THWACK Orion SDK Forum

SolarWinds Lab #86 - Orion SDK 101: Intro to PowerShell and Orion API

 

5 Comments
MVP
MVP

I'm only about 10 minutes in, but I need that desktop background! haha. The timing of this video is amazing as I'm just in the process of onboarding some new devices for our Network Automation team who want there own dedicated dashboard and to look at some API Polling.

Level 10

Anyone asked about SAML auth in API/SDK? 🙂 I missed this live 😞

Level 8

You mentioned the Lab Archives, but I only see lab episodes #72 to #92. I've tried a few different browsers but do not see anything that says, "next page" to find other past labs.

This stuff is great!

 

The thing I'd really like to see is how to search multiple tables in one report. I have information in Orion.Nodes, Orion.NodeIPAddresses, Orion.NodeVlans, and Orion.NodesCustomProperties that I would like to pull into one report. And if there's a way to calculate different formats to put in the table. Email me and I can explain better. 🙂

Thanks!

Community Manager
Community Manager

@kgrahamjr You say "report" a few times, but do you mean Custom Query Widget?  If so, then what you're asking for shouldn't be too crazy difficult.  Did you find the field names you want to search by using SWQL Studio?  Either way, the best place to ask questions like this is the Orion SDK forum.

Level 8

I did mean a Report > All Reports. I do find the field names in SWQL Studio, but I'll go see about asking in the Orion SDK Forum as you suggest.

Thanks, love the videos!

 

About the Author
Kevin's first computer was the family TI-99/4A. He's learned computing the best way possible: by fixing his own broken machines. He was a SolarWinds customer for nearly 10 years before joining the company. He's worked the range of IT jobs: from the 3-person consultancy to the international law firm. Along the way, he's become a SolarWinds advocate and evangelist of monitoring glory. His passions include shooting archery, blacksmithing, playing D&D, and helping IT professionals leave at a reasonable time each and every day.