System utlization for each user.

Posted on 2011-04-25
Last Modified: 2012-05-11
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.
Question by:Sandesh555
    LVL 24

    Expert Comment

    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.

    Author Comment

    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.

    Author Comment

    Please also note that I am not tracking any specific application.  I am tracking the entire system utlization...

    Author Comment

    Can someone help me here
    LVL 24

    Accepted Solution

    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.

    Author Comment


    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

    728 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

    20 Experts available now in Live!

    Get 1:1 Help Now