No data in Historic Event Report

Products

• VMware Smart Assurance

Issue/Introduction

You have setup the event reporting to extract the live and historic archive alarms. You can see the data in MySQL and ElasticSearch. But the data is not coming up in the report.

Environment

Watch4net|M&R 7.x

Cause

One of the report filter used is eventState=='0'. However, event state in FE is mapped to strings ACTIVE or INACTIVE. This mapping is present in APG_HOME/Custom/WebApps-Resources/Default/property-mapping/ES-RPE2.xml and APG_HOME/Custom/WebApps-Resources/Default/property-mapping/FLOW-RPE2.xml.

Resolution

As per requirement, replace report filter eventState=='0' or eventState=='1' with either eventStateAsString=='ACTIVE' or eventStateAsString=='INACTIVE' (as per mapping in FLOW-RPE2.xml and ES-RPE2.xml).