Symantec Access Management

Expand all | Collapse all

Wrong login timestamp saving in SQL DB

  • 1.  Wrong login timestamp saving in SQL DB

    Posted 06-16-2021 06:17 AM
    Hello Team,

    We are using MSSQL as database for siteminder and IDM. Wrong login time saving in siteminder audit tables in SQL.
    From where we need to change configuration for saving correct timestamps.
    Changes should done from siteminder side or SQL server side..?

    Please need help on this.

    Regards,
    Girish Chandra


  • 2.  RE: Wrong login timestamp saving in SQL DB

    Posted 06-17-2021 08:19 AM
    Hello Team,

    We are displaying user last login time in application, now customer wants to change time zone means IST.

    User last login time saving in User Directory as 20210617114830Z<IP>, in application time displaying Last Login: Thu Jun 17 11:48:30 IST 2021.
    But actually user last login time is 2021 06 17 05:18PM.
    This is our requirement, is this possible to achieve in running environment..?
    If yes, please help us to do.

    Regards,
    Girish Chandra