{"main_obj":[{"g":{"C__CATG__CONTACT":["132","description","Beschreibung (Kontaktzuweisung)"]}},{"g":{"C__CATG__CONTACT":["127","contact_object","Kontakt (Kontaktzuweisung)"]}},{"g":{"C__CATG__CONTACT":["129","role","Rolle (Kontaktzuweisung)"]}},{"g":{"C__CATG__CONTACT":["128","primary","Prim\u00e4r (Kontaktzuweisung)"]}},{"g_custom":{"C__CATG__CUSTOM_FIELDS_EIN_UND_AUSTRITTSDATUM":["1568","f_popup_c_17628546009944330","Eintrittsdatum (Ein- und Austrittsdatum)"]}},{"g_custom":{"C__CATG__CUSTOM_FIELDS_EIN_UND_AUSTRITTSDATUM":["1569","f_popup_c_17628546009946731","Austrittsdatum (Ein- und Austrittsdatum)"]}},{"g_custom":{"C__CATG__CUSTOM_FIELDS_LEBENSZYKLUS":["1578","f_popup_c_17708020932274500","Last Logon:  ()"]}},{"g":{"C__CATG__STORAGE_DEVICE":["301","serial","Seriennummer  (Ger\u00e4t)"]}}],"lvls":[],"query":"SELECT \nobj_main.isys_obj__id AS '__id__', \nj5.isys_catg_contact_list__description AS 'LC__CMDB__LOGBOOK__DESCRIPTION###0_21', \njob4.isys_obj__title AS 'LC__CMDB__CATG__GLOBAL_CONTACT###0_21', \nj7.isys_contact_tag__title AS 'LC__CMDB__CONTACT_ROLE###0_21', \n(CASE j5.isys_catg_contact_list__primary_contact WHEN 0 THEN 'LC__UNIVERSAL__NO' WHEN 1 THEN 'LC__UNIVERSAL__YES' END) AS 'LC__CATG__CONTACT_LIST__PRIMARY###0_21', \nj8.isys_catg_custom_fields_list__field_content AS 'locales::fmt_date::Eintrittsdatum###4_22', \nj9.isys_catg_custom_fields_list__field_content AS 'locales::fmt_date::Austrittsdatum###4_22', \nj10.isys_catg_custom_fields_list__field_content AS 'locales::fmt_datetime::Last Logon:###4_25', \nj2.isys_catg_stor_list__serial AS 'LC__CATG__STORAGE_SERIAL###0_43' \n\n FROM isys_obj AS obj_main \nINNER JOIN isys_cmdb_status AS obj_main_status ON obj_main_status.isys_cmdb_status__id = obj_main.isys_obj__isys_cmdb_status__id \nLEFT JOIN isys_catg_contact_list AS j5 ON j5.isys_catg_contact_list__isys_obj__id = obj_main.isys_obj__id  \nLEFT JOIN isys_connection AS j4 ON j4.isys_connection__id = j5.isys_catg_contact_list__isys_connection__id \nLEFT JOIN isys_obj AS job4 ON j4.isys_connection__isys_obj__id = job4.isys_obj__id \nLEFT JOIN isys_contact_tag AS j7 ON j7.isys_contact_tag__id = j5.isys_catg_contact_list__isys_contact_tag__id \nLEFT JOIN isys_catg_stor_list AS j2 ON j2.isys_catg_stor_list__isys_obj__id = obj_main.isys_obj__id  \nLEFT JOIN isys_catg_custom_fields_list AS ROOT_C__CATG__CUSTOM_FIELDS_EIN_UND_AUSTRITTSDATUM ON obj_main.isys_obj__id = ROOT_C__CATG__CUSTOM_FIELDS_EIN_UND_AUSTRITTSDATUM.isys_catg_custom_fields_list__isys_obj__id\n                                AND ROOT_C__CATG__CUSTOM_FIELDS_EIN_UND_AUSTRITTSDATUM.isys_catg_custom_fields_list__isysgui_catg_custom__id = (SELECT isysgui_catg_custom__id FROM isysgui_catg_custom WHERE isysgui_catg_custom__const = 'C__CATG__CUSTOM_FIELDS_EIN_UND_AUSTRITTSDATUM')\n                                AND ROOT_C__CATG__CUSTOM_FIELDS_EIN_UND_AUSTRITTSDATUM.isys_catg_custom_fields_list__field_type = 'commentary'  LEFT JOIN isys_catg_custom_fields_list AS j8 ON obj_main.isys_obj__id = j8.isys_catg_custom_fields_list__isys_obj__id AND j8.isys_catg_custom_fields_list__field_key = 'c_17628546009944330' \n                                AND j8.isys_catg_custom_fields_list__data__id = ROOT_C__CATG__CUSTOM_FIELDS_EIN_UND_AUSTRITTSDATUM.isys_catg_custom_fields_list__data__id  \n LEFT JOIN isys_catg_custom_fields_list AS j9 ON obj_main.isys_obj__id = j9.isys_catg_custom_fields_list__isys_obj__id AND j9.isys_catg_custom_fields_list__field_key = 'c_17628546009946731'  AND j9.isys_catg_custom_fields_list__data__id = ROOT_C__CATG__CUSTOM_FIELDS_EIN_UND_AUSTRITTSDATUM.isys_catg_custom_fields_list__data__id  \nLEFT JOIN isys_catg_custom_fields_list AS ROOT_C__CATG__CUSTOM_FIELDS_LEBENSZYKLUS ON obj_main.isys_obj__id = ROOT_C__CATG__CUSTOM_FIELDS_LEBENSZYKLUS.isys_catg_custom_fields_list__isys_obj__id\n                                AND ROOT_C__CATG__CUSTOM_FIELDS_LEBENSZYKLUS.isys_catg_custom_fields_list__isysgui_catg_custom__id = (SELECT isysgui_catg_custom__id FROM isysgui_catg_custom WHERE isysgui_catg_custom__const = 'C__CATG__CUSTOM_FIELDS_LEBENSZYKLUS')\n                                AND ROOT_C__CATG__CUSTOM_FIELDS_LEBENSZYKLUS.isys_catg_custom_fields_list__field_type = 'commentary'  LEFT JOIN isys_catg_custom_fields_list AS j10 ON obj_main.isys_obj__id = j10.isys_catg_custom_fields_list__isys_obj__id AND j10.isys_catg_custom_fields_list__field_key = 'c_17708020932274500' \n                                AND j10.isys_catg_custom_fields_list__data__id = ROOT_C__CATG__CUSTOM_FIELDS_LEBENSZYKLUS.isys_catg_custom_fields_list__data__id  \n\nWHERE TRUE \n \n AND obj_main.isys_obj__id = %s\n ORDER BY j5.isys_catg_contact_list__description DESC LIMIT 0, 1"}