Cisco Unified Presence 8.6(3) - Contact List Export?

[jledbett]

Is their a way to export the contact list (and custom groups) for each CUPC user?  I only see an import function in the BAT application for CUP.  

Thanks,

J.

[josh.l.anderson]

Did you ever work out a way to do this?

[jledbett]

No, didn't find anything and Cisco TAC didn't have anything. 

[josh.l.anderson · Accepted solution]

Not sure if you still need it or not, but if you run this SQL query from the Presence server SSH session, it will (hopefully) give you what you need in a format that is semi-friendly (maybe) to be imported back in via BAT (I've not tested it yet, but I according to the template, I think this is everything). If you are taking it somewhere other than BAT, hopefully this will get you started.

Make sure to substitute your domain where necessary.

SELECT enduser.userid AS UserID,'cisco.com' AS UserDomain,REPLACE(rosters.contact_jid, '@cisco.com', '') AS ContactID,'cisco.com' AS ContactDomain,rosters.nickname AS NickName,groups.group_name AS GroupName FROM rosters,enduser,OUTER groups WHERE (rosters.user_id = enduser.xcp_user_id) AND (rosters.roster_id = groups.roster_id)

This is a slightly simpler version if you are taking it somewhere else:

SELECT enduser.userid,rosters.contact_jid,rosters.nickname AS NickName,groups.group_name AS GroupName FROM rosters,enduser,OUTER groups WHERE (rosters.user_id = enduser.xcp_user_id) AND (rosters.roster_id = groups.roster_id)

Message was edited by: Joshua Anderson

[jledbett]

It does output the required information...much appreciated!  Thanks.