IBM Support

How can you export a list of user accounts?

Question & Answer


Question

How can you export a list of user accounts?

Answer

Contents

Question
How can you export a list of user accounts?

Answer
It appears that you can extract the data you need by querying the TL_SYSTEM database.? Tealeaf does not support the direct querying of the internal SQL databases and only provides information given the understanding that their schemas are subject to change without notice.

Use this query to extract users and their group membership:

select mu.mc_user_name mu.email mu.tz_timezone mu.nt_domain mu.nt_user mug.mc_group_name
from
MC_USER mu
MC_USER_GROUP_MAP mugm
MC_USER_GROUP mug
where
mu.mc_user_id = mugm.mc_user_id
and mug.mc_group_id = mugm.mc_group_id
Article Reference
00000606
"
[{"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Product":{"code":"SSERNK","label":"Tealeaf Customer Experience"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

More support for:
Tealeaf Customer Experience

Software version:
All Versions

Document number:
777145

Modified date:
08 December 2018

UID

ibm10777145

Manage My Notification Subscriptions