OBR: OMi Extended Content Pack 10x: Adding CONTROL_EXTERNALID In Hourly & Daily Summarization Tables

OBR: OMi Extended Content Pack 10x: Adding CONTROL_EXTERNALID In Hourly & Daily Summarization Tables

Application Version:

OBR 10.2x and OMi10x_Extended_ETL CP: 10.x

Don't see CONTROL_EXTERNALID count column in the Summarization tables SH_Event_Count and SD_Event_Count.

End user likes to see No.of tickets logged for Critical, Major.... over a period of time. 

We can get CONTROL_EXTERNALID based on Severity from K_Event_Ext table for the date passed but it seems impossible while showing the count day wise!!

Tags (2)
3 Comments
Micro Focus Expert
Micro Focus Expert
Status changed to: Waiting for Votes
 
Micro Focus Expert
Micro Focus Expert
Status changed to: Already Offered

This field is already available in OMi Extended content.

K_Event_Ext.Control_ExternalID stores the CONTROL_EXTERNALID received from OMi.

Custom online aggregation in reports can be created using EventCount Cubes in the OMi Extended universe along with the required attributes like CONTROL_EXTERNALID.

 

Acclaimed Contributor.. m_vidyasagar Acclaimed Contributor..
Acclaimed Contributor..

Hi Vineetha,

I used K_Event_Ext.Control_ExternalID to show the count, thought it would be good if we have few more columns like No.of Critical Ticket, Major Tickets etc .. in SH_Event_Count\SD_Event_Count itself..

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.