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

book

Article ID: 207890

calendar_today

Updated On:

Products

CA Spectrum

Issue/Introduction

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. 

Environment

Release : 10.4

Component : Spectrum Core / SpectroSERVER

Resolution

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.