Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.

Enable all reports on all projects


Hi all,

is it possible to enable in one step (maybe a SQL script) all reports on all projects? I would really appreciate such a solution, as it would save me lots of time on walking manually through all projects.

Thx in advance Daniel

· 1
Replies (1)
not helpful

Sure, configure 1 project only and then copy it using SQL:

insert into geminireportsvisibility(reportid,reporttype, projectid, visibility, visibilitymembertype) select reportid,reporttype, p.projectid, visibility, visibilitymembertype from geminireportsvisibility r, gemini_projects p where r.projectid=your configured project id

Mark Wing
· 9108
Mark Wing