insert new record in " Device" table . CUCM 11.5 - SQL command

[Hamidsharifi6277]

Dears,

I want to add a new record in the "device" table in CUCM 11.5 by SQL command.

when I use the following SQL command to add my new record into the Device table I face the 430 output.

I use this format :

run sql insert into device(pkid,name,description,tkmodel,fkdevicepool,tkproduct,fkenduser,fksipprofile,fksecurityprofile,fkphonetemplate) values(newid(),'HTEST25','J4W TEST5-H',503,'131e-d3cg-6611-893409c032c9',390,'ed2c-0f7f-f4c4-80ac9624434f','8678-5fg9-59d9-af04e37cf3e0','a32c-4c5e-b3e1-8daf60e81594','a52c-4435-a4ec-540d266d8c40')

Could you help me to find a solution to add a new row in the Device table in Cisco CUCM by SQL command. ?

Thanks 

[Jaime Valencia]

Just don't, SQL is not meant to be used to configure and/or admin CUCM, you need to use either the CCMAdmin page or AXL.

[Hamidsharifi6277]

Thanks, Jaime,

Exactly I wanna use AXL to solve this issue but I need to find out the SQL Query that I can use for this.

I am writing a personal java user interface to prevent doing the repetitive tasks in my team.

Do you have any idea to add a new record in CUCM by SQL command or any other command-based method? 

Thanks