My client owns a company which has about 3000 employees. All employees work off satellite offices. Every satellite office has one employee. My client needs to keep tab of when every employee comes in to office and leaves. The connectivity from satellite office varies from 128 kbps to higher.
My Solution: I am thinking of creating a Active Directory domain (windows server 2003), create IDs for every employee, host a website with IIS, and extract login and logout details per user. The server would be a Intel dual-core with 6 GB RAM and about 500 GB to start with.
Is it even possible to extract first login and last logout details this way? What happens when a employees logs out during lunch or gets disconnected from the site? Will IIS rewrite the log a relogin as first login? how do we tackle this? Client would like to be able to extract a report of first login and last logout by himself... do we have an script or a third-party app which could do this? Also, I would appreciate if you could tell me what should be the websites internet pipe? For 3000 users logging in, would a 2 MBPS link suffice? The website is only used for logins and serves no other purpose.
Do we have any other alternate solution? I also thought about RADIUS but it does not fit into this requirement. Or could a ISP provide us logins, host a website and provide login/logout details? Any other viable solution?