topic Re: How to pass multiple values from a search as parameters to a macro so the macro will be run for each value? in Knowledge Management

How to pass multiple values from a search as parameters to a macro so the macro will be run for each value?

akawacz — Wed, 21 Oct 2015 14:23:12 GMT

I have created a macro with a parameter. Then I have a list/search with 8 values.

How is it possible to pass those values into macro as parameters so that macro will be run 8 times and give appended results?

Thank you

Re: How to pass multiple values from a search as parameters to a macro so the macro will be run for each value?

woodcock — Wed, 21 Oct 2015 16:09:11 GMT

First of all, you can call another macro from within a macro. I assume you are asking how to make a macro that can take a variable number of parameters. Directly, you cannot, but you can pass in the value for a field which has encoded inside like this:

... | `mymacro("value1;value2;value3;value4;value5;value6;value7;value8")`

Then inside the macro, use makemv delim=";" to break apart the field into a multi-valued field and then use mvexpand to create separate events on which to operate, perhaps calling another macro.

Re: How to pass multiple values from a search as parameters to a macro so the macro will be run for each value?

akawacz — Thu, 22 Oct 2015 08:15:07 GMT

This was helpfull however my situation is a bit different

my marcro:
eval FLAG=if(isnull($Parameter$),0,1) | eval TYPE="$Parameter$" | stats sum(FLAG) as COUNT by TYPE, sourcetype, REPORT_TIME

so on my list there are 8 different values. Every value go to the macro into 2 places ($parameter$) and give the result then another value go into 2 places and result and so on.

| mymacro(parameter) |

Is it posible to do that ?

Re: How to pass multiple values from a search as parameters to a macro so the macro will be run for each value?

woodcock — Thu, 22 Oct 2015 13:05:29 GMT

I do not understand your term list. Are you saying that parameter is a multi-valued field with 8 values? Maybe you should give example data (with fields).

Re: How to pass multiple values from a search as parameters to a macro so the macro will be run for each value?

akawacz — Thu, 22 Oct 2015 15:28:17 GMT

I want to get my list from search if possible. It will be 8 column names. If not I can maybe use CSV file and use inputlookup command

Then I want to add one column name at the time run a macro then add another and run a macro. At the end result will be comined.

example data:
Name
ID
ect

hope this help

Re: How to pass multiple values from a search as parameters to a macro so the macro will be run for each value?

woodcock — Thu, 22 Oct 2015 17:11:13 GMT

OK, then! That is different. Try this:

... | foreach * [`mymacro(<<FIELD>>)`]

Re: How to pass multiple values from a search as parameters to a macro so the macro will be run for each value?

akawacz — Tue, 29 Sep 2020 07:43:01 GMT

I think with your hint I am closer to solution however I have encounter further issues.Results are not combined into one. It is showing last result

It looks that my macro does not work properly.
eval FLAG=if(isnull($Parameter$),0,1) | eval TYPE="$Parameter$" | stats sum(FLAG) as COUNT by TYPE, sourcetype, REPORT_TIME

Once I am testing without macro and put brackets ] after second
eval expression - i have got result for one filed. Once I put them at the end I got error message.
...... | foreach IM_* [eval FLAG=if(isnull(<>),0,1)]|stats sum(ERR_FLAG) as ERR_COUNT by sourcetype, REPORT_PERIOD

Foreach can not deal with Text.

Re: How to pass multiple values from a search as parameters to a macro so the macro will be run for each value?

woodcock — Mon, 26 Oct 2015 15:03:42 GMT

I see that you asked another question related to this and I am as confused on that one as I am on this one. We are working too much on a particular solution path without understanding the entire problem. Let's back ALL THE WAY UP and get a firm foundation. Show a minimal sample data set and then show a mock-up of the desired output. I am sure we will be able to help you.

Re: How to pass multiple values from a search as parameters to a macro so the macro will be run for each value?

akawacz — Tue, 29 Sep 2020 07:43:03 GMT

Hello,
Thank you for helping me here
As you probably see I have managed to solve my issue in a bit different way (second my question ) but here I wanted use a macro for that.

So basically I wanted check how many values are populated in the filed for couple of different columns.

E.g. Column ASSIGNEE for some different months have different counts for populated filed
Sep- 100 Nov -200 vs all events is 1000. So Sep- is 10% and Nov 20% of populated values in the filed ASSIGNE

I was going to do a macro which will be populated one column at a time.
E.g. first time ASSIGNE later another column name and so on.
For this reason I have transformed column headers into value
index=test_im | stats dc(IM*) as IM* | transpose| fields column |

Then I was planing use one column put to the macro using FOREACH command

My idea was:

index=test_im | stats dc(IM*) as IM* | transpose| fields column
| foreach * [mymacro(<>)]

Macro: will populate <> with columns (like ASSIGNEE later another coulmn and so on. )At the end result will be combined
my macro:
eval FLAG=if(isnull($Parameter$),0,1) | eval TYPE="$Parameter$" | stats sum(FLAG) as COUNT by TYPE, sourcetype, REPORT_TIME

Sorry for not good expalanation. Just starting with Splunk and want to explore a lot of new commands.

Re: How to pass multiple values from a search as parameters to a macro so the macro will be run for each value?

woodcock — Mon, 26 Oct 2015 17:31:14 GMT

Just post your final answer to both questions and then click "Accept" to close them both.

Re: How to pass multiple values from a search as parameters to a macro so the macro will be run for each value?

akawacz — Tue, 27 Oct 2015 10:44:28 GMT

I have Accepted second question. Here Macro is still not working for me.

Re: How to pass multiple values from a search as parameters to a macro so the macro will be run for each value?

yvassilyeva — Fri, 11 Aug 2023 17:57:11 GMT

@woodcock

when you are saying

| foreach * [`mymacro(<<FIELD>>)`]

what is the value of a * ? I am tryin gto use macro twice in my search, but not working