[cisco-voip] Extension Mobility Report

[Wes Sisk]

Stephen is going in the right direction with data dictionary:
http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_programming_reference_guides_list.html

For devices with users currently logged in you can use 
device.logintime.  From the data dictionary:
Remarks: When the user logged in. This is a time_t value stored as a 
long. Set by the Login stored procedure.

Looks like this may be reorganized in CM8.0.  These are not intended to 
be complete instructions but rather a pointer to how to find the 
information.

/Wes


stephen.welsh at unifiedfx.com wrote:
> Hi Rebecca,
>
> I'm not sure if this is possible to extract from the UCM database, I 
> don't believe UCM records data on the login event, however the RISPort 
> API does provide a timestamp on the last 'registration' event. I did 
> some testing in the past, and generally when a user logs in/out, the 
> phone re-registers (in order to get the line information etc.), which 
> causes the RISPort timestamp to be updated.
> So you can use the RISPort timestamp as the login/out time, but if a 
> network event has happened since the user logged in/out, that would 
> also update the timestamp, so I would not trust it 100%, but it would 
> be a good indication.
>
> So how do you get the RISPort time stamp, you may be thinking....
>
> PhoneView from Unified FX (http://www.unifiedfx.com), among other 
> things keeps assest and state management information, that includes 
> logged in user details, as well as the RISPort timestamp. So if you do 
> a File->export and save the phone data to a CSV file, you have a list 
> of all the phones with their user and timestamp (login time), but keep 
> in-mind the login time will not be 100% correct if there has been a 
> network event that caused the phone to re-register etc.
>
> I've attached a sample CSV of the export produced by PhoneView, to 
> give you an idea of the data available.
>
> Thanks
>
> Stephen
> ------------------------------------------------------------------------
>
> On 28 Oct 2010, at 19:48, Corder, Rebecca J wrote:
>> Is there a way to run a report of what time a group of users (or all 
>> users in the CUCM environment) has logged in to their phones? I know 
>> you can go to the phone and look to see an individual's status but 
>> can I pull that status in a report for a group of people, I not all?
>>  
>> Thanks.
>>  
>>  
>> *Rebecca Corder*
>> *Telecommunications Team Lead*
>> *Bechtel Corporation*
>>  
>> _______________________________________________ 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 
> ------------------------------------------------------------------------
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20101029/bf8f1267/attachment.html>