<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">
<div>Hi Dave,</div>
<div><br>
</div>
<div>The "extensionmobilitydynamic" table holds that information, run the following from the UCM command line:</div>
<div><br>
</div>
<div>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</div>
<div><br>
</div>
<div>An example looks like this:</div>
<div><br>
</div>
<div>
<div>userid<span class="Apple-tab-span" style="white-space:pre"> </span>logintime</div>
<div>==================<span class="Apple-tab-span" style="white-space:pre"> </span>
=====================</div>
<div>stephen.welsh<span class="Apple-tab-span" style="white-space:pre"> </span>2013-04-26 13:28:07.0</div>
<div>david.williams<span class="Apple-tab-span" style="white-space:pre"> </span><span class="Apple-tab-span" style="white-space:pre"></span>2013-04-26 16:44:20.0</div>
</div>
<div><br>
</div>
<div>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.</div>
<div><br>
</div>
<div>However, I recommend you have a look at <b>PhoneView</b> from UnifiedFX (<a href="http://www.unifiedfx.com">http://www.unifiedfx.com</a>), 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.</div>
<div><br>
</div>
<div>
<div>Thanks</div>
<div><br>
<div>
<div>Stephen Welsh</div>
<div>CTO</div>
<br class="Apple-interchange-newline">
<img height="16" width="100" id="54f54e6c-0a33-44d8-b00c-3d1a02f0a7b8" apple-width="yes" apple-height="yes" src="cid:CBBF0493-235C-43D2-A874-9FB3D95AF598@b2.unifiedfx.com"></div>
</div>
</div>
<div><br>
</div>
<br>
<div>
<div>On 26 Apr 2013, at 17:38, Dave Wolgast <<a href="mailto:dwolgas1@rochester.rr.com">dwolgas1@rochester.rr.com</a>></div>
<div> wrote:</div>
<br class="Apple-interchange-newline">
<blockquote type="cite">
<div dir="ltr">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?
<div>
<div><br>
</div>
-- <br>
Dave Wolgast<br>
Livonia, NY </div>
</div>
_______________________________________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><br>
https://puck.nether.net/mailman/listinfo/cisco-voip<br>
</blockquote>
</div>
<br>
</body>
</html>