Resource to Search by Port Description

Version 2
    Click to view larger image

    Hey All!

     

    I had a request to create a widget on port description, and I whipped this up real quick.  Enjoy!

     

    1. On the dashboard, customize  the page and add a “Custom Query” widget
    2. Edit the widget, title this “Search Port Description”, and check the box for “Enable Search”
    3. Use the following queries:
      For the top box:

    select UP.Node.Caption as [Node Name],

    UP.Node.DetailsUrl as [_LinkFor_Node Name],

    UP.name as [Interface Name],

    UP.DetailsUrl as [_LinkFor_Interface Name],

    UP.PortDescription as [Port Description],

    UP.PortVLANs.DisplayName as [VLan]

    from Orion.UDT.Port as UP
    For the bottom Box:
    select UP.Node.Caption as [Node Name],

    UP.Node.DetailsUrl as [_LinkFor_Node Name],

    UP.name as [Interface Name],

    UP.DetailsUrl as [_LinkFor_Interface Name],

    UP.PortDescription as [Port Description],

    UP.PortVLANs.DisplayName as [VLan]

    from Orion.UDT.Port as UP
      WHERE UP.PortDescription like '%${SEARCH_STRING}%'

    4. Change the number of rows per page to a larger number, up to 100 (I used 10)

      5. Submit, and you now have a resource for searching!


    Let me know if you have any questions!