Custom Search View - Limitation to a specific group

Question

Good afternoon.

I'm having a trouble with the limitations and the search feature in solarwinds, it's displaying all the element with the same "name", for example if I search and ID 2525 it shows all the data that contains this number.

Now, checking the THWACK, i found a post about a custom search view with a Custom Query Resource.

I've already add this, but I'm trying to limit this search to an specific group and nodes contained in it.

SELECT

n.Caption AS NODE,

'/Orion/images/StatusIcons/small-' + ToString(n.StatusIcon) AS [_IconFor_NODE],

'/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N%3a' + ToString(n.NodeID) AS [_LinkFor_NODE],

n.ObjectSubType,

n.StatusDescription,

n.IPAddress

FROM Orion.Nodes n

where

n.Caption LIKE '%${SEARCH_STRING}%'

This query shows me this:

¿Is there a way to search only the nodes related to a group? or the other option, ¿show in the custom search only the nodes asociated to a group?

I'll appreciate your comments.

Regards.

javip2086 · Answer

Terry, thanks for your comments.

Actually this query works fine, when I search an ID that don`t belong to the client, it show nothing.

The original search, when I enter an ID 123, shows all the results with 123 (X123, x123y, 123y, 123XY, etc.), but whit this query,  doesn’t show nothing outside the client group.

Thank you very much for your comments and support.

Regards.

TerryHarding · Answer

The Custom Query only allows one search box so filtering also on group is only attainable by entering the extra ' AND GroupName LIKE '%eMAIL% in the search box.

javip2086 · Answer

Thanks Terry.

It works great for the search but what I’m looking for is to restrict the search to an specific group.

Let’s say that I want that the search only show results of the Group Name “Email” if I enter an ID/Node Name.

¿Is this possible?