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

VLAN report

We have a Cisco 6509 and need to have a daily report of what ports (Up or Down) that are assigned to which VLANs. I thought Switch Port Mapper did this but can't seem to find it (we have Orion 8.1, downloaded an eval version of toolkit)

Thanks in advance

Find more posts tagged with

Accepted answers

All comments

mark_wiggans

Switch Port Mpapper can be found in the Network Discovery tools -> Toolset

jds

But the Switch Port Mapper application does not display the VLAN the interface is in.

jbaulsir

True, but you have to view them one at a time (Community@vlan#) we need one view with all ports (Up or Down) and what Vlan they're in.

Jim

Haley

If you have Cirrus Configuration Manager, you can run the Switch Ports report to get a listing of vlan #s and port status. The port status field is not included in the report by default, but you can easily modify, and select port status as a new field to include in the report.

thamizh85

Try this SQL Query:

Select [Nodes].SysName,[Nodes].AgentIP, [INTERFACES].[InterfaceDescription], [INTERFACES].[OperStatus],[BridgePorts].VlanID, [VLANS].VLANName

From BridgePorts

Inner JOIN Nodes ON

[Nodes].NodeID = [BridgePorts].NodeID

Inner JOIN Interfaces ON

[Nodes].NodeID = [Interfaces].NodeID

AND [INTERFACES].InterfaceIndex = [BridgePorts].InterfaceIndex

Inner JOIN Vlans ON

[VLANS].VlanID = [BridgePorts].VlanID AND

[Nodes].NodeID = [VLANS].NodeID

ORDER BY [Nodes].SysName,[INTERFACES].[InterfaceIndex]

Make sure you run inventory prior to running this SQL.