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..)