I need to be able to generate a report that reports how many interfaces "ports' are on a switch stack. Need the total used and available. What's the best way to do this?
Who is the vendor of the switch?
IF Cisco check the inventory reportsAlso for this type of thing UDT would have this information
Agreed UDT is likely your best bet here, see online demo here to see the functionality - Device Tracker Summary (solarwinds.com)
