<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Stephen is going in the right direction with data dictionary:<br>
<a class="moz-txt-link-freetext" href="http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_programming_reference_guides_list.html">http://www.cisco.com/en/US/products/sw/voicesw/ps556/products_programming_reference_guides_list.html</a><br>
<br>
For devices with users currently logged in you can use
device.logintime. From the data dictionary:<br>
Remarks: When the user logged in. This is a time_t value stored as a
long. Set by the Login stored procedure.<br>
<br>
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.<br>
<br>
/Wes<br>
<br>
<br>
<a class="moz-txt-link-abbreviated" href="mailto:stephen.welsh@unifiedfx.com">stephen.welsh@unifiedfx.com</a> wrote:
<blockquote
style="border: medium none ! important; padding-left: 0px ! important; padding-right: 0px ! important; margin-left: 0px ! important; margin-right: 0px ! important;"
cite="mid:3CAFF85B-783C-449F-91A9-110F3F99B6CF@unifiedfx.com"
type="cite"><base href="x-msg://315/">Hi Rebecca,
<div><br>
</div>
<div>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.</div>
<div>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.</div>
<div><br>
</div>
<div>So how do you get the RISPort time stamp, you may be thinking....</div>
<div><br>
</div>
<div>PhoneView from Unified FX (<a moz-do-not-send="true"
href="http://www.unifiedfx.com">http://www.unifiedfx.com</a>), 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.</div>
<div><br>
</div>
<div>I've attached a sample CSV of the export produced by PhoneView,
to give you an idea of the data available.</div>
<div><br>
</div>
<div>Thanks</div>
<div><br>
</div>
<div>Stephen</div>
<pre wrap="">
<hr size="4" width="90%">
<base href="x-msg://315/"><div>
<div><div>On 28 Oct 2010, at 19:48, Corder, Rebecca J wrote:</div>
<blockquote
style="border: medium none ! important; padding-left: 0px ! important; padding-right: 0px ! important; margin-left: 0px ! important; margin-right: 0px ! important;"
type="cite"><div link="blue" vlink="purple" lang="EN-US"><div
class="WordSection1" style="page: WordSection1;"><div
style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri,sans-serif;">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?<o:p></o:p></div><div
style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri,sans-serif;"><o:p> </o:p></div><div
style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri,sans-serif;">Thanks.<o:p></o:p></div><div
style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri,sans-serif;"><o:p> </o:p></div><div
style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri,sans-serif;"><o:p> </o:p></div><div
style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri,sans-serif;"><b><span
style="font-size: 10pt; font-family: Arial,sans-serif;">Rebecca Corder<o:p></o:p></span></b></div><div
style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri,sans-serif;"><b><span
style="font-size: 10pt; font-family: Arial,sans-serif;">Telecommunications Team Lead<o:p></o:p></span></b></div><div
style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri,sans-serif;"><b><span
style="font-size: 10pt; font-family: Arial,sans-serif;">Bechtel Corporation<o:p></o:p></span></b></div><div
style="margin: 0in 0in 0.0001pt; font-size: 11pt; font-family: Calibri,sans-serif;"><o:p> </o:p></div></div>_______________________________________________
cisco-voip mailing list
<a moz-do-not-send="true" href="mailto:cisco-voip@puck.nether.net"
style="color: blue; text-decoration: underline;">cisco-voip@puck.nether.net</a>
<a moz-do-not-send="true"
href="https://puck.nether.net/mailman/listinfo/cisco-voip"
style="color: blue; text-decoration: underline;">https://puck.nether.net/mailman/listinfo/cisco-voip</a>
</div></blockquote></div>
</div><pre wrap="">
<hr size="4" width="90%">
_______________________________________________
cisco-voip mailing list
<a class="moz-txt-link-abbreviated" href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a>
<a class="moz-txt-link-freetext" href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</a>
</pre></pre>
</blockquote>
</body>
</html>