Can we move all our Global reports to Groups/Users

[tejapolaki]

We have around 2000 reports marked as global and visible to everyone which shouldn't be, planning to clean this and move reports to system groups/users accordingly. Is there a way we can do this task through mass edit or using a script as doing 2000 reports individually is time consuming.

Any advise would be grateful.

Thanks in Advance.

[gupta_vipul013 · Accepted solution]

Hi Teja,

Yes we can do that.

There are two tables, in which all report data related to sharing stores.

1. Report [sys_report]

2. Report users and Groups [sys_report_users_groups]

And there are three types of sharing:

1. Me

2. Everyone - here we can define Roles also.

3. Groups and Users

Now, there is an field USER in the REPORT table.

1. If the type of sharing is ME then this field contains the SYS_ID of that particular user.

2. If the type of sharing is Everyone then the value of this field is GLOBAL. And if user defines the specific ROLE, then this value will store in the ROLES field of the same(REPORT[sys_report]) table.

3. If the type of sharing is Group and Users, then the values of groups and roles are stores in the Report users and Groups [sys_report_users_groups] table.

        a. GROUP ID field of this table refer to the Groups [sys_user_group] table.

        b. REPORT ID field of this table refer to the Reports [sys_report] table.

        c. USER ID field of this table refer to the   Users [sys_user] table.

I'm sure, this information helps you a lot. You can use DATA LOAD to insert/modify the above fields of the mentioned tables.

In case of any concern, please let me know.

Regards,

Vipul Gupta

[tejapolaki]

Thank you...

We are able to move