MAP Array Values

[rstainforth]

Hi,

Does anyone have a list of the MAP Array values for the customer info in Config.PM? I'm trying to grab as much customer info as possible in the ticket, primarily fields relating to customer company, department, job title etc and can't find a comprehensive list of array values; what I have Is the following - which is only partial correct I know - that should give you an idea of what I mean:

From Kernel/Config.PM

Map => [
[ 'UserFirstname', 'First Name', 'givenname', 1, 1, 'var' ],
[ 'UserLastname', 'Last Name', 'sn', 1, 1, 'var' ],
[ 'UserLogin', 'AD User Name', 'sAMAccountName', 1, 1, 'var' ],
[ 'UserEmail', 'Email', 'mail', 1, 1, 'var' ],
[ 'UserCustomerID', 'CustomerID', 'mail', 1, 1, 'var' ],
['DepartmentNumber','Company','o', 1, 1, 'var' ],
[ 'UserPhone','Phone','telephonenumber',1, 1, 'var'],
[ 'UserFax','Fax','facsimileTelephoneNumber',1, 1,'var'],
[ 'UserMobile','Mobile','mobile',1, 1, 'var'],
[ 'UserStreet','Street','street',1, 1, 'var'],
[ 'UserCity','City', 'city',1, 1, 'var'],
[ 'UserZip','Postal Code', 'postalCode',1, 1, 'var'],

[crythias]

you can go to the SQL box and DESCRIBE the customer_user table, but you will need to ALTER TABLE for items OTRS doesn't natively hold, or if you're using Active Directory, reference the fields it provides.

Code: Select all

id
login
email
customer_id
pw
title
first_name
last_name
phone
fax
mobile
street
zip
city
country
comments
valid_id
create_time
create_by
change_time
change_by