How to SELECT a specific interface ?

Question

Hi, so this might seem like a pretty dumb question, but i want to write a report in SW using the advanced database query and i have a specific interface i want to report on, literally my only question would be, how do i select the interface i want to report on? like what would the select part of the SWQL command look like, because it's not 'SELECT interface' if you get what I'm trying to say, is there something like DisplayName that i would have to write ? i'm not very familiar with query languages so i'd need this very spelled out for me sorry to say. Any help would be very much appreciated !!

Alphadale · Answer

Thx for info

mesverrum · Answer

You are probably going to want to take a step back.

Step 1 was mentioned to you in another thread recently, you want to install SWQL studio and get acquainted with the data that's available to you.   Intro to SWQL Studio

One of my colleagues wrote this blog series that walks through some real world scenarios in how to build queries  An Adventure Into Modern Dashboarding: Introduction to SWQL Studio

Also this video is pretty good as well at demonstrating how to write queries. 91. Customizing the Orion Platform with the Orion API and SWQL

I also always liked the w3schools intro to SQL series, https://www.w3schools.com/sql/sql_intro.asp  ,  as a tutorial for people to get familiarized with querying that isn't specifically SolarWinds stuff.