[cisco-voip] Unity SQL questions

Wes Sisk wsisk at cisco.com
Tue Apr 25 22:52:31 EDT 2006


Per Zelenka sitting next to me:

There are Subscriber Message Activity reports which you can run from
SAWeb in 4.x Unity .. only gotcha is that this is a per subscriber
report and not very easy to do in bulk.  If this is an Exchange
integration, they can simply go into Exchange System Manager, then down
to the Mailbox Store and sort by the Logon Time or Last Access Time to
see which mailboxes are idle for a long duration of time.. which I'm
assuming you could write a neat ASDIedit script to pull that info if
they really wanted to.  It may be a neat feature request for a tool in
Unity to do, but nothing exists in bulk for what the customer is looking
for at the moment.

/Wes

On Apr 20, 2006, at 4:35 PM, Robert Singleton wrote:

Hello!

I'm new to the list and I've been scanning through the archives. I have
learned two or three really valuable things in just a couple of hours.

What I have not yet found is some information that would help me
eliminate unused Unity accounts, and thus recover those license seats. I
have 571 of 590 configured licenses in use. Considering that these users
are distributed in about 45 stores in 4 states and that I'm not the only
person maintaining these systems, it is entirely possible that there may
be users in these stores that are no longer employed, but their Unity
account may not have been removed. It's also possible that employees may
have been replaced and newer users are using the older accounts, but
that's a different problem. :)

I am pretty comfortable querying the databases and have found a couple
of fields that *sound* like they would help, but in verifying some of
the data, it doesn't add up correctly.

One way I would think I could do this is to determine when a mailbox was
last accessed. If it's been a long time, I can investigate that user.

The TimeLastCall field in the Subscriber table seems to have the date
and time of the users last call to Unity, but I saw a user that I know
specifically has lots of VM traffic, but the TimeLastCall field in his
record showed a 2005 date.

I have also run queries on CDRs, looking for all extensions that called
Unity, then compared the user name in Unity and CCM that match that
extension against the employee list for that branch, but matching is
often problematic. Picture James Thomas Smith in HR's database, but it's
Tom Smith on the phone and JTSmith in Unity. Matches can be made, but...

Along the same line, is there an SQL way to see the dates of the
messages in Exchange? If the last time a user received or retrieved a
message was 6 months ago, does that user really need a mailbox?

Thanks in advance for any assistance anyone my provide!

Robert

_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip



More information about the cisco-voip mailing list