CUCM SQL question

[Bekzod Fakhriddinov]

Hi,

is there a way to do run sql select .... and show only first 5 or 10 lines ? Is there way to send break  when SQL select is running ?

Thank you 

[Jaime Valencia]

run sql "whatever query you want" limit X

[Bekzod Fakhriddinov]

nope it didn't work, also i tried with fecth command it didnt work too :( .. looks like its not clean postgresql ? 

example: run sql select name,description,tkmodel from device limit 5 

A syntax error has occurred.

admin:run sql select name,description,tkmodel,tkdeviceprotocol,fkdevicepool, fkenduser from device where name like 'SEP%' and fkenduser IS NULL limit 5
A syntax error has occurred.

[Jaime Valencia]

Works fine for me on 12.0

admin:run sql select name,description,tkmodel from device limit 5
name description tkmodel
============================================== ============================================= =======
Sample Device Template with TAG usage examples #FirstName# #LastName# (#Product# #Protocol#) 645
Auto-registration Template #FirstName# #LastName# (#Product# #Protocol#) 645
MTP_2 MTP_CUCM11PUB 110
CFB_2 CFB_CUCM11PUB 50
ANN_2 ANN_CUCM11PUB 126

[Bekzod Fakhriddinov]

ok, I know why, I read earlier that limit command works on ur , because i have v10.5 and my sql is old may not support that command, unfortunately. 

I know its for different topic but you know the answer and u can help : 

 is un-checking "Trace On" option under IM&P Serviceability for XCP services will cause any service interruption ?   DO i need to restart XCP router? 

jabberd with xcp config manager is eating Vmemory 95% :( .