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:
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.