7 Replies Latest reply on Jul 14, 2014 12:34 PM by jesspetty

    Unused Ports -> Contextual web resource

    Apocalypse21

      I can't seem to find reference to this in my searches so I apologize if it has been covered.

       

      One of the features I love about UDT is the ability to report on interfaces on a switch that are inactive and how long they have been inactive for.  We have a lot of "fully patched" edge switches in our environment so determining which ones are inactive used to be time consuming.

       

      As the number of switches we monitor is quite large (>3000) I use the "daysunused" field and then filter on a specific node ID or other to narrow the results to the number of switches that I want to report on.  Unfortunately, I can only generate the report in Win32 on our main server (not available in web reporting) and need to built custom reports any time our field techs are looking for this data.

       

      Ideally I would have a contextual resource when any technician opened a switch detail view in NPM that would show these results.  Even the ability to click on a link to generate a contextual report.  Maybe I can use my existing report with a contextual variable that is based on the node that is being viewed?  I'm not sure if that is possible.

       

      Does anybody know how to do this or is this a new feature request.

       

      Thanks for your help!

       

      Dan

        • Re: Unused Ports -> Contextual web resource
          peter.ksenzsigh

          Hi,

          currently there is no such contextual resource possibility. Could you please raise the feature request for this Idea?

          Thanks

          Peter

              • Re: Unused Ports -> Contextual web resource
                Apocalypse21

                I have had no feedback but I did create a feature request.  Please upvote!

                 

                http://thwack.solarwinds.com/ideas/3787

                  • Re: Unused Ports -> Contextual web resource
                    mezdem

                    bump

                     

                    this is exatley want we require also.

                     

                    The first comments back from engineers re UDT - was a question as to whether there was a resource that will show them quickly per switch which ports can be re-patched i.e. not been used in xx days (bepoke threshold dependant) so that we dont have to reset counters and check back in 10, 20, 30 days (especially over summer holidays)

                     

                    This would be an essential resouce, any news on whether i can be done soon?

                      • Re: Re: Unused Ports -> Contextual web resource
                        mezdem

                        I have got this web resource working a treat now.

                         

                        Create a new report (old/new way) - mine is still via report writer - old habbits and all that.

                         

                        SQL for the query is:

                         

                        SELECT

                        Nodes.Caption AS Caption, UDT_UnUsedPorts.PortID AS PortID, UDT_UnUsedPorts.Name AS Name, UDT_UnUsedPorts.PortDescription AS PortDescription, UDT_UnUsedPorts.DaysUnused AS DaysUnused,UDT_UnUsedPorts.NodeID AS NodeID

                        FROM

                        Nodes INNER JOIN UDT_UnUsedPorts ON (Nodes.NodeID = UDT_UnUsedPorts.NodeID)

                        where UDT_UnUsedPorts.Name not like 'Port-channel%' and

                        UDT_UnUsedPorts.NodeID ='${NodeID}'

                        ORDER BY 2 ASC

                         

                        add the reource as a custom report to the appropriate node page in NPM. I have a Device Tracker sub-tab then a Capacity Mgmt tab.

                         

                        this page exports well and prints ok. I have actually amended the wording on the SW view to state 'Never Used' as the word 'never' under the heading days unused raised some questions internally. Works a charm

                         

                        1 of 1 people found this helpful
                          • Re: Unused Ports -> Contextual web resource
                            orionfan

                            This is something I have been looking for.  Thanks for posting this.

                             

                            I tried to create the report with Reportwriter, and when I execute the query, I get the message:

                             

                            SQL Error:

                             

                            Conversion failed when converting the varchar value '$-{NodeID}' to data type int.

                              • Re: Unused Ports -> Contextual web resource
                                jesspetty

                                Short answer: It still works despite this error.

                                 

                                Longer answer: Yes you get that when executing in Report Writer, or if you were to navigate to the list of Reports and run the report on its own (which seems understandable, since it has no 'context' within which to determine ${NodeID} in these scenarios).  However, if you save the report and add it as a resouce on something like a Node Details view, the report will actually run and show data properly. Note I assume it was just a typo above where it says '$-{NodeID}'; if not you should correct this to '${NodeID}'.