Question & Answer
Question
How can you export a list of user accounts?
Answer
Contents
Question
Question
How can you export a list of user accounts?
Answer
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
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":""}}]
Was this topic helpful?
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