Need a report on trunk ports

Vidyadip91

I have bulk onboarded all the devices. Now I am trying to isolate all the trunk ports so that I can put it into alerting and remove all other unnecessary ports. I do not found any OOB report on it. I am using Self Hosted 2026.1.1. A possible report could be with below swql but for this node has to be added to UDT which is not in my case. Is there any other option to have any report in NPM.

SELECT TOP 100 NodeID, Name, TrunkMode, PortDescription
FROM Orion.UDT.Port
WHERE NodeID = 'XXXX' AND TrunkMode = '1'

ahawkins72

Hey @Vidyadip91 ,

I have looked at this off and on today, searching for the metrics somewhere in the database other than UDT. I haven't come up with anything, but would it be an option to utilize universal device poller for this?

https://documentation.solarwinds.com/en/success_center/npm/content/core-monitoring-mibs-with-universal-device-pollers-sw548.htm

I feel like the switchport mode should be a readily available OID to poll, and from there you should be able to build a report on those. I hope this helps!