Overview

An idea was deleted from your community, and you would like to know which user deleted that idea or when they deleted it.

Solution

<supportagent>

Support agents:

This type of request can be considered a custom reporting request that is outside the scope of support. However, if you need to perform these queries on a customer's database, you can follow these steps:

1. Navigate to the customer's instance in the Jive Cloud Admin.
2. Click on the Magic Query Tool for their instance.
3. Select the "Email results" checkbox.
4. Use the queries listed below based on the information the customer provided.

</supportagent>

Jive Hosted

Please review one of these options:

1. Querying a copy of your application database:
   1. Download a copy of your application database.
   2. Ask your IT team to run the queries listed in the on-premise section below on this database copy.
2. An engagement with Jive Professional Services. For more information, please contact your account manager or account executive. Please note that a professional services engagement may incur additional costs.

Jive On-Premise

If you know the exact name of the idea that was deleted, please ask your IT team to run the following query on your Jive application database, replacing <ideaname> with the name of the idea:

SELECT jiveuser.userid, jiveuser.firstname, jiveuser.lastname, description, 
TO_CHAR(TO_TIMESTAMP(timestamp / 1000), 'DD/MM/YYYY HH24:MI:SS') AS date 
FROM jiveauditlog LEFT JOIN jiveuser ON jiveauditlog.userid = jiveuser.userid
WHERE details LIKE '%Deleted idea%<ideaname>%' 
ORDER BY auditmessageid DESC
LIMIT 500

If you don't know the exact name of the idea, please ask your IT team to run the following query on your Jive application database, then filter through the idea names in the description column of the results:

SELECT jiveuser.userid, jiveuser.firstname, jiveuser.lastname, description, 
TO_CHAR(TO_TIMESTAMP(timestamp / 1000), 'DD/MM/YYYY HH24:MI:SS') AS date 
FROM jiveauditlog LEFT JOIN jiveuser ON jiveauditlog.userid = jiveuser.userid
WHERE details LIKE '%Deleted idea%' 
ORDER BY auditmessageid DESC
LIMIT 500

The results of these queries will be similar to the following example: