Highlighted
Honored Contributor.. Honored Contributor..
Honored Contributor..
396 views

sloresponsehist table

I would like to know what is the purpose of the table "sloresponsehist". There is a table called "sloresponse" which i am aware of.

 

We have our transactional databse synced with reporting databse. There is a delay of 2 hours between transactional and reporting because the table "sloresponsehist" is taking too much time. We are considering not to sync this table with reporting databse. Before we take this approcah iwould like to know what is the purpose of this table and if it is ok not to sync this table with reporting database.

 

Version 9.41

Database: Oracle

0 Likes
1 Reply
Highlighted
Micro Focus Expert
Micro Focus Expert

In the sm 9.41 release notes, it has this bit of info.  If you are not going to report on sla, it should be fine to ignore this historical table but that is unlikely as sla reporting is very common.

QCCR1E66808
There is no way to monitor UC and OLA because the sloresponse records are deleted when the incident no longer has the vendor field or the incident is passed from one assignment group to another. The sloresponse records contain valuable information for Service Level Management (SLM) and should never be deleted.
Now the sloresponse records are logged in a new table sloresponsehist. Every time when the SLM calculation is triggered, the data of the related sloresponse records is logged to the new table, so that historical data is kept in the system.

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.