[cisco-voip] Any way to find out what phone a user "owns" ?

[Lelio Fulgenzi]

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) 

    • CDR Reports 
    • User Reports > Bills > Department 
    • click Search Users 
    • enter the criteria and click Search 



This will provide the devices owned by that user. 




Thanks 


--- 
Lelio Fulgenzi, B.A. 
Senior Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1 
(519) 824-4120 x56354 (519) 767-1060 FAX (ANNU) 
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 
Cooking with unix is easy. You just sed it and forget it. 
- LFJ (with apologies to Mr. Popeil) 


----- Original Message -----
From: "Adam Frankel (afrankel)" <afrankel at cisco.com> 
To: "Lelio Fulgenzi" <lelio at uoguelph.ca> 
Cc: "Cisco VoIPoE List" <cisco-voip at puck.nether.net> 
Sent: Wednesday, December 21, 2011 4:40:01 PM 
Subject: Re: [cisco-voip] Any way to find out what phone a user "owns" ? 


run sql select pkid from enduser where userid = '<userid>' 

run sql select * from device where fkenduser ='<pkid of userid>' 



From: Lelio Fulgenzi <lelio at uoguelph.ca> 
Sent: Wed, Dec 21, 2011 4:18:51 PM 
To: Cisco VoIPoE List <cisco-voip at puck.nether.net> 
CC: 
Subject: [cisco-voip] Any way to find out what phone a user "owns" ? 




Under phone configuration, you can select a user that owns the phone. 

How do you find out which phone a user owns? 

--- 
Lelio Fulgenzi, B.A. 
Senior Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1 
(519) 824-4120 x56354 (519) 767-1060 FAX (ANNU) 
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 
Cooking with unix is easy. You just sed it and forget it. 
- LFJ (with apologies to Mr. Popeil) 




_______________________________________________
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/20111221/58a73bf2/attachment.html>