What table do I need to look at to find the MAC address of a phone device?

[maxavier99]

I would like to be able to pull the MAC address for an associated phone device based on the either the a phone number lookup or user lookup.  I've tried searching thru the Data Dictionary for the "MAC Address" but could not find the appropriate table with the required information.  Does anyone know what table has this data?

sample code:

$SQLstr.sql = "select first 10 device.ctiid, device.versionstamp, device.isactive, device.fkenduser, device.name, device.description, device.datetimeinserted, enduser.title, enduser.telephonenumber, enduser.status,

                        enduser.ocsprimaryuseraddress, enduser.discoveryuseridentity,

                        enduser.directoryuri, enduser.department, enduser.firstname, enduser.lastname, enduser.assocpc,

                        enduser.homephone, enduser.mailid, enduser.building, enduser.mobile, enduser.primarynodeid, enduser.site, enduser.nickname 

               from device, enduser, enduserdevicemap

               where device.pkid=enduserdevicemap.fkdevice and

            enduser.pkid=enduserdevicemap.fkenduser and enduser.discoveryuseridentity='mkellen@ad.sjm.com'"

Thanks

[npetrele]

The simplest way is to look up the phone name, if you're using phone names that are listed as SEP plus the MAC address. Just strip off the SEP and what's left is the MAC address.  If you're not using SEP+MAC names, let me know.

[Aaron Harrison]

Hi

There is no MAC address in the DB, that's why. Most hardware phones (as described by Nicholas) have the MAC in their device name, however softphones don't.

1. CIPC can use a laptop MAC, but this may not be the the actual MAC used at the network level (e.g. if it switched from w/less to wired)
2. Jabber etc typically use freeform text names
3. Etc.

So if you really need the MAC, you'll have to get it elsewhere. If you just need an ID, use the dev name...

Aaron

[maxavier99]

Thanks for the information. This has been very helpful.