This document has not been formally reviewed for accuracy and is provided "as is" for your convenience.
Summary
Sometimes we need to access directly the history table, like we used to do it on SM with activity table, to generate reports or audits.
Reference
Problem Description:
SMAX Database is not so easy to understand and there is a lack of information on how the structure was desined, so here is a simple way to access it.
Cause:
No clear information on SMAX DB structure.
Resolution:
Connect to the DB using an admin tool like PGAdmin or DBeaver, then:
- Search for the DB “xservices_ems” on the "maas_admin" schema.
- Open the table history_<tenant ID>.
- There you can use the entity_id field to filter and get the necessary results.
We will see one record per each line on the history tab.
Environment:
Tested on SMAX 2019.11