how do I check if a specific field is in the Spectrum reporting database?

Products

• CA Spectrum

Issue/Introduction

I am currently using the SRMDBAPI to create custom reports, as the schema is published by CA.  This is useful to know what fields exist in which tables.

 

How can I find out what fields exist in which tables, in Spectrum reporting database?

Is it possible toprint the schema for the reporting db?

Environment

Any mySQL database, which in Spectrum includes the reporting and the ddmdb, among others.This full list of MySQL databases can be gotten via MySQL as follows:mysql> show databases;+--------------------+| Database |+--------------------+| information_schema || archive || ddmdb || eh_integ || mibtools || mysql || netqos_integ || performance_schema || reporting || srmdbapi |+--------------------+10 rows in set (0.00 sec)

Resolution

A schema only dump of the reporting database can be gotten, with the following command:

mysqldump -d -uroot -proot reporting reportingSchema.txt

The "-d" switch ensure that only the schema, is published and no data gets dumped.

 

 

Additional Information

Please reference the "Inventory of SRMDBAPI Views" of the documentation for more information.