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

Document ID : KB000016765
Last Modified Date : 14/02/2018
Show Technical Document Details
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.

 

Question:

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)
Answer:

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: