Heads Up :
The post you are writing will appear in a public forum. Please ensure all content is appropriate for public consumption. Review the employee guidelines for the community here.
Created by: Michael Schmidt on 19-05-2013 04:26:11 PM Hi,
how can I set via SQL insert command an Endusers controlled profile?
I tried both of these SQL insert commands but controlled profile was not set.
- INSERT INTO enduserdevicemap (fkdevice, fkenduser, pkid, tkuserassociation) VALUES ('devicepkid','enduserpkid'), newid(), '1') - INSERT INTO enduserdevicemap (fkdevice, fkenduser, pkid, tkuserassociation) VALUES ('devicepkid','enduserpkid'), newid(), '4') BR Michael
Subject: RE: SQL insert enduser controlled profile Replied by: Martin Sloan on 20-05-2013 07:42:02 AM Hi Michael,
When I look at my device profile in that table the enum for tkuserassociation is set to 5. I didn't use a sql insert for mine though, I added it using 'updateUser->userid->phoneProfiles->profileName'. I would give emun 5 a shot or try the update user method if you're able.
Marty
Subject: RE: SQL insert enduser controlled profile Replied by: Michael Schmidt on 20-05-2013 08:30:40 AM Hi Marty, thank you. With value "5" it`s working 🙂 Rgd. to this thread "http://developer.cisco.com/web/axl/forums/-/message_boards/message/1741830" I tested value "4" which is not working. BR Michael
Subject: RE: SQL insert enduser controlled profile Replied by: Martin Sloan on 20-05-2013 09:16:47 AM Glad to hear it worked! I checked out the records in the typeuserassociation table and wouldn't have been able to say from looking at them which one would be correct for device profile but I guessed it was 5 since that's what mine had.
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community:
