Adaxes

Reports with +1000 objects are truncated

0 votes

Hi,

I am running into an issue when running reports where the report/export will not return the full set of results. So, for example, if I wan to run a report to show all users of a specific OU and the group of users against which I am running the report is larger than 1000, any result past 1000 is omitted from both the displayed and exported results. How can I resolve this?

by (80 points)
0

Hello,

How do you generate the reports? Do you use a PowerShell script for this purpose? If so, can you post the script?

by (216k points)
0

SInce I don't see a report that produces a list of users for a given OU I am running the "All Users" report from the User report list under the Reports tab in the Web UI. I then export all results to CSV and filter out the OUs I don't need. For the specific report I am running, there will be more than 1000 users listed, even after filtering out the OUs I don't need, which is how I know the results are being truncated.

by (80 points)
0

Hello,

So, you export a report on all users in all your domains to a CSV file, and then filter it out manually somehow?

At what point do you get a truncate list of users - when generating the report in the Web Interface, or after export to a CSV file? Does the list get built correctly in the Web Interface?

by (216k points)
0

Yes, I run a report on all users (for a single domain), export to CSV, and then manipulate the list using Excel autofilter. The truncation occurs when generating the report in Web Interface before exporting to CSV. I don't think the list is building correctly in the Web UI.

by (80 points)
0

OK, we'll ask our team to investigate the issue. We'll update this topic as soon as they come up with something.

By the way, what version of Adaxes are you using?

by (216k points)
0

Thanks! We are currently running Adaxes 2013.1 version 3.5.9329.0 (64 bit).

by (80 points)
0

Hello,

Thanks, we'll pass the information to our QA team.

by (216k points)
0

Hello,

Unfortunately, our QA team cannot reproduce the issue. To help them with this, can you post here a screenshot where it would be clearly visible that a report got truncated at 1000 results? Alternatively, you can send the screenshot to our support email (adaxes[at]softerra.com).

by (216k points)
0

Hello,

We haven't received any screenshots from you yet. Can you resend them?

by (216k points)

1 Answer

0 votes
by (294k points)

Hello,

Starting with Adaxes 2018.1 you can create custom reports and modify the built-in ones. Also, there is no limit for the number of displayed items in reports. For details on how to create a report, see https://www.adaxes.com/tutorials_ActiveDirectoryManagement_CreateReport.htm.

Related questions

0 votes
1 answer
Objects are missing despite I am Service administrators

Hello, I cannot see all objects from the Adaxes Service Administration console and do not understand why. I log with a Service administrazors that have full access. There is no ... for this users and as far as I know no restriction. Thanks for your help.

asked Dec 11, 2019 by tentaal (1.1k points)
0 votes
1 answer
How to query managers with direct reports who have a specific attribute value

Ideally looking to make this a rule based group, but report or business unit should work also. In our domain, service accounts become direct reports of the user who requested/ ... if a specific object is a/not a direct report. Is this possible? Thank you

asked Nov 14, 2023 by ThompsonAlex (40 points)
0 votes
1 answer
Script that can set a true/false value for a user that is a People Leader (someone with direct reports).

We have the following script we need fixed to run within Adaxes to add true/false value to a customattribute for use in building dynamic distribution lists. $users = ... } else { Set-Mailbox -Identity $user.Name -CustomAttribute8 "Individual contributor" } }

asked Jul 13, 2022 by willy-wally (3.2k points)
0 votes
1 answer
Setup a report in Adaxes that shows all the objects with the Replicate Directory permissions

For security purposes, we need to audit the objects that are capable of replicating the directory. As we have a number of individuals that need this report, I would like to ... four domains and would like to see any objects with this permission in any of them

asked May 20, 2022 by jiambor (1.2k points)
0 votes
1 answer
Exchange Management: Error "Multiple objects with Sid S-1-5-10 were found"

Hello, we have a forest with two trees that hold one domain each. There is a default tree-root trust (transitive, two-way) between the top domains. Since both trees are in ... Sid S-1-5-10 were found". Any help would be appreciated, thank you! Regards HarryNew

asked Oct 8, 2020 by HarryNew (270 points)
3,588 questions
3,277 answers
8,303 comments
548,090 users