<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Verdana; font-size: 10pt; color: #000000'>With the help from someone off-list, I found another way (although one day I will have to simply give in and start using SQL)<br><ul><li>CDR Reports <br></li><li>User Reports > Bills > Department</li><li>click Search Users</li><li>enter the criteria and click Search</li></ul><p>This will provide the devices owned by that user.</p><p><br></p><p>Thanks <br></p><br><span><br><span name="x"></span>---<br>Lelio Fulgenzi, B.A.<br>Senior Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1<br>(519) 824-4120 x56354 (519) 767-1060 FAX (ANNU)<br>^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^<br>Cooking with unix is easy. You just sed it and forget it. <br> - LFJ (with apologies to Mr. Popeil)<br><span name="x"></span><br></span><br><hr id="zwchr"><b>From: </b>"Adam Frankel (afrankel)" <afrankel@cisco.com><br><b>To: </b>"Lelio Fulgenzi" <lelio@uoguelph.ca><br><b>Cc: </b>"Cisco VoIPoE List" <cisco-voip@puck.nether.net><br><b>Sent: </b>Wednesday, December 21, 2011 4:40:01 PM<br><b>Subject: </b>Re: [cisco-voip] Any way to find out what phone a user "owns" ?<br><br>
<div style="font-family:Arial;font-size:13px;"><font face="Arial">run
sql select pkid from enduser where userid = '<userid>'<br>
<br>
run sql select * from device where fkenduser </font>='<pkid
of userid>'<br>
<br>
<span style="color:#000000;" class="headerSpan"><br>
<hr><font style="font-size:x-small" face="Tahoma"><!--@A@--><b>From:</b>
Lelio Fulgenzi <a class="moz-txt-link-rfc2396E" href="mailto:lelio@uoguelph.ca" target="_blank"><lelio@uoguelph.ca></a><!--@A@--><br>
<!--@D@--><b>Sent:</b> Wed, Dec 21, 2011 4:18:51 PM<!--@D@--><br>
<!--@R@--><b>To:</b> Cisco VoIPoE List
<a class="moz-txt-link-rfc2396E" href="mailto:cisco-voip@puck.nether.net" target="_blank"><cisco-voip@puck.nether.net></a><!--@R@--><br>
<!--@C@--><b>CC:</b>
<!--@C@--><br>
<!--@S@--><b>Subject:</b> [cisco-voip] Any way to find out
what phone a user "owns" ?<!--@S@--><br>
</font><br>
</span>
<blockquote style="border: medium none ! important; padding-left:
0px ! important; padding-right: 0px ! important; margin-left:
0px ! important; margin-right: 0px ! important; font-family:
serif;" cite="mid:1797079105.529220.1324502331574.JavaMail.root@erie.cs.uoguelph.ca">
<style>p { margin: 0; }</style>
<div style="font-family: Verdana; font-size: 10pt; color:
#000000">Under phone configuration, you can select a user that
owns the phone.<br>
<br>
How do you find out which phone a user owns?<br>
<span><br>
<span></span>---<br>
Lelio Fulgenzi, B.A.<br>
Senior Analyst (CCS) * University of Guelph * Guelph,
Ontario N1G 2W1<br>
(519) 824-4120 x56354 (519) 767-1060 FAX (ANNU)<br>
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^<br>
Cooking with unix is easy. You just sed it and forget it. <br>
- LFJ (with apologies to Mr.
Popeil)<br>
<span></span><br>
</span><br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre>_______________________________________________
cisco-voip mailing list
<a class="moz-txt-link-abbreviated" href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a>
<a class="moz-txt-link-freetext" href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a>
</pre>
</blockquote>
<br>
</div>
</div></body></html>