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…

Bump! I am also interested in this

Question: How do you classify a port as used or unused? It can be based on: * Current interface status - Assume all down to be unused * No traffic seen on the interface for x number of days * Interface configuration defaulted

Perhaps, you could use SQL to identify all the duplicate nodes and manually delete them. See this post:

OK I found some relevant guides: Hope it is useful!

Bump!