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

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?

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)

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: