Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

Unity Connection 8.6 - SQL query to list account creation time

Hello everyone.

My customer has asked for a listing of every user in their Unity Connection 8.6 system and the date that user account was created.  I'm thinking that using the subscriber alias and their mailbox creation time should do it.

While I'm not sure of the syntax, its been suggested that a SQL query might be able to search the user records and return for each user, the voicemail subscriber alias and the mailbox creation timestamp. This sounds exactly right but but I've no idea how to construct the required SQL query in a command form that I can paste into Unity Connection.

I had a search before posting but didn't really find anything relevant to this fairly obscure request. Can anyone suggests the commands that may be used from CLI on the Unity Connection server to accomplish this, please?

Thanks in advance.

Jonathan

1 ACCEPTED SOLUTION

Accepted Solutions
Hall of Fame Super Red

Re: Unity Connection 8.6 - SQL query to list account creation ti

Hi Jonathan,

You could use this great tool from the Unity Tools suite

Cisco User Data Dump

These are pre-canned Field definitions;

Date of user creation. The date the user was added to the Unity Connection system

Alias.

http://ciscounitytools.com/Applications/CxN/UserDataDump/Help/UserDataDump.htm#_Toc359835396

Cheers!

Rob

"Seek it out and ye shall find  " 

- OneRepublic

3 REPLIES
Hall of Fame Super Red

Re: Unity Connection 8.6 - SQL query to list account creation ti

Hi Jonathan,

You could use this great tool from the Unity Tools suite

Cisco User Data Dump

These are pre-canned Field definitions;

Date of user creation. The date the user was added to the Unity Connection system

Alias.

http://ciscounitytools.com/Applications/CxN/UserDataDump/Help/UserDataDump.htm#_Toc359835396

Cheers!

Rob

"Seek it out and ye shall find  " 

- OneRepublic

New Member

Unity Connection 8.6 - SQL query to list account creation time

Bingo!

Many thanks Rob.

Jonathan

Hall of Fame Super Red

Unity Connection 8.6 - SQL query to list account creation time

Hi Jonathan,

You are most welcome my friend! These are some of the best

Cisco Tools available to be sure

Cheers!

Rob

"Seek it out and ye shall find  " 

- OneRepublic

101
Views
0
Helpful
3
Replies
CreatePlease to create content