I am looking to build a dashboard where a user can submit a session number & retrieve the entire history of a session with one catch: the session id isn’t on the last event but there is a UID that links one of the events to the last event. This pertains to Check Point SmartWorkflow if that helps anyone.
The relevant events would look something like this:
SessionID1 user1 changeType1 UID1 SessionID1 user1 changeType2 UID2 SessionID1 user1 changeType3 UID3 SessionID1 user1 changeType4 UID4 NoSessionID user2 changeType5 UID2
It would be nice to just use the session id but I also need the extra event that includes UID2 with no session id. This is probably a simple query but I haven’t quite figured it out.