anish manikandan | 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 |
| Please sign in to flag this as inappropriate. |