This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Reference to Current User in Reports

Is there a way to add parameters to a report depending on the user that is running/subscribing to the report. So some logic like if 'user running the report' in business role x, show report for all department y?

0 Markus Weiss-Ehlers over 8 years ago

How to access the person that is running/subscribing to the report is demonstrated in some of the out-of-the-box reports.

The easiest is one of the empty template reports VI_Reporting_Template_Portrait_Params. Take a look at the parameter ReportScheduledBy, it uses a valuation script to define the value of the parameter.

If Provider.Contains("UID_Person") Then
Value = $UID_Person$
Else
Value = Connection.User.Uid
End If

You can use the content of the parameter in your report queries then.

There is also a forum post with a similar question that Google found. https://www.quest.com/community/products/one-identity/f/identity-manager/21129/report-on-personwantsorg-user-see-all-requests/58792

HtH