List the tables in the data lake from an XG Firewall.
-- List ALL XG FW Tables SELECT DISTINCT log_type, log_component, COUNT(dist_key) entries FROM xgfw_data GROUP BY log_type, log_component ORDER By log_type, log_component ASC
Sample results
+---------------+--------------------+-----------+ | log_type | log_component | entries | |---------------+--------------------+-----------| | Anti-Spam | SMTP | 6 | | Event | AD SSO | 6 | | Event | ATP | 1 | | Event | Anti-Virus | 32 | | Event | Appliance | 4 | | Event | CLI | 2 | | Event | Central Management | 15 | | Event | Gateway | 3 | | Event | IPS | 2 | | Event | Interface | 65 | | Event | Up2Date | 6 | | Firewall | Appliance Access | 29019 | | System Health | CPU | 864 | | System Health | Disk | 861 | | System Health | Interface | 4305 | | System Health | Live User | 861 | | System Health | Memory | 861 | +---------------+--------------------+-----------+
