cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

How to change visibility of a custom report

I have some custom reports created through sql script on FNMSCompliance database.

But this is coming out with public visibility, while I'd like to have the possibility to change is to private.

Is it possible to change something, also at db level, to make it private?

Thanks

(5) Replies
mfranz
By Level 17 Champion
Level 17 Champion

Hi,

Check out the table ComplianceSavedSearch:

SELECT *
FROM ComplianceSavedSearch

There's the column RestrictedAccessTypeID, which refers to these values:

2021-03-08_16h25_02.png

The column just before that referes to the creating operator and therefore who can see the report when private.

Best regards,

Markward

This is interesting but does FNMS share users with its db? I mean, the report is created using an SQL script, so, can the user running scripts be considered the creator also on the web UI?

Hi,

No, it looks like custom SQL-based reports do not get a CreatedByOperatorID by default. There's no option in the procedure:

2021-03-08_16h43_23.png

So you'll have to change it after creating the report.

Best regards,

Markward

Does this mean that in this case I cannot set 2?

I think you should be able to set 2, but also make sure to identify the ID for the oprator who should "own" the report and then update that field as well.