OOB SM: Problems, Incidents, Links Between Them

It's unload of OOB Micro Focus Service Manager tables

@kaggle.feniksm_oob_sm_problems_incidents_links_between_them

Table List

3 tables(54.58 KB)

Incidents

Pm Im

Problems

Problems

@kaggle.feniksm_oob_sm_problems_incidents_links_between_them.problems

15.21 KB
9 rows
15 columns

n Код	n_02e762 Фаза	n_8495ef Группа Назначенных	n_26d2a7 Статус	n_fa6203 Основная КЕ	n_596fda Затронутая Услуга	n_ce10bb Название	n_5324d0 Описание	n_1471cd Код Закрытия	n_548b96 Корневая Причина	n_e76655 Обходное Решение	n_e8ea56 Число Связанных Инцидентов	n_ec0692 Комментарии По Закрытию	n_17dd8d Устранение
PM10001	Проверка	E-mail / Webmail (Africa)	Устранена	nan	Printing (North America)	North America Printer service always down.	Recently, user reports a lot on not able to print, please investigate on the root cause, and see if anything we can do proactively. The expected resolution time has been reached	nan	Причина.	nan		nan	Решение
PM10002	Закрытие	Application	Закрыта	nan	Applications	Norton downgrade the user performance recently, there could be a potential issue.	There are lots of PC performance issues reported against Norton anti virus software. The process seems to peg the CPU at 60% or more and consumed at least 1 GB of RAM locally. This could be a potential issue that the vendor needs to address.	Проблема со стоимостью	This has been identified as a Known Issue with Norton. The vendor will be supplying a hot fix.	In the meantime, the user settings can be adjusted for “moderate” security for intranet only. This will improve performance on the local machine until the permanent fix can be provided.		йй	Norton has supplied Hotfix #363361 to resolve this issue. This has been tested and validated. The fix can be applied to the server and it will automatically update the user’s machines at the next log in.
PM10005	Классификация	nan	Классифицируется	nan	Intranet / Internet (North America)	Lync online meeting not loading	IM10170 : Lync online meeting not loading IM10183 : Lync unable to attend online meeting-not able to hear audio IM10201 : unabled to do lync meetings with customers	nan	nan	nan	4	nan	nan
PM10006	Исследование	Cisco	В работе	nan	Applications	Lync issue	IM10052 : Lync issue IM10108 : password resetted and user unable to access the outlook	nan	nan	nan	2	nan	nan
PM10007	Классификация	Cisco	Назначена	nan	E-mail / Webmail (North America)	can't open default email folders	IM10029 : can't open default email folders IM10117 : Unable to open BT Email in outlook The expected resolution time has been reached	nan	nan	nan	2	nan	nan
PM10008	Закрытие	E-mail / Webmail (Australia)	Закрыта	adv-aus-lapt-127	Applications	installation error message for lync	IM10080 : installation error message for lync IM10136 : Request for Lync installation	Проблема со стоимостью	test	nan	2	1	Решение
PM10009	Исследование	E-mail / Webmail (Australia)	В работе	adv-aus-lapt-127	Intranet / Internet (North America)	VPN keeps dropping. Ongoing issue.	IM10043 : VPN keeps dropping. Ongoing issue. IM10071 : User cannot remote access the intranet	nan	nan	nan	2	nan	nan
PM10010	Закрытие	Application	Закрыта	nan	E-mail / Webmail (North America)	Unable to access email on cell phone	IM10152 : Unable to access email on cell phone IM10175 : User still unable to access email IM10193 : User unable to access anything using aircard for VPN	Проблема с ресурсами	Причина в нехватке ресурсов.	Установлен новый модуль.	3	Проблема решена. Заменен модуль IVP.	Корневая причина выявлена и устранена.
PM10011	Классификация	Intranet / Internet Support (North America)	Классифицируется	nan	Intranet / Internet (South America)	remote access failed, vpn issue	IM10062 : remote access failed, vpn issue IM10063 : remote access to intranet failed, seems VPN issue	nan	nan	nan	2	nan	nan


CREATE TABLE problems (
  "n" VARCHAR,
  "n_02e762" VARCHAR,
  "n_8495ef" VARCHAR,
  "n_26d2a7" VARCHAR,
  "n_fa6203" VARCHAR,
  "n_596fda" VARCHAR,
  "n_ce10bb" VARCHAR,
  "n_5324d0" VARCHAR,
  "n_1471cd" VARCHAR,
  "n_548b96" VARCHAR,
  "n_e76655" VARCHAR,
  "n_e8ea56" DOUBLE,
  "n_2236ef" VARCHAR,
  "n_ec0692" VARCHAR,
  "n_17dd8d" VARCHAR
);