Eh observed the link that sent me and checking the content I see that they make a query to the NCM module table.
Put an example of what I would like to be able to help me.
But I need a team table mode report, is it possible?
Thanks for help me!
Not sure that it can be done via the web report writer but this seems to work in my lab, replace City (3 times in this query) with your custom property for teams
, count(p.name) as [Ports Total]
when p.OperationalStatus = 1 then 'Up'
when p.OperationalStatus = 2 then 'Down'
end as [Port Status]
from orion.nodes n
join Orion.UDT.Port p on p.nodeid=n.nodeid and porttype=6
group by n.customproperties.City, p.OperationalStatus
order by n.customproperties.City, p.OperationalStatus
Nice thing about this query is it doesn't depend on the port being monitored in NPM or UDT, just that it was ever discovered in UDT. I filtered it to porttype 6 which appears to be physical ethernet, but you may need to poke around at that to see what types of interfaces show up in your environment if you find things are missing.
Loop1 Systems: SolarWinds Training and Professional Services
1 of 1 people found this helpful
I just bought UDT, and haven't installed it yet, so I'm of little use with practical experience on that particular way of getting the job done.
However, if you have NPM, you've got all you need to discover which ports have NOT had traffic on them recently. And you can decide whether they can be unpatched and repurposed, or not.
Hopefully I don't have to say: "You've got to be managing / monitoring all the ports on a switch for NPM to tell you which ones haven't had traffic on them in a while."
Here's how I do it:
I'm confused about the accuracy and validity of the used/unused ports report. I've discovered multiple unused ports in a switch, but UDT reports the switch as 100% PortsUsed.
See this thread: