Hi All,
I want to calculate the total timing used by total users. Here "OUT" is showing that when an user logged in and "IN" timing is showing at what time user is logged out. If the corresponding IN-OUT is not matching then it consider the time from the mid-night of last day. Then Total timing of the Individual users I have to calculate. In the following data.
17:07:00 IN MAESTRO_MAIN dinda@abc
17:09:22 IN MAESTRO_MAIN dinda@abc
17:19:06 OUT MAESTRO_MAIN dinda@abc
17:21:07 IN JAGUAR_MAIN dinda@abc
17:25:44 IN MAESTRO_MAIN dinda@abc
11:39:01 OUT MAESTRO_MAIN secshard@ganga
11:40:11 IN MAESTRO_MAIN secshard@ganga
11:40:22 OUT MAESTRO_MAIN secshard@ganga
11:54:48 IN MAESTRO_MAIN secshard@ganga
11:57:27 OUT MMOD_XCLUSTER secshard@ganga
11:58:04 IN MMOD_XCLUSTER secshard@ganga
14:43:54 IN MAESTRO_MAIN rakesh@abc
14:55:32 IN JAGUAR_MAIN rakesh@abc
14:58:56 IN MAESTRO_MAIN rakesh@abc
15:06:58 IN JAGUAR_MAIN rakesh@abc
19:01:21 OUT MAESTRO_MAIN rakesh@abc
19:24:07 IN MAESTRO_MAIN rakesh@abc
19:24:20 OUT MAESTRO_MAIN rakesh@abc