+ Post New Thread
Results 1 to 4 of 4
Windows Server 2008 R2 Thread, Record data during login, how would you do it? in Technical; We're wanting to gather data across our campus of student and computer activity trends. I first started recording basic things ...
  1. #1
    jmair's Avatar
    Join Date
    Aug 2007
    Posts
    291
    Thank Post
    65
    Thanked 9 Times in 9 Posts
    Rep Power
    16

    Record data during login, how would you do it?

    We're wanting to gather data across our campus of student and computer activity trends. I first started recording basic things like username, OU of user (grade), what computer and where that computer is located (also OU). I was using VBS at login, porting this info to text file and using a quick converter to open the info in PivotViewer .

    All was well untill we wanted to get more info such as how many times each user logged into x machine and how many times per day during what period etc. So I tried writing the info in VBS to an excel spreadsheet. Turns out though that the spreadsheet can only be opened by one user at a time, and this wouldn't be a good solution for students signing in at a lab at the same time.

    So now I'm at an impass, and open to any other ideas. Should I do something in VBS and store data to an Access DB? Is there a better method or another way of soing this?

    I should note that we will need to export the data to excel to be turned into a format for the PivotViewer. Other than that I'm open to suggestions!

  2. #2

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    11,271
    Thank Post
    884
    Thanked 2,749 Times in 2,322 Posts
    Blog Entries
    11
    Rep Power
    785
    Use a SQL express database, an access MDB will give you the same problems and be slow, it also has issues if you are hitting it from an x64 station.

  3. Thanks to SYNACK from:

    jmair (1st December 2010)

  4. #3
    jmair's Avatar
    Join Date
    Aug 2007
    Posts
    291
    Thank Post
    65
    Thanked 9 Times in 9 Posts
    Rep Power
    16
    I'll download it now and give it a shot! Thanks SYNACK!

  5. #4

    Join Date
    Dec 2007
    Location
    cumbria
    Posts
    182
    Thank Post
    7
    Thanked 43 Times in 39 Posts
    Rep Power
    26
    How about using EventCreate in a logon script - you can get all clients to log to one central machine .



SHARE:
+ Post New Thread

Similar Threads

  1. [Pics] I think this is a new record
    By somabc in forum Jokes/Interweb Things
    Replies: 8
    Last Post: 21st October 2010, 10:15 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •