hi folks, we got a requirement to create xx number of reports based on a filter.
For example the lookup file has filter of team
TeamName,sourcetype Windows,windows:* Unix,syslog Oracle,oracle*
We have a single search to grab the data , but based on the lookup, I need to xx reports based on TeamName Split the PDF/report within the result. So while sending, it needs to be in xx reports (3 in above case).
Windows.pdf, unix.pdf, Oracle.pdf and so on
Is it possible to do? Or do we need xx number of searches to do this? (please note, our requirement is about 70 such groups which makes it 70 individual searches otherwise)
@koshyk can you try the following
| inputlookup team_data.csv | map maxsearches=100 search="| tstats count where index=_internal AND sourcetype IN ("$sourcetype$") by sourcetype | eval emailFieldForTest=\"$email$\" | sendemail to=\"$email$\" format=\"html\" server=smtp.abc.com:123 use_tls=1 subject=\"Alert for $TeamName$\" message=\"This is an alert for $TeamName$\" sendpdf=true"
PS: You can remove sendemail command to test whether
emailFieldForTest is being populated with correct email or not. When you get this to working you can get rid of
Team data for above example is based on Splunk's internal index which prepares the lookup similar to yours for
splunkd, access and mongodb sourcetypes in Splunk's `internal` index.
| makeresults | fields - _time | eval data="splunkd,splunkd,firstname.lastname@example.org;access,*access*,email@example.com;mongodb,mongodb,firstname.lastname@example.org" | makemv data delim=";" | mvexpand data | makemv data delim="," | eval TeamName=mvindex(data,0),sourcetype=mvindex(data,1),email=mvindex(data,2) | table TeamName sourcetype email | outputlookup team_data.csv