Thursday, March 9, 2017

OIM query to find entitlements associated with application instance

SELECT ent.ent_code AS "Entitlement Name", ent.ent_display_name AS "Entitlement Display Name" from ent_list ent
INNER JOIN app_instance app_instance ON
app_instance.object_key = ent.obj_key AND
app_instance.itresource_key = ent.svr_key AND
app_instance.app_instance_name = 'ActiveDirectory';

No comments:

Post a Comment