This stored procedure takes one parameter, NodeID, and selectively adds interfaces based on InterfaceType and a custom node field called DeviceType. This stored procedure also uses the following downloads:
- Add SNMP Functionality to SQL Server
- SQL Server Stored Procedure - Add Interface
- Get the InterfaceTypeName using a SQL Server Function
- Get the InterfaceTypeDescription using a SQL Server Function
I'm using the stored procedure to add cable modems and MTAs from another system, bypassing the SolarWinds front-end. The code as-is may not be useful to many, but it may give you some ideas.