CSV dump of all users in a group including users in nested groups - Enterprise Reporter Custom Reports - Enterprise Reporter Custom Reports - Dell Community

CSV dump of all users in a group including users in nested groups

Enterprise Reporter Custom Reports

Enterprise Reporter Custom Reports
Find, share and request custom reports you would like to see in Enterprise Reporter.

CSV dump of all users in a group including users in nested groups

This question has been answered by DELL-Aarti M

Hi, I'm looking for a report that has user and email addresses for all users in a group including nested groups members.

I almost got it but I was not able to clean the report from garbage.

The format needs to be a clean and simple two column report with headers. one column will have username (CN) and the second column will have its email.

No grouping or breaks, no title:

CN=Admin,CN=Users,DC=DOM1,DC=local  user@Dom1.local

Thank you!

Verified Answer
  • Hi there,

    I have created a custom report for you to try.

    Go to Report Manager and import the attached report under "My Report". I have attached a SQL statement which needs to be run on Enterprise Reporter database. Please make sure to backup your database.

    Link to download Report and SQL Statement is as follows:


    Let me know how it goes.

    Thanks,

    Aarti

All Replies
  • Hey There,

    I'm looking into this and will get back to you as soon as I can.


    Thanks,

    Aarti

  • Hi there,

    I have created a custom report for you to try.

    Go to Report Manager and import the attached report under "My Report". I have attached a SQL statement which needs to be run on Enterprise Reporter database. Please make sure to backup your database.

    Link to download Report and SQL Statement is as follows:


    Let me know how it goes.

    Thanks,

    Aarti