Application

The Application node is for configuring general settings which affect the way the Access Analyzer Console functions.

Application Log

The Access Analyzer Application Log section determines what information Access Analyzer stores in the application log.

The Application log level controls the types of messages generated for each job and the application. You can modify it at the job level in the Job Properties window. See the General Tab topic for additional information. Options available in the Application log level dropdown menu include:

• Debug – Records everything that happens during job execution, most verbose level of logging

  • Records all Info level information
  • Records everything else that happens
  • Creates the largest file

• Info – Records information about what stage of the job is being performed when errors or warnings occurred

  • Records all Warning level information
  • Records job progress information

• Warning – Records all warnings which occur during job execution

  • Records all Error level information
  • Records all warnings and the time of occurrence

• Error – Records all errors which occur during job execution

  • Records job start time
  • Records errors and the time of occurrence
  • Records job completion time

info

Set the log level to Warning. The global log level determines what messages Access Analyzer writes to the SA_Messages table and displays in the Access Analyzer Console. If a job has a higher log level than the global setting, those additional messages go to the job log only and don't appear in the database. For additional information on changing the job log level, see Job Properties | General tab.

The other log levels are designed to assist with troubleshooting job execution issues. Only use the Debug level when experiencing problems. After you fix the problem or send the Application log to Netwrix Support, reduce the logging level to Warning or Info.

Profile Security

The Profile Security section provides the option to enable an enhanced method of encryption to various credentials the Access Analyzer application stores.

.

There are two options available in the Profiles stored with dropdown menu:

• Application – Default setting, doesn't employ the enhanced encryption
• Vault – Enables the enhanced encryption of stored credentials. See the Vault topic for requirements and additional information.

Usage Statistics

Use the Usage Statistics section to select whether to send usage statistics data to Netwrix to help improve the product.

• If selected, Access Analyzer collects usage statistics and sends them to Netwrix

  • Upon startup of the Access Analyzer console, the system checks whether it has sent usage statistics in the last 7 days. If it hasn't, stored procedures run against the Access Analyzer database and gather data about job runs, access times, and environmental details like resource counts, user counts, number of exceptions, and so on. Access Analyzer then sends this data back to Netwrix to help identify usage trends and common problem areas and improve the product.
  • This includes only anonymous statistic-level data. Access Analyzer doesn't collect or send any private company or personal data to Netwrix.

• If cleared, Access Analyzer doesn't collect or send usage statistics to Netwrix

Host Target Options

The Host Target Options section provides radio buttons to select the source that Access Analyzer should use to connect to hosts.

Select from the following two options:

• Use host name
• Prefer DNS name if available

Grid View Parameters

The Grid View Parameters section controls how the data grids display within the Access Analyzer Console.

• Automatically rename duplicate columns within a table – Checks for and renames columns with duplicate names

• Automatically correct invalid column names – Checks for and corrects column names which contain characters SQL can't handle

  info

  Leave both options selected.

• Save filters and grouping on data grids – Maintains filters configured for a data grid for the next viewing. If not selected, filtered data grids reset between viewings.

• Maximum row count for interactive grid view – Indicates the number of rows displayed in tables accessible in under a job’s Status and Results nodes

  • Maximum row count defaults to 1000 and has a cap of 99,999 rows. This number doesn't impact the number of rows within the SQL database. To view the full row count for a table exceeding this size, use the SQL Server Management Studio or another SQL Server interface tool which displays the full table.

Filtered data grids aren't lost if you don't save persistent filters. The Filtration Dialog available for every data grid maintains a list of recent filters. See the Data Grid Functionality topic for additional information.

Cleanup

The Cleanup section is designed to conserve space in the SQL Database Transaction Log. It only works when you configure the database to use Simple Recovery Model.

• Compact Database Transaction Log – If selected, Access Analyzer compacts the Database Transaction Log every time you close the Access Analyzer application

  info

  In most environments, leave this option selected. If a scheduled task ends while multiple tasks are still running, the process of compacting the database freezes it and causes the running tasks to fail.

• Run Post Processing SQL Script to Set Host Status – If selected, this option ascribes the values of SUCCESS, WARNING, or ERROR to indicate what happened on that host during job execution

  info

  Leave this option selected.

Application Exit Options

The Application Exit Options section controls whether Access Analyzer displays a confirmation when you close the Access Analyzer application.

If selected, the Show Confirmation Dialog option causes a Confirm Exit window to open when the Access Analyzer user attempts to exit the application. If deselected, the Access Analyzer application closes without confirmation.

The Confirm Exit window requires you to click Yes before the Access Analyzer application closes.

The Cancel and Save buttons are in the lower-right corner of the Application view. These buttons become enabled when you modify the Application global settings. Whenever you make changes at the global level, click Save and then OK to confirm the changes. Otherwise, click Cancel if you didn't intend to make changes.