CUCM SQL Query for MAC Address and Device Pool

[wicklinec]

Hi Everyone,

What I'm trying to do, is run a sql query against our CUCM server, to return a MAC address, as well as the device pool it is in. I am close, but I think I am missing one big part. My current query is this :

run sql select Devicepool.name,device.name from Devicepool inner join Device on Device.fkDevicepool=DevicePool.pkid

This works, except the devicename has the SEPxxxxx in front of the mac address. Is there a way to do a right() command, or run a seperate query that will return just the MAC address, as well as the Device Pool? 

Any help is greatly appreciated. Thanks!

Chris W

[HARIS_HUSSAIN]

Hey 

I tried with CUCM Data Dictionary but was unable to find the column name for MAC Address

https://developer.cisco.com/media/UCM10.5DataDictionary/UCM10.5DataDictionary.htm.

Also checked in CUCM Device Table table but unable to find the same.

May be someone with more expertise on CUCM SQL Queries can help