+ Post New Thread
Page 2 of 2 FirstFirst 12
Results 16 to 19 of 19
Home Access Plus+ Thread, HAP Logon Tracker - Couple of questions in Projects:; Originally Posted by nickbro Yes, it's a 60 seconds timeout, or shoudl be Is there anyway you could build in ...
  1. #16

    Join Date
    Jul 2008
    Posts
    43
    Thank Post
    0
    Thanked 3 Times in 2 Posts
    Rep Power
    13
    Quote Originally Posted by nickbro View Post
    Yes, it's a 60 seconds timeout, or shoudl be
    Is there anyway you could build in a switch for the program so the timeout can be customized to lower than 60 seconds

  2. #17

    Join Date
    Jul 2008
    Posts
    43
    Thank Post
    0
    Thanked 3 Times in 2 Posts
    Rep Power
    13
    Quote Originally Posted by broadld View Post
    Is there anyway you could build in a switch for the program so the timeout can be customized to lower than 60 seconds
    I have just tested the new HAP logon with the HAP website stopped and it logged straight on and off with no problem but it didn't have a 60 second wait it just went straight through with no problems. Is this what you were expecting it to do Nick?

  3. #18

    nickbro's Avatar
    Join Date
    Jul 2010
    Location
    Gilwern, Wales
    Posts
    3,648
    Thank Post
    43
    Thanked 550 Times in 459 Posts
    Rep Power
    121
    It's by design so you can properly script it via logon scripts (no x86 folder)

  4. #19

    Join Date
    Jul 2008
    Posts
    43
    Thank Post
    0
    Thanked 3 Times in 2 Posts
    Rep Power
    13
    Quote Originally Posted by nickbro View Post
    Here's the code to clear logons, you can schedule it with Windows Task Scheduler

    1. Save this as clearlogons.sql (c:\)
    Code:
    USE [hap]
    GO
    
    UPDATE [dbo].[TrackerEvents]
       SET [LogoffDateTime] = GETDATE()
     WHERE [dbo].TrackerEvents.LogoffDateTime is null
    GO
    2. Add a scheduled task to run as a user with rights to the database (or use a logon id)
    3. This is the command to run: (use osql -? to find out what you can change)
    Code:
    osql -E -i c:\clearlogons.sql
    This was a great help Nick thanks.

    I have slightly adjusted this and think this may be useful for others as well. It basically pulls out records with a logon date less than current date - 2 days and where the logoff date is null.

    USE [hap]
    GO

    UPDATE [dbo].[TrackerEvents]
    SET [LogoffDateTime] = GETDATE()
    WHERE [dbo].[TrackerEvents].[LogonDateTime] < DATEADD(dd,-2,GETDATE()) and [dbo].[TrackerEvents].[LogoffDateTime] is null
    GO

SHARE:
+ Post New Thread
Page 2 of 2 FirstFirst 12

Similar Threads

  1. HAP+ Newbie - Couple of questions
    By tj2419 in forum Home Access Plus+
    Replies: 13
    Last Post: 6th May 2013, 02:38 PM
  2. Replies: 17
    Last Post: 11th March 2011, 01:48 PM
  3. A couple of questions....
    By garethedmondson in forum Windows 7
    Replies: 8
    Last Post: 28th June 2010, 11:18 AM
  4. Italc: Couple of questions
    By superatticman in forum Network and Classroom Management
    Replies: 33
    Last Post: 9th November 2009, 10:44 AM
  5. Couple of questions
    By button_ripple in forum MIS Systems
    Replies: 8
    Last Post: 1st February 2009, 06:16 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
  •