I know there is a very similar thread to the this one already – Excel to count number of concurrent sessions based on start/end times – however, as much as I try, I am unable to replicate and manipulate the suggested answer to meet my needs.
I am also looking to detect when a user ID is logged onto a legacy unix ERP system from multiple PCs simultaneously – potentially they’re sharing their credentials with a colleague.
An example of the data is:
Record # Time In Time Out User PC Name 1 10:54 10:55 Al PC1 2 10:55 16:55 Dave PC42 3 09:11 09:29 Al PC1 4 11:02 18:03 Al PC1 5 16:19 17:38 George PC678 6 16:43 17:41 Al PC678 7 16:46 17:39 Dave PC42 8 17:25 17:49 Al PC42
The “Time In” and “Time Out” values are actually full date/times, so you don’t need to worry about comparing events that happened on different days. I am displaying only the times here so as to avoid providing Too Much Information. The above data can be shown graphically as:
Towards the end of the list (and the bottom of the chart) you can see that user Al is accessing the system from multiple PCs at the same time, as well as the other users also accessing the system from the same PCs. User Al is either walking round and logging in (unlikely) or the other users are able to log in as Al in order to perform tasks their permissions do not allow them to do. Ideally I'd like to have a new column to highlight that at that time there were concurrent sessions from User ID Al on different PCs. Record # 4, 6 and 8 would alert – Record # 2 and 7 are OK as the same user logged in on the same PC.