Cisco Meeting Server – coSpaces to CSV

I had a requirement to compare the full list of coSpaces configured on a CMS cluster to the list of coSpaces created by an Acano Manager LDAP import, pulling the data from Acano Manager is easy enough, just dump the SQL table but with CMS the only database access is via the API or webadmin and it’s not easy to output 3000+ coSpaces.

In the end I decided to write a script to iterate through the GET coSpaces API path until all of the output was saved in a CSV, it will save the space name, space uri, space callId, and coSpaceId. These were the only fields I required for the compare but more can be supported with minimal effort.

Setup

  1. Connect to your CMS server via CLI and add a new user account for performing the API request, store the password safely, or alternatively use an existing account.
  2. Download the script from the link below or copy it from the bottom of this post
  3. Input the details of your CMS server in the configuration section of the script
  4. Configure which OS your are using and where the output CSV file should be stored
    1. For Linux based systems use;
    2. For Windows based systems use;
    3. Modify the path in your chosen option
  5. If you want the script to output to screen, which is useful for identifying issues, change this to a 1
  6. Run the script using python3

Linux output

Windows output

Full Script