To view the export history perform the following steps from the IM Manager Administration Console:
1. Click on the Administration tab.
2. Click on Configuration|Export menu item.
3. Click on the History icon for the export job.
There are IM conversations that contain many thousands of messages.
Typically this issue can happen when an IM conversations contains over ten thousand (10,000) messages. Run the following SQL query against the IM Manager database. Before running the query replace the date ranges with ones appropriate to your environment:
SELECT CONVERT(varchar(100), message_date, 1) AS day, session_guid, COUNT(id) AS numberofmessages, SUM(DATALENGTH(content))
WHERE (message_date BETWEEN '5/24/2011' AND '6/10/2011')
GROUP BY CONVERT(varchar(100), message_date, 1), session_guid
having count(id) > 10000
ORDER BY COUNT(id) DESC
The conversations with the highest number of messages are returned first. The following is an example:
1. Run the SQL query above to determine the affected conversation IDs. 2. Run the following SQL against the IM Manager database to remove the conversation. Replace the session ID with the appropriate one returned from the SQL query.
Delete from messages where session_guid = '<session_guid>'