marcog
Consultant

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

0 Kudos
5 Replies
mfranz
Shining star

Re: How to change visibility of a custom report

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

Softline Group is Europe's leading independent expert in Software Asset Management.
marcog
Consultant

Re: How to change visibility of a custom report

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?

0 Kudos
mfranz
Shining star

Re: How to change visibility of a custom report

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

Softline Group is Europe's leading independent expert in Software Asset Management.
marcog
Consultant

Re: How to change visibility of a custom report

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