UDT Port Usage Report

Question

I'm trying to create a report (or query) that will list the number of ports being used per NPM node. Ideally this would only show the most current data and could be expanded or changed to show number of unused ports as well. I attempted, unsuccessfully, to tweak existing reports to give me this data. I'm able to generate a percentage, but this doesn't help me, as I'm trying to get an actual count so I can plan for expansion during our next network refresh project.

Any help would be greatly appreciated!!

Thanks,

Matt

dkeyser · Accepted Answer

I was thinking you could just use something like this:

SELECT Nodes.Caption

, DateTime

,PortCount as 'Port Count'

,ActivePortCount as 'Active Port Count'

,(PortCount - ActivePortCount) as 'Inactive Port Count'

FROM UDT_PortUsage_Detail

join Nodes on Nodes.NodeID = UDT_PortUsage_Detail.NodeID

where DateTime >= DATEADD(HOUR,-1,getdate())

But I'm running into the issue where I'm seeing DateTime enteries in the future.