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…
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…
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…
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…
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.
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…
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…
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…
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):…
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…
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…
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…
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…
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…
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…
Hello Community,
I need to create a report on password change attempts. Is there a table that collects password change attempts?
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…
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…
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…
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…
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…
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…
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…
We currently have a attestor notification process that:
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?
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…