Deletion of Opportunities,leads etc (mystery)

[Fay]

Hi,

On 3 occassions last week 3 different opportunites have suddenly disappeared from SugarCRM & I can't see where (they are 100% gone). Is there anyway of seeing deleted items or history of deletions?

Many Thanks for any help you can offer.

(Community)

[letrium]

Hi,
Yes you can see deleted records in database.
All deleted records just flagged as deleted.

[roblaus]

Yeah check for deleted = 1 in the opportunities table. You could also have a look at the tracker table, maybe you'll find something useful there.

[letrium]

You can use this simple query

 SELECT * FROM opportunities WHERE deleted =1 
  

Regards,
Alex

[Fay]

You can use this simple query

 SELECT * FROM opportunities WHERE deleted =1 
  

Regards,
Alex

This is great, can you expand the query so it shows the associated account name. Also, how do I find out the user, all I can see is the user id & I don't know how to find out who that is. Any help is appreciated. Thansk

[salesagility]

goto to the users table ... the userid is in there ... this will tell you who is deleting records

you may wish to limit users ability to delete by going to admin>roles

[Fay]

goto to the users table ... the userid is in there ... this will tell you who is deleting records

you may wish to limit users ability to delete by going to admin>roles

I have the user id, how do I find out which user that was. I can't see the number under user id in admin?

All I can see is af057915-fafe-a064-25f0-4a6d6d4bf15c as the user id

[Fay]

I have the user id, how do I find out which user that was. I can't see the number under user id in admin?

All I can see is af057915-fafe-a064-25f0-4a6d6d4bf15c as the user id

Does anyone know an easy way of being able to determine which user "name" relates to each user id? Thanks

[sugarcane]

Hi Fay,

This data is stored in the database in the Users table.

The way to see this information within Sugar is to go to Admin-->User Management. When you click on a user, in the URL, you will see the id at the end. Alternatively, you can export the list of users to a csv. This will export the id, user name, and other user information.

[Fay]

You can use this simple query

 SELECT * FROM opportunities WHERE deleted =1 
  

Regards,
Alex

Thanks Alex, your response helped me resolve my issue