Administration XML Developer Forums

Combination View Flat View Tree View
Threads [ Previous | Next ]
Is it possible to look for the user associated with a given extension( telephone number or primary extension ) ???

Thank you.

Re: Primary Extension
Answer
8/20/08 3:52 PM as a reply to Jean-Francois Handfield.
Yes. The executeSQLQuery API can be used to do this. Send the following query to get the user name associated to a phone.

<sql>
select userid from enduser where pkid =
(select fkenduser from enduserdevicemap where fkdevice =
(select pkid from device where name = 'PHONE-NAME'));
</sql>

This will return the userid associated with the device PHONE-NAME

Re: Primary Extension
Answer
8/20/08 11:27 PM as a reply to Jean-Francois Handfield.
Thank you for your help! I'll give it a try and let you know the outcome.

Do you think you could help me out with my other question, the one about the PilotPoint members???

Thank you again