Splunk Search
Highlighted

DB Connect Temporal Lookup - does it exist?

New Member

Hi.

I am trying to figure out how to put together a time based lookup using the DBX conduit, connected to a radius session table. Radius table has start/stop times and IP. Original event table has IP and event time. It feels like I need to do something like this:

Lookup SQL:

SELECT * from `radius`.`radiusacct`
WHERE acctstarttime < @eventTime 
AND (@eventTime > acctstoptime OR acctstoptime IS NULL)

Field Mapping:

Event IP --> Radius IP

But I don't think I am able to call out things like @eventTime in the SQL Query, am I?

Any ideas on how to accomplish?

Thanks

Dave

0 Karma