Exchange Export using Attribute

[Guest]

If I Right Click on a user and select Listing Views / User All I will see a property Name called dlMemSubmitPerms. How can I get just the User name and this attribute (dlMemSubmitPerms) into a spreadsheet? Thanks.

[kstanush]

Re: Exchange Export using Attribute

Click on the first toolbar button (File->Manage Object View), and modify either the default All Users or Container/OU query to include this attribute. You might have to manually enter this attribute in the bottom right corner of the screen as its a special-sort of attribute.

You can then just run the default (double-click) query for either All Users or your OU and you will see this attribute.

If you just want this attribute and maybe the cn of the account, create a new query and probably assign it to All Users.

Once you get the users displayed, do a Control-A, then Control-C to copy them to the clipboard, then Control-V into Excel.

Let me know if you need to know step-by-step how to do this.

[Guest]

Re: Exchange Export using Attribute

You might have to manually enter this attribute in the bottom right corner of the screen as its a special-sort of attribute.

Once I am in Object Manager Configuration I clicked on the AD Queries Tab and the Query Type is All Users. I then clicked on Users (Summary) to add the attribute. I can not find the attribute so if I want to manually enter this attribute; I can not find the area I type it into the bottom right corner as you stated. I am using the latest version 6.3.
Thank you very much for your help.

[Guest]

Re: Exchange Export using Attribute

I figured it out. Thanks for the info!!!

[kstanush]

Re: Exchange Export using Attribute

Sorry, I was going off memory and my memory added something that wasn't there. The method to add an attribute is not exactly documented, so how exactly did you add this attribute in Hyena to get it to appear ?

[Guest]

Re: Exchange Export using Attribute

This is how it worked. Thanks again.
File - Manage Object View.
AD Custom Tab
New at Bottom.
Attribute Directory Name: dlMemSubmitPerms
Display Title: dlMemSubmitPerms
Directory Data Type: ADSTYPE_CASE_EXACT_STRING (top)
Attribute Option: Multi-value attribute. OK
File - Manage Object View Again.
AD Queries Tab.
Users(Detailed-Contact) - or choose anyone you want to modify.
Under Attribute Category select User Attributes (default).
Scroll to find the new attribute you added - dlMemSubmitPerms
Add this attribute to query directory attributes. OK
Right Click on All users and select Tabular Views - Users(Detailed-Contact) or whatevery you added the attribute to.

The only problem is we have several users in the dlMemSubmitPerms attribute. What this attribute is: This attribute shows what users are allowed to send email to the particular user. We have about 10 users/groups who can do this. I wanted to run a query to make sure the right groups are in this field. When I run it I see 3 users because it does not only show the user but the FQDN of the user and where it is in AD seperated with a ^. After a certain number of characters it displays !!!. I guess it can not come up with all the info.

[kstanush]

Re: Exchange Export using Attribute

I'm glad to see that you figured out how to add an attribute, but I'm sorry that you ran into the length limitation. Hyena uses a standard Windows list control for its right window, and Windows limits the data to 255 characters for any given cell (column). If we try to put more into a cell, Windows will shut down the application. Hyena puts a ...! characters if it has to truncate the information.

There are two options that I can think of:

1. Exporter Pro, which comes with Hyena can export this information to a text file, which is not limited to how long something can be. Exporter Pro has an 'Other' text entry field where you just type in the attribute and add it to the export template. The easiest way to get the users information exported would be to select them in Hyena, then select Tools->Exporter Pro->Export Selected Objects, then either modify or create an export configuration with an AD template to have the information that you want. AFter that, just view the exported data in Excel.

2. Our next version of Hyena, v6.5 which should be available by the end of next week, has a new feature for viewing AD object attributes (and to modify them). While this new feature will not show the attributes in a tabular format, you can multi-select objects, select the attribute to view/update, and have a window where you can both see and update all of the values in an attribute. This window will show multi-valued attributes with a separate row for each value, so they are a bit easier to read. Let me know if you want to have a peak at v6.5 now.

[Guest]

Re: Exchange Export using Attribute

That would be great to see 6.5 now. We have been using Hyena forever. Our company has a 10 user license for it. Thanks!

[kstanush]

Re: Exchange Export using Attribute

OK, I've posted Hyena v6.5 to the site. Unless you find and report any problem, this same file will be the 'update' version of the Hyena v6.5 install.

The only reason that we have not officially released Hyena v6.5 now is that we are just waiting for the foreign language translations to be completed, as we like to release all language revisions at the same time.

To get Hyena v6.5 download:
http://www.systemtools.com/download/hyena65.zip

This is an update-only download, so its assumed that you already have Hyena v6.x installed, AND most importantly, you maintenance expiration date is AFTER July 1, 2005

Thanks in advance for any comments