Hi Team,
I set up the preprocessor to add 60 days to the pwdlastset and imported it into the user profile because we need to print the Active Directory account password expiration timestamp there.
Below is the Json that we have used:
{
"ADDITIONALTABLES": {
"USERS": "select u.customproperty16,u.userkey,u.username,DATE(DATE_ADD(acc.lastpasswordchange, INTERVAL 60 DAY)) AS EXPIRY from users u JOIN user_accounts ua ON u.userkey = ua.userkey JOIN accounts acc ON acc.accountkey = ua.accountkey JOIN endpoints ep ON acc.endpointkey = ep.endpointkey and acc.status = 1 AND ep.endpointname IN ('Active Directory') "
},
"COMPUTEDCOLUMNS": [
"customproperty16"
],
"PREPROCESSQUERIES": [
"UPDATE NEWUSERDATA LEFT JOIN CURRENTUSERS ON NEWUSERDATA.USERNAME = CURRENTUSERS.USERNAME SET NEWUSERDATA.customproperty16 = (case when NEWUSERDATA.customproperty16 is null or NEWUSERDATA.customproperty16 = '' then '' else lastchange end)"
]
}
UserAttribute:
[
customproperty16::pwdLastSet#millisec,
USERNAME::sAMAccountName#String
]
but getting this Issue
Can anyone please resolve this issue?
Do you have any idea on this. I've tried below sample Json as well but still getting the same issue.
{
"ADDITIONALTABLES":{"USERS": "SELECT username, CUSTOMPROPERTY16 from USERS"},
"COMPUTEDCOLUMNS": ["CUSTOMPROPERTY16"],
"TABLEINDEXES": {
"currentusers": ["username"]
},
"PREPROCESSQUERIES": ["UPDATE NEWUSERDATA SET NEWUSERDATA.CUSTOMPROPERTY16 = 'Updated' where NEWUSERDATA.username = 'testuser' "]
}
