How to access the history table records

  • Document ID:KM03636503
  • Creation Date:27-Apr-2020
  • Modified Date:27-Apr-2020
    • Micro Focus Products:
      service management automation

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