{'Guid': 'VARCHAR(64) NOT NULL PRIMARY KEY', 'Package': "VARCHAR(255) NOT NULL DEFAULT ''", 'VolumeId': 'VARCHAR(32)', 'Status': 'VARCHAR(32)', 'FsType': 'VARCHAR(16)', 'SizeTotal': 'BIGINT DEFAULT 0', 'SizeUsed': 'BIGINT DEFAULT 0', 'SizeFree': 'BIGINT DEFAULT 0', 'UsedPct': 'DECIMAL(5,1) DEFAULT 0', 'RaidType': 'VARCHAR(32)', 'DiskCount': 'INT DEFAULT 0', 'CreateTime': 'DATETIME DEFAULT CURRENT_TIMESTAMP', 'Module': 'VARCHAR(255)'}
{'Guid': 'VARCHAR(64) NOT NULL PRIMARY KEY', 'Package': "VARCHAR(255) NOT NULL DEFAULT ''", 'DiskId': 'VARCHAR(16)', 'Model': 'VARCHAR(128)', 'Serial': 'VARCHAR(64)', 'Status': 'VARCHAR(32)', 'Temp': 'INT', 'SmartStatus': 'VARCHAR(32)', 'SizeBytes': 'BIGINT DEFAULT 0', 'IoRead': 'BIGINT DEFAULT 0', 'IoWrite': 'BIGINT DEFAULT 0', 'CreateTime': 'DATETIME DEFAULT CURRENT_TIMESTAMP', 'Module': 'VARCHAR(255)'}
{'Guid': 'VARCHAR(64) NOT NULL PRIMARY KEY', 'Package': "VARCHAR(255) NOT NULL DEFAULT ''", 'DsmVersion': 'VARCHAR(32)', 'UptimeSecs': 'BIGINT DEFAULT 0', 'CpuUserPct': 'DECIMAL(5,1) DEFAULT 0', 'CpuSystemPct': 'DECIMAL(5,1) DEFAULT 0', 'MemTotalMb': 'INT DEFAULT 0', 'MemUsedMb': 'INT DEFAULT 0', 'MemFreeMb': 'INT DEFAULT 0', 'MemUsedPct': 'DECIMAL(5,1) DEFAULT 0', 'SysTemp': 'INT', 'CreateTime': 'DATETIME DEFAULT CURRENT_TIMESTAMP', 'Module': 'VARCHAR(255)'}
{'Guid': 'VARCHAR(64) NOT NULL PRIMARY KEY', 'Package': "VARCHAR(255) NOT NULL DEFAULT ''", 'Interface': 'VARCHAR(32)', 'RxBytes': 'BIGINT DEFAULT 0', 'TxBytes': 'BIGINT DEFAULT 0', 'RxRate': 'BIGINT DEFAULT 0', 'TxRate': 'BIGINT DEFAULT 0', 'CreateTime': 'DATETIME DEFAULT CURRENT_TIMESTAMP', 'Module': 'VARCHAR(255)'}
{'Guid': 'VARCHAR(64) NOT NULL PRIMARY KEY', 'Package': "VARCHAR(255) NOT NULL DEFAULT ''", 'CacheId': 'VARCHAR(32)', 'Status': 'VARCHAR(32)', 'SizeCacheBytes': 'BIGINT DEFAULT 0', 'ReadHitPct': 'DECIMAL(5,1) DEFAULT 0', 'WriteHitPct': 'DECIMAL(5,1) DEFAULT 0', 'ReadHits': 'BIGINT DEFAULT 0', 'ReadMisses': 'BIGINT DEFAULT 0', 'WriteHits': 'BIGINT DEFAULT 0', 'WriteMisses': 'BIGINT DEFAULT 0', 'CreateTime': 'DATETIME DEFAULT CURRENT_TIMESTAMP', 'Module': 'VARCHAR(255)'}
{'Guid': 'VARCHAR(64) NOT NULL PRIMARY KEY', 'Package': "VARCHAR(255) NOT NULL DEFAULT ''", 'Protocol': 'VARCHAR(16)', 'ActiveCount': 'INT DEFAULT 0', 'CreateTime': 'DATETIME DEFAULT CURRENT_TIMESTAMP', 'Module': 'VARCHAR(255)'}
{'Guid': 'VARCHAR(64) NOT NULL PRIMARY KEY', 'Package': "VARCHAR(255) NOT NULL DEFAULT ''", 'TaskId': 'INT DEFAULT 0', 'TaskName': 'VARCHAR(255)', 'Status': 'VARCHAR(32)', 'LastResult': 'VARCHAR(32)', 'LastBackupTime': 'DATETIME', 'NextBackupTime': 'DATETIME', 'CreateTime': 'DATETIME DEFAULT CURRENT_TIMESTAMP', 'Module': 'VARCHAR(255)'}
INSERT INTO data_nas_volume
(Guid, Package, VolumeId, Status, FsType,
SizeTotal, SizeUsed, SizeFree,
UsedPct, RaidType, DiskCount, Module)
VALUES
('{guid}', '{package}', '{volume_id}',
'{status}', '{fs_type}',
{size_total}, {size_used}, {size_free},
{used_pct}, '{raid_type}', 0,
'ObjServiceNas')
INSERT INTO data_nas_disk
(Guid, Package, DiskId, Model, Serial,
Status, Temp, SmartStatus, SizeBytes,
IoRead, IoWrite, Module)
VALUES
('{guid}', '{package}', '{disk_id}',
'{model}', '{serial}',
'{status}', {temp}, '{smart_status}',
{size_bytes}, {io_read}, {io_write},
'ObjServiceNas')
INSERT INTO data_nas_system
(Guid, Package, DsmVersion, UptimeSecs,
CpuUserPct, CpuSystemPct,
MemTotalMb, MemUsedMb, MemFreeMb, MemUsedPct,
SysTemp, Module)
VALUES
('{guid}', '{package}', '{dsm_version}',
{uptime_secs},
{cpu_user_pct}, {cpu_system_pct},
{mem_total_mb}, {mem_used_mb}, {mem_free_mb},
{mem_used_pct}, {sys_temp},
'ObjServiceNas')
INSERT INTO data_nas_network
(Guid, Package, Interface,
RxBytes, TxBytes, RxRate, TxRate, Module)
VALUES
('{guid}', '{package}', '{interface}',
{rx_bytes}, {tx_bytes}, {rx_rate}, {tx_rate},
'ObjServiceNas')
INSERT INTO data_nas_ssdcache
(Guid, Package, CacheId, Status,
SizeCacheBytes, ReadHitPct, WriteHitPct,
ReadHits, ReadMisses, WriteHits, WriteMisses,
Module)
VALUES
('{guid}', '{package}', '{cache_id}',
'{status}', {size_cache_bytes},
{read_hit_pct}, {write_hit_pct},
{read_hits}, {read_misses},
{write_hits}, {write_misses},
'ObjServiceNas')
INSERT INTO data_nas_connections
(Guid, Package, Protocol, ActiveCount, Module)
VALUES
('{guid}', '{package}', '{protocol}',
{active_count}, 'ObjServiceNas')
INSERT INTO data_nas_backup
(Guid, Package, TaskId, TaskName, Status,
LastResult, LastBackupTime, NextBackupTime,
Module)
VALUES
('{guid}', '{package}', {task_id},
'{task_name}', '{status}', '{last_result}',
{last_backup_time}, {next_backup_time},
'ObjServiceNas')
SELECT VolumeId, Status, UsedPct, SizeUsed,
SizeTotal, RaidType, CreateTime
FROM data_nas_volume WHERE Package = '{package}' ORDER BY CreateTime DESC LIMIT {limit}
SELECT DiskId, Model, Status, Temp,
SmartStatus, IoRead, IoWrite, CreateTime
FROM data_nas_disk WHERE Package = '{package}' ORDER BY CreateTime DESC LIMIT {limit}
SELECT CpuUserPct, CpuSystemPct,
MemUsedPct, MemUsedMb, MemTotalMb,
SysTemp, UptimeSecs, DsmVersion, CreateTime
FROM data_nas_system WHERE Package = '{package}' ORDER BY CreateTime DESC LIMIT 1