Manually edit description in IdentityIQ 6.1 and above

[#1]

Prior to the release of IIQ 6.1, the description for any object was stored within the XML defining that object. It was possible to export the XML, edit the description, and then import the object to modify the description of an application, policy, etc.

With the release of IIQ 6.1, the description content is no longer stored in the XML object and is now managed in a separate database table called spt_localized_attribute. While SailPoint does not support customers manually editing the contents of the IdentityIQ system tables, this example is provided for informational purposes only.

Here is a sample SQL statement demonstrating the modification of the description for the 'AdminsApp' within the demo data:

insert into spt_localized_attribute (created, modified, owner, name, locale,

attribute, value, target_class, target_name, target_id, id)

values (1374495641912, '', '', 'AdminsApp : description : en_US', 'en_US',

'description', 'Here is a new description for the AdminsApp', 'Application', 'AdminsApp',

'ff8080813ecca887013eccca479b0523', 'ff80808140064daf014006531138000d')

[#2]

support said that if you do not like the idea of manually running insert sql on app db you can just export the LocalizedAttribute from debug pages clean it and import it into your other region.

Ok so grab the LocalizedAttribute xml object via debug pages like this…..

<?xml version='1.0' encoding='UTF-8'?>

<!DOCTYPE LocalizedAttribute PUBLIC "sailpoint.dtd" "sailpoint.dtd">

<LocalizedAttribute attribute="description" created="1363121619226" id="581212dc3d6057bf013d6061411a0271" locale="en_US" modified="1363268898870" name="App: description : en_US" targetClass="Application" targetId="581214122b586fdb012b637810782274" targetName="App" value="The App application provides a user friendly way to view access for users outside."/>

Clean it up removing the modified, created, id, and targeted like this:

<?xml version='1.0' encoding='UTF-8'?>

<!DOCTYPE LocalizedAttribute PUBLIC "sailpoint.dtd" "sailpoint.dtd">

<LocalizedAttribute attribute="description" locale="en_US" name="App : description : en_US" targetClass="Application" targetName="App" value="The App application provides a user friendly way to view access for users outside."/>

Then import via ui