Case, Assumptions | Fortinet FortiDB instruction


SOX Report Specifics	End of Period Adjustments Report (EPA)

Column	Description

Object	The name and owner of the database object that was directly manipulated by
	the flagged activity

Time Stamp	The exact time the flagged activity was conducted.

Terminal Name	The terminal IP address or name.

Origin Application	The name, or other identifier, for the originating application, if the activity
	originated from an external application or from an application server.

Action	The type of action successfully completed by the User ID.

Determining Your Reporting Period

Reporting Period is the time frame surrounding a user-defined period-end day (PED). The reporting period extends a user-defined number of days before (UDDB) and a user-defined number of days after (UDDA) the PED.

Assumptions:

PED = the 1st day of each month

UDDB = 8

UDDA = 15

Case 1

Assumption:

You are running your End of Period Adjustments (EPA) report sometime before midnight on the first day of August

Assertions:

a)the most recent PED is the first day of July

b)the reporting period is (July 1)- 8 days until (July 1) + 15 days Conclusion:

The resulting report period is June 23 until July 16, inclusive.

Case 2

Assumption:

You are running your End of Period Adjustments (EPA) report sometime before midnight on the second day of August

Assertions:

a)the most recent PED is the first day of August

b)the reporting period is (Aug 1)- 8 days until (Aug 1) + 15 days Conclusion:

FortiDB Version 3.2 Utilities	User Guide
15-32000-81369-20081219	49

Image 51

Fortinet FortiDB manual Case, Assumptions

Contents

Utilities User Guide Trademarks FortiDB Utilities User Guide Table of Contents Index FortiDB MA Utilities Selecting Addresses for Auto-Discovery Auto Discovery Results from Auto-Discovery Selecting Non-Standard Ports for Auto-Discovery Discovered Database Information Populating Connection Form MS-SQL MS-SQL Connection Summary Button Connection Summary Output Connection Summary Rule Chaining Rule Chaining Setting Screen Rule Chaining Chaining with Parameterized User-Defined Rules General Pudr Steps Parameterized User-Defined Rule Flow Diagram Validating the Pudr before Saving Disabled Parameter Checkboxes Example of Chaining to a PL/SQL-based Pudr Item Setting for Session Policy Policy Settings for Suspicious Login Time Immediate Table Columns That Could Appear in Alerts Chained-Rule Alerts UBM Session Policy and PudrResulting Killed Session DB Example Multiple Source-Rule-Violation Behavior Rule Chaining Setting a Report Schedule Setting a Timer-based ScheduleAlert Report Manager Deleting a Timer Schedule Deleting a Previously Set Timer ScheduleSetting a Calendar-based Schedule Setting a Timer-Based Schedule Setting a Randomized Interval Setting a Combined ScheduleSetting a Randomized Interval Setting a Calendar-Based Schedule ARM Reporting by Time ARM Reporting by Time Calendar Pop-up Reporting by TimeEnabling Email Recipients Specifying Report Parameters New Reports Menu New Report Setting Screen top New Report Setting Screen bottom Using the Select Checkbox to Affect Multiple Reports Saved and Enabled Report View Reports Dropdown List on Current Reports Screen Activating ARMRunning and Analyzing Reports Status Menu Status Dialog Summary-Action Output Types Current Report ConfigurationReport Summary Action Choosing Summary Report Action Report Detailed Action LimitationReport Size Archiving Reports Custom Reports Using This FeatureCustom Reports Scheduling Time-only Schedule Settings Daily Schedule Settings Weekly Schedule Settings Monthly Schedule SettingsCustomer and Company Information Report and Template Generation and Management Company Information DialogCustom Reports Main Adding Reports Modifying ReportsAdding a Report Deleting Reports Modifying a ReportDeleting a Report Modifying Report Templates Generating Reports Report ResultTemplates Manager Modifying a Template Generated Html Report Example Report History Report History Property Purpose Possible Values Default Licensing and AdministrationUser Administration for Custom Reports and SOX Reports Reports radio button on the User Administration screen Limitations Property Purpose Possible Values Default1 SOX Reports within Custom Reports Manager SOX Compliance Reports Report Name Acronym General Setup InstructionsReports and Acronyms Common Report Header Fields HPC Report Sample Cobit Objectives and Setup RequirementsHistory of Privilege Changes Report HPC Report Body Columns AUC Report Sample Abnormal or Unauthorized Changes to Data Report AUC AUS Report Sample Abnormal Use of Service Accounts Report AUS ATD Report Sample Abnormal Termination of Database Activity Report ATD End of Period Adjustments Report EPA Settings Dialog for the EPA ReportEPA Report Sample Assumptions Case VAS Report Sample Verification of Audit Settings Report VAS Licensing and Administration Archiving ReportsReport Size Verification of Audit Settings Report VAS Index