Export IMP (11.5) contact lists to csv via cli

[m.stolzenberg]

Hello Team,

I fond some older topics, that some contact stuff can be made via cli. E.g. deleting all the contacts.

Now I hope that there is a solution to export all contacts via CLI (same as I would use the bulk tool -> export) , so that I can import them to a new cluster via bulk.

Thanks

Marcus

[Nithin Eluvathingal]

 Exporting end user details from  CLI using SQL command  is possible. If you want to  import later i would suggest to use the Bulk export option.

2.12.0.0

2.12.0.0

[m.stolzenberg]

My problem is, that I cannot access the gui.
I must du the you on vm without connection to network. So I must user vm console / cli

[Nithin Eluvathingal]

You cannot access the Imp/cucm cli through VMware console.

you get only settings related to VMware and not the cucm/imp

you must access the gui of cucm and export the end users.

[m.stolzenberg]

I can do a cli login to IMP & CUCM via vmware remote console.
So my hope was that I can do some:

run sql select * from .... to get the list.
Currently I am not able to access the web gui and use the bulk tool.

The new imp node (same name / ip) is up and running.
If i cannot use cli I will try to power down the new productiv nodes. Power up the old one. Export the data...

Marcus

[Nithin Eluvathingal]

Users are synced  from cucm.

can I know what exactly you trying to do?

[m.stolzenberg]

Ok.

We had to do a recovery from cucm / IMP cluster.

We only recovered the cucm pub to get basic phoneservices back again.

Now we removed all cucm / imp nodes from the recovered cluster and reinstalled the missing cucm and imp nodes.

Here we lost all the users contact lists. Now my idea was -> disconnect the old imp node from network. Start the old node. Access the old node via vm remote console cli. Login to imp. Do some run sql stuff to get back / list the contac lists. Copy the output to csv import this list to the new imp node.

[Nithin Eluvathingal]

IF the old servers are still available why don't you restore the complete cluster rather than only the PUB.

2.12.0.0