Application Description stored in which Sailpoint table

[#1]

HI All

I just want to know that where the value of Description field of an Application is stored?

I checked in identityiq.spt_application table but I didnt find description column.

Thanks

[menno_pieters]

It is stored as a LocalizedAttribute object in the table spt_localized_attribute:

<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE LocalizedAttribute PUBLIC "sailpoint.dtd" "sailpoint.dtd">
<LocalizedAttribute attribute="description" created="1457529493898" id="8ae14ad05356de5a01535b87198a0221" locale="en_US" modified="1457529519631" name="Active Directory:description:en_US" targetClass="Application" targetId="40289ffe4bd9b6c3014be65b071b017b" targetName="Active Directory" value="My Active Directory&lt;br>"/>

mysql> select * from spt_localized_attribute;
+----------------------------------+---------------+---------------+-------+------------------------------------+--------+-------------+-------------------------+--------------+------------------+----------------------------------+
| id                              | created      | modified      | owner | name                              | locale | attribute  | value                  | target_class | target_name      | target_id                        |
+----------------------------------+---------------+---------------+-------+------------------------------------+--------+-------------+-------------------------+--------------+------------------+----------------------------------+
| 8ae14ad05356de5a01535b87198a0221 | 1457529493898 | 1457529519631 | NULL  | Active Directory:description:en_US | en_US  | description | My Active Directory<br> | Application  | Active Directory | 40289ffe4bd9b6c3014be65b071b017b |
+----------------------------------+---------------+---------------+-------+------------------------------------+--------+-------------+-------------------------+--------------+------------------+----------------------------------+
1 row in set (0,00 sec)

- Menno

[sunilsaurabh04]

Hi

I have one doubt here.

We can see in value <br> is coming.

How we can remove that?

Thanks

Sunil

[menno_pieters]

<br> is an HTML line ending. You can remove that by editing the field and not pressing enter.