Reporting Database

CA Spectrum Report Manager uses a MySQL database to store data that is used in its reports. Consider the following points about the Reporting database:
casp102
CA Spectrum Report Manager uses a MySQL database to store data that is used in its reports. Consider the following points about the Reporting database:
  • If you install OneClick without installing Report Manager, a local MySQL database server is installed. This local database provides the Distributed Data Manager (DDM) database, the MIB Tools database, the eHealth integration database, and the Reporting database.
    For this installation, the Reporting database is used only to store Service Manager data. For more information, see SpectroSERVER and CA Spectrum Databases Overview.
  • If you include Report Manager with the OneClick installation, the Reporting database stores the Service Manager data. The database also stores the asset data and historical event and alarm data for reporting purposes.
    The asset data and historical event and alarm data must be stored in the MySQL instance that is on the OneClick web server. The data cannot be stored on a separate computer.
For more information, see the Install Report Manager section and the Report Manager section.