AnsweredAssumed Answered

Calculate time difference between 2 events.

Question asked by Terpstrj on Jun 4, 2018
Latest reply on Jun 5, 2018 by Terpstrj

Hi all,

 

I hope someone could help me.

I have an event tag that stores who is logged in/out in a system and I want to show all results of people who are logged in for more than 8 hours on the same node.

Can this be retrieved from this tag??

 

Example: entries in the tag

28-mei-18 08:54:43  ||USER1  logged in |NODE_A|

28-mei-18 09:54:43  ||USER1  logged in |NODE_B|

28-mei-18 10:54:43  ||USER1  logged out |NODE_B|

28-mei-18 09:54:43  ||USER2  logged in |NODE_B|

28-mei-18 17:54:43  ||USER1  logged out |NODE_A|

28-mei-18 21:54:43  ||USER2  logged out |NODE_B|

 

Desired Result:

28-mei-18 08:54:43  ||USER1  logged in |NODE_A|

28-mei-18 09:54:43  ||USER2  logged in |NODE_B|

28-mei-18 17:54:43  ||USER1  logged out |NODE_A|

28-mei-18 21:54:43  ||USER2  logged out |NODE_B|

 

I'm really struggeling to create an filter expression  for this.

I hope that people can point me in the right direction or else tell me that this isn't possible, because that is also an anwer of course

 

Thanks in advance.

 

Jorgen

Outcomes