Information you need to acquire before starting this tutorial:
If you are outside the office you must be connected to the VPN
1. Download DBeaver (or any other PostgreSQL client): Download
1.1. Install DBeaver hitting next on everything, leaving as the default installation.
2. Create a connection to TT1 DB:
Host: tt1-db-prod-ruptela.lt
Port: 5432
Database: track
Username: rouser
3. Connect to the DB. In the Database Navigator, lick on the tt1-db-prod-ruptela.lt and then on the plug+ icon.
3.1 if it asks to download drivers, hit the download button.
4. Open new SQL query window:
5. Copy and paste the SQL Query below and swap <imei> for the IMEI of the object your are looking for:
select * from delete_reason dr where imei = <imei>
Example:
select * from delete_reason dr where imei = 869867036867127
6. Click on the > button to the left of the query (or press CTRL+ENTER).
If object is not deleted, no results will return.
If object was deleted, a result will appear showing the last deletion occurrence. Check the field created_at to know the exact time the object was deleted in LCM.