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:
SELECT * from `radius`.`radiusacct`
WHERE acctstarttime < @eventTime
AND (@eventTime > acctstoptime OR acctstoptime IS NULL)
Event IP --> Radius IP
But I don't think I am able to call out things like @eventTime in the SQL Query, am I?