I made a query recently and also a search query .
Create a new widget with this custom query:
SELECT OAS.Node.Caption as [Node] -- node name
, OAS.Node.DetailsUrl as [_LinkFor_Node] -- mouse hover for node
, OAS.Databases.DisplayName as [DB] -- DB name
,OAS.Databases.DetailsUrl as [_LinkFor_DB] -- mouse hover for DB info
, DisplayName as [Application] --application name
, DetailsURL as [_LinkFor_Application] --mouse hover for application name
FROM Orion.APM.SqlServerApplication OAS
-- OAS (Orion.APM.SqlServerApplication) created to link
Order By Node Asc
And this for the search:
SELECT OAS.Node.Caption as [Node]
, OAS.Node.DetailsUrl as [_LinkFor_Node]
, OAS.Databases.DisplayName as [DB]
,OAS.Databases.DetailsUrl as [_LinkFor_DB]
, DisplayName as [Application]
, DetailsURL as [_LinkFor_Application]
-- anything that matches a WHERE as '${SEARCH_STRING}' will filter
FROM Orion.APM.SqlServerApplication OAS
WHERE (DisplayName Like '${SEARCH_STRING}'
OR OAS.Node.Caption Like '${SEARCH_STRING}'
OR OAS.Databases.DisplayName Like '${SEARCH_STRING}')
Order By Displayname Asc
Result;