This may SEEM like a simple request, but it is WAY too involved to complete simply. There a MANY, MANY questions that need to be answered in order to BEGIN.
First of all, Network Administrators can easily create reports of this type of activity. The Windows Authentication process logs each network connection request and termination. (they may not be KEEPING these logs, which could be requested) If (as in my company) the Network Admin people do not wish to SHARE this information, it IS possible to interrogate the PC's Event logs and attempt to locate the necessary events. But this is done on each workstation. If the users log into different workstations, and you wish to pull the information from these machines, you will have to have Admin privileges on each machine. There are software packages, both Free and can be purchased, that can do this nicely. However, the software must be run by someone with Admin privileges. A somewhat simpler approach to collect the data beginning NOW is to create login/logout procedures/scripts for the environment. These are standard scripts that are created by Network Admins and execute whenever a user logs in or out. It's possible that your company already has these, and it would be a matter of adding a few lines of code that would append the necessary info to a text file that you could interrogate. Again, it requires the cooperation of the Network Administrator(s). Paul ----------------------------------------- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley ----------------------------------------- ________________________________ From: lokesh <lokeshsmg2...@gmail.com> To: excel-macros@googlegroups.com Sent: Tue, January 3, 2012 5:01:13 AM Subject: $$Excel-Macros$$ User login and logout time Hi Rajan, Please see the attached excel mail and i want the mentioned user names login time and logout time based on their employee ID’s. Please do the needful, if you have any concern please leave me a msg. Regards Lokesh.M-- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
