Lastlogontimestamp attribute from AD

Identity Security Cloud (ISC) ISC Discussion and Questions
7

Hi @renzambos ,

You can try below, though I haven’t tested it, it should be able to give you the format you are looking for:

{
    "name": "Transform LastLogon Timestamp",
    "type": "dateFormat",
    "attributes": {
        "inputFormat": "EPOCH_TIME_WIN32",
        "outputFormat": "dd/MM/yyyy HH:mm a z",
        "input": {
            "type": "firstValid",
            "attributes": {
                "values": [
                    {
                        "attributes": {
                            "sourceName": "Active Directory",
                            "attributeName": "lastLogonTimeStamp"
                        },
                        "type": "accountAttribute"
                    },
                    "135379419570000000"
                ]
            }
        }
    },
    "internal": false
}

For desired formats, you can take a look at this SimpleDateFormat (Java Platform SE 8 ) (oracle.com). The Date format transform ( Date Format | SailPoint Developer Community) supports this.

For the desired timezone conversion, yes agree with @shekhardas1825, that you can use Date Math transform.

Hope this helps.

Thanks,
Shailee