Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

List Interfaces by Alias or description

Apologies if this has been answered but I am unable to find anything.

I am a network engineer and have no knowledge of sql but we are now using Solarwinds to monitor our network.

I managed to get lists of all our devices that are unmanaged/ alerts muted (basically mixing alot of swql queries found on this website)

I am now trying to create a custom swql query that will show any interface on all our nodes that has a specific Alias/Description .

I can get a list using the Basic SQL query but it just displays how many interfaces, does not show nodes or interfaces so we can easily click on link and load the page.

I believe i have the start to get what i want displayed . But am not sure what to query to list interfaces that have a specific Alias or description (looks like when i change description on an interface the alias also changed so either will work)

SELECT

,n.Caption AS [Node]

,i.interfacename as [Interface]

,i.interfacealias as [Alias]

,n.DetailsURL AS [_LinkFor_Node]

,i.DetailsURL AS [_LinkFor_Interface]

,'/Orion/images/StatusIcons/Small-' + n.StatusLED AS [_IconFor_Node]

,'/Orion/images/StatusIcons/Small-' + i.StatusLED AS [_IconFor_Interface]

?????????

ORDER BY [node] asc

Thanks

Find more posts tagged with

Accepted answers

adam.beedell

Hi fraser-sky

Something like this then?

All comments

adam.beedell

Before getting deep into SWQL on that one - Have you gone to Manage Nodes and switched to Interfaces at the top?

fraser-sky

Hi Adam

Thanks for the quick reply. I can see the interfaces I am looking for with that method but it involves alot of clicking

What I have done is created a Maintenance Page with a number of Tabs with custom Swql queries.

So all i do is access this page and I can see what nodes, interfaces are unmanaged or have Muted alerts, who actioned it, I then just click the link and it loads the page of the node/interface.

adam.beedell

Hi fraser-sky

Something like this then?

fraser-sky

Thanks Adam

That is exactly what I was after.

I can also see where i went wrong, Missed the i after Orion.NPm INterfaces, Did not Join Nodes and and missed the i after WHERE.

I have learnt a little more about sql but think will leave it to the experts and post another question when I get stuck.

Thanks Again