[cisco-voip] CUPS/CUPC last login?

[Stephen Welsh]

Hi Dave,

My bad missed the CUPC reference ;)

"extensionmobilitydynamic" will not apply in this case as the user is not logging in into the device, what you need is when CUPC is online and registered.

The closet thing you can do is use the Realtime Information Service data to obtain the last registration time, this can be queried using the following command form UCM CLI:

show risdb query phone

It can be exported to a file for parsing, unfortunately you will have to do this for each active subscriber and collate the information.

You can also use the RISPort API, William Bell has a good article on using this API to gather the above information:

http://www.netcraftsmen.net/component/content/article/70-unified-communications/499-identifying-the-correct-device-status-in-a-risport-response.html

Our product (PhoneView) also gathers RISPort information and includes a "timestamp" field in the export that is the latest date/time from RISPort, this in combination with the Status of the phone would allow you to get the registration time of all devices. However at this point in time we do not support CUPC as there is limited functionality for remote management of this soft endpoint. We will be adding support for the new DX650 so we could look at adding CUPC too.

This is obviously based on querying CUCM, there may be more relevant/valuable information directly from CUPS, details on the various API's for CUPS can be found here:

http://developer.cisco.com/web/cupapi/home

If you could share more about your requirement for tracking CUPC I may be able to provide more relevant feedback on getting the right information etc.
Given that you are referring to a presence enabled client using the presence information may provide a much richer dataset, for example keeping track of users available/busy state etc.

Thanks

Stephen

On 26 Apr 2013, at 19:29, Dave Wolgast <dwolgas1 at rochester.rr.com<mailto:dwolgas1 at rochester.rr.com>>
 wrote:

Thanks for the quick answer.

To make sure I have this correct, Cisco Unified Personal Communicator (CUPC) login data is stored in the CUCM database under the extensionmobilitydynamic table?

Thanks again!


On Fri, Apr 26, 2013 at 1:48 PM, Stephen Welsh <stephen.welsh at unifiedfx.com<mailto:stephen.welsh at unifiedfx.com>> wrote:
Hi Dave,

The "extensionmobilitydynamic" table holds that information, run the following from the UCM command line:

run sql SELECT eu.userid, DBINFO('utc_to_datetime', ed.logintime) AS logintime FROM extensionmobilitydynamic AS ed JOIN enduser AS eu ON ed.fkenduser = eu.pkid

An example looks like this:

userid logintime
================== =====================
stephen.welsh 2013-04-26 13:28:07.0
david.williams 2013-04-26 16:44:20.0

If you need to gather and export all that information, you will probably need to use something that interfaces with the AXL API on UCM, there is an AXL Plugin that has some sample code/application that you should be able to use.

However, I recommend you have a look at PhoneView from UnifiedFX (http://www.unifiedfx.com<http://www.unifiedfx.com/>), one of it's many features is the ability to gather key information about each phone and it's logged in user including the above information. This can be exported to a spreadsheet for further investigation or reporting.

Thanks

Stephen Welsh
CTO

[X]


On 26 Apr 2013, at 17:38, Dave Wolgast <dwolgas1 at rochester.rr.com<mailto:dwolgas1 at rochester.rr.com>>
 wrote:

Is there a query that can be run on either CUCM or the CUPS server that will list users with their last login time/date?

--
Dave Wolgast
Livonia, NY
_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net<mailto:cisco-voip at puck.nether.net>
https://puck.nether.net/mailman/listinfo/cisco-voip

--
Dave Wolgast
Livonia, NY

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20130426/434ce130/attachment.html>