Home
HCL Sametime® Administration Guide 12.0.1
Administering
This section provides information on administering on Sametime environments.
Using the Sametime Database utility
The Sametime Database utility is used to synchronize the information with that of the Sametime server database.
Deleting user IDs
The delete feature of the Sametime Database utility removes specified individual contact names from contact lists and privacy lists.

HCL Sametime® Administration Guide 12.0.1
- Accessibility features for Sametime
  Accessibility features help users who have a disability, such as restricted mobility or limited vision, use information technology products successfully. HCL® strives to provide products with usable access for everyone.
- What's new
  HCL Sametime and HCL Sametime Premium 12.0.1 provide many new features, enhancements and fixes to servers and clients. Additional releases to version 12.0.1 also provides updates to the product.
- Planning
  This section describes the system requirements and server configurations needed for HCL Sametime and HCL Sametime Premium.
- Installing
  This section provides information on installing the servers for Sametime and Sametime Premium.
- Configuring
  This section provides information on configuring the HCL Sametime server. Configuration tasks are dependent on the deployment environment.
- Securing
  This section provides information on securing your HCL Sametime environments.
- Administering
  This section provides information on administering on Sametime environments.
  - Managing Sametime clients
    This section provides information on managing Sametime clients.
  - Managing file transfer data
    As with meeting recordings and reports, files that are shared in the chat are stored in a Docker volume or a Kubernetes persistent volume. By default, you can download these files within 90 days.
  - Testing Sametime chat and meeting clients
    This article assumes that you have successfully installed and configured Sametime or Sametime Premium.
  - Starting and stopping the Sametime server
    Starting and stopping the Sametime server involves starting and stopping the Sametime services running in the container management system.
  - Starting and stopping MongoDB
  - Managing policies
    Sametime policies allow administrators to control user access to features.
  - Configuration files
    Configuration files maintain information used by the Sametime server for various reasons.
  - Enabling multi-tenancy
    Multi-tenancy allows multiple organizations to be part of the Sametime community. With multi-tenancy, Sametime users can chat, add users and groups to contact lists, and have awareness of users in their organization or in other organizations that are configured to be visible to them.
  - Using the Sametime Database utility
    The Sametime Database utility is used to synchronize the information with that of the Sametime server database.
    - Converting chat history owner data from Domino directory to LDAP format
      The convert feature of the Sametime Database utility changes all contact list information from the Domino Directory format to LDAP format.
    - Deleting user IDs
      The delete feature of the Sametime Database utility removes specified individual contact names from contact lists and privacy lists.
    - Moving users
      The move feature of the Sametime Database utility allows you to move users from one organization to another.
    - Updating user IDs
      The updates feature of the Sametime Database utility changes specified first names, last names, display names, or group names.
  - MongoDB
    This section provides information relating to administering MongoDB.
  - Managing Sametime Meetings
    This topic explains the features you can enable or disable for meetings. Currently, the settings that you can change are global settings that apply to the entire server. User policies cannot control the settings.
- Troubleshooting
  This section provides information on troubleshooting and supporting Sametime environments.
- Uninstalling Sametime
  In the event that Sametime must be removed, follow the procedure for the platform that Sametime is installed on.
- Migrating and Upgrading
  This section provides information on migrating data from an earlier release to Sametime 12.
- Notices

Deleting user IDs

The delete feature of the Sametime Database utility removes specified individual contact names from contact lists and privacy lists.

Before you begin

Stop the Sametime server prior to running the Sametime Database utility. Refer to Starting and stopping the Sametime server for the steps.

About this task

The following is the format for the delete task in the CVS file. Each user ID to be deleted is listed on a separate line.

DELETE
"uid"

CSV files are case-sensitive and sensitive to spaces.

Procedure

Create a CSV file. The file must be saved in UTF-8 format.
In the CVS file, specify the DELETE descriptor followed by the UIDs to be deleted. Specify each UID on a separate line. For example:
```
DELETE
uid=John Deere,ou=sametime,dc=hcl,dc=com
uid=Marta Smith,ou=sametime,dc=hcl,dc=com
cn=portaladminid,o=example.com 
```
Copy the CSV file into an accessible read or writable location.

Create or edit a file that contains the environment variables.

Add the MongoDB access information to the file.

MONGO_CONNECTION_URL=mongodb://username:password@ip-address:port

Add the location of the CVS file.
```
DELETE_CSV=/temp/test_delete.csv
```
To delete the chat history of the affected IDs, add the following line.
```
DEEP_DELETE=1
```

The following is an example env_file_name file.


MONGO_CONNECTION_URL=mongodb://sametimeUser:xxxxxxxx@192.168.1.1:27017/admin?authSource=admin&authMechanism=SCRAM-SHA-256&readPreference=primary&directConnection=true&ssl=false
DELETE_CSV=/temp/test_delete.csv
DEEP_DELETE=1

Mount the CVS file in the container for the application to access and process.
Run the Database utility using the following command. The CSV file is mounted in the container in the/temp directory in the following example for the application to access and process. The tag attribute is the image tag to use.
```
docker run -v /temp:/temp:rw --env-file env_file_name.env hclcr.io/st/sametime-db-utility:tag
```
To verify your changes, view the report created in the data directory.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box. Note: To report a problem or question about the product software, do not use this form. Instead, go to the HCL Software Support site.