Outdated Guide on Table structure for SQLite Database

[Johnng007]

Description

Before 4.8.0 vulnerability data for each agent can be viewed using the SQLite database. This view is still incorrectly represented here

Below are the right tables in 4.8.0

sqlite> .tables
ciscat_results        sca_policy            sys_netiface
fim_entry             sca_scan_info         sys_netproto
metadata              scan_info             sys_osinfo
pm_event              sync_info             sys_ports
sca_check             sys_hotfixes          sys_processes
sca_check_compliance  sys_hwinfo            sys_programs
sca_check_rules       sys_netaddr

Vulnerability information has been migrated to Wazuh Indices, therefore this documentation should be updated to reflect the added vulnerability indices.

The current Indices list is:

curl -k -u admin:admin https://127.0.0.1:9200/_cat/indices/wazuh-*?v
health status index                                     uuid                   pri rep docs.count docs.deleted store.size pri.store.size
green  open   wazuh-alerts-4.x-2024.07.16               zOvcMG-eQ4-HyBGLGiJm9Q   3   0         48            0    360.5kb        360.5kb
green  open   wazuh-alerts-4.x-2024.07.15               9ujEXilSQ3ufuiVVu1_Sag   3   0         34            0    308.6kb        308.6kb
green  open   wazuh-alerts-4.x-2024.07.14               3QN8v2_5S_6kVruYrHcJqg   3   0         39            0    288.9kb        288.9kb
green  open   wazuh-states-vulnerabilities-wazuh-server _ETWzgqMQJeQsbSlyyausw   1   0        123            0    491.6kb        491.6kb
green  open   wazuh-alerts-4.x-2024.07.13               K8486Pa9TNK5b2amUzSccg   3   0         36            0      323kb          323kb
green  open   wazuh-alerts-4.x-2024.07.12               gMuind4ZQXmgWCVlgjyBYA   3   0        302            0    852.1kb        852.1kb
green  open   wazuh-statistics-2024.29w                 Bai_8HkGTH2qeuWvECHKrQ   1   0         62            0    209.3kb        209.3kb
green  open   wazuh-alerts-4.x-2024.07.11               vopoZ2FSSOKUFSutBGnqGw   3   0        202            0      679kb          679kb
green  open   wazuh-monitoring-2024.29w                 rjkt6ZoBScSRcX6djXWaeQ   1   0        148            0      207kb          207kb
green  open   wazuh-monitoring-2024.28w                 3eGqlXzlSoWxCr33oSbU2A   1   0        314            0    412.7kb        412.7kb