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

Report - Unmanaged Interfaces

njoylif

Report for unmanaged interfaces, including unmanaged from and to times.

Removed custom property and joined with Nodes table to give node status icon, NodeUnmanaged, NodeCaption...

Unmanaged_Interfaces_w_nodeinfo.OrionReport

Find more posts tagged with

Accepted answers

All comments

Deltona

I think 'Parent' has been removed in the latest version of Orion.

Report no longer works

njoylif

You can just remove that column...just allows hyperlink to node.

see note

NOTE: this report includes a custom property called Parent that is the name of the Node the interface belongs to.

Just remove that column in the SQL section and you should be good, or send me a message and I'll help you fix it/ add the column if you want it. This allows me to report node/interface and hyperlink both

Deltona

I noticed that right after adding the comment...

Would you be able to modify the report to display the Node and the Node Status icon?

This would allow me to see whether an interface is unmanaged because the node is unmanaged or because it was unmanaged individually.

TIA

njoylif

let me know if that gives you what you are looking for.

Thx

Deltona

It is perfect!

Once again, thanks for sharing.

cahunt

I adjusted this slightly to give me a Last Unmanage report for my interfaces, also shows interface to be un managed. IT was easy once I had this setup. Very nice Report!!!

Select

n.StatusLED, n.Caption as NodeName, n.UnManaged as NUnMgd, i.Unmanaged as IntUnMgd,

i.NodeID, i.InterfaceID, i.Caption, i.unmanagefrom, i.UnManageUntil

From Interfaces i left join Nodes n on i.NodeID=n.NodeID

Where i.UnManaged=0 and i.UnManageUntil > 0

order by i.UnManageFrom

edw7n

thanks..works for me