Hello again, my apologies for all of these questions.
I have a lookup table called login_sessions.csv which will keep track of allowed login sessions. It has the following columns UID, sessionstart, and sessionend.
I would like to add and remove entries to the lookup table depending on the value of a field called "action" in the events.
If the value of action is "login" then I would like to add the userID, session_start, session_end fields from the event into the login_sessions.csv lookup, and if the value is "logoff" then I would like to remove the existing entry from the lookup.
I was hoping I could use something like an if or case statement to do this, but I have only seen them used with eval and I haven't had much luck so far.
E.G.
if(action=="login", (inputlookup append=true login_sessions.csv | eval UID=userID, sessionstart=session_start, sessionend=session_end | outputlookup login_sessions.csv))
Is there a way to do this in a search?
Thank you for any assistance.
... View more