how to update OTRS CMDB item field using MySQL query?

[williamrobert1983]

Hi all,

How to update the Email ID Value using Serial Number directly in OTRS db using MySQL Query? I need query to update the Email ID values using Serial Number. Please help me how to use Query.

I have attached the sample screen shot.

Thanks lot .

William

[jojo]

you are not allowed to alter data directly in the database.

use import/export functionality to update the CMDB data