Chatta subito con l'assistenza
Chat con il supporto

Archive Manager for Exchange 8.9 - Auditing Guide

Configure Database

info

NOTE: If Express installation was used to install Archive Manager for Exchange, the auditing database must be configured with the Configuration tool. If Advanced installation was used to install Archive Manager for Exchange, the database configuration is done automatically.

In this topic:

·Steps to configure the Auditing database

·Steps to install the Auditing database

·Steps to configure the connection setting


Steps to configure the Auditing database

1.When the installation completes, the Configuration wizard opens. If it does not open automatically, click Start > Quest > Archive Manager Configuration.

2.From the feature panel on the left, click Auditing and select the Database tab.

3.Click Configure. The Database Connection Wizard opens.

clip0004

4.Select either Microsoft SQL Server or Oracle and click Next. If you choose Microsost SQL Server, the Database Connection window opens for the Microsoft SQL Server connection information.

clip0005

For Microsoft SQL Server

a.Server name - name of the SQL server (eg. AMXDB)

b.Initial catalog - name of the HSM database (e.g. MAMAUDIT which is the default name of the HSM database)

c.Schema name - name of the SQL Schema (e.g. dbo)

d.Authentication – authentication type used for the database. Choose either Windows authentication or SQL Server authentication

e.Username - database login username if SQL Server authentication is the selected as the authentication mode.

f.Password - password of the database user if SQL Server authentication is the selected as the authentication mode.

For Oracle

a.Oracle net name - net service name that describes the network address of the database server in your tnsnames.ora file.

b.Schema - name of the Oracle schema from your tnsnames.ora file.

c.Username - database login username.

d.Password -  password of the database user.

5.Click Next and then click Yes on the confirmation dialog that opens.

6.If the database connection is setup successfully, the configuration completion window opens.

7.Click Finish to close the Database Connection wizard.


Steps to install the Auditing database

1.From the feature panel on the left in the Configuration tool, click Auditing and then select the Database tab.

2.Verify that the database connection information is as expected. Then click Run Scripts.

clip0006

3.Click Select All and then click Next. The script installer wizard opens.

clip0007

4.Enter the following information:

a.Authentication - authentication type used for the database. Choose either Windows authentication or SQL Server authentication

a.Database user - database login username if SQL Server authentication is the selected as the authentication mode.

b.Password - password of the database user if SQL Server authentication is the selected as the authentication mode.

c.I want to see the SQL script before it is run (for advanced users) - select this check box to review the SQL scripts.

5.Click Next.

6.If the I want to see the SQL script before it is run (for advanced users) check box was selected in the previous step the View SQL Scripts window opens.

clip0008

7.Click Next or if the I want to see the SQL script before it is run (for advanced users) check box was not selected, the Run SQL Scripts window opens.

clip0009

8.Click Next. to run the scripts.

9.Click Finish to close the script installer. The Scripts section of the Configuration tool displays the status and version of the scripts(the version of the scripts you install may differ from the version shown in the image below).

clip0003


Steps to configure the connection setting

1.From the feature panel on the left in the Configuration tool, click Auditing and then select the Connection tab.

clip0010

 

Configure Log targets

In the Log targets tab you can configure multiple types of log targets. The default and mandatory log target is the log database. Other targets are optional, depending on administrator’s needs. Multiple log targets can be defined and their usage can be conditional. Logging events of different severity can be logged to different targets or entries containing a specific string can be omitted.

clip0011

Steps to add a new log target

1.From the feature panel on the left in the Configuration tool, click Auditing and then select the Logtargets tab.

2.Click Add. The Add log target window opens.

clip0012

Enter the information as described below:

a.Name - name of the log target.

b.Type - type of the log target. Choose from one of the following options:

·Debug Output - writes log entries into the debug output; it can be used only for debugging purposes, since it does not keep the entries

·Event log - writes log entries into the system event log; it is recommended to use this target for critical errors and events only

·File - writes log entries into the specified file

·Rolling File - Writes log entries into files and rolls log files based on size or date or both

·Send a message to a user - sends log entries as network messages; it can be used for notification purposes in case of critical errors

·Email - sends log entries as e-mails; it can be used for notification purposes in case of critical errors

3.Click OK to add the new log target to the Log targets list view.

Steps to configure log targets

The target selected in the Log targets list can be configured in the Log target configuration section. You can configure it in the Log target configuration section. For each log target you can define:

·Threshold level

·Filters

·Layout (not applicable for database)

Additionally, every log target has its specific properties as described further.

Threshold Level

Threshold level specifies the threshold level for the selected log target. All logging events with lower level than the threshold level are ignored. If Off is selected, nothing will be logged for the selected target.

Filters

User can define a set of filters for each logging target. Filters form a chain that the logging event has to pass through. Any filter along the way can accept the event and stop processing, deny the event and stop processing, or allow the event on to the next filter. If the event gets to the end of the filter chain without being denied it is implicitly accepted and will be logged.

The available filter types are:

·StringMatchFilter – matches a string (or regular expression) in the rendered message

·PropertyMatchFilter – matches a string (or regular expression) in the value for a specific event property

·DenyAllFilter – this filter drops all logging events

To define a filter for a log target:

1.Select the log target in the Log targets list view.

2.In the Filters section click Edit.

3.In the Edit filters dialog double-click the filter type.

4.In the filters options specify filter settings.

5.Click Apply.

clip0013

Example:

If you want to allow through only messages that have a specific substring (e.g. 'database') then you need to specify the following filters:

·StringMatchFilter, String to match: ‘database’, Accept on match: true

·DenyAllFilter

If you do not want to log events having substring ‘debug’, you need to specify the following filter:

·StringMatchFilter, String to match: ‘debug’, Accept on match: false

Layout

User can define the layout of a log entry (line) for log targets, except of the Auditing Database. The layout is the sequence of property values separated by arbitrary characters. The available properties are:

·Product – product generating the logging event

·Category – category of the logging event

·Level – level of the logging event

·Message – application supplied message associated with the logging event

·Method – method name where the logging request was issued

·Data – data associated with the logging event

·Computer – name of the computer where the logging request was issued

·User – name of the user generating the logging request

·Date – date of the logging event

·Newline – platform dependent line separator character or characters

Specific Log target Properties

Auditing database

Intermediate directory

For minimizing the logging overhead, this log target operates in asynchronous mode, i.e. the entries are not written into the database directly, but they are held in an internal list and continually written into the database. In case of crash or other unpredictable situations the entries from the memory are lost, so there is an option to persist them to a file. By specifying the intermediate directory the intermediate file creation is activated. For each logging event a file is created, holding the event data. These files are deleted after the log entry was written to the database.

Flush intermediate files

Determines whether to flush the intermediate files immediately. If this option is set to false, then the underlying stream can defer persisting the entry to a later time, so it is likely that not the whole log entry will be written to the disk when the application exits, thus becoming the entry unusable and lost.

 

Event log

Application name

Specifies the Application name. This appears in the event logs when logging.

Log name

Specifies the name of the log where log entries will be stored. This is the name of the log as it appears in the Event Viewer tree. The default value is to log into the Application log, this is where most applications write their events. However if you need a separate log for your application (or applications) then you should specify the log name.

Level mapping

Specifies the mapping between a logging level (severity) and an event log entry type.

 

File

Log file

Specifies the path to the file that logging will be written to.

File creation

Indicates whether the file should be appended to or overwritten.

Locking model

Specifies the locking model used to handle locking of the file. When minimal locking is set, the system locks the file only for the minimal amount of time when logging each message. The exclusive locking locks the file from the start of logging to the end.

Immediate flush

Specifies whether to flush the log file immediately. Avoiding the flush operation at the end of each log writing results in a performance gain of 10 to 20 percent. However, there is safety trade-off involved in skipping flushing. Indeed, when flushing is skipped, then it is likely that the last few log events will not be recorded on disk when the application exits.

 

Rolling File

Log file

Specifies the path to the file that logging will be written to.

Backup file count

Specifies the maximum number of backup files that are kept before the oldest is erased

Rolling style

Specifies the rolling style; the possible values are the following:

·Once - roll files once per program run

·Size - roll files based only on the size of the file  

·Date - roll files based only on the date  

·Composite - roll files based on both the size and date of the file

Roll log files by size

Specifies the maximum size in bytes that the output file is allowed to reach before being rolled over to backup files.

Roll log files every

Specifies the interval when a log file is being rolled over to backup files.

File creation

Indicates whether the file should be appended to or overwritten.

Locking model

Specifies the locking model used to handle locking of the file. When minimal locking is set, the system locks the file only for the minimal amount of time when logging each message. The exclusive locking locks the file from the start of logging to the end.

Immediate flush

Specifies whether to flush the log file immediately. Avoiding the flush operation at the end of each log writing results in a performance gain of 10 to 20 percent. However, there is safety trade-off involved in skipping flushing. Indeed, when flushing is skipped, then it is likely that the last few log events will not be recorded on disk when the application exits.

 

Send a message to a user

Server

Specifies the DNS or NetBIOS name of the remote server on which the Net Send to run.

Recipient

Specifies the message alias to which the message should be sent.

 

Email

To

Specifies the e-mail address of the message recipient by semicolon-separated list of e-mail addresses.

From

Specifies the e-mail address of the sender.

Subject

Specifies the subject line of the e-mail message.

Smtp host

Specifies the name of the SMTP relay mail server to use to send the e-mail messages.

Buffer size

Specifies the size of the cyclic buffer used to hold the logging events. When the specified buffer size is reached, oldest events are deleted as new events are added to the buffer. The buffer is used to keep the logging context; when a message is sent, the whole content of the buffer is included.

If the buffer size is set to a value less than or equal to 1 then no buffering will occur and the messages are sent immediately.

 

Activate auditing

 

1.In the Archive Manager Administration Center, open Tools > Options > Server settings > Auditing.

2.Select the Activate Auditing check box.

3.In the Server Name enter the name of the machine where the Auditing feature is installed

4.Specify the Server Port or leave the default.

5.Click Apply.

clip0014

Add audit users

As the default, only the super-user has auditing rights, i.e. only the super-user can browse the auditing logs in ArchiveWeb. If you want other users to have access to auditing logs in ArchiveWeb, specific auditing roles must be granted.

1.Log on to ArchiveWeb with the super-user credentials.

2.Click the logged on user display name in the right upper corner. From the dropdown menu select Manage settings. Then click Roles on the grey sub-bar.

clip0021

3.In the left pane select the server for which the roles should apply. Or select Global option. ArchiveWeb roles appear in the main pane. List of roles is split into sections – Exchange Archive features are listed under Exchange roles, search features under Search roles etc. The Auditing roles are listed at the end.

4.Select the Show auditing logs role. All users with this role are displayed under the list. To add another user, click the Add users and groups icon (clip0024) to add it to the list. Then click the Allow toggle.

clip0022

Related Documents

The document was helpful.

Seleziona valutazione

I easily found the information I needed.

Seleziona valutazione