Fortianalyzer Database Yapısı | Tuncay BAŞ, Fortinet UTM Firewall ve PHP, .NET Yazılım Günlüğü

Fortianalyzer v5′de postgresql kullanıyor.

- table_ref tablosunun yapısı

exec sql-query-generic "select * from INFORMATION_SCHEMA.COLUMNS where table_name = 'table_ref';"

FAZ100C # exec sql-query-generic "select * from INFORMATION_SCHEMA.COLUMNS where

 table_name = 'table_ref';"

 table_catalog | table_schema | table_name | column_name  | ordinal_position |              column_default               | is_nullable |     data_type     | character_maximum_length | character_octet_length | numeric_precision | numeric_precision_radix | numeric_scale | datetime_precision | interval_type | interval_precision | character_set_catalog | character_set_schema | character_set_name | collation_catalog | collation_schema | collation_name | domain_catalog | domain_schema | domain_name | udt_catalog | udt_schema | udt_name | scope_catalog | scope_schema | scope_name | maximum_cardinality | dtd_identifier | is_self_referencing | is_identity | identity_generation | identity_start | identity_increment | identity_maximum | identity_minimum | identity_cycle | is_generated | generation_expression | is_updatable

---------------+--------------+------------+--------------+------------------+-------------------------------------------+-------------+-------------------+--------------------------+------------------------+-------------------+-------------------------+---------------+--------------------+---------------+--------------------+-----------------------+----------------------+--------------------+-------------------+------------------+----------------+----------------+---------------+-------------+-------------+------------+----------+---------------+--------------+------------+---------------------+----------------+---------------------+-------------+---------------------+----------------+--------------------+------------------+------------------+----------------+--------------+-----------------------+--------------

 postgres      | public       | table_ref  | tbl_id       | 1                | nextval('table_ref_tbl_id_seq'::regclass) | NO          | bigint            |                          |                        | 64                | 2                       | 0             |                    |               |                    |                       |                      |                    |                   |                  |                |                |               |             | postgres    | pg_catalog | int8     |               |              |            |                     | 1              | NO                  | NO          |                     |                |                    |                  |                  |                | NEVER        |                       | YES

 postgres      | public       | table_ref  | tbl_name     | 2                |                                           | NO          | character varying | 64                       | 64                     |                   |                         |               |                    |               |                    |                       |                      |                    |                   |                  |                |                |               |             | postgres    | pg_catalog | varchar  |               |              |            |                     | 2              | NO                  | NO          |                     |                |                    |                  |                  |                | NEVER        |                       | YES

 postgres      | public       | table_ref  | tbl_type     | 3                | 0                                         | NO          | smallint          |                          |                        | 16                | 2                       | 0             |                    |               |                    |                       |                      |                    |                   |                  |                |                |               |             | postgres    | pg_catalog | int2     |               |              |            |                     | 3              | NO                  | NO          |                     |                |                    |                  |                  |                | NEVER        |                       | YES

 postgres      | public       | table_ref  | dev_type     | 4                | 0                                         | NO          | smallint          |                          |                        | 16                | 2                       | 0             |                    |               |                    |                       |                      |                    |                   |                  |                |                |               |             | postgres    | pg_catalog | int2     |               |              |            |                     | 4              | NO                  | NO          |                     |                |                    |                  |                  |                | NEVER        |                       | YES

 postgres      | public       | table_ref  | version      | 5                |                                           | YES         | character varying | 9                        | 9                      |                   |                         |               |                    |               |                    |                       |                      |                    |                   |                  |                |                |               |             | postgres    | pg_catalog | varchar  |               |              |            |                     | 5              | NO                  | NO          |                     |                |                    |                  |                  |                | NEVER        |                       | YES

 postgres      | public       | table_ref  | itime_start  | 6                | 0                                         | NO          | integer           |                          |                        | 32                | 2                       | 0             |                    |               |                    |                       |                      |                    |                   |                  |                |                |               |             | postgres    | pg_catalog | int4     |               |              |            |                     | 6              | NO                  | NO          |                     |                |                    |                  |                  |                | NEVER        |                       | YES

 postgres      | public       | table_ref  | itime_end    | 7                | 0                                         | NO          | integer           |                          |                        | 32                | 2                       | 0             |                    |               |                    |                       |                      |                    |                   |                  |                |                |               |             | postgres    | pg_catalog | int4     |               |              |            |                     | 7              | NO                  | NO          |                     |                |                    |                  |                  |                | NEVER        |                       | YES

 postgres      | public       | table_ref  | dtime_start  | 8                | 0                                         | NO          | integer           |                          |                        | 32                | 2                       | 0             |                    |               |                    |                       |                      |                    |                   |                  |                |                |               |             | postgres    | pg_catalog | int4     |               |              |            |                     | 8              | NO                  | NO          |                     |                |                    |                  |                  |                | NEVER        |                       | YES

 postgres      | public       | table_ref  | dtime_end    | 9                | 0                                         | NO          | integer           |                          |                        | 32                | 2                       | 0             |                    |               |                    |                       |                      |                    |                   |                  |                |                |               |             | postgres    | pg_catalog | int4     |               |              |            |                     | 9              | NO                  | NO          |                     |                |                    |                  |                  |                | NEVER        |                       | YES

 postgres      | public       | table_ref  | row_num      | 10               | 0                                         | NO          | integer           |                          |                        | 32                | 2                       | 0             |                    |               |                    |                       |                      |                    |                   |                  |                |                |               |             | postgres    | pg_catalog | int4     |               |              |            |                     | 10             | NO                  | NO          |                     |                |                    |                  |                  |                | NEVER        |                       | YES

 postgres      | public       | table_ref  | space_used   | 11               | 0                                         | NO          | bigint            |                          |                        | 64                | 2                       | 0             |                    |               |                    |                       |                      |                    |                   |                  |                |                |               |             | postgres    | pg_catalog | int8     |               |              |            |                     | 11             | NO                  | NO          |                     |                |                    |                  |                  |                | NEVER        |                       | YES

 postgres      | public       | table_ref  | logtype_mask | 12               | 0                                         | NO          | integer           |                          |                        | 32                | 2                       | 0             |                    |               |                    |                       |                      |                    |                   |                  |                |                |               |             | postgres    | pg_catalog | int4     |               |              |            |                     | 12             | NO                  | NO          |                     |                |                    |                  |                  |                | NEVER        |                       | YES

 postgres      | public       | table_ref  | flags        | 13               | 0                                         | NO          | integer           |                          |                        | 32                | 2                       | 0             |                    |               |                    |                       |                      |                    |                   |                  |                |                |               |             | postgres    | pg_catalog | int4     |               |              |            |                     | 13             | NO                  | NO          |                     |                |                    |                  |                  |                | NEVER        |                       | YES

- table_ref içeriği

FAZ100C # exec sql-query-generic "select * from table_ref;"
tbl_id |              tbl_name              | tbl_type | dev_type | version | itime_start | itime_end | dtime_start | dtime_end | row_num | space_used | logtype_mask | flags
--------+------------------------------------+----------+----------+---------+-------------+------------+-------------+------------+---------+------------+--------------+-------
32     | XXXXXX3G12021700-elog-1391896925-0 | 101      | 0        | 050513 | 1391896925 | 1391983200 | 1391904125 | 1391990400 | 353     | 188416     | 1            | 1
2      | YYYYYY3G10603101-tlog-1391119218-0 | 116      | 0        | 050513 | 1391119218 | 1391205702 | 1391126418 | 1391212902 | 130200 | 46276608   | 3            | 1
11     | YYYYYY3G10603101-dlog-1391119980-0 | 100      | 0        | 050513 | 1391119980 | 1391205688 | 1391127180 | 1391212888 | 17236   | 7462912    | 0            | 1
10     | XXXXXX3G12021700-tlog-1391378435-0 | 116      | 0        | 050513 | 1391378435 | 1391464920 | 1391385634 | 1391472120 | 86890   | 43163648   | 3            | 1
3      | XXXXXX3G12021700-tlog-1391119286-0 | 116      | 0        | 050513 | 1391119286 | 1391205632 | 1391126485 | 1391212831 | 28924   | 9617408    | 3            | 1
9      | XXXXXX3G12021700-elog-1391292129-0 | 101      | 0        | 050513 | 1391292129 | 1391378401 | 1391299328 | 1391385600 | 350     | 188416     | 1            | 1
12     | YYYYYY3G10603101-tlog-1391205704-0 | 116      | 0        | 050513 | 1391205704 | 1391292069 | 1391212903 | 1391299269 | 181398 | 64806912   | 3            | 1
21     | YYYYYY3G10603101-elog-1391205711-0 | 101      | 0        | 050513 | 1391205711 | 1391292069 | 1391212910 | 1391299268 | 8456    | 2826240    | 47           | 1
30     | YYYYYY3G10603101-elog-1391292084-0 | 101      | 0        | 050513 | 1391292084 | 1391378428 | 1391299283 | 1391385627 | 7546    | 2498560    | 11           | 1
29     | XXXXXX3G12021700-tlog-1391896893-0 | 116      | 0        | 050513 | 1391896893 | 1391981108 | 1391904093 | 1391988307 | 333546 | 162701312 | 3            | 1
5      | XXXXXX3G12021700-tlog-1391205715-0 | 116      | 0        | 050513 | 1391205715 | 1391292062 | 1391212915 | 1391299262 | 93804   | 46669824   | 3            | 1
4      | XXXXXX3G12021700-elog-1391119330-0 | 101      | 0        | 050513 | 1391119330 | 1391205601 | 1391126529 | 1391212800 | 352     | 188416     | 1            | 1
1      | YYYYYY3G10603101-elog-1391119216-0 | 101      | 0        | 050513 | 1391119216 | 1391205699 | 1391126415 | 1391212898 | 8755    | 2998272    | 47           | 1
20     | XXXXXX3G12021700-tlog-1391724035-0 | 116      | 0        | 050513 | 1391724035 | 1391810517 | 1391731234 | 1391817717 | 71201   | 24346624   | 3            | 1
19     | XXXXXX3G12021700-elog-1391637727-0 | 101      | 0        | 050513 | 1391637727 | 1391724001 | 1391644926 | 1391731200 | 357     | 188416     | 1            | 1
24     | YYYYYY3G10603101-wlog-1391205848-0 | 119      | 0        | 050513 | 1391205848 | 1391265676 | 1391213049 | 1391272876 | 24725   | 10493952   | 0            | 1
25     | YYYYYY3G10603101-dlog-1391205848-0 | 100      | 0        | 050513 | 1391205848 | 1391260785 | 1391213049 | 1391267985 | 13458   | 5668864    | 0            | 1
14     | XXXXXX3G12021700-tlog-1391464922-0 | 116      | 0        | 050513 | 1391464922 | 1391551278 | 1391472122 | 1391558477 | 55164   | 20070400   | 3            | 1

7,165 total views, 2 views today

tuncaybas