CUCM DB - Where is 'span to pc port' stored?

[Elliot Dierksen]

I have looked in the data dictionary and done a

run sql select * from device where name = 'SEPXXXX'

 but I am not seeing it. I think it is on an XML column, but that didn't show from platform CLI. Any ideas? I have both version 10.5 and 12.5 in play.

[Elliot Dierksen]

I think I found it.

run sql select fkdevice from devicexml4k where xml like '%<spanToPCPort>0</spanToPCPort>%'

 Anyplace else I should look?