Splunk Search

How to DBX3 dbxoutput command

khyoung7410
Communicator

Hi
In dbx1, the dboutput command was used as follows :
index=_internal source=*metrics.log group=per_source_thruput
| eval opt_dt=strftime(_time,"%F")
| eval series_nm=series
| eval mb=kb/1024
| table series_nm, series, mb, opt_dt
| dboutput database=MS type=sql "insert into bigdata_splunk_daily (series_nm, series, mb, opt_dt)
values ($series_nm$, $series$, $mb$, $opt_dt$)"

How should I used it in dbx3?

Tags (1)
0 Karma

p_gurav
Champion

You can use dbxoutput only. Refer below doc:
http://docs.splunk.com/Documentation/DBX/3.1.3/DeployDBX/Createandmanagedatabaseoutputs#Use_dbxoutpu...

Also you can create output using UI.

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

[Puzzles] Solve, Learn, Reuse: Word-play

This puzzle series (first published here) is based on analysing words.Some of the statements in your puzzle ...

Tuning Edge Processor in Hybrid Mode: What Limits Each Data Path

When you run Edge Processor in hybrid mode, alongside a Splunk heavy forwarder on the same host, two questions ...

Best Practices: Splunk auto adjust pipeline queue

When you enable autoAdjustQueue in Splunk, maxSize should be understood as the queue size Splunk starts with ...