Finding which ext are associated with which Mailbox

[planetmaker]

We really need to find out if an ext if associated with another mailbox(es)

Example. If a user leaves and the ext gets reassigned the ext is still listed as an alt ext with MWI.

The user inheriting the ext will still get MWI and have access to the mailbox for the team the original user had.

Or they may want voicemail for that ext but can’t as its already associated with another mailbox via an Alt Ext.

On unity 4 the was a tool that produced a text file that listed all mailboxes and their associated exts. However 4 was a windows box and I’m not sure if there is anything like that in unity 7.

To preempt this issue,  is there any way to dissassociate an ext from a mailbox if the ext becomes " free " or dissasociated from a profile?

[Rob Huffman · Accepted solution]

Hi PM,

I'm not sure if you are asking about Unity Connection 7 or Unity 7

If it is Unity Connection 7;

There is a perfect tool for this type of report. We have used this to search for the same info.

Connection  User Data Dump (CUDD) Tool

The Connection User Data Dump (CUDD) is a  Windows-based remote database administration tool available on the Cisco  Unity Tools website. CUDD allows you to export specific information  about users to a file that can be viewed or imported into another  application, such as a database utility or Microsoft Excel. When the  data is exported, the tool automatically creates a header row that lists  the data type found in each column of the output, for ease of import  into other programs.

The tool is available from the "Superb" Unity  Tools site;

http://www.ciscounitytools.com/Applications/CxN/UserDataDump/UserDataDump.html

From the  Help Notes;

Field Definitions

The following is a list of all the fields you can optionally have User Data Dump include in the CSV output. You can select one or as many items as you like.

• Address. Mailing address of user.
• Alias. The Exchange alias of the      user. 
• All      Alternate Extensions. All alternate      extensions (up to 9) defined for each user.  Columns for all 9 extensions will      be created, those that are not used for each user will simply be blank.
• All      Alternate MWI Strings. All      alternate MWI strings (up to 9) defined for each user.  Columns for all 9 alternate MWI      strings will be created, those that are not used for each user will simply      be blank.
• Base Notification Devices.  This outputs information about the      5 build in notification devices created for all users with mailboxes in      Connection.  It includes the      destination of the device (either a phone number or an email address) and      if each device is active or not (1 means active, 0 means disabled).  Selecting this option will add 10      columns to the output: HOME_PHONE_ACTIVE, HOME_PHONE_DESTINATION, WORK_PHONE_ACTIVE,      WORK_PHONE_DESTINATION, PAGER_ACTIVE,PAGER_DESTINATION, MOBILE_PHONE_ACTIVE,      MOBILE_PHONE_DESTINATION
• Billing      ID.  The billing Id value      for this user.  You’ll      find this on the Edit User Basics page for the user on the SA.
• Building. Building name of user.
• Busy Action. This value represents what Unity      Connection will offer the caller as options in the case the user’s      extension is busy.  A value of      “0” means no holding will be offered (i.e. the caller is sent      right to the user’s greeting).  A value of “1” means Unity Connection will always offer      to hold (the caller can always over ride that and go to the greeting,      however).  A value of      “2” means Unity Connection will ask the caller if they would      like to hold or not.  This      value can include the alternate, standard and closed transfer rule for      users.
• Caller Input Key Actions.  This value will dump out a human readable action string for each      of the 12 user input keys for all users.  Columns      “CALLER_INPUT_0” through “CALLER_INPUT_9”,      “CALLER_INPUT_*” and “CALLER_INPUT_#” will be      added to the output.  The      action strings for these columns will read like “Send to greeting      for call handler: operator”, or “Ignore”, or “Take      Message”.  The strings      will look very similar to what you see on the user input key page in the      SA.
• City.  City name for user.
• COS      Name. The display name of      the Class Of Service this user is associated with.
• Count of new voice messages in the last      24 hours. This value is the number of new voice messages that have come in from      the phone for the selected users in the last 24 hours.  The time User Data Dump is run      marks the end time and 24 hours prior marks the start time.  Note that this does not include      voice messages, receipts, faxes or other messages generated from the desk      top.  It’s a count only      of voice messages left via the phone interface.
• Count of new voice messages in the last      7 days. This value is the number of new voice messages that have come in      from the phone for the selected users in the last 7 days.  The time User Data Dump is run      marks the end time and 7 days prior marks the start time.  Note that this does not include      voice messages, receipts, faxes or other messages generated from the desk      top.  It’s a count only      of voice messages left via the phone interface.
• Country. Country name      for user.
• Date of user creation.  The date the user was added to the      Unity Connection system.
• Days till next PW change.  (Only      available in stand alone installation)  How many days are left till the user      will be required to change their phone password.  This field is blank if the user has      “Password never expires” on their PW policy page or if the      system wide password policy does not enforce password expirations.
• Default Playback Volume.  This will return “Medium” (default),      “Louder” or “Quieter” depending on what the      playback value is set to on the user’s messages page.
• Department. Department name for user.
• Display      Name. The display name property from Exchange.
• EMAIL Address (corporate email). For Connection 8.5 and later this      will include the corporate email address for users.  This is not the same as the SMTP      address available below which is specific to Connection.  The EMAIL Address is the address      where user’s get their external email sent.
• Employee ID.
• First      Name. The first name property from Exchange for this user.
• Greetings Enabled.  This value will show you if the closed, alternate, busy or      internal greetings are enabled for each user or not.  The columns      “GREETING_ALTERANATE_ACTIVE”,      “GREETING_BUSY_ACTIVE”, “GREETING_INTERNAL_ACTIVE”,      and “GREETING_CLOSED_ACTIVE” will be added to the output.  A value of “0” means      the greeting is not active and a value of “1” means it      is.  Remember that the standard      and error greetings are always active no matter what so they are not      included in the output here. 
• Language.  Outputs the MS NT standard 3      letter codes for languages.  ENU is US English, JPN is Japanese etc… I include a list of 3      letter language codes below.
• Last      Name. The last name property from Exchange for this user.
• List      In Directory.  Either 0 or      1.  0 means the user will not      be listed in the alpha directory where outside callers can find them by      spelling their name.  A 1      indicates they will be listed.
• Location      Name. The display name of      the location object this user is associated with.  In a multiple Unity Connection      server digital networking configuration this can be handy information.
• Mailbox deleted message count.  The total number of deleted      messages in the user’s inbox.  This applies only if the user is associated with a Class of Service      that copies deleted messages into the deleted items folder instead of      immediately purging them.
• Mailbox read message count.  The total number of messages that are      marked as read in the user’s inbox.
• Mailbox size (in bytes).  Total size in bytes of all messages in      the users inbox.
• Mailbox Warning Quota (in      bytes).  Maximum number of      bytes the user can have in their inbox before they will start getting a      warning each time they log in that their mailbox is “almost      full”
• Mailbox Send Quota (in      bytes).  Maximum number of bytes      the user can have in their inbox before they will no longer be allowed to      send new voicemail messages.
• Mailbox Send/Receive Quota (in      bytes).  Maximum number of      bytes the user can have in their inbox before they will not longer be      allowed to send or receive voicemail messages.
• Mailbox store name.  The name of the mailstore the      subscriber’s mailbox is stored on.
• Mailbox unread message count.  The total number of messages that are      marked unread (new) in the user’s inbox.
• Manager.
• Maximum      Message Length.  The      maximum length of messages (in seconds) that outside callers can leave      this user.
• Postal Code.
• Primary      Extension. The primary      extension number value from Unity Connection (i.e. the value you dial to      sign into your mailbox when calling in over the phone to check      messages).  This value is not      visible in the Exchange admin.
• Primary MWI Status.  Either 1 for “on” or 0 for “off”.  This is the status of the      user’s MWI as Unity Connection knows it (i.e. if we think      we’ve turned it on or off).
• Primary      MWI String. The number      configured on the MWI box on the messages page of the user.  By default the SA page shows      “X” which means to replace it with the extension number for      this user.  For this reason      it’s always a good idea to include the extension as well when you      want to see the MWI string.
• Public Distribution List Membership.  This will produce a single column that contains all the public      distribution lists that Unity Connection knows about that each users is a      member of.  The aliases of the      distribution lists will be separated by semicolons which looks something      like this “allusers;unaddressedmessages;marketingsouth”.
• Rings To Wait.  The number of rings to wait that are configured for the transfer      rule on the user. NOTE: If the transfer is disabled (i.e. the transfer      type above is “0”) or the transfer type is release (transfer      type is “1” above) then this value is meaningless and may show      up as “4” which is the default.  This value can include the      alternate, standard and closed transfer rule for users.
• Schedule      Name. The name of the      schedule this user is associated with.  The schedule determines when the      “standard” vs. “closed” greetings are played.
• Secure Message Setting. Setting pulled from the class of      service the subscriber is configured for.  The value is either      “Always” for always mark messages secure, “Never”      for never mark secure, “Ask” for ask the caller or      “Private” to set all private messages secure.
• Set      for First Time Enrollment.  Either      0 or 1.  0 means the user is no      longer flagged for first time enrollment, a 1 means they are.  Typically an administrator will set      everyone up for first time enrollment and when they call in and go through      the enrollment this flag is set to 0.  This can be a handy way of telling who has not yet setup their      mailbox so admins can go by and gently remind users they need to do this.
• SMTP Address (Connection specific).  The internal SMTP Address used by      Connection for message delivery.
• State.  State name for user.
• Switch      Name. This value indicates      which switch a user is associated with in a multiple switch      installation. 
• Time      of Last Call. Indicates      the date and time the user called in to check messages last.  This can be handy for finding out      which boxes have not been access at all or which ones have not been      accessed in a long time.  This      value is in GMT and not your local time, keep that in mind.
• Title. User’s title.
• Touchtone conversation name.  The name of the touchtone subscriber      conversation will be included in this field.  “SubMenu” is the      default (standard) conversation, “SubMenu_AlternateN” is the      Alternate N conversation and so on.  All users have a touchtone conversation style even if they are      configured to use the voice recognition input style.
• Transfer Number. This will be the dial string      configured for the transfer rules of a user.  This value will include the      alternate, standard and closed transfer rule for users.
• Transfer Numbers All Pass Restriction Table Rules.  Transfer numbers may be out of      compliance with the restriction table patterns for the transfer      restriction table associated with a user’s COS.  In some cases this may be OK (for      instance a site using a help desk model where users are not allowed to set      their own transfer numbers but administrators are).  In other cases it may be that a      restriction table was edited after users made changes to their transfer      numbers via the phone or the web interfaces.  Either way, this column will have a      “1” if ALL the transfer numbers pass the subscriber’s      transfer restriction table and “0” if one or more of them      mail.
• Transfer Type.  This will be “-1” if the transfer rule is disabled,      “0” if it’s enabled but the rule is set to go to the      greeting and not ring a phone, “1” if it’s configured to      do a release transfer or “2” if it’s configured for a      supervised transfer or “99” if this transfer rule is      configured to launch the personal call transfer rules (PCTR) for the      subscriber. This value can include the alternate, standard and closed      transfer rule for users.
• User Lockout Status.  (Only      available in stand alone installation)  Either 0 for “not locked out” or 1 for “locked      out”.  This indicates if      Unity Connection has locked a users account as a result of too many login      failures over the phone.
• Voice Name Recorded.  This will return a “1” if the user has a voice name      recorded or a “0” if they do not.
• Voice recognition input style being used.  If the user is configured to use VUI this field will output a      “1”, otherwise it’s “0”

Requirements/Special  Notes

This  version of User Data Dump runs on Windows XP/2000/2003 or Vista.

***This  version of User Data Dump only works with Unity Connection 7.0(1) or  later.

Hope this  helps!

Rob

[planetmaker]

You, Sir, are the man !!

Yes it is Unity Connection.

I've not tried it yet but it would appear to be just what I want !!

Thnaks!

[Rob Huffman]

Hi PM,

Good stuff my friend, you are most welcome

Just in case you haven't checked out these other great UC Tools;

Connection 7.1(1) Training Material

http://www.ciscounitytools.com/Training/Connection/CUC7_11.html

Audiotext Manager for Connection

http://www.ciscounitytools.com/Applications/CxN/ATM/ATM.html

Connection 8.0(1) Training Material

http://www.ciscounitytools.com/Training/Connection/CUC8_01.html

Port Status Remote Monitor for Connection (rPSM)

http://www.ciscounitytools.com/Applications/CxN/PortStatusMonitorCUC7x/PortStatusMonitorCUC7x.html

Cheers!

Rob

[planetmaker]

Certainly will, I've already checked the other downloads on the site and you are quite right - "superb"

Thanks again !

[Kapil Atrish]

Excellent stuff Rob. I was looking for something similar for Unity connection. I saw your post and it made my day.

Thanks a ton,

inner_silence