exporting group with contacts

[Guest]

I'm using 5.5 with Exporter Pro 1.0B. (which rocks by the way)

I have an AD group comprised primarily of contacts. I need to export a list of the group members and the email addresses of those members.

Individually, I can export the memberships of all AD groups and I can export all of my contacts. I just can't seem to get them to work together.

Any help would be greatly appreciated.
Thanks.

[cmccullough]

Re: exporting group with contacts

Can you give more details on what you are doing, and what is not happening the way you want?

I tested just now using the Active Directory Group Members export, and a group that I have with Contacts in it exported correctly.

[Guest]

Re: exporting group with contacts

I can't seem to figure out a way to export the group membership and list the email addresses of each of the group members.

Using the Group Members query and checking the "Export Group Members" box I can get all of the members (even the ones that are contacts) but I cant figure out how to include the contacts email addresses in the report. Selecting the mail attribute will give me the email address og the group, but that's not what I'm looking for.

Thanks for your help on this.

[kstanush]

Re: exporting group with contacts

You can do this, but its an advanced option that we have not documented. We found it virtually impossible to fit into the GUI.

First, you need Exporter 1.2, which is currently a beta, but we are done with it and may release it by the end of the week. To get it, send a blank email to [email protected]

Then, find the active directoryqueries.cfg file for your export, usually its found in the directory with stexport.exe. Edit this file with notepad

Find the section for the directory template that you are using to export the group members, and anywhere below the part with the name in brackets, ie [AD Group members], enter this:

GroupMemberAttributes=attribute,attribute,etc

The default attributes are distinguishedname,cn,displayname,description,objec tclass,samaccountname,useraccountcontrol,%IS_PRIMA RY%

If you want this, enter them (cut-and-paste from this post) and add your own attribute.

Let me know if this works (its advanced and tested only by me...)

Thanks for your help

[Guest]

Re: exporting group with contacts

It worked like a charm. In fact I tried that on 1.0b before getting the beta and it seems to have worked there too.

I've been using Hyena for about five years and never cease to be eager for the next release to see what cool new things you guys have stuffed in there.

THANKS! (as always)

[Guest]

Re: exporting group with contacts

I find this very interesting but can't seem to figure out exactly where and what belongs, would you provid an example. Here is my config file...


[Detailed User]
Enabled=0
OutputFileName=ad_users.txt
Level=1
Filter=1
Attributes=%OBJECT_PATH%,%OBJECT_NAME%,name,displa yname,scriptpath,profilepath,homedrive,homedirecto ry,comment,description,employeeid,pwdlastset,userw orkstations,accountexpires,use raccountcontrol,lockouttime,samaccountname
GetUserGroups=0

[Containers/OUs]
Enabled=0
OutputFileName=ad_containers.txt
Level=1
Filter=10
Attributes=%OBJECT_PATH%,%OBJECT_NAME%,name,displa yname,adspath,objectcategory,objectclass

[Groups]
Enabled=0
OutputFileName=ad_groups.txt
Level=1
Filter=2
Attributes=%OBJECT_PATH%,%OBJECT_NAME%,adspath,nam e,description,grouptype,samaccountname
GetGroupMembers=0
GetUserGroups=1

[Computers]
Enabled=0
OutputFileName=ad_computers.txt
Level=1
Filter=6
Attributes=%OBJECT_PATH%,%OBJECT_NAME%,name,descri ption,displayname,dnshostname,operatingsystem,oper atingsystemservicepack,operatingsystemversion,sama ccountname,useraccountcontrol

[Group Members]
Enabled=0
OutputFileName=ad_group_members.txt
Level=1
Filter=2
GetGroupMembers=1
Attributes=%OBJECT_PATH%,%OBJECT_NAME%,adspath,nam e,description,grouptype,samaccountname
[User Group Membership]
Enabled=0
OutputFileName=ad_user_groups.txt
Level=1
Filter=1
GetUserGroups=1
Attributes=%OBJECT_PATH%,%OBJECT_NAME%,adspath,nam e,displayname


Thanks for the assistance.

[kstanush]

Re: exporting group with contacts

Modify this section, to look like this:

[Group Members]
Enabled=1
OutputFileName=ad_group_members.txt
Level=1
Filter=2
GetGroupMembers=1
Attributes=%OBJECT_PATH%,%OBJECT_NAME%,adspath,nam e,description,grouptype,samaccountname
GroupMemberAttributes=distinguishedname,cn,display name,description,objectclass,samaccountname,userac countcontrol,%IS_PRIMARY%

Make sure the lines don't wrap. You will need to modify the GroupMemberAttributes setting to add/remove the attributes for whatever else you want/don't want. I don't have an Exchange server up right now, but for example, if the attribute for email address is 'emailaddress' you would simply add it to this line.

Let me know if you have questions or problems.

[Guest]

Re: exporting group with contacts

I have modifed the following and have added the "mail" parameter to the line but I am not sure how to reap the benefits of this. I went to try to export it and received an error that exporter can only export computers, ou, printers, etc.

How would I generate this report? Thanks.

Dave

[kstanush]

Re: exporting group with contacts

When you select objects in Hyena to export, just select the OU(s) that the objects are in, not the individual objects themselves. We may add individual object exporting in the next Exporter Pro release, but its not really needed. Just select one or more OUs, then export the selected objects. Or, just run Exporter Pro directly and configure it however you want to.