Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

How to track end user network log on from a web app.

Posted on 2015-02-04
17
Medium Priority
?
118 Views
Last Modified: 2015-02-18
Good Afternoon Pro's,

I have been asked to find a solution for the following problem.

We have a network of about 100'000 users.
Of these users, we have about 25'000 users who use a time and activity tracking web application to track their activity on each of the 'tasks' that they have been assigned to.

My boss has asked me to look into a solution that would:

1. Track how long a person is logged into their computer
2. Transmit that data to a table in the web app.

The purpose of this, as told by the boss, is to use a solution to grab that data (hours logged on) gathered from the above solution, so that when the end user has to 'enter their hours' at the end of the week, those hours for that user would be displayed and then the user would be able to transfer those logged in hours to work hours within the web app.

Please feel free to ask any questions and feel free to think outside the box.

I will be monitoring this post closely.

Thank you in advance.
0
Comment
Question by:Myrocco
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 7
17 Comments
 
LVL 34

Expert Comment

by:it_saige
ID: 40589551
You could have many different solutions provided.  The first one that comes to my mind is a services that starts a session based application.  The session based application would then be responsible for updating the table (or a table) with logged in and out information (although I am fairly certain that there is an AD setting that can confirm the last time a user logged in and most likely settings in WMI that do the same).  The session based application can also be configured to treat session changes (or locks) as logged out events.

Now, my question to you is this.  Does a user logging into a workstation, truly signify work accomplished in an activity tracking web application?  The smarter option may be to have the web application tracking this activity as it can be configured to maintain session based parameters for a users activities.

-saige-
0
 

Author Comment

by:Myrocco
ID: 40589755
Thanks IT SAIGE,

Yes, that was one thought, to use AD in some way, however, Having 'read up', I discovered that it would be best if one would go thru the DC and configure/view the security features.

Your questions:

1. Does a user logging into a workstation, truly signify work accomplished in an activity tracking web application?
A: I think, the answer to that, is 'NO'.  However, my boss is not to much worried about that.  His main focus is to give the end user the total number of hours that that user had been logged into the local machine/network at the end of the week so that total number of hours would be displayed in a input form when the user does open the app at the end of the week to "hurry up and put their time in".  In effect, make it easier for the engineer end user to close the gap between working hours and activity working hours.

2. The smarter option may be to have the web application tracking this activity as it can be configured to maintain session based parameters for a users activities.
A: I thought of that also, however, that would mean that we would have to load a small applet into main 'image' used to image the machines thru-out the company.  That applet would have to 'auto-start' the web app in the background of the local machine.  Also, because only 25'000 or so users actually use the app.  I could imagine what a bureaucratic mess it would be to isolate those 25'000 machines out of so many that would not need it.

How about, maybe, some kind of applet that references the user table and then would ping the network for each user's status on the network.  Would something like that function?

Thanks for your input !!!!!!
0
 

Author Comment

by:Myrocco
ID: 40589764
How about some kind of SMS solution?  Maybe use the user table to get the names of the users that need this applet, then, work with the upper IT management, so that, when they push out those SMS packages those users would receive the applet that would interface with the web app database, thus tracking the hours...  What are your thoughts on that?
0
Plesk WordPress Toolkit

Plesk's WordPress Toolkit allows server administrators, resellers and customers to manage their WordPress instances, enabling a variety of development workflows for WordPress admins of all skill levels, from beginners to pros.

See why 2/3 of Plesk servers use it.

 
LVL 34

Expert Comment

by:it_saige
ID: 40589822
If you are using SMS for push (or pull) installations, I am certain that there is a reporting mechanism that could be queried for the statistics of these requests (username, time started, time completed, etc.).  Let me check, there might be a powershell solution to this.

Along those lines, you could potentially leverage a script that run's when an engineer logs in in order to gather these statistics.

-saige-
0
 

Author Comment

by:Myrocco
ID: 40589854
I agree.  The only REAL issue is this.  We are a rough IT unit within the company and have no direct access to the servers.  What ever we choose to do, we will have to go thru the horrific ordeal of working whatever we choose to do thru the IT department.  We wish to find some kind of solution that would minimize that need.
0
 
LVL 34

Expert Comment

by:it_saige
ID: 40589855
After a brief search, it does look like it is possible to retrieve this type of information from SMS.  It's just a matter of generating the correct report or using the right query.

https://vasanthsccm.wordpress.com/2012/02/10/sql-queries-for-sccm/ - Is a list of some useful SCCM queries (and there are plenty of other queries that popped up in my search).

Do you think this can help accomplish your goal?

-saige-
0
 
LVL 34

Expert Comment

by:it_saige
ID: 40589858
Just read your last entry.

-saige-
0
 
LVL 34

Accepted Solution

by:
it_saige earned 2000 total points
ID: 40589874
If the users are all in the same OU, then the web application modifications would make the most sense as you could easily have an OU specific script start the web application when the user log's in.  

Otherwise, is there any other way these users are bound together in AD?

If there is not, then the simplest solution may be to do what I had initially outlined.  Create a service that launches an application on user login.  This application then reports to your web app's database.

-saige-
0
 

Author Comment

by:Myrocco
ID: 40591855
Given that the web app is programmed in VS 6.0.

Is it possible to place a cookie on the clients machine (when the client opens the web app home page)  that would monitor their systems "login/logoff" "uptime" and so on, then send data to the web app's back end DB?
0
 

Author Comment

by:Myrocco
ID: 40594976
Hey, it_saige, We decided that what will happen is to tap the BE DB of the ms lync service and get the data from that angle.

Please accept the points as I appreciate your input....
0
 

Author Comment

by:Myrocco
ID: 40594984
I've requested that this question be closed as follows:

Accepted answer: 0 points for Myrocco's comment #a40591855

for the following reason:

.
0
 

Author Comment

by:Myrocco
ID: 40594979
it_saige needs his points !!!!!
0
 

Author Comment

by:Myrocco
ID: 40594980
it_saige needs his points
0
 
LVL 34

Expert Comment

by:it_saige
ID: 40594985
Author wishes to assign points.

-saige-
0
 
LVL 34

Expert Comment

by:it_saige
ID: 40594987
No problem Myrocco.  Glad you guys were able to find an angle that will work for you.

-saige-
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
Geo-targeting is the practice of distributing content based on a person’s location, as best as you can determine it. Let’s look at some ways you could successfully use this tactic. The following tips and case studies could lead to meaningful results.
The purpose of this video is to demonstrate how to make a WordPress Site faster and smaller in size by cleaning up the database. This will be demonstrated using a Windows 8 PC. Plugin WP Optimize will be used. Go to your WordPress login page. T…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

636 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