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

Incidents

@kaggle.feniksm_oob_sm_problems_incidents_links_between_them.incidents

34.46 KB
225 rows
18 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_2236ef Код Закрытия	n_17dd8d Описание	n_52b71b Подкатегория	n_27c9f2 Решение	n_fffd35 Фаза
IM10001	3 — Средний	closed	Закрыт	nan	Applications	Cannot add attachment to OneNote Shared directory.	nan	Application	nan	True	инцидент	Диагностика выполнена успешно	Cannot add attachment to OneNote Shared directory.	сбой	Cleanup the backups in document server, free spaces.	Закрытие
IM10002	3 — Средний	open	Классифицируется	nan	Printing (North America)	Not able to print due to lack of ink in printer.	nan	Office Supplies (North America)	nan	nan	инцидент	nan	Seldom ink exist in printer, there's alway error, when printing.	nan	nan	Классификация
IM10003	2 — Высокий	open	Классифицируется	adv-nam-printer-hr-3000	Printing (North America)	Not able to print	Printing (North America)	Office Supplies (North America)	nan	nan	инцидент	nan	Not result return after start a print.	nan	nan	Классификация
IM10004	2 — Высокий	closed	Закрыт	nan	E-mail / Webmail (North America)	Webmail login failed	nan	E-mail / Webmail (North America)	nan	True	инцидент	Диагностика выполнена успешно	Webmail server cannot be reached, browser can't find it	сбой	Restart PC will reconnect to webmail server.	Закрытие
IM10005	2 — Высокий	closed	Закрыт	Norton Anti-Virus	Applications	E-mail attachments being blocked	nan	Application	nan	nan	инцидент	Решено с помощью инструкции для пользователя	Virus scanner blocks e-mail attachments	сбой	Create an additional ticket to support team.	Исследование
IM10006	2 — Высокий	closed	Закрыт	adv-nam-printer-fin-5550	Printing (North America)	Printer keeps printing empty paper	nan	Office Supplies (North America)	nan	nan	инцидент	Диагностика выполнена успешно	Printer keeps printing empty paper	сбой	A change request created to reset the print jobs to avoid the waste to printer.	Закрытие
IM10007	2 — Высокий	closed	Закрыт	adv-Windows-102_microsoft_exchange_server	advantage-WindowsGroup	Not able to attach file to OneNote Sharefolder	nan	Application	nan	nan	инцидент	Диагностика выполнена успешно	Not able to attach file to OneNote Sharefolder	оборудование	Need to increase the hard disk size of File Share server	Закрытие
IM10008	3 — Средний	open	Классифицируется	nan	Printing (North America)	Printer Issue	nan	Office Supplies (North America)	nan	nan	инцидент	nan	Paperjam occurs when a printing job is larger than one page	сбой	nan	Классификация
IM10009	2 — Высокий	open	Назначен	adv-nam-server-web	Intranet / Internet (North America)	Network logon failure	Intranet / Internet (North America)	Intranet / Internet Support (North America)	True	nan	инцидент	nan	Cannot logon on the network	сбой	nan	Классификация
IM10010	3 — Средний	open	Классифицируется	nan	advantage-DesktopGroup	My tomcat server encounter warning	nan	Hardware	True	nan	инцидент	nan	My tomcat server got warning message about not the most up-to-date software.	nan	nan	Классификация


CREATE TABLE incidents (
  "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" VARCHAR,
  "n_2236ef" VARCHAR,
  "n_ec0692" VARCHAR,
  "n_17dd8d" VARCHAR,
  "n_52b71b" VARCHAR,
  "n_27c9f2" VARCHAR,
  "n_fffd35" VARCHAR
);