0 votes

I use another product (being replaced by Adaxes) that creates a CSV file of users exported from AD. The CSV is then imported to a SQL Database where it is joined with other data.

I am trying to replicate the report in Adaxes, but keep running into an error, "the number of diplayed columns is limited to 20" and I need to export 20 fields. I guess I understand the 20 columns may be to maintain performance for an interactive display, but this is really only needed for export.

I tried to create a schedule and add the columns in the scheduled job but have the same issue.

Is there something simple I am missing? Is this a hard limitation of Adaxes?

by (40 points)

1 Answer

0 votes
by (270k points)

Hello Shawn,

This is a hardcoded limitation in Adaxes for reports. There is no way to have a report with more than 20 columns in it in Adaxes. As an option, you can use a script to create the CSV file. For an example, have a look at the following script from our repository: https://www.adaxes.com/script-repository/export-user-properties-to-csv-file-s623.htm.

0

The script itself works well, thank you. I am new to Adaxes and have a basic understanding of Powershell. I am trying to limit the scope to all users in a specific OU and all users in the subtree. I am going to work on figuring it out, but if you have any suggestions, that would be great.

0

Hello,

To achieve the desired, use Script 2: Export properties of all users from the article in a scheduled task configured for the Organizational Unit object type. Make sure for the Activity Scope to include the OU itself, not the entire subtree. image.png

0

Thank you. I had tried that, but I am still getting all results. It isn't critical, getting the entire report running is better. I can filter out data in SQL.

image.png

This is running a query directly against AD, if I understand it correctly. One value I had in my other report was the OU the object existed in. When I look in AD the object canonical-name is listed, but that is a constructed value and there isn't a direct AD attribute that is easily accessible. I see Adaxes has a canonical-name that I can include in a standard report. Any suggestions on how to access that?

For example, if my object canonical-name is: domain.com/OU/SubOU1/SubOU1-2/Jack Brown

The other report gave me the OU of the object: domain.com/OU/SubOU1/SubOU1-2/J

The closest I can find in AD Attributes is the distinguishedName: CN=Jack Brown,OU=SbuOU1-2,OU=SubOU,OU=OU,DC=domain,DC=com

Thank you again for all the help.

0

Hello,

Sorry for the confusion, but we are not sure what report column you mean. As per our check, Canonical-Name (LDAP name canonicalName) is the only attribute that matches your reference. However, there is no attribute containing a user path without its name. That is something that can only be built explicitly in the script for each user.

0

So sorry! I was using "canonical-name" and simply fixing it without the "-" is collecting the user object in the better format. I will use that to get the OU object, that should be easy enough to just trim off the last "\" and any text after it.

Thank you for the help! I am all set.

Related questions

0 votes
1 answer

As the title says is it still a requirement?

asked Feb 23, 2023 by techg (320 points)
0 votes
1 answer

Hello, I would like to be able to limit the number of emails sent by a scheduled task in a specified time period. For example the scheduled task for password change reminder ... to have something that I can put on scheduled tasks to prevent this in the future.

asked Jun 12, 2015 by Infounlim (470 points)
0 votes
1 answer

Dear Support Admin Hi, I hope you are in good health. I have a problem regarding the office 365 license my problem is: I have a case where if HR adds a new AD user, ... Is that possible to do? for example using a script or display it in another form? Thank you

asked Mar 4, 2022 by systech (100 points)
0 votes
1 answer

Is it possible for the approval email to display the picture? I've been unable to find the configuration panel for this process. Attached is the message we receive.

asked Mar 2, 2020 by kcd (20 points)
0 votes
1 answer

Hi Version 2018.2.Update 1 Option is missing on View OrganizationalUnits Views Actions. It's there for ditto groups and users. Said in another way - the option is selected by default, leaving out the possibility NOT to display within a box. - Thanks

asked Nov 29, 2018 by Boxx.dk (2.6k points)
3,326 questions
3,026 answers
7,727 comments
544,681 users