Exporting accounts with two sets of information

[Guest]

Hi, I need to export a list of all of our user accounts that have the letters "svc" in the username and the OU that they are in in Active Directory. This is my first time using this and having a hard time sorting through all the options...I would like to see the information on the "object" tab in AD. Thanks for your help.

[cmccullough]

Re: Exporting accounts with two sets of information

You'll have to export all users and then filter the output for the users you want using Excel or Access.

To export users you can click on your domain in Hyena, then go to Tools->Exporter Pro->Export Selected Objects. Click the Settings button, and then double-click on Detailed User and edit it's properties. Enable it for exporting, and in the lower right window find and add adspath. This will give you the full path like you see on the Object Tab.

Start that export and when finished you can open the output file with Excel or Access to filter for the users you are interested in.

[Guest]

Re: Exporting accounts with two sets of information

Ok, I started the export but it's pulling all the computer names. Is there also a way to filter out the computer names?

[kstanush]

Re: Exporting accounts with two sets of information

An alternate way to do this would be to add either the DN or ADsPath to the field for an AD query, and then use Hyena's filtering GUI to handle the restriction on the usernames.

To do this:

-Click the first toolbar button
-Click on the AD Queries tab
-Select the "All Users" query type and select one of the queries, for example, User (Detailed-General).
-Change the Attribute category to be General Directory Object Attributes
-Select either the DN or ADsPath attribute and add it to the query output fields. Move the output fields up in the list perhaps
-Close the Object Manager dialog.

Then, right click on All Users, select Tabular Views->and then select the name of the query that you added the DN/ADsPath fields to.

When you get a display, select the green filter toolbar button and type in what you want to find in the filter cell for either DN,ADsPath,or just username. If you mess up, just click the filtering button again and start over.

When you have what you want, Control-A, then Control-C to send the data to a file or the clipboard.

The OU will be part of the DN or ADsPath.

[Guest]

Re: Exporting accounts with two sets of information

thank you very much...