Znuny and ((OTRS)) Community Edition

Hi RStraub Thanks for the suggestion. I found the warranty expiration date is stored in xml_storage table. So I used below sql to get the result. my $sql = "select ci.configitem_number, xs.xml_content_value from xml_storage xs, configitem ci "; $sql = $sql."where xs.xml_content_key li...

I found the WarrantyExpirationDate is stored in table xml_storage, but how to connect to this table? The data in this table is like the following: mysql> select * from xml_storage where xml_content_key like '%WarrantyExpirationDate%'; +------------------------------+---------+-----------------------...

Hi folks I'm new in OTRS developing. I need to find the WarrantyExpirationDate of CIs, and check if it's nearly approaching, to decide if it's need to alert the user. But I stocked in getting WarrantyExpirationDate of CIs. I think there are 2 ways to get it, one is by web service, Kernel::GenericInt...