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