Results 1 to 4 of 4
  1. #1
    Join Date
    May 2002
    Location
    Timbaktu
    Posts
    185

    Unanswered: Date the Login was locked

    Is there a way to find the date when the account(login) was Locked in Sybase?

  2. #2
    Join Date
    Aug 2002
    Posts
    5
    No. The status column in syslogins is set to "2" when a login has been locked. There is no way of telling when the login was locked (via sybase). Third party products which act as network sniffers might be helpful.

    - Q

  3. #3
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    Hiya,

    You might be able to determine the date login got logged looking at the corresponding 'accdate' column for this login.

    This column details the date and timestamp the last time I/o was cleared for that login.

    Although, I must say I've not tested it.

    Cheers
    Willy

  4. #4
    Join Date
    Aug 2002
    Posts
    5
    As Willy said, the accdate column does keep track of when the totcpu and totio were last cleared. These columns totcpu and totio are always increasing as Sybase keeps track of accumulated io and cpu per login. Running sp_reportstats will provide a report for you based on these values using accdate as a "start time". Running sp_clearstats however, will first run the report, then clear the values. At this time, accdate gets reset to the current date. Definitely interesting, but not related to the login lock time.

    - Qso

Posting Permissions

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