I am using the Version RSA IGL 7.1 P09
Problem:
In the User Access Review I wanted to perform a review for specific application entitlements which has matching keyword in the long description.
eg : 'DB Access' keyword in the entitlement long description.
How we can achieve this. I have tried with this setting as show in the screenshot attached, but failed to get the valid records.
I ran this query in the SQLdeveloper against the DB and works fine.
select ID from pv_application_entitlement where Long_Desc like '%DB Access%'
I am not sure why it is keep changing while i click ok to save changes.. you can see In the Screenshot the where condition field name
I gave 'ents.long_desc' but when i click save changes it changed to 'ents.longDesc.' without underscore.
Any help is really appreciated here.
Hi Lakshman,
I don't think you need the select ID from pv_application _entitlement in your filter:
Try the above and let me know if that works?
Another way this could be achieved if there are different categories for your entitlements that is more robust would be to extend the object schema to include an attribute of type and populate this with values such as DB Access. You could then filter on this new attribute. This would ensure any entitlements tagged, even if the long description had a spelling error for example, would still be included.
Not essential but worth considering if you have multiple types of entitlements you want to review on and the description attribute is not reliable enough.
Hopefully the above will work for your specific use case just now though.