62 lines
2.6 KiB
SQL
62 lines
2.6 KiB
SQL
-- Veeam Backup Agents (agent installs on managed machines)
|
|
CREATE TABLE IF NOT EXISTS veeam_backup_agents (
|
|
instance_uid VARCHAR(255) PRIMARY KEY,
|
|
organization_uid VARCHAR(255) REFERENCES veeam_organizations(instance_uid) ON DELETE SET NULL,
|
|
site_uid VARCHAR(255),
|
|
management_agent_uid VARCHAR(255),
|
|
name VARCHAR(500) NOT NULL,
|
|
agent_platform VARCHAR(50),
|
|
status VARCHAR(50),
|
|
management_agent_status VARCHAR(50),
|
|
operation_mode VARCHAR(50),
|
|
gui_mode VARCHAR(50),
|
|
platform VARCHAR(50),
|
|
version VARCHAR(100),
|
|
version_status VARCHAR(50),
|
|
management_mode VARCHAR(100),
|
|
installation_type VARCHAR(50),
|
|
activation_time TIMESTAMPTZ,
|
|
total_jobs_count INTEGER DEFAULT 0,
|
|
running_jobs_count INTEGER DEFAULT 0,
|
|
success_jobs_count INTEGER DEFAULT 0,
|
|
synced_at TIMESTAMPTZ DEFAULT NOW(),
|
|
created_at TIMESTAMPTZ DEFAULT NOW(),
|
|
updated_at TIMESTAMPTZ DEFAULT NOW()
|
|
);
|
|
|
|
-- Veeam VSPC Alarms (platform-level alarms, distinct from job failures)
|
|
CREATE TABLE IF NOT EXISTS veeam_alarms (
|
|
instance_uid VARCHAR(255) PRIMARY KEY,
|
|
alarm_template_uid VARCHAR(255),
|
|
repeat_count INTEGER DEFAULT 0,
|
|
object_uid VARCHAR(255),
|
|
object_type VARCHAR(100),
|
|
object_name VARCHAR(500),
|
|
object_computer_name VARCHAR(500),
|
|
organization_uid VARCHAR(255) REFERENCES veeam_organizations(instance_uid) ON DELETE SET NULL,
|
|
location_uid VARCHAR(255),
|
|
management_agent_uid VARCHAR(255),
|
|
last_activation_uid VARCHAR(255),
|
|
last_activation_time TIMESTAMPTZ,
|
|
last_activation_status VARCHAR(50),
|
|
last_activation_message TEXT,
|
|
last_activation_remark TEXT,
|
|
area VARCHAR(50),
|
|
resolved BOOLEAN DEFAULT false,
|
|
synced_at TIMESTAMPTZ DEFAULT NOW(),
|
|
created_at TIMESTAMPTZ DEFAULT NOW(),
|
|
updated_at TIMESTAMPTZ DEFAULT NOW()
|
|
);
|
|
|
|
-- Indexes
|
|
CREATE INDEX IF NOT EXISTS idx_veeam_agents_org ON veeam_backup_agents(organization_uid);
|
|
CREATE INDEX IF NOT EXISTS idx_veeam_agents_status ON veeam_backup_agents(status);
|
|
CREATE INDEX IF NOT EXISTS idx_veeam_agents_mgmt_status ON veeam_backup_agents(management_agent_status);
|
|
CREATE INDEX IF NOT EXISTS idx_veeam_agents_platform ON veeam_backup_agents(agent_platform);
|
|
CREATE INDEX IF NOT EXISTS idx_veeam_agents_synced ON veeam_backup_agents(synced_at);
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_veeam_alarms_org ON veeam_alarms(organization_uid);
|
|
CREATE INDEX IF NOT EXISTS idx_veeam_alarms_status ON veeam_alarms(last_activation_status);
|
|
CREATE INDEX IF NOT EXISTS idx_veeam_alarms_resolved ON veeam_alarms(resolved);
|
|
CREATE INDEX IF NOT EXISTS idx_veeam_alarms_time ON veeam_alarms(last_activation_time);
|
|
CREATE INDEX IF NOT EXISTS idx_veeam_alarms_synced ON veeam_alarms(synced_at);
|