Some users may experience issues accessing the case portal. For more information, please click here.

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

0 Kudos

This thread has been automatically locked due to inactivity.

To continue the discussion, please start a new thread.

5 Replies
mfranz
Level 16 Champion
Level 16 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

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

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

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.

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

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.

Softline Group is Europe's leading independent expert in Software Asset Management.
0 Kudos