[cisco-voip] Unity SQL questions

[Robert Singleton]

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