• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 303
  • Last Modified:

System utlization for each user.

Hi Team,

I am trying to build a tool that will track the system utlization for the user who has logged into the system.  This is what I want tracked.

When the user logs in.
When the user logs Out.
When the system is idel for more than 3/4 minutes.
When the user locks his/her system.
When the user unlocks his/her system.

I am planing to use MS Access, any idea how do I proceed.  I am open to suggestion, no hard and fast rule that I want to use access.
0
Sandesh555
Asked:
Sandesh555
  • 4
  • 2
1 Solution
 
johanntagleCommented:
Except for the checking for idle time, each of the action requires an action by the user, so each code that handles the action just needs to insert data that logs the action into the database.  Something like:

insert into user_logs (user_name, timestamp, action) values ('Sandesh','2011-04-25 21:00:00','Log out');

For the idle time, you need a timer in your application that resets whenever a user does something.  But when the timer hits its limit, you do another database insert.
0
 
Sandesh555Author Commented:
How do I auto run the insert code when the user perfrms those actions.

For e.g., how would access know it has to run the log in query.  How will it auto triger.
0
 
Sandesh555Author Commented:
Please also note that I am not tracking any specific application.  I am tracking the entire system utlization...
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Sandesh555Author Commented:
Can someone help me here
0
 
johanntagleCommented:
Oh you mean logs in, out, etc to and from a windows server?  I think you need to add something like "Windows System Programming", if such a zone exists, to your question, and that should be the question's primary zone.  I don't think Access has the ability to detect such activity.  You need to create an application that monitors such an activity (maybe reading from windows system data) then store the data collected to Access.
0
 
Sandesh555Author Commented:
Thanks
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now