Table view for non administrators

ronaldjansen

I'm looking for a simple solution to provide a table view for non administrators so they can quickly find an browse all the nodes.

Next step is to change the view and save them as a profile linked to the user.

The next step (for operators, Table View for operators):

dgsmith80

I would suggest a nice workaround might be a Custom Query with a Search Filter. The Query will respect Account and View limitations.

Pretty Basic, but should get you started, then you can define what you want to see using WHERE Statements. With the new mouseover popup you can go directly into the Node Details, Edit Node, Mute or UnManage.

SELECTn.Caption AS [Node Name],n.DetailsUrl AS [_LinkFor_Node Name],'/Orion/images/StatusIcons/small-' + n.StatusIcon AS [_IconFor_Node Name],n.IP_Address AS [Polling IP Address],n.ObjectSubType AS [Polling Method]FROM Orion.Nodes n

SEARCH:

SELECTn.Caption AS [Node Name],n.DetailsUrl AS [_LinkFor_Node Name],'/Orion/images/StatusIcons/small-' + n.StatusIcon AS [_IconFor_Node Name],n.IP_Address AS [Polling IP Address],n.ObjectSubType AS [Polling Method]FROM Orion.Nodes nWHERE n.Caption LIKE '%${SEARCH_STRING}%' OR n.IP_Address LIKE '%${SEARCH_STRING}%'

- David Smith (dgsmith80 )

Kenson - SolarWinds Authorized Partner

Training, Licenses & Professional Services