cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
497
Views
0
Helpful
3
Replies

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

maxavier99
Beginner
Beginner

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

3 Replies 3

npetrele
Cisco Employee
Cisco Employee

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.

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

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!

Thanks for the information. This has been very helpful.

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:

Recognize Your Peers