[SOLVED]Setting Dynamic Field value via sql script

[ThomasPL10]

Hello

I'm trying to set value of Dynamic Field based on some information from AD. For purposes of this case I would like to create some custom script which will connect to AD collect required information and put some predefined value into Dynamic Field.

The problem is that I cannot find any cell in DB which allows me to define Dynamic Field value for particular ticket. Is it even possible? Or maybe do you know some other way to do this.

Thank you in advance for your help!

[jojo]

You should not write directly to the database!

On assigning a customer user to a ticket it is possible to copy values from the LDAP/AD to DynamicFields

[ThomasPL10]

Hello jojo thank you for the quick reply.

The thing is that I need to do this for e-mail tickets and make the whole process automatic. I know that I can put the value to dynamic field via postmaster filter however using the filter I don't know how to get info from AD.

[jojo]

there is an automatic event module doing this. But you need to upgrade to OTRS5 first

[ThomasPL10]

If you would like to give me some details on this "automatic event module" I'd appriciate it. I have OTRS 5 in my lab environment. I'd love to test it.

[reneeb]

Search for DynamicFieldFromCustomerUser::Mapping in the SysConfig

[ThomasPL10]

Thank you reneeb! It will probably fit my needs.