Custom SWQL query for VLAN Identification of an interface

Can you doodle up what you'd want this resource to have in it?  It's totally possible, but it's easier to build out what you'd want if we knew how you envision the final result.

Hi, thanks for replying. So as I mentioned above, I have two VLANS, say 400 and 401, when the script runs it moves two interfaces from VLAN 400 to VLAN 401, when it runs again it moves them back. I would like a widget on my NOC dashboard that contains the names of both VLANS and displays a green icon next to the one that the interfaces are currently assigned to, with a caption saying “active”, or such like. I don’t know if this is achievable or not.

The VLANS and interfaces are listed within NPM and are monitored on the switch they reside on, I can collect interface utilisation and other metrics for them. I can also identify the VLAN that they are assigned by looking at the interface config within NCM, however when looking at the VLANS in NPM I cant see assigned interfaces, and this is why I’ve been struggling I think.

Any help would be very much appreciated, being able to display this information would solve a lot of issues. Thank you

In a very basic representation, you want something like the above, but with icons or something in the last column?

Something like that would be perfect, is this possible? Thanks again.

Something like that would be perfect, is this possible? Thanks again.

Oh, it's totally possible.  Let me dig into the API and find you the starting query.

I'm assuming you didn't want this for every node and every interface - how did you want them filtered?

Hi, so I'd like it filtered by the specific interfaces, i.e the 2 that move VLANS. Does that help?

Thanks again.

Right now my query pulls this stuff everything, but you could easily tweak the filters as needed.  Also, in the my query example, I'm using VLAN 2001 as my "bad" because I didn't have your VLANs in my lab.  You'd have to change that as well.

Access Layer VLANs (with good/bad VLAN defined) - Custom Queries - The Orion Platform - THWACK - SolarWinds Community

That looks great thanks very much for this, I'll give it a go and let you know if I get the desired results. Thanks again.