Database Schema - Revision history

Bcarmichael: /* http_events */

2020-09-08T18:37:59Z

http_events

← Older revision		Revision as of 18:37, 8 September 2020
Line 214:		Line 214:
	\|-		\|-
	\|web_filter_reason		\|web_filter_reason
	\|Web Filter ~~Reason~~		\|Reason for action (Web Filter)
	\|character(1)		\|character(1)
	\|This reason Web Filter blocked/flagged this request		\|This reason Web Filter blocked/flagged this request
	\|-		\|-
	\|web_filter_category_id		\|web_filter_category_id
	\|Web Filter ~~Category Id~~		\|Web Category (Web Filter)
	\|smallint		\|smallint
	\|This numeric category according to Web Filter		\|This numeric category according to Web Filter
	\|-		\|-
	\|web_filter_rule_id		\|web_filter_rule_id
	\|Web Filter ~~Rule Id~~		\|Web Rule (Web Filter)
	\|smallint		\|smallint
	\|This numeric rule according to Web Filter		\|This numeric rule according to Web Filter
	\|-		\|-
	\|web_filter_blocked		\|web_filter_blocked
	\|Web Filter ~~Blocked~~		\|Blocked (Web Filter)
	\|boolean		\|boolean
	\|If Web Filter blocked this request		\|If Web Filter blocked this request
	\|-		\|-
	\|web_filter_flagged		\|web_filter_flagged
	\|Web Filter ~~Flagged~~		\|Flagged (Web Filter)
	\|boolean		\|boolean
	\|If Web Filter flagged this request		\|If Web Filter flagged this request

2020-02-19T14:44:24Z

2020-01-29T17:17:45Z

http_events

@@ Line 1,537: / Line 1,537: @@
 |text
 |The name of the malware according to Virus Blocker
 |-
 |}

2020-01-29T17:04:11Z

sessions

@@ Line 232: / Line 232: @@
 |boolean
 |True if Threat Prevention blocked the session, false otherwise
 |-
 |application_control_lite_protocol

2020-01-29T16:36:16Z

sessions

← Older revision		Revision as of 16:36, 29 January 2020
Line 227:		Line 227:
	\|integer		\|integer
	\|The matching rule in Firewall (if any)		\|The matching rule in Firewall (if any)
			\|-
			\|threat_prevention_blocked
			\|Threat Prevention Blocked
			\|boolean
			\|True if Threat Prevention blocked the session, false otherwise
	\|-		\|-
	\|application_control_lite_protocol		\|application_control_lite_protocol
Line 330:		Line 335:
	\|}		\|}
	<section end='sessions' />		<section end='sessions' />


	== session_minutes ==		== session_minutes ==

2020-01-28T23:23:04Z

threat_prevention_events

← Older revision		Revision as of 23:23, 28 January 2020
Line 2,390:		Line 2,390:
	\|}		\|}
	<section end='user_table_updates' />		<section end='user_table_updates' />

	~~== threat_prevention_events ==~~
	~~<section begin='threat_prevention_events' />~~

	~~<section end='threat_prevention_events' />~~

2020-01-28T22:15:39Z

threat_prevention_events

@@ Line 2,391: / Line 2,391: @@
 <section end='user_table_updates' />
-== user_table_updates ==
+== threat_prevention_events ==
-<section begin='user_table_updates' />
+<section begin='threat_prevention_events' />
-{| border="1" cellpadding="2" width="90%%" align="center"
+<section end='threat_prevention_events' />

2020-01-28T22:12:44Z

user_table_updates

← Older revision		Revision as of 22:12, 28 January 2020
Line 2,353:		Line 2,353:
	<section end='syslog' />		<section end='syslog' />


			== user_table_updates ==
			<section begin='user_table_updates' />

			{\| border="1" cellpadding="2" width="90%%" align="center"
			!Column Name
			!Human Name
			!Type
			!Description
			\|-
			\|username
			\|Username
			\|text
			\|The username
			\|-
			\|key
			\|Key
			\|text
			\|The key being updated
			\|-
			\|value
			\|Value
			\|text
			\|The new value for the key
			\|-
			\|old_value
			\|Old Value
			\|text
			\|The old value for the key
			\|-
			\|time_stamp
			\|Timestamp
			\|timestamp without time zone
			\|The time of the event
			\|-
			\|}
			<section end='user_table_updates' />

	== user_table_updates ==		== user_table_updates ==

2019-08-21T21:47:29Z

http_events

← Older revision		Revision as of 21:47, 21 August 2019
Line 1,464:		Line 1,464:
	\|This reason Web Filter blocked/flagged this request		\|This reason Web Filter blocked/flagged this request
	\|-		\|-
	\|~~web_filter_category~~		\|web_filter_category_id
	\|Web Filter Category		\|Web Filter Category ID
	\|~~text~~		\|int
	\|This category according to Web Filter		\|This category ID according to Web Filter
	\|-		\|-
	\|web_filter_blocked		\|web_filter_blocked
Line 1,501:		Line 1,501:
	\|}		\|}
	<section end='http_events' />		<section end='http_events' />


	== ftp_events ==		== ftp_events ==

2017-06-14T20:24:37Z