Raw format : DateTime Description Event Type Source Count
Desired format : DateTime Source Type Event Description Count
| table DateTime Source Type Event Description Count
Replace the default value if any value is missing.
|fillnull value=your_value field=your_field
Also is there any way to store the received data into exernal storage system (db or hadoop).Instead store into Splunk database.
Yes, you can install the DBX app and do SQL inserts. The method for doing this, without indexing, is tricky. You essentially use Splunk as an ETL tool.
Also is there any way to avoid the indexing on received data?
Yes, if you just want to "not index" certain data, and don't need to move it somewhere... you can send it to the nullqueue via the props.conf file.
... View more