Fehlermeldung bei Update von 0.9.4 auf 0.9.5
-
Hallo zusammen!
Ich habe lange keine Updates mehr gemacht und wollte mein System nun Schrittweise auf 0.9.8.2 updateten. Bereits beim ersten Update bekomme ich allerdings folgende Fehlermeldung :
MySQL-Error: Table 'idoit_data.isys_property_2_cat' doesn't exist
Query: INSERT INTO
isys_property_2_cat(isys_property_2_cat__cat_id,isys_property_2_cat__cat_type,isys_property_2_cat__property1_title,isys_property_2_cat__property1_columnname,isys_property_2_cat__property1_reference,isys_property_2_cat__property2_title,isys_property_2_cat__property2_columnname,isys_property_2_cat__property2_reference) VALUES
(36, 'g', 'LC_WORKFLOW__ACTIVE', 'isys_catg_nagios_list__is_active', NULL, NULL, NULL, NULL)Mir fehlt also anscheinend eine Tabelle.
Ich wäre daher dankbar, wenn mit jemand das create-Statement schicken könnte.
Achja, der Rest des Updates ist fehlerfrei durchgelaufen.
Vielen Dank,
Schrubber -
Das Statment zur Installation der Tabelle findest du in den Installationsdateien von idoit. Wenn du dir die Vollversion lädst findest du im Setup Ordner unter SQL - idoit_data.sql.
Dort findest du zu isys_property_2_cat:-- -- Tabellenstruktur für Tabelle `isys_property_2_cat` -- CREATE TABLE `isys_property_2_cat` ( `isys_property_2_cat__id` int(10) unsigned NOT NULL AUTO_INCREMENT, `isys_property_2_cat__cat_id` int(10) NOT NULL, `isys_property_2_cat__cat_type` char(1) COLLATE utf8_unicode_ci NOT NULL, `isys_property_2_cat__property1_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `isys_property_2_cat__property1_columnname` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `isys_property_2_cat__property1_reference` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `isys_property_2_cat__property2_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `isys_property_2_cat__property2_columnname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `isys_property_2_cat__property2_reference` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`isys_property_2_cat__id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=157 ; -- -- Daten für Tabelle `isys_property_2_cat` -- INSERT INTO `isys_property_2_cat` VALUES(1, 1, 'g', 'LC__CMDB__CATG__GLOBAL_TITLE', 'isys_catg_global_list__title', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(2, 1, 'g', 'LC__CMDB__CATG__GLOBAL_SYSID', 'isys_catg_global_list__sysid', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(3, 1, 'g', 'LC__CMDB__CATG__GLOBAL_PURPOSE', 'isys_catg_global_list__isys_purpose__id', 'isys_purpose', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(4, 1, 'g', 'LC__CMDB__CATG__GLOBAL_CATEGORY', 'isys_catg_global_list__isys_catg_global_category__id', 'isys_catg_global_category', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(5, 1, 'g', 'LC__CMDB__CATG__GLOBAL_AQUIRE', 'isys_catg_global_list__acquirementdate', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(6, 1, 'g', 'LC__CMDB__CATG__GLOBAL_GUARANTEE_PERIOD', 'isys_catg_global_list__guarantee_period', NULL, 'LC__CMDB__CATG__GLOBAL_GUARANTEE_PERIOD_UNIT', 'isys_catg_global_list__isys_guarantee_period_unit__id', 'isys_guarantee_period_unit'); INSERT INTO `isys_property_2_cat` VALUES(7, 2, 'g', 'LC__CMDB__CATG__MODEL_MANUFACTURE', 'isys_catg_model_list__isys_model_manufacturer__id', 'isys_model_manufacturer', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(8, 2, 'g', 'LC__CMDB__CATG__MODEL_TITLE', 'isys_catg_model_list__isys_model_title__id', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(9, 2, 'g', 'LC__CMDB__CATG__MODEL_SERIAL', 'isys_catg_model_list__serial', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(10, 2, 'g', 'LC__CMDB__CATG__MODEL_FIRMWARE', 'isys_catg_model_list__firmware', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(11, 3, 'g', 'LC__CMDB__CATG__FORMFACTOR', 'isys_catg_formfactor_list__isys_catg_formfactor_type__id', 'isys_catg_formfactor_type', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(12, 3, 'g', 'LC__CMDB__CATG__FORMFACTOR_RACKUNITS', 'isys_catg_formfactor_list__rackunits', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(13, 3, 'g', 'LC__CMDB__CATG__FORMFACTOR_INSTALLATION_HEIGHT', 'isys_catg_formfactor_list__installation_hight', NULL, 'LC__CMDB__CATG__FORMFACTOR_INSTALLATION_DEPTH_UNIT', 'isys_catg_formfactor_list__isys_depth_unit__id', 'isys_depth_unit'); INSERT INTO `isys_property_2_cat` VALUES(14, 3, 'g', 'LC__CMDB__CATG__FORMFACTOR_INSTALLATION_WIDTH', 'isys_catg_formfactor_list__installation_width', NULL, 'LC__CMDB__CATG__FORMFACTOR_INSTALLATION_DEPTH_UNIT', 'isys_catg_formfactor_list__isys_depth_unit__id', 'isys_depth_unit'); INSERT INTO `isys_property_2_cat` VALUES(15, 3, 'g', 'LC__CMDB__CATG__FORMFACTOR_INSTALLATION_DEPTH', 'isys_catg_formfactor_list__installation_depth', NULL, 'LC__CMDB__CATG__FORMFACTOR_INSTALLATION_DEPTH_UNIT', 'isys_catg_formfactor_list__isys_depth_unit__id', 'isys_depth_unit'); INSERT INTO `isys_property_2_cat` VALUES(16, 4, 'g', 'LC__CMDB__CATG__CPU_TITLE', 'isys_catg_cpu_list__title', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(17, 4, 'g', 'LC__CMDB__CATG__CPU_MANUFACTURER', 'isys_catg_cpu_list__isys_catg_cpu_manufacturer__id', 'isys_catg_cpu_manufacturer', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(18, 4, 'g', 'LC__CMDB__CATG__CPU_TYPE', 'isys_catg_cpu_list__isys_catg_cpu_type__id', 'isys_catg_cpu_type', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(19, 4, 'g', 'LC__CMDB__CATG__CPU_FREQUENCY', 'isys_catg_cpu_list__isys_catg_cpu_frequency__id', 'isys_catg_cpu_frequency', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(20, 5, 'g', 'LC__CMDB_CATG__MEMORY_TITLE', 'isys_catg_memory_list__isys_memory_title__id', 'isys_memory_title', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(21, 5, 'g', 'LC__CMDB_CATG__MEMORY_MANUFACTURER', 'isys_catg_memory_list__isys_memory_manufacturer__id', 'isys_memory_manufacturer', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(22, 5, 'g', 'LC__CMDB_CATG__MEMORY_TYPE', 'isys_catg_memory_list__isys_memory_type__id', 'isys_memory_type', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(23, 5, 'g', 'LC__CMDB_CATG__MEMORY_QUANTITY', 'isys_catg_memory_list__quantity', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(24, 5, 'g', 'LC__CMDB_CATG__MEMORY_CAPACITY', 'isys_catg_memory_list__capacity', NULL, 'LC__CMDB_CATG__MEMORY_UNIT', 'isys_catg_memory_list__isys_memory_unit__id', 'isys_memory_unit'); INSERT INTO `isys_property_2_cat` VALUES(25, 9, 'g', 'LC__CMDB__CATG__POWER_CONSUMER_TITLE', 'isys_catg_power_consumer_list__isys_pc_title__id', 'isys_pc_title', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(26, 9, 'g', 'LC__CMDB__CATG__POWER_CONSUMER__MANUFACTURE', 'isys_catg_power_consumer_list__isys_pc_manufacturer__id ', 'isys_pc_manufacturer', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(27, 9, 'g', 'LC__CMDB__CATG__POWER_CONSUMER__MODEL', 'isys_catg_power_consumer_list__isys_pc_model__id', 'isys_pc_model', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(28, 7, 'g', 'LC__CMDB__CATG__INTERFACE_P_TITLE', 'isys_catg_netp_list__title', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(29, 7, 'g', 'LC__CMDB__CATG__INTERFACE_P_MANUFACTURER', 'isys_catg_netp_list__isys_iface_manufacturer__id', 'isys_iface_manufacturer', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(30, 7, 'g', 'LC__CMDB__CATG__INTERFACE_P_MODEL', 'isys_catg_netp_list__isys_iface_model__id', 'isys_iface_model', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(31, 7, 'g', 'LC__CMDB__CATG__INTERFACE_P_SERIAL', 'isys_catg_netp_list__serial', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(32, 7, 'g', 'LC__CMDB__CATG__INTERFACE_P_SLOTNUMBER', 'isys_catg_netp_list__slotnumber', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(33, 8, 'g', 'LC__CATG__STORAGE_CONTROLLER', 'isys_catg_stor_list__isys_catg_controller_list__id', 'isys_catg_controller_list', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(34, 8, 'g', 'LC__CATG__STORAGE_CONNECTION_TYPE', 'isys_catg_stor_list__isys_stor_con_type__id', 'isys_stor_con_type', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(35, 8, 'g', 'LC__CATG__STORAGE_HOTSPARE', 'isys_catg_stor_list__hotspare', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(36, 8, 'g', 'LC__CATG__STORAGE_CAPACITY', 'isys_catg_stor_list__capacity', NULL, 'LC__CMDB_CATG__MEMORY_UNIT', 'isys_catg_stor_list__isys_stor_unit__id', 'isys_stor_unit'); INSERT INTO `isys_property_2_cat` VALUES(37, 8, 'g', 'LC__CATG__STORAGE_TYPE', 'isys_catg_stor_list__isys_stor_type__id', 'isys_stor_type', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(38, 8, 'g', 'LC__CATG__STORAGE_TITLE', 'isys_catg_stor_list__title', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(39, 8, 'g', 'LC__CATG__STORAGE_MANUFACTURER', 'isys_catg_stor_list__isys_stor_manufacturer__id', 'isys_stor_manufacturer', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(40, 8, 'g', 'LC__CATG__STORAGE_MODEL', 'isys_catg_stor_list__isys_stor_model__id', 'isys_stor_model', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(41, 12, 'g', 'LC__CMDB__CATG__APPLICATION_TITLE', 'isys_catg_application_list__title', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(42, 14, 'g', 'LC__CMDB__CATG__ACCESS_TITLE', 'isys_catg_access_list__title', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(43, 14, 'g', 'LC__CMDB__CATG__ACCESS_TYPE', 'isys_catg_access_list__isys_access_type__id', 'isys_access_type', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(44, 14, 'g', 'LC__CMDB__CATG__ACCESS_URL', 'isys_catg_access_list__url', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(45, 14, 'g', 'LC__CMDB__CATG__ACCESS_PRIMARY', 'isys_catg_access_list__primary', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(46, 15, 'g', 'LC__CMDB__CATG__BACKUP__TITLE', 'isys_catg_backup_list__title', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(47, 18, 'g', 'LC__CMDB__CATG__EMERGENCY_PLAN_TITLE', 'isys_catg_emergency_plan_list__title', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(48, 20, 'g', 'LC__CMDB__CATG__FILE_TITLE', 'isys_catg_file_list__title', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(49, 21, 'g', 'LC__CMDB__CATG__CONTACT_TITLE', 'isys_catg_contact_list__isys_contact__id', 'isys_contact', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(50, 22, 'g', 'LC__CMDB__CATG__LOGBOOK', 'isys_catg_logb_list__isys_logbook__id', 'isys_logbook', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(51, 26, 'g', 'LC__CMDB__CATG__LOCATION_POS', 'isys_catg_location_list__pos', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(52, 26, 'g', 'LC__CMDB__CATG__LOCATION_FRONTSIDE', 'isys_catg_location_list__frontside', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(53, 27, 'g', 'LC__CMDB__CATG__IMAGE_TITLE', 'isys_catg_image_list__title', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(54, 27, 'g', 'LC__CMDB__CATG__IMAGE_OBJ_FILE', 'isys_catg_image_list__image_link', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(55, 28, 'g', 'LC__CMDB__CATG__MANUAL_TITLE', 'isys_catg_manual_list__title', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(56, 33, 'g', 'LC__CMDB__CATG__TITLE', 'isys_catg_sound_list__title', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(57, 33, 'g', 'LC__CMDB__CATG__MANUFACTURER', 'isys_catg_sound_list__isys_sound_manufacturer__id', 'isys_sound_manufacturer', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(58, 1, 's', 'LC__CATG__RACK_HEIGHT_UNITS', 'isys_cats_enclosure_list__rack_units', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(59, 35, 'g', 'LC__CMDB__CATG__TITLE', 'isys_catg_graphic_list__title', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(60, 35, 'g', 'LC__CMDB__CATG__MANUFACTURER', 'isys_catg_graphic_list__isys_graphic_manufacturer__id', 'isys_graphic_manufacturer', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(61, 35, 'g', 'LC__CMDB__CATG__MEMORY', 'isys_catg_graphic_list__memory', NULL, 'LC__CMDB__CATG__GRAPHIC_MEMORY_UNIT', 'isys_catg_graphic_list__isys_memory_unit__id', 'isys_memory_unit'); INSERT INTO `isys_property_2_cat` VALUES(62, 1, 's', 'LC__CATG__RACK_WIDTH', 'isys_cats_enclosure_list__rack_width', NULL, 'LC__CATG__RACK_UNIT', 'isys_cats_enclosure_list__isys_depth_unit__id', 'isys_depth_unit'); INSERT INTO `isys_property_2_cat` VALUES(63, 1, 's', 'LC__CATG__RACK_HEIGHT', 'isys_cats_enclosure_list__rack_height', NULL, 'LC__CATG__RACK_UNIT', 'isys_cats_enclosure_list__isys_depth_unit__id', 'isys_depth_unit'); INSERT INTO `isys_property_2_cat` VALUES(64, 1, 's', 'LC__CATG__RACK_DEPTH', 'isys_cats_enclosure_list__rack_depth', NULL, 'LC__CATG__RACK_UNIT', 'isys_cats_enclosure_list__isys_depth_unit__id', 'isys_depth_unit'); INSERT INTO `isys_property_2_cat` VALUES(65, 2, 's', 'LC__CATS__STREET', 'isys_cats_building_list__street_postal', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(66, 2, 's', 'LC__CATS__PCODE', 'isys_cats_building_list__postalcode', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(67, 2, 's', 'LC__CATS__CITY', 'isys_cats_building_list__city_postal', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(68, 2, 's', 'LC__CATS__COUNT_FLOOR', 'isys_cats_building_list__count_floor', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(69, 3, 's', 'LC__CMDB__CATS__ROOM_TYPE', 'isys_cats_room_list__isys_room_type__id', 'isys_room_type', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(70, 3, 's', 'LC__CMDB__CATS__ROOM_NUMBER', 'isys_cats_room_list__number', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(71, 3, 's', 'LC__CMDB__CATS__ROOM_FLOOR', 'isys_cats_room_list__floor', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(72, 4, 's', 'LC__CMDB__CATS__SERVICE_SPECIFICATION', 'isys_cats_service_list__specification', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(73, 4, 's', 'LC__CMDB__CATS__SERVICE_MANUFACTURER', 'isys_cats_service_list__isys_service_manufacturer__id', 'isys_service_manufacturer', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(74, 4, 's', 'LC__CMDB__CATS__SERVICE_RELEASE', 'isys_cats_service_list__release', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(75, 5, 's', 'LC__CATG__SWITCH_MODULAR', 'isys_cats_switch_net_list__modular', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(76, 5, 's', 'LC__CATG__SWITCH_COUNT_SLOT', 'isys_cats_switch_net_list__count_slot', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(77, 6, 's', 'LC__CMDB__CATS__POBJ_TYPE', 'isys_cats_pobj_list__isys_pobj_type__id', 'isys_pobj_type', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(78, 6, 's', 'LC__CMDB__CATS__POBJ_VOLT', 'isys_cats_pobj_list__volt', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(79, 6, 's', 'LC__CMDB__CATS__POBJ_WATT', 'isys_cats_pobj_list__watt', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(80, 6, 's', 'LC__CMDB__CATS__POBJ_AMPERE', 'isys_cats_pobj_list__ampere', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(81, 7, 's', 'LC__CMDB__CATS__WAN_ROLE', 'isys_cats_wan_list__isys_wan_role__id', 'isys_wan_role', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(82, 7, 's', 'LC__CMDB__CATS__WAN_TYPE', 'isys_cats_wan_list__isys_wan_type__id', 'isys_wan_type', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(83, 7, 's', 'LC__CMDB__CATS__WAN_CAPACTIY_UNIT', 'isys_san_capacity_unit_isys_san_capacity_unit__id', 'isys_wan_capacity_unit', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(84, 7, 's', 'LC__CMDB__CATS__WAN_CAPACITY', 'isys_cats_wan_list__capacity', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(85, 8, 's', 'LC__CMDB__CATS__EMERGENCY_PLAN_CALC_TIME_NEEDED', 'isys_cats_emergency_plan_list__calc_time_need', NULL, 'LC__CMDB__CATS__EMERGENCY_PLAN_UNIT_OF_TIME', 'isys_cats_emergency_plan_list__isys_unit_of_time__id', 'isys_unit_of_time'); INSERT INTO `isys_property_2_cat` VALUES(86, 8, 's', 'LC__CMDB__CATS__EMERGENCY_PLAN_PRACTICE_ACTUAL_DATE', 'isys_cats_emergency_plan_list__practice_actual_date', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(87, 9, 's', 'LC__CATS__AC_TYPE', 'isys_cats_ac_list__isys_ac_type__id', 'isys_ac_type', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(88, 9, 's', 'LC__CATS__AC_THRESHOLD', 'isys_cats_ac_list__threshold', NULL, 'LC__CMDB__CATG__UNIT', 'isys_cats_ac_list__isys_temp_unit__id', 'isys_temp_unit'); INSERT INTO `isys_property_2_cat` VALUES(89, 9, 's', 'LC__CATS__AC_REFRIGERATING_CAPACITY', 'isys_cats_ac_list__capacity', NULL, 'LC__CMDB__CATG__UNIT', 'isys_cats_ac_list__isys_ac_refrigerating_capacity_unit__id', 'isys_ac_refrigerating_capacity_unit'); INSERT INTO `isys_property_2_cat` VALUES(90, 9, 's', 'LC__CATS__AC_AIR_QUANTITY', 'isys_cats_ac_list__air_quantity', NULL, 'LC__CMDB__CATG__UNIT', 'isys_cats_ac_list__isys_ac_air_quantity_unit__id', 'isys_ac_air_quantity_unit'); INSERT INTO `isys_property_2_cat` VALUES(91, 9, 's', 'LC__CATG__RACK_WIDTH', 'isys_cats_ac_list__width', NULL, 'LC__CMDB__CATG__UNIT', 'isys_cats_ac_list__unit', NULL); INSERT INTO `isys_property_2_cat` VALUES(92, 9, 's', 'LC__CATG__RACK_HEIGHT', 'isys_cats_ac_list__height', NULL, 'LC__CMDB__CATG__UNIT', 'isys_cats_ac_list__unit', NULL); INSERT INTO `isys_property_2_cat` VALUES(93, 9, 's', 'LC__CATG__RACK_DEPTH', 'isys_cats_ac_list__depth', NULL, 'LC__CMDB__CATG__UNIT', 'isys_cats_ac_list__unit', NULL); INSERT INTO `isys_property_2_cat` VALUES(94, 12, 's', 'LC__CMDB__CATS__SAN_CAPACITY_VALUE', 'isys_cats_san_list__capacity', NULL, 'LC__CATG__MEMORY_UNIT', 'isys_cats_san_list__isys_stor_unit__id', 'isys_stor_unit'); INSERT INTO `isys_property_2_cat` VALUES(95, 13, 's', 'LC__CATD__TITLE', 'isys_cats_access_point_list__title', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(96, 13, 's', 'LC__CMDB__CATS__ACCESS_POINT_FUNCTION', 'isys_cats_access_point_list__isys_wlan_function__id', 'isys_wlan_function', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(97, 13, 's', 'LC__CMDB__CATS__ACCESS_POINT_STANDARD', 'isys_cats_access_point_list__isys_wlan_standard__id', 'isys_wlan_standard', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(98, 13, 's', 'LC__CMDB__CATS__ACCESS_POINT_CHANNEL', 'isys_cats_access_point_list__isys_wlan_channel__id', 'isys_wlan_channel', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(99, 13, 's', 'LC__CMDB__CATS__ACCESS_POINT_BRODCAST_SSID', 'isys_cats_access_point_list__broadcast_ssid', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(100, 13, 's', 'LC__CMDB__CATS__ACCESS_POINT_SSID', 'isys_cats_access_point_list__ssid', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(101, 13, 's', 'LC__CMDB__CATS__ACCESS_POINT_MAC_FILTER', 'isys_cats_access_point_list__mac_filter', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(102, 13, 's', 'LC__CMDB__CATS__ACCESS_POINT_AUTH', 'isys_cats_access_point_list__isys_wlan_auth__id', 'isys_wlan_auth', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(103, 13, 's', 'LC__CMDB__CATS__ACCESS_POINT_ENCRYPTION', 'isys_cats_access_point_list__isys_wlan_encryption__id', 'isys_wlan_encryption', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(104, 14, 's', 'LC__CMDB__CATS__MONITOR_DISPLAY', 'isys_cats_monitor_list__display', NULL, 'LC__CMDB__CATG__UNIT', 'isys_cats_monitor_list__isys_monitor_unit__id', 'isys_monitor_unit'); INSERT INTO `isys_property_2_cat` VALUES(105, 14, 's', 'LC__CMDB__CATS__MONITOR_TYPE', 'isys_cats_monitor_list__isys_monitor_type__id', 'isys_monitor_type', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(106, 14, 's', 'LC__CMDB__CATS__MONITOR_RESOLUTION', 'isys_cats_monitor_list__isys_monitor_resolution__id', 'isys_monitor_resolution', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(107, 15, 's', 'LC__CMDB__CATS__CLIENT_TYPE', 'isys_cats_client_list__isys_client_type__id', 'isys_client_type', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(108, 16, 's', 'LC__CMDB__CATG__TITLE', 'isys_cats_switch_fc_list__title', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(109, 16, 's', 'LC__CMDB__CATS__SWITCH_FC_ACTIVE', 'isys_cats_switch_fc_list__unit_active', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(110, 17, 's', 'LC__CATG__SWITCH_MODULAR', 'isys_cats_router_list__modular', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(111, 17, 's', 'LC__CATG__SWITCH_COUNT_SLOT', 'isys_cats_router_list__count_slot', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(112, 18, 's', 'LC__CMDB__CATS__PRT_TYPE', 'isys_cats_prt_list__isys_cats_prt_type__id', 'isys_cats_prt_type', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(113, 18, 's', 'LC__CMDB__CATS__PRT_ISCOLOR', 'isys_cats_prt_list__iscolor', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(114, 18, 's', 'LC__CMDB__CATS__PRT_ISDUPLEX', 'isys_cats_prt_list__isduplex', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(115, 18, 's', 'LC__CMDB__CATS__PRT_EMULATION', 'isys_cats_prt_list__isys_cats_prt_emulation__id', 'isys_cats_prt_emulation', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(116, 19, 's', 'LC__CMDB__CATG__GLOBAL_CATEGORY', 'isys_cats_file_list__isys_file_category__id', 'isys_file_category', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(117, 19, 's', 'LC__CMDB__CATG__GLOBAL_GROUP', 'isys_cats_file_list__isys_file_group__id', 'isys_file_group', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(118, 19, 's', 'LC__CMDB__CATG__VERSION', 'isys_cats_file_list__isys_file_version__id', 'isys_file_version', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(119, 20, 's', 'LC__CMDB__CATS__APPLICATION_SPECIFICATION', 'isys_cats_application_list__specification', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(120, 20, 's', 'LC__CMDB__CATS__APPLICATION_MANUFACTURER', 'isys_cats_application_list__isys_application_manufacturer__id', 'isys_application_manufacturer', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(121, 20, 's', 'LC__CMDB__CATS__APPLICATION_RELEASE', 'isys_cats_application_list__release', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(122, 22, 's', 'LC__CMDB__CATS__NET__TITLE', 'isys_cats_net_list__title', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(123, 22, 's', 'LC__CMDB__CATS__NET__TYPE', 'isys_cats_net_list__isys_net_type__id', 'isys_net_type', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(124, 22, 's', 'LC__CMDB__CATS__NET__NET', 'isys_cats_net_list__address', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(125, 22, 's', 'LC__CMDB__CATS__NET__MASK', 'isys_cats_net_list__mask', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(126, 22, 's', 'LC__CMDB__CATS__NET__DEF_GW', 'isys_cats_net_list__def_gw', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(127, 22, 's', 'LC__CMDB__CATS__NET__DHCP', 'isys_cats_net_list__dhcp', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(128, 22, 's', 'LC__CMDB__CATS__NET__DNS_SERVER', 'isys_cats_net_list__isys_net_dns_server__id', 'isys_net_dns_server', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(129, 22, 's', 'LC__CMDB__CATS__NET__DNS_DOMAIN', 'isys_cats_net_list__isys_net_dns_domain__id', 'isys_net_dns_domain', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(130, 23, 's', 'LC__CMDB__CATS_CP_CONTRACT__TYPE', 'isys_cats_cp_contract_list__isys_cp_contract_type__id', 'isys_cp_contract_type', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(131, 23, 's', 'LC__CMDB__CATS_CP_CONTRACT__CARD_NUMBER', 'isys_cats_cp_contract_list__card_number', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(132, 23, 's', 'LC__CMDB__CATS_CP_CONTRACT__START_DATE', 'isys_cats_cp_contract_list__start_date', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(133, 23, 's', 'LC__CMDB__CATS_CP_CONTRACT__END_DATE', 'isys_cats_cp_contract_list__end_date', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(134, 23, 's', 'LC__CMDB__CATS_CP_CONTRACT__THRESHOLD', 'isys_cats_cp_contract_list__threshold_date', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(135, 23, 's', 'LC__CMDB__CATS_CP_CONTRACT__PHONE_NUMBER', 'isys_cats_cp_contract_list__phone_number', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(136, 23, 's', 'LC__CMDB__CATS_CP_CONTRACT__PIN', 'isys_cats_cp_contract_list__pin', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(137, 23, 's', 'LC__CMDB__CATS_CP_CONTRACT__PIN2', 'isys_cats_cp_contract_list__pin2', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(138, 23, 's', 'LC__CMDB__CATS_CP_CONTRACT__PUK', 'isys_cats_cp_contract_list__puk', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(139, 23, 's', 'LC__CMDB__CATS_CP_CONTRACT__PUK2', 'isys_cats_cp_contract_list__puk2', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(140, 23, 's', 'LC__CMDB__CATS_CP_CONTRACT__CARD_NUMBER', 'isys_cats_cp_contract_list__tc_card_number', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(141, 23, 's', 'LC__CMDB__CATS_CP_CONTRACT__PHONE_NUMBER', 'isys_cats_cp_contract_list__tc_phone_number', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(142, 23, 's', 'LC__CMDB__CATS_CP_CONTRACT__PIN', 'isys_cats_cp_contract_list__tc_pin', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(143, 23, 's', 'LC__CMDB__CATS_CP_CONTRACT__PIN2', 'isys_cats_cp_contract_list__tc_pin2', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(144, 23, 's', 'LC__CMDB__CATS_CP_CONTRACT__PUK', 'isys_cats_cp_contract_list__tc_puk', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(145, 23, 's', 'LC__CMDB__CATS_CP_CONTRACT__PUK2', 'isys_cats_cp_contract_list__tc_puk2', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(146, 23, 's', 'LC__CMDB__CATS_CP_CONTRACT__SERIAL_NUMBER', 'isys_cats_cp_contract_list__serial_number', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(147, 23, 's', 'LC__CMDB__CATG__DESCRIPTION', 'isys_cats_cp_contract_list__description', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(148, 11, 's', 'LC__CMDB__CATS__MAINTENANCE_CONTRACT_NUMBER', 'isys_cats_maintenance_list__contract_number', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(149, 11, 's', 'LC__CMDB__CATS__MAINTENANCE_CONTRACT_DURATION_START', 'isys_cats_maintenance_list__contract_duration_start', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(150, 11, 's', 'LC__CMDB__CATS__MAINTENANCE_CONTRACT_DURATION_END', 'isys_cats_maintenance_list__contract_duration_end', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(151, 11, 's', 'LC__CMDB__CATS__MAINTENANCE_CONTRACT_REACTION_RATE', 'isys_cats_maintenance_list__isys_maintenance_reaction_rate__id', 'isys_maintenance_reaction_rate', NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(152, 11, 's', 'LC__UNIVERSAL__COSTS', 'isys_cats_maintenance_list__costs', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(153, 11, 's', 'LC__CMDB__CATG__DESCRIPTION', 'isys_cats_maintenance_list__contract_description', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(154, 11, 's', 'Support-URL', 'isys_cats_maintenance_list__support_url', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(155, 37, 'g', 'LC_WORKFLOW__ACTIVE', 'isys_catg_nagios_list__is_active', NULL, NULL, NULL, NULL); INSERT INTO `isys_property_2_cat` VALUES(156, 37, 'g', 'Hostname', 'isys_catg_nagios_list__name1', NULL, NULL, NULL, NULL); -- -------------------------------------------------------- -
Vielen Dank, das war's was ich suchte!
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login