topic How to create multiple reports/pdf output from a single search? in Splunk Search

How to create multiple reports/pdf output from a single search?

koshyk — Sat, 06 Apr 2019 20:39:31 GMT

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)

Re: How to create multiple reports/pdf output from a single search?

niketn — Tue, 29 Sep 2020 23:58:32 GMT

@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"

The search query returns result only sourcetype for specific team at a time. The sendemail command uses $email$ passed through map command.

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 emailFieldForTest field.

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,splunkd_support@somewhere.com;access,*access*,access_support@somewhere.com;mongodb,mongodb,mongodb_support@somewhere.com"
| 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

Re: How to create multiple reports/pdf output from a single search?

koshyk — Sun, 07 Apr 2019 16:24:43 GMT

thank you mate. I've got the idea. will accept it.