09-18-2013 05:34 AM
I have login data obtained from an application's log that gives me the following details.
user_name, process_id, login_time & logout_time and both login and logout time are in date time formats.
I want to count number of processes running per hour -
Range Users Processes
01SEP2013 12:00:00 - 01SEP2013 01:00:00 5 35
There may be cases of overlap here because one process can run upto several hours likewise one user can be working on a process for several hours. I want to find out how many users together run how many processes. Any ideas ? Please help.