Hello, i am trying to create a dependency map without the external creation of tokens that are being fed to the append searches. Here is the motive: I have a list of Sources and Targets, where as ...
See more...
Hello, i am trying to create a dependency map without the external creation of tokens that are being fed to the append searches. Here is the motive: I have a list of Sources and Targets, where as the Source of one Relation is the Target of many others and so on. This is recursive, but i would stop at 4 iterations for now ) The resulting table must only have the pairs of Source and Target Services as basis for the visualization. The first search looks something like this: index=poc_analyze_something_rather Target_Service=$my_initial_token_from dashboard$ | table Source_Service Target_Service The initial token is being fed via drilldown from the dashboard. So far no issue at all. So the first search creates the list of Source_Services connected to the Target_Service (token). Now i have actually two issues...sorry... First is that i cannot create the table of the pairs and create a token at the same time. The creation of the token would look something like this: index=poc_analyze_something_rather Target_Service=$my_initial_token_from dashboard$ | stats values(Source_Service) as results | eval list_of_Source_Services_search_one = mvjoin(results, ",") So the first issue is how to team them up in one search if possible The second issue starts once i have the token. The second search would look something like that: | append [ | search index=poc_analyze_something_rather Target_Service IN($list_of_Source_Services_Search_one$) | table Source_Service Target_Service ] However the first search does not seem to pass the token along into the append search. It is no issue at all if i make a search in the dashboard (no visualization) like this to create the token: <search> <query> index=poc_analyze_something_rather Target_Service=$my_initial_token_from dashboard$ | stats values(Source_Service) as results | eval source_list= mvjoin(results, ",") </query> <earliest>-15m</earliest> <latest>now</latest> <done> <set token="list_of_Source_Services_Search_one">$result.source_list$</set> </done> </search> The append search has no issues at all with this token. However there must be a way to create the list the Source and Targets without resulting to a dashboard with xml coded searches. Any idea? Thanks Mike