https://docs.saviyntcloud.com/bundle/SSM-Admin-v55x/page/Content/Chapter16-SSM-Analytics/Managing-An...
Password Expired
When Password Expired is configured as an allowed action, it expires user’s password on the configured date. You can manually set or schedule the password expiry. This action can be configured as a default action. This action does not create any tasks, instead it marks the password to be expired for the selected users.
The Analytics query must have the columns given below:
userKey - Stores the userkey of the user whose password has to be expired.
Sample query:
Manual action (bulk/single row action)
SQL
select u.userkey, u.username , u.LASTPASSWORDUPDATEDATE, date_add(u.LASTPASSWORDUPDATEDATE,Interval p.expireafter day) as 'Expiry Date' from users u, policyrule p
where u.PASSWORDEXPIRED=0
and p.SCOPE='USER'
and p.EXPIREAFTER > 0
and DATEDIFF(date_add(u.LASTPASSWORDUPDATEDATE,Interval p.expireafter day),sysdate()) = 0;
Schedule from Run All V2 Analytics Job
SQL
select u.userkey, u.username , u.LASTPASSWORDUPDATEDATE, date_add(u.LASTPASSWORDUPDATEDATE,Interval p.expireafter day) as 'Expiry Date', 'passwordExpired' as 'Default_Action_For_Analytics' from users u, policyrule p
where u.PASSWORDEXPIRED=0
and p.SCOPE='USER'and p.EXPIREAFTER > 0
and DATEDIFF(date_add(u.LASTPASSWORDUPDATEDATE,Interval p.expireafter day),sysdate()) = 0;
Schedule from Run All V1 Analytics Job
SQL
select u.userkey, u.username , u.LASTPASSWORDUPDATEDATE, date_add(u.LASTPASSWORDUPDATEDATE,Interval p.expireafter day) as 'Expiry Date', 'Password Expired' as 'Default_Action_For_Analytics' from users u, policyrule p
where u.PASSWORDEXPIRED=0
and p.SCOPE='USER'and p.EXPIREAFTER > 0
and DATEDIFF(date_add(u.LASTPASSWORDUPDATEDATE,Interval p.expireafter day),sysdate()) = 0;
Regards,
Rushikesh VartakIf the response is helpful, please click
Accept As Solution and kudos it.
