Click HERE to see how Saviynt Intelligence is transforming the industry. |
01/08/2024 10:39 PM - edited 01/08/2024 10:39 PM
I have created two new endpoints , uploading accounts from UI using feed file. I want to make CP2 of account as entitlement so that while scheduling certs CP2 values are treated as entitlements. How to achieve that.
01/08/2024 11:03 PM
You can use custom Query job
01/08/2024 11:07 PM - edited 01/08/2024 11:10 PM
Can you please provide some sample query for this ? I need ENDPOINT's CP2=ENTITLEMENT where endpointkey=3
01/09/2024 05:19 AM
UPDATE Endpoints e
JOIN Entitlementtypes et ON e.endpointkey = et.endpointkey
JOIN entitlement_values ev ON et.entitlementtypekey = ev.Entitlementtypekey
SET e.customproperty2 = ev.entitlement_value where e.endpointname =