ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

How to determine the gc_rec_ID in the reporting database for a particular global collection.


Article ID: 207890


Updated On:


CA Spectrum


Looking to run scripts against the report manager database. The customer was looking to find out what gc_rec_id is associated with a global collection in the report manager database. 


Release : 10.4

Component : Spectrum Core / SpectroSERVER


You can get the gc_rec_id from the globalcollection table in the reporting database.

Connect to the reporting database using the following command:

./mysql --defaults-file=../my-spectrum.cnf

From the mysql prompt, run the following command:

select * from globalcollection;

This will show you the gc_rec_id and the globacollection name for each global collection in the reporting database.