• Report Editor - Unable to export date format in excel

    We have created a simple report which had one column EndDate in the following format: dd/MM/yyyy. Even though the text format for the column has been selected correctly, the data after exporting it into an excel doesn´t reflect properly.

    It seems…

  • How to fetch the data from History DB?

    Hello,

    We are using version 9.0 LTS and we have installed History DB on the same server as One IM database. I am able to see the historical data in TimeTrace as I have configured Time trace database and added History DB in Time Trace DB. But, I want to…

  • How to check deleted reports in One Identity Manager

    Hello Experts,

    There are few reports which got deleted from prod environment. We are not able to figure out who has deleted these reports. Can you please let us know if there is any kind of data/log which gets stored in One Identity Manager so that we…

  • 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?

    Hello,

    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

    Hi,

    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>
      <Columns>
        <Column…

  • Issue with attribute in VI_Person_Overview_With_History report

    Hi,

    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?

    Hi,

    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?

    Hello,

    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

    Hello,

    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

    Hello,

    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

    Hi,

    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…