06/05/2023 02:42 AM
Hi Team,
We have a requirement to launch entitlement owner certification for users only if the user is not undergone certification in last quarter. Is it possible to filter user based on 'lastcertified date'?.
I checked few tables like certification_user_status, certification_user_account_status which has no data and certification_account_entitlement1_status holds data of only expired campaign which we can't rely on.
Kindly help me with the correct table name which holds all campaign fields like - lastcertified date, lastcertifiedcampaignname,certified,audittrail.
Thanks,
smitha
Solved! Go to Solution.
06/05/2023 03:33 AM
Generally the lastcertifieddate for a user will be updated in case of a User manager campaign performed previously for a particular user. For entitlement owner campaign, the objects involved are accounts and entitlements. so basically you should check the lastcertifieddate for the account-entitlement rather than at the user level. let me know if this helps.
06/05/2023 07:16 AM
Check below fields in users and accounts table.
06/06/2023 02:38 AM - edited 06/06/2023 02:39 AM
Please consider the following SQL queries to retrieve the necessary information:
Query 1:
SELECT u.LASTCERTIFIEDDATE, u.LASTCERTIFIEDUSER
FROM saviynt.users u
Query 2:
SELECT a.LASTCERTIFIEDACT1m, a.LASTCERTIFIEDcm..ENT
FROM saviynt.accounts a
Please let us know if further details is needed