Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

CUPC contact SQL insert

Has anyone used the following command to populate a users contacts? Just wondering if I need to include all of the table fields (i.e., index,displayonphone,iscup,isblocked).

Get user pkid:

run sql select pkid from enduser where userid='Enduser ID'

Get fkepascontactgroup:

run sql select * from epascontacts where fkenduser_owner = 'pkid'

Insert new contact:

run sql insert into epascontacts (fkenduser_owner,fkepascontactgroup,buddy) values 'pkid','fkepascontactgroup','buddy'

307
Views
0
Helpful
0
Replies