Solved

Logging employee entry and exit details via a website?

Posted on 2008-10-30
17
289 Views
Last Modified: 2013-12-07
Dear Gurus,
 
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?

Please advice.
0
Comment
Question by:Mir Ali
  • 9
  • 8
17 Comments
 
LVL 51

Accepted Solution

by:
tedbilly earned 250 total points
Comment Utility
Websites can't be used to track activity because it's actually not a true client/server application.  A browser requests a page, the page is sent, then the browser disconnects from the website.  There is NO way to know when the user closes the browser.  A number of times on this website I've answered questions about tracking activity on websites and after a long discussion they eventually realize I'm correct.

Simply tracking login/logout isn't really valuable because I can think of many ways to setup a service to log me in and out without being in front of my computer.

The only low-cost way I can think of doing this is setting up messenger accounts for all the staff then writing an application that uses the messenger API to track the time they are logged into their computer.  Even then they could fool the system but it would keep your client happy.

I've worked in many service businesses that bill hours to clients and seen many sophisticated client server applications to track time.  None are able to prevent fraud.  Ultimately anybody who is lazy can find a way to beat any system.  Unless you capture every keystroke and grab regular screenshots how do you know someone isn't just sitting at their desk randomly pressing keys?

Ultimately unless you sit and watch staff all day every day how do you know they are working?

Thank goodness I don't work for that company.  It makes me sad to think there are companies out there like it.
0
 

Author Comment

by:Mir Ali
Comment Utility
Thank you for your view, Ted. Do you think having a RADIUS server is an option? Or do we have any third-party applications which could help me out?
0
 

Author Comment

by:Mir Ali
Comment Utility
Ted, I should tell you that I'm shocked to hear my "bright idea" will not work. Relived that I did not implement the solution.... glad I approached to you guys.
0
 
LVL 51

Expert Comment

by:tedbilly
Comment Utility
RADIUS might work if it collects audit logs for login/logout activity.  I'm don't know if you can get to the data for it.

Otherwise, a simple timesheet billing application might work.  Some can be installed at the Administrator level so that the regular users (who aren't Administrators) can't uninstall it but it will log their hours regularly as soon as they sign in.  Lawyers and Engineers use software like that to track their hours.  Any hours not billable to a client is overhead, but it does track their time.  It's been 16 years since I worked in Engineering so any software I could recommend for that purpose would have changed by now.
0
 

Author Comment

by:Mir Ali
Comment Utility
Ted, my initial plan was to create a Active Directory domain and use IIS to log first log in and last log out. I'm looking at all kinds of third-party solutions and none seems to be 'fitting the bill'
0
 
LVL 51

Expert Comment

by:tedbilly
Comment Utility
Is each client computer Windows?
0
 

Author Comment

by:Mir Ali
Comment Utility
Yes. All client computers are on Windows 2000/XP.
0
 
LVL 51

Expert Comment

by:tedbilly
Comment Utility
All logon/logoff activity can be configured to appear in the 'Security' section of the 'Event Viewer' in Windows.  I've seen articles online for converting those events into entries in SQL databases.
0
Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

 

Author Comment

by:Mir Ali
Comment Utility
Do we have any alternate third-party solution?
0
 
LVL 51

Expert Comment

by:tedbilly
Comment Utility
No recent ones.  It's been 16 years since I worked in Engineering when I used any automated billing applications.
0
 

Author Comment

by:Mir Ali
Comment Utility
Since we have not reached any solution, I'm going to pull my question off this if I do not hear from anybody in the next 24 hours.
0
 
LVL 51

Expert Comment

by:tedbilly
Comment Utility
If you read the support and FAQ's for EE awarding points isn't always about receiving a solution.  Sometimes the answer is 'No' or you have to do follow up yourself.

I answered your original question which was 'No' a website cannot be used to achieve your goals.
0
 

Author Comment

by:Mir Ali
Comment Utility
I agree. I'm in touch with Quest and they're providing me a web-based solution... i managed to get hold of 3-4 thirdparty vendors who do these services. Quest charges $15 a month for this service and are working up the pricing for a 3000 user environment. I'll post more details when I get more details.
0
 

Author Comment

by:Mir Ali
Comment Utility
Quest has agreed to provide me their software TimeForce. The software lease would be for one year and they would also host the website and do system maintanence (server and report backups). We are still finilizing the pricing but they vary as they charge depending on number of licenses.
0
 
LVL 51

Expert Comment

by:tedbilly
Comment Utility
Once again.  I answered your original question correctly and recommended you find a 3rd party solution which you did.  I deserve the points.
0
 

Author Comment

by:Mir Ali
Comment Utility
I agree and I truly appreciate you being on this question all along. But in my question, I did ask for a third-party solution and at the end, I got one myself. Since we both did our work, would you mind if I split the points between us?
0
 
LVL 51

Expert Comment

by:tedbilly
Comment Utility
Well technically you asked two questions in one.  The second part should have been in another question.  I feel I deserve the points.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Join & Write a Comment

Suggested Solutions

Lync server 2013 Backup Service Error ID 4049 – After File Share Migration
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
This video teaches viewers how to create their own website using cPanel and Wordpress. Tutorial walks users through how to set up their own domain name from tools like Domain Registrar, Hosting Account, and Wordpress. More specifically, the order in…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now