Uploaded image for project: 'Jira Service Management Data Center'
  1. Jira Service Management Data Center
  2. JSDSERVER-8008

LDAP import: parse datetime values correctly

XMLWordPrintable

    • 1
    • 3
    • We collect Jira Service Desk feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      Microsofts Active Directory uses two different formats to store dates. Currently these values are imported as plain text, which especially for the second format (see below) sadly does not help at all.
      It would be really helpful if Insight converted these values to readable datetimes automatically.

      Generalized Time
      example: 20180705131341.0Z
      result: 05.07.2018 15:13:41
      example fields: whenChanged, whenCreated

      Microsoft OID for Time
      example: 131799092312363246
      result: 28.08.2018 07:53:51
      example fields: lastLogon, badPasswordTime, pwdLastSet

            [JSDSERVER-8008] LDAP import: parse datetime values correctly

            SET Analytics Bot made changes -
            Support reference count New: 3
            Marc Dacanay made changes -
            Labels Original: affects-server insight-l New: affects-server insight-l ril
            Marc Dacanay made changes -
            Remote Link New: This issue links to "Internal ticket (Web Link)" [ 977630 ]
            SET Analytics Bot made changes -
            UIS Original: 2 New: 1
            SET Analytics Bot made changes -
            UIS Original: 1 New: 2
            SET Analytics Bot made changes -
            UIS Original: 2 New: 1
            SET Analytics Bot made changes -
            UIS Original: 3 New: 2
            SET Analytics Bot made changes -
            UIS New: 3

            Marek Bujak added a comment -

            Is there a way to convert Microsoft OID for Time to any readable one using simple java format like hh:mm:ss?

            Marek Bujak added a comment - Is there a way to convert Microsoft OID for Time  to any readable one using simple java format like hh:mm:ss?
            Chung Park Chan made changes -
            Description Original: Microsofts Active Directory uses two different formats to store dates.Currently these values are imported as plain text, which especially for the second format (see below) sadly does not help at all.It would be really helpful if Insight converted these values to readable datetimes automatically.

            *Generalized Time*
            example: 20180705131341.0Z
            result: 05.07.2018 15:13:41
            example fields: whenChanged, whenCreated

            *Microsoft OID for Time*
            example: 131799092312363246
            result: 28.08.2018 07:53:51
            example fields: lastLogon, badPasswordTime, pwdLastSet             		New: Microsofts Active Directory uses two different formats to store dates. Currently these values are imported as plain text, which especially for the second format (see below) sadly does not help at all.
            It would be really helpful if Insight converted these values to readable datetimes automatically.

            *Generalized Time*
            example: 20180705131341.0Z
            result: 05.07.2018 15:13:41
            example fields: whenChanged, whenCreated

            *Microsoft OID for Time*
            example: 131799092312363246
            result: 28.08.2018 07:53:51
            example fields: lastLogon, badPasswordTime, pwdLastSet

              Unassigned Unassigned
              da0dd4439f59 Alex Cooksey
              Votes:
              9 Vote for this issue
              Watchers:
              7 Start watching this issue

                Created:
                Updated: