SQL Query for identifying the Subscribed Cisco IP Phone Services for a particular device

[Adan Zuniga]

All,

I need to see if particular phones have 3 IP phone services configured "Extension Mobility Service", "Auto Agent Login" and "Agent Login". I tried the following statement, but this is not giving me the output that I expected. Can you please help? 

select d.description, d.tkphoneservicedisplay, ty.name, ty. moniker from device as d join typephoneservicedisplay as ty on d.tkphoneservicedisplay=ty.enum where d.name='SEPA0554F8D3538'

[Jaime Valencia]

This is the Video Over IP community, might want to move your post to IP Telephony or UC apps.

[Adan Zuniga]

Done. Thanks