I want to create a report listing all the interfaces of a switch with the duplex settings. How would I get this info?
Thanks
If the custom poller option doesn't appear in the drop downs you may need to experiment with other report types or it might be simpler to start a new report and select the sql option then paste something like
SELECT CustomPollers.UniqueName, Interfaces.InterfaceName, CustomPollerStatus.Status
FROM CustomPollerStatus INNER JOIN
CustomPollerAssignment ON CustomPollerStatus.CustomPollerAssignmentID = CustomPollerAssignment.CustomPollerAssignmentID INNER JOIN
CustomPollers ON CustomPollerAssignment.CustomPollerID = CustomPollers.CustomPollerID INNER JOIN
Interfaces ON CustomPollerAssignment.InterfaceID = Interfaces.InterfaceID
WHERE (CustomPollers.UniqueName = N'dot3StatsDuplexStatus')
into it
Add as many fields from the interfaces table as you need
dot3StatsDuplexStatus should be replaced by the name you gave your UnDP
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.