Custom command to generate table from multivalue events
example for wsus data:
| mvtable mvfields="kbnumber,arrival_date" keepfields="host,OS,_time" | table *
mvfields: fields containing several values, cardinality of the first field in the list is assumed to be the desired number of output rows. keepfields: specify the single value fields to be retained on each resulting row.
Example from the screenshot:
| makeresults | eval kbnumber="1234 5678 9012" | eval arrival_date="2019.05.17 2019.05.17 2019.05.17 2019.05.17" | eval host="test" | eval OS="Windows 10"
| eval kbnumber=split(kbnumber," ") | eval arrival_date=split(arrival_date," ")
| mvtable mvfields="kbnumber,arrival_date" keepfields="host,OS,_time" | table *
Created By
Dominique Vocat
Resources
Log in to report this app listing