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?
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.
Please reference the "Inventory of SRMDBAPI Views" of the documentation for more information.