Site Login Statistics

It would be great to be able to track and view some site login statistics.

1)who is currently logged in

2)daily list of who logged in, how many times, how long they were logged in for, there IP address

Anyone doing this or need this too?

I don't know if any other developers have implemented this but we have had requests for something similar from our clients but have not built it yet. Are you interested in having someone develop this functionality for you?

Here is a basic overview of what would need to be done. You would need to know ASP and SQL to accomplish this.

1. Setup a new table in SQL to store the user login information you want to collect: SessionID, CustomerID, StartDate/Time, EndDate/Time, IP Address.

2. In the global.asa Session_OnStart you would add code to create a new entry in the new SQL table with the initial information. You wouldn't have a customer ID until they login or create an account.

3. If/when a customer logs in or creates an account, add their customer ID to the SQL user record for the active session.

4. In the global.asa Session_OnEnd, write out the End Date/Time to the active SQL user record.

5. Create a report in the Control Panel that would summarize the data collected in the new SQL user table to show the details you want. Sum on CustomerID to see how many times a specific customer logged in. Perform cals on the Start/End times to see how long users stayed on the site, etc.

6. Create a report in the Control Panel that shows currently active users (where the EndTime is not filled in for the user table). If there is a customerID entered in the user record, you could pull the customer name from the customer table.

Hope that points you in the right direction.

Here is a helpful article on the global.asa events and where you would add your code: http://www.w3schools.com/asp/asp_globalasa.asp. Is that what you need?