• Lock down reporter in Webportal

    Hello, Does anyone have instructions or can lead me on how to lock down reporter? Here are some things we would like to consider doing.

    • Remove the "New Report" button
    • Hide tables to choose for reports
    • Hide columns to select in a table for …
  • Creating a report / Maximal member count of a Group (ADSGroup, AADGroup) in last month

    Hi there, is there an OOTB functionality to set a report of the historical group memberships?

    We have customers who receive a monthly invoice. The quantities are calculated based on the memberships in AD or AAD groups, specifically the maximum number from…

  • How to insert a quantitative report created in the Report Editor to be viewed within the portal?


    I created a quantitative report within the Report Editor, I would like to view it through the Web Portal, I created this report based on "VI_ITShop_Orders", customizing the search parameters, is there any way to do this?

    When trying to…

  • Quantitative reports on the portal


    I would like help with a question, I need it to be possible for the user to generate a report on the portal with the number of requests approved by a certain area, only with the total number of requests, without descriptions of who requested what…

  • Why is a custom report empty when scheduled but filled when downloaded on the spot?

    Hi there,

    One Identity - Identity Manager 8.2.

    I created a custom report with the report editor. My problem is: when I try to download the report from web portal clicking on "Get the report now", everything works great (see next two pictures):…

  • How to rename columns in Simple List Report?

    Hi there,

    In IM 8.2 I have created a report in the Manager using the simple list report mode. The report is the following:

    <DatabaseExportDefinition BaseTable="PersonWantsOrg">
      <WhereClause>OrderState = 'Assigned'</WhereClause>

  • Issue with attribute in VI_Person_Overview_With_History report


    we are trying to use the VI_Person_Overview_With_History default report in the Report Editor. The problem is the condition under Display_UNSAccountDisplay_cn.

    {If(String.IsNullOrEmpty(UNSAccount.Data_CanonicalName),UNSAccount.Display, UNSAccount.Data_CanonicalName…

  • How to make a report created in the Report Editor available in the Simple List Report?


    In One Identity Manager 8.2.1 I have created a report in the Report Editor, and I want to make it avaible in the Simple List Report view of the Web Portal.

    I've tried to add it from the Manager, as shown below:

    Then, I assigned the report to…

  • Identity Manager DGE Activity Reports

    Hi everyone,

    I'm currentry trying to configure and display the Account Activity and Resource Activity reports in the Data Governance Edition for the following host types:

    1. DFS host

    2. Remote Windows Server (Resource Activity Report non available…

  • Report: How to get the Affected Objects view of a JobQueue in a sql query?


    What I want is to do a report of the frozen jobs in the Job Queue. If I go on a frozen job I can see the name of the affected objects thanks to the view "Affected Objects", is there a way to retrieve the data seen there thanks to sql request so…

  • Report built in webportal with a new column header


    Can someone tell me if there is a way to change the column header to have another name other than the technical name or display name in a report?

    I built the report in webportal then can see it in Manager. Was wondering if there is anyway to change…

  • Create report of password change attempts

    Hello Community,

    I need to create a report on password change attempts. Is there a table that collects password change attempts?

  • Analyzer functionalities for RBAC system

    Hi everyone,

    I need to implement an RBAC system with dynamic roles and I am using the Analyzer tool for the analysis. The version of 1IM is 8.1.5.

    I have some questions about the Analyzer functionalities.

    1. Is it possible to export a report with the…

  • Create report with two related tables


    You would need to create a report in which you relate the Person table and the PersonPasswordHistory table to the common field UID_Person.

    So that the report shows me the password changes along with the name and surname.

    How can i configure this…

  • Load stored PDF in Web Designer

    Hello everyone!

    We have one particular problem in our One identity environment 8.1. All editions that we make into our custom report for an attestation case don't apply to the report on a web portal.

    When I use Report editor I can see that all my…

  • Report for historical assignments and table UNSAccountInUNSGroup

    The standard report VI_Person_Overview_With_History show amongst other things historical assignments of UNSAccounts ang UNSGroups, with name of UNSGroup and assigned from and assigned until time, using CreationTime and DeletionTime. I would also like…

  • List of Users for UNSGroup (AD Domain Admins) and Report

    Hello - We're trying to find an OOB report or potentially create one that simply reports and lists all the current members of a specific UNSGroup.  To start, we're looking at our AD Domain Admins group and want to be able to create a PDF report to…

  • Passing parameters from process to report

    Hi Community

    I have a custom report. Four parameters are defined to run the query but two of them are customizable by the user while the other two are variable and their value can be assigned only by the process (from example RPS_RPSSubscription_Send_Report…

  • How to handle 500k rows of data in one Report

    I am attempting to export a report in Report Editor that contains a huge amount of data(500K rows) and would like to export the report in excel/csv.
    Version is 8.0 and the erro which I get is System.IndexOutOfRangeException: Index was outside the bounds…

  • Attestor-specific report as message body

    We currently have a attestor notification process that:

    1. Identifies an attestor with pending attestation approvals
    2. Executes a script to generate a message body containing a summary table of number of pending approvals per policy for the attestor
    3. Sends…
  • How to export report to xlsx format without having headers again and again


    I want to export the port to XLSX format via process and so I have added the export format parameter as "XLSX" but the report is having headers again and again. How to avoid this?

  • problem subscribing reports

    Hi all

    I'm trying to subscribe to some reports from web portal --> settings --> subscriptions,  but as I press the button "Add Subscription", I get the following error message:

    "Error while loading the collection RPSReport in VI_MyData_PersonalData_RPSControlRef2…

  • How to send subscribable report in xls format as an attachment in mail?


    I have created a process which sends an email with report as an attachment. While configuring mail, I have kept the format "mail template, report in attachment" and provided report in report parameter set. But here it is sending an email with report…

  • Error occurs when checking report from web portal


    we have created custom report of system role and input parameter required is UID_Eset and for the web portal we have created custom page to select UID_Eset and display this report. We are able to select and view this report in Manager tool but in…

  • Ho can we make Craeted Rports avilablein One Idm Portal so user can request for it

    Is there any way to create Reports via Report tool and make it avilable in User Portal ,so they can be requested  via User  Portal .Is there any way for it.

    PLease help me..