cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

Cisco Community Designated VIP Class of 2020

665
Views
0
Helpful
1
Replies
Highlighted
Beginner

CUCM SQL Query for MAC Address and Device Pool

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

Everyone's tags (3)
1 REPLY 1
VIP Rising star

Hey 

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

CreatePlease to create content
Content for Community-Ad
FusionCharts will render here