Getting Data In

Splunk DB Connect 1: Configuring my data input using select from both an HDR and DTL table, how can I specify which rising column will be used?

premdutt
Explorer

Hi

I have same AUD_UPDT_TMSTP column in my table HDR and DTL table and I am configuring my data input using select * from both tables' queries like ( HDR.* DTL.*).

[dbmon-tail://abc/db-cgw]
index = db-cgw-restricted
output.format = kv
output.timestamp = 0
output.timestamp.column = AUD_UPDT_TMSTP
query = SELECT HDR.* ,DTLS.* FROM CGW.MPM_HDR HDR RIGHT OUTER JOIN CGW.MPM_DTLS DTLS ON HDR.HDR_SKEY = DTLS.HDR_SKEY Where {{ HDR.$rising_column$ > ?}}
sourcetype = cgw-mpm-prod
disabled = 0
tail.rising.column = AUD_UPDT_TMSTP
table = db-mpm-prod

Question 1: Column from which table (HDR or DTL) will be used in rising column?
Question 2: How can we specify that rising column of DTL should be used instead of HDR?

thank you

0 Karma

jcoates_splunk
Splunk Employee
Splunk Employee

I'm not sure this can work in DBX1 -- you're already trying the things I'd suggest. DBX2 might be more successful. If neither works, I'd suggest making a database view to combine the tables and then running DB Connect against that, or indexing both tables and combining in Splunk if that makes sense for the data in question (e..g time series events as opposed to tables full of current state).

0 Karma

premdutt
Explorer

SELECT HDR.* ,DTLS.* FROM CGW.MPM_HDR HDR RIGHT OUTER JOIN CGW.MPM_DTLS DTLS ON HDR.HDR_SKEY = DTLS.HDR_SKEY Where {{ HDR.$rising_column$ > ?}}

0 Karma

premdutt
Explorer

SELECT HDR.* ,DTLS.* FROM CGW.MPM_HDR HDR RIGHT OUTER JOIN CGW.MPM_DTLS DTLS ON HDR.HDR_SKEY = DTLS.HDR_SKEY Where {{ HDR.$rising_column$ > ?}}

0 Karma
Get Updates on the Splunk Community!

What's new in Splunk Cloud Platform 9.1.2312?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.1.2312! Analysts can ...

What’s New in Splunk Security Essentials 3.8.0?

Splunk Security Essentials (SSE) is an app that can amplify the power of your existing Splunk Cloud Platform, ...

Let’s Get You Certified – Vegas-Style at .conf24

Are you ready to level up your Splunk game? Then, let’s get you certified live at .conf24 – our annual user ...