Question
2
Replies
916
Views
USU GmbH
Posted: 2 years ago
Last activity: 2 years 7 months ago
How to view deleted database table instances
There is an issue that some database table instance was deleted from the system. I see in the history (History-DATA-ADMIN-DB-TABLE) that it was there at end of November but it is gone now. Now I want to know when it was deleted and who or why that was the case.
Is there any possibility to see information about deleted database table instances or basically all non versioned rules?
Posted: 2 years ago
Posted: 2 years ago
Thanks for your suggestion but sadly it only has the same information one can find it the instances of History-DATA-ADMIN-DB-TABLE.
I restored it on 08.02 but before that there is no deletion visible.
| PXTIMECREATED | PYMEMO | PXRULEACTION | PYHASHISTORYSNAPSHOT |
|---|---|---|---|
| 2017-11-27 14:35:41.426 | Saved this record | Save | true |
| 2017-11-27 15:51:38.978 | Saved this record | Save | true |
| 2018-02-08 09:58:34.589 | This instance is restored from an earlier version | Version Restore | <null> |
| 2018-02-08 09:58:37.656 | Saved this record | Save | true |
I'm not certain, but you might be able to find this information in the <data_schema>.pr_history_data table where pxinsname like '%DATA-ADMIN-DB-TABLE%';