We have a requirement to retrieve the complete port/interface inventory for all switches currently under monitoring in SolarWinds NPM.
Current Scenario:
- Switch nodes are under monitoring.
- Interfaces/ports have not been added for monitoring.
- When we open List Resources for an individual switch, we can see all available interfaces/ports discovered on the device.
- Some switches were added through a Discovery Profile several years ago, while others were added using the Add Node option.
Requirement: Fetch the interface/port details for all monitored switches directly from the SolarWinds database (SWQL/SQL), without importing the interfaces for monitoring.
I would appreciate any guidance or recommendations from the community on the best approach to retrieve this information.
If anyone has implemented a similar requirement or is aware of the relevant SWQL entities, database tables, or supported methods to obtain the complete port/interface inventory for monitored switches without importing the interfaces for monitoring, please share the details.
Appreciate your help and insights. Thank you.