+ 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
    274
    Thank Post
    58
    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,174
    Thank Post
    868
    Thanked 2,702 Times in 2,289 Posts
    Blog Entries
    11
    Rep Power
    773
    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
    274
    Thank Post
    58
    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
    25
    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, 09: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
  •