cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
296
Views
0
Helpful
15
Replies
Highlighted
Beginner

Determining when the Unity voicemail password was changed last

I know that I can force users to change their voicemail password every so often. Is there a method to determine how old their voicemail password is?

15 REPLIES 15
Highlighted
Cisco Employee

Re: Determining when the Unity voicemail password was changed la

On a per-user basis, you can see the date of last change on a subscriber's Phone Password page in the SA.

Highlighted
Beginner

Re: Determining when the Unity voicemail password was changed la

Is there a method of creating a report for all users that would show this information?

Highlighted
Cisco Employee

Re: Determining when the Unity voicemail password was changed la

You could use sql query to check:

SELECT Alias, PwTimeChanged

FROM Subscriber

Note that the time shown in the table is GMT time (Central time is GMT - 6 hours)

Highlighted
Cisco Employee

Re: Determining when the Unity voicemail password was changed la

Be sure to use the view for queries (vw_Subscriber) and not the raw table (Subscriber) - items can (and do) move around the raw tables but the views remain backwards compaitble.

Also, I can add this to the Subscriber Information Dump tool that spits out a CSV if you want - it'd take me about 20 minutes. Subscriber Information Dump already kicks out the time of the last call and if the user has a trivial PW set and the like - this seems like a good addition to it.

Highlighted
Beginner

Re: Determining when the Unity voicemail password was changed la

That sounds great, Jeff. Would this work on Unity 2.4.6 as well as 4.x? We are currently using 2.4.6 but in the process of upgrading to 4 within the next month or two.

Highlighted
Beginner

Re: Determining when the Unity voicemail password was changed la

One additional question. Could the Subscriber Information Dump be set up in the Windows Scheduler to run periodically to generate said report?

Highlighted
Beginner

Re: Determining when the Unity voicemail password was changed la

That would be possible with Unity 4.x which we are currently upgrading to. Is there a way to check on Unity 2.4.6?

Highlighted
Cisco Employee

Re: Determining when the Unity voicemail password was changed la

2.x is a whole different ball of wax - I do have a version of Subscriber Information Dump that runs against 2.x but I haven't cracked that code in over a year now. There is no SQL DB to query against in 2.x, the information is packed into binary blobs added as properties into Exchange objects - fishing it out requires you go through the DOH interface - much (much) more painful than just querying SQL.

The 3.x/4.x version of SubInfoDUmp could be updated in about 20 minutes to update, package a new setup and post - the 2.x version would burn most of a day - unfortunately I don't have that type of time to burn just right now.

We haven't shipped or supported 2.x in quite some time - I guess my advice would be to expidite the upgrade to 4.x.

Highlighted
Beginner

Re: Determining when the Unity voicemail password was changed la

Thanks Jeff. That might be just the push I need to get this project moving along. I don't know if you saw my additional post, but could the 4.x version of SubInfoDump be run from Windows Scheduler or AT? Can you let me know when it's been updated?

Thanks again. I appreciate all you do.

Highlighted
Cisco Employee

Re: Determining when the Unity voicemail password was changed la

Subscriber Information Dump already supports a command line option that can be called from wherever - check out the help on it's home page:

http://www.ciscounitytools.com/APP_subr_info_dump_3x.htm

there's a section in there called "Silent Command Lnie Mode".

For notifications you can subscribe to the tools update mailer (go to www.CiscoUnityTools.com and follow the link for this). All updates to existing tools, new tools or updated documents on the site kick out a notificaiton to this mailer - that's the easiest way to keep up with what's going on with the site.

Highlighted
Beginner

Re: Determining when the Unity voicemail password was changed la

Thanks again, Jeff. I subscribed to the updates and am reviewing the help doc now.

Highlighted
Cisco Employee

Re: Determining when the Unity voicemail password was changed la

Just as a follow up on this - I finished the updates to the tool and it's in QA's hands for testing before I post it.

If you want a beta copy before then, ping me (lindborg at cisco dot com) and I'll shoot you a copy.

Highlighted
Beginner

Re: Determining when the Unity voicemail password was changed la

You are a gentleman and a scholar. Thanks Jeff.

Highlighted
Cisco Employee

Re: Determining when the Unity voicemail password was changed la

The updated tool is now posted on www.CiscoUnityTools.com.

enjoy

CreatePlease to create content
Content for Community-Ad

Cisco COVID-19 Survey