How to determine the name of the Data Aggregator user for querying the Data Repository database

book

Article ID: 142957

calendar_today

Updated On:

Products

CA Infrastructure Management CA Performance Management - Usage and Administration CA Performance Management - Data Polling DX NetOps

Issue/Introduction

When querying the Data Repository it may be required to use the Data Aggregator user to make sure the correct schema is used for the queries.

Environment

Release : 3.7

Component : IM Reporting / Admin / Configuration

Resolution

The Data Aggregator user can be found in the  /opt/IMDataAggregator/apache-karaf-2.4.3/etc/dbconnection.cfg file as:

dbUser=<username>

For example:

dbUser=dauser

Additional Information

NOTE: Above uses the default installation path, your installation path may vary.