I need to show a report of all the switch ports in our environment. All switch ports are not in NPM but they are in UDT. Is there a way to get this info and show a total number at the bottom? Thanks.
Assuming you have all your nodes in NCM and a scheduled "Network Inventory" job running on them (I think there's a "Nightly Network Inventory" job by default in NCM > Jobs)
You should be able to create a report on the following:
(Site_ID is one of our custom properties so we can run the report on just one site if we wanted to. Omit it for all sites)
Then make a custom table with the following database columns (or whatever you want to see):
Interfaces Last Change
When ran, or better yet, when emailed as a csv file, you get the following information for every Ethernet switchport:
The colours have been manually added using conditional formatting in Excel to show UP ports (green) and DOWN ports (red).
The "Last Change" column tells you how long ago the port went up or down, this comes directly from the switch's own stats, not from Solarwinds DB
I have this report run daily and emailed to me so if someone ever asks me for capacity in a site, I can easily see which switches are under-utilised or at max etc.
Not sure if this is the sort of thing you're looking for but its one way we do things. We don't use UDT.
You do NOT have to monitor every single port in NPM because this info is collected from the devices using the Inventory job.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.