HelloMy FIMService databse is huge. One talbe is 96gb, the ObjectValueText table. Does anyone know what this is used for and can I purge it ?

That table contains values for objects with attributes of type string (non-indexable). You must have loaded up a lot of data into attributes of that type. To reduce the size of the table you need to delete these values in these attributes or reduce the data in themDavid Lundell www.ilmBestPractices.com

No you can't purge it directly.David Lundell www.ilmBestPractices.com

Strange. This is just a simple lab site with no more that 100 users and groups. Its is the only table that is huge, the rest are under a meg

Hi Kevin,A lot of data for Request objects is stored in the ObjectValueText table. A Request object is created for every operation that takes place in FIM, so you can imagine how this table size can increase dramatically over time. There will be a mechanism in an upcoming update release, which will automatically delete expired Request objects and reduce the size of this table as a result.