Below is the log format 😞 log sample)
ID swipe_status date time location
362558 SwipeIn 2017-01-01 05:00:00.466 USA
Index = Swipe_index
Total time between the swipe in & the swipe out for a user
1.1. List of users who were present in the organization for '9' or more than '9' hrs. (i.e. Time between swipe in and swipe out >= 9 hrs)
List of users who have multiple instances of swipein & swipeout
2.1. Total time between first swipe in and last swipe out for all users who have multiple instances of swipe-in & swipe- out
2.2. List of users whose total time between first swipe in and last swipe out is '9' or more than '9' hrs
2.3. List of users whose total time between first swipe in and last swipe out is less than '9' hrs
List of users who have requested an access on weekends
... View more