02-21-2012 12:42 PM - edited 03-19-2019 04:27 AM
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.
Solved! Go to Solution.
03-13-2012 02:56 PM
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
03-13-2012 11:53 AM
Did you ever work out a way to do this?
03-13-2012 12:54 PM
No, didn't find anything and Cisco TAC didn't have anything.
03-13-2012 02:56 PM
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
03-14-2012 11:45 AM
It does output the required information...much appreciated! Thanks.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide