Changes between Version 1 and Version 2 of UseCaseUC2PrototypeImplementation
- Timestamp:
- 08/23/26 19:50:20 (4 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
UseCaseUC2PrototypeImplementation
v1 v2 28 28 29 29 {{{ 30 SELECT 31 id, 32 name, 33 user, 34 ip, 35 os, 36 first_seen, 37 last_seen, 38 sysmon_available 30 SELECT id, name, user, ip, os, first_seen, last_seen, sysmon_available 39 31 FROM computers 40 WHERE tenant_id = 1 41 AND env_name = 'default' 32 WHERE tenant_id = 1 AND env_name = 'default' 42 33 ORDER BY last_seen DESC; 43 34 }}} … … 60 51 61 52 {{{ 62 SELECT 63 id, 64 name, 65 user, 66 ip, 67 os, 68 first_seen, 69 last_seen, 70 sysmon_available 53 SELECT id, name, user, ip, os, first_seen, last_seen, sysmon_available 71 54 FROM computers 72 WHERE name = 'Ilina-laptop';55 WHERE tenant_id = 1 AND name = 'Ilina-laptop'; 73 56 }}} 74 57 … … 79 62 '''Систем''' 80 63 81 Ги прикажува последните системски метрики за компјутерот '''Ilina-laptop'''.64 Ги прикажува тековните системски метрики за компјутерот '''Ilina-laptop''' (последен snapshot). 82 65 83 66 '''SQL''' 84 67 85 68 {{{ 86 SELECT 87 cpu_usage, 88 ram_usage, 89 disk_usage, 90 timestamp 91 FROM computer_history 92 WHERE computer_id = 93 ( 94 SELECT id 95 FROM computers 96 WHERE name = 'Ilina-laptop' 97 ) 98 ORDER BY timestamp DESC 99 LIMIT 10; 69 SELECT cpu_usage, ram_usage, disk_usage, timestamp 70 FROM computer_history_current 71 WHERE computer_id = (SELECT id FROM computers WHERE tenant_id = 1 AND name = 'Ilina-laptop'); 100 72 }}} 101 73 … … 113 85 114 86 {{{ 115 SELECT 116 pid, 117 name, 118 cpu_percent, 119 memory_mb, 120 username 87 SELECT pid, name, cpu_percent, memory_mb, username 121 88 FROM computer_processes_current 122 WHERE computer_id = 123 ( 124 SELECT id 125 FROM computers 126 WHERE name = 'Ilina-laptop' 127 ) 89 WHERE computer_id = (SELECT id FROM computers WHERE tenant_id = 1 AND name = 'Ilina-laptop') 128 90 ORDER BY cpu_percent DESC; 129 91 }}}
