Hey All!
I had a request to create a widget on port description, and I whipped this up real quick. Enjoy!
- On the dashboard, customize the page and add a “Custom Query” widget
- Edit the widget, title this “Search Port Description”, and check the box for “Enable Search”
- 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!