Hi good day,Can somebody help me with Solarwinds-Orion-UDT-3.2.4I want to make in ReportWriter or ReportWeb a report per team of ports in use and free ports.Anyone who can guide me with what variables to use?First of all, Thanks.Kind regards
Thank you
This is the what i needed.
Thank you njoylif for help me.
For others I leave here the link: UDT report for used/unused ports per device
Anyway, many thanks to: brett.holzhauer rschroeder
Kind regards...
jjhj
I can try and assist you with that. I found this message board in our archives and this may be able to help you out. Let me know if this is a solution that works!
Re: Report on ports used and unused
Dear brett.holzhauer,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!
Kind Regards
ah okay! This may be a question for one of our fellow THWACK-sters.
rschroeder - do you have any insights into this?
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:
How to create a report displaying the Last Time Data was Transmitted or Received on a Switch Port
Thank you rschroeder
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
Select n.customproperties.City
, count(p.name) as [Ports Total]
, case
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.
-Marc Netterfield
Loop1 Systems: SolarWinds Training and Professional Services
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:
How long does a port have to be down before UDT reports it as "available" or "unavailable"?
