Under Review

XG FW - List all tables in the data lake

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 |
+---------------+--------------------+-----------+