SRMS

테이블 (4)

감시되는서버 (MonitroedServer)

  • IP (ip) — String — 기본 키 — NOT NULL — Monitored Server IP
  • Hostname (hostname) — String — NOT NULL — Server's Name
  • Comment (comment) — String — Description of Server
  • LimitCpu (limitCpu) — Integer — NOT NULL — Limit Usage of CPU
  • LimitMemory (limitMem) — Integer — NOT NULL — Limit Usage of Memory
  • IsActive (isActive) — Boolean — NOT NULL — Monitor On/Off
  • IsAlarm (isAlarm) — Boolean — NOT NULL — Alarm On/Off
  • TeamsCode (teamsCode) — String — Teams Code for Push message

알람받는대상 (AlarmRecipient)

  • AlarmRecipientId (alarmRecipientId) — Integer — 기본 키 — NOT NULL — PK
  • IP (ip) — String — 외래 키 → 감시되는서버.IP — NOT NULL — Monitored Server IP
  • MailAddress (mailAddress) — String — NOT NULL — Mail Address to Push message

자원사용률 (ResourceUsage)

  • ResourceUsageId (resourceUsageId) — Integer — 기본 키 — NOT NULL — PK
  • IP (ip) — String — 외래 키 → 감시되는서버.IP — NOT NULL — Monitored Server IP
  • date — String — NOT NULL — Time to measurement
  • CPUUsage (cpuUsage) — Integer — NOT NULL — Server CPU Usage
  • MemoryUsage (memUsage) — Integer — NOT NULL — Server Memory Usage
  • CPUsUsage (cpusUsage) — String — NOT NULL — Server CPU Usage for each core

장애이벤트 (FailureEvent)

  • FailureEventId (failureEventId) — Integer — 기본 키 — NOT NULL — PK
  • IP (ip2) — String — 외래 키 → 감시되는서버.IP — NOT NULL — Monitored Server IP
  • StartTime (startTime) — String — NOT NULL — Failure's Start Time
  • EndTime (endTime) — String — Failure's End Time
  • IsSolve (isSolve) — Boolean — NOT NULL — Failure Event Alive or Die
  • Type (type) — String — NOT NULL — Failure Type (CPU, Memory etc..)