# Generate Report of MiCollab Client Accounts

You can generate real-time reports of USP and MiCollab Client account information. The report can be generated when MiCollab is in either integrated or co-located mode.

To generate these reports, you need a basic knowledge of Linux commands.

## USP Accounts Report

To generate this report:

1. Log into the MiCollab server console as "root" using the administrative password.

2. Enter the following command to access the directory that contains the required script:

   / usr/mas/bin/ db_report_helper_scripts

3. Run the report by entering following command: java -jar UserAndServicesDump.jar > {filename}.csv

   For example: java -jar UserAndServicesDump.jar > {amtc_report}.csv

4. Copy the file to your PC.

5. Open the file in a spreadsheet editor.

Note: The report may not display UTF-8 characters properly depending on the editor being used. For instance, Excel may not display UTF-8 characters properly. Other editors such as Sublime or Word may display them in readable format.

A sample report is shown below:

The USP report fields are described below:

Field | Description
--- | ---
index | Record number
firstname | First name for the account holder
lastname | Last name for the account holder
loginid | Login ID that the account holder will use to log in to the Desktop Client
email_address | E-mail address of account holder
department | Department of account holder
location | Location of account holder
phone | Extension number of account holder
mailbox | Voice mailbox extension of account holder
uca | TRUE: Service is enabled or {blank}: Service is disabled
mca
saa | Speech Auto Attendant extension
tw | Teleworker extension of account holder

## MiCollab Client Accounts Report

To generate this report:

1. Log into the MiCollab server console as "root" using the administrative password.

2. Enter the following command to access the directory that contains the required script:

   cd /usr/mas/bin/db_report_helper_scripts

3. Save the report to a file by entering following command: sh ./dump_uca_account.sh > {full path and file name}

   For example: sh ./dump_uca_account.sh > /tmp/output.csv

4. Copy the file to your PC.

5. Open the file in a spreadsheet editor.

Note: The report may not display UTF-8 characters properly depending on the editor being used. For instance, Excel may not display UTF-8 characters properly. Other editors such as Sublime or Word may display them in readable format.

The MiCollab Client report fields are described below:

Field | Description
--- | ---
first_name | First name for the account holder
last name | Last name for the account holder
login_id | Login ID that the account holder will use to log in to the Desktop Client
pbx_node | Password that the account holder will use to log in to the desktop client
desk_phone_extension | Extension for the account holder's desk phone
soft_phone_extension | Extension for the account holder's softphone
voice_mail_server | Voice mail server configured for the PBX node associated with this account
voice_mail_number | Voice mail extension for the account holder's PBX node
voice_mail_public_number | Extension for the account holder's mailbox extension
language | Language setting of user's account
country | Country setting for the account holder