SQL insert enduser controlled profile

Version 1
    This document was generated from CDN thread

    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.