Unable to use source filter for the events in MySQL.

Products

• VMware Smart Assurance

Issue/Introduction

MySQL events report does not fetch any data when source filter is used. It does work for the events stored in ElasticSearch.

Environment

All supported releases of Watch4net|M&R

Resolution

1). Take a backup of /APG_HOME/Custom/WebApps-Resources/Default/property-mapping/FLOW-RPE2.xml

2). Edit /APG_HOME/Custom/WebApps-Resources/Default/property-mapping/FLOW-RPE2.xml and add below entry after eventSource entry:

        <property name="com.watch4net.apg.v2.modules.database.GenericFlow.properties.StringValue">
                <name class="string">Source</name>
                <table class="string">${table}</table>
                <display-name class="string">source</display-name>
        </property>

3). Restart tomcat service.