Server Manager Help 10/6/2014 1

(1)

Server Manager

Help

(2)

(3)

Getting Started ... 7

About SpectorSoft Server Manager... 8

Client Server Architecture ... 9

System Requirements... 10

Screencasts ... 11

Upgrade from Disk Monitor ... 11

Upgrade from Internet Server Monitor ... 11

Upgrade from Log Manager ... 11

Licensing and Registration ... 12

Application Program Interface ... 16

PCI DSS Compliance ... 16

Terminology... 18

Tutorials ... 19

Configure Server Manager to use MySQL ... 20

Configure Server Manager to use SQL Server ... 24

Configure Server Manager to use the file system ... 27

Conserve Disk Space ... 30

Migrate to a New Server ... 30

Monitor a Rolling Text Log File (IIS) ... 32

Monitor CSV Files ... 40 Management Console ... 46 Management Console ... 46 Object Explorer ... 47 Options ... 48 Service Connections ... 49

Enable and Disable Objects ... 50

Monitor Hierarchy ... 51

Registry Explorer ... 51

Import a Disk List ... 52

Filename Masks ... 53

Server Manager Properties ... 54

Email Settings ... 55

Database Settings ... 56

Convert Data... 57

Active Directory Settings ... 58

(4)

Table of Contents

Web Server Publishing Settings ... 60

Management Server Settings ... 63

HTML and Email Template Settings ... 64

WMI Settings ... 67

Web Proxy Server Settings ... 67

SNMP Server Settings ... 68

Computers, Devices and Hosts ... 70

Add Computers, Devices and Hosts... 70

Assign Computer, Device or Host ... 71

Map Computers, Devices and Hosts ... 72

Computer, Device and Host Properties ... 73

Assign Logon As Credentials ... 74

Copy Assignments ... 75

Import a Host List ... 76

Search for Computers, Devices and Hosts ... 76

Browse Active Directory Dialog ... 77

Browse Network Dialog ... 77

Templates ... 78 Templates ... 78 Add Template ... 81 Assign Template ... 81 Template Properties ... 82 Reports ... 83 Reports ... 83 Add Report ... 84 Assign Report ... 84 Report Properties ... 85 Views ... 86 Summary Reports ... 87

Account Lockout Reports ... 88

Security Event Log Reports ... 92

Logon Sessions Reports ... 92

Failed Logons Reports ... 94

Success Logons Reports ... 96

Account Management Reports ... 98

New Accounts Reports ... 100

Object Access Reports ... 101

Event Log Reports ... 109

(5)

Duplicate Files Reports ... 115

File and Directory Access Permissions Reports ... 117

File Extension Reports ... 119

Largest Files Reports... 119

Least Accessed Files Reports ... 121

Recently Accessed Files Reports ... 123

Temporary Files Reports... 124

Schedules ... 126

Add Schedule ... 127

Assign Schedule ... 127

Schedule Properties... 128

Day and Time Exclusions ... 128

Delete Day and Time Exclusion ... 130

Day and Time Exclusion Properties ... 131

Filters ... 133

Add Filter ... 134

Assign Filter ... 134

Filter Properties ... 136

Import and Export Filters... 137

Actions, Alerts and Notifications ... 138

Desktop Actions, Alerts and Notifications ... 139

Add Action ... 140

Assign Action ... 141

Action Properties ... 141

Database Actions ... 142

Action Variable Tags ... 143

File Output Options ... 152

Tray Icon ... 153

Auto Configurators ... 155

Add Auto Configurator ... 155

Auto Configurator Properties ... 155

Assign Templates to Auto Configurator ... 157

Select Active Directory Organizational Unit ... 157

Groups ... 158

(6)

Table of Contents

Assign Group ... 160

Log Management ... 163

Email Logs ... 163

Encrypt and Sign Files ... 164

Event Log to Syslog ... 166

EVT and EVTX Files... 168

Export Logs ... 169

Log Repository Retention Policy ... 170

Search for Logs ... 171

Log Viewers... 172

Log Viewers ... 172

Event Log Viewer ... 173

Syslog Log Viewer ... 173

Text Log Log Viewer... 173

Goto Line ... 174

Windows Service ... 175

Assign Service Logon As Credentials... 175

Windows Service Log ... 175

Run the Service in Verbose Mode ... 176

Syslog Server ... 176 SNMP ... 177 SNMP Server ... 177 SNMP Server ... 177 SNMP Trap Viewer... 177 Batch Functions ... 178 Batch Functions ... 178

Batch Assign Computers, Devices and Hosts to a Group... 178

Batch Assign Logon As Credentials ... 179

Batch Assign Templates to a Group... 179

Batch Delete Computers, Devices and Hosts ... 180

Batch Update Auto Configurators ... 180

Batch Update Computers, Devices and Hosts ... 181

Batch Update Reports ... 181

Batch Update Templates ... 182

Select Multiple Auto Configurators ... 182

Select Multiple Computers, Devices and Hosts ... 183

(7)

Select Multiple Templates ... 184

Troubleshooting ... 185

Access Denied Errors ... 185

Quota Violation Errors ... 187

The RPC server is unavailable Errors ... 188

Windows Firewall ... 189

About SpectorSoft ... 190

(8)

(9)

introductory topics to get you started: § Client Server Architecture § Management Console § Groups

§ Terminology

After completing the Server Manager installation for the first time, there are some required configuration tasks you need to complete prior to configuring Server Manager to monitor and report.

Required tasks:

1. If you have already purchased a license, register your license.

2. Follow the Server Manager Configuration Wizard. If the wizard does not automatically open, select Tools > Server Manager Configuration Wizard. The wizard includes the following pages:

o Service Credentials o Email Settings o Database Settings

Optional tasks:

§ Configure Active Directory Connections § Configure Syslog Server Settings

§ Configure Web Server Publishing Settings § Configure Management Server Settings § Configure HTML and Email Template Settings § Configure WMI Settings

§ Configure Web Proxy Server Settings

What's next?

§ Add Computers, Devices and Hosts § Create and assign Templates § Create and schedule Reports

(10)

About SpectorSoft Server Manager

SpectorSoft Server Manager is an enterprise-wide systems and application monitoring software package enabling both small business and large enterprise System Administrators to proactively manage their networks and fulfill compliance requirements.

§ Consolidates, archives and monitors Windows Event Logs, Syslogs, and Text Log files. § Includes Security Event Log Reports such as:

§ Object Access Auditing § Failed Logon Attempts § Successful Logons § Logon Sessions § Account Management § Account Lockout § New Accounts § Monitors resources such as:

§ Disk space

§ CPU load over time § Memory load over time

§ Monitors and controls applications and services such as: § Websites

§ Email servers § Databases

§ Windows Services and Processes § Monitors Internet connectivity and throughput.

§ Includes extensive disk and directory monitoring and analysis functions and reports. § Monitors changes to the Windows Registry.

§ Monitors SSL and digital certificate expiration and validity.

How does Server Manager work?

Server Manager...

§ Installs to a single computer/server then remotely manages computers, devices, and hosts.

§ Is configured though a client user interface which can be installed to any Windows computer at any location.

§ Fires alerts and notifications through email, SMS, remote desktop popups, SNMP traps and more. § Automatically publishes systems and network status to your web server for remote access via your

iPhone or Android.

(11)

Client Server Architecture

Server Manager is implemented using client/server architecture. The server, referred to as the Server Manager Service, runs as a Windows service and is responsible for all Monitor and Report execution. The client application, referred to as the Management Console, runs on any supported Windows platform and is responsible for all configuration and management. The tray icon, also a client application, is responsible for desktop notifications (e.g. message box and sound alerts). You can install the console and tray icon on as many computers as necessary.

The client/server interface is implemented using TCP port 6766 by default. The TCP interface authenticates all incoming connections using Windows authentication. Access will only be granted if the user accessing the service belongs to the Administrator group. For secure environments, the TCP interface can be configured to encrypt all packets using private keys. For more information see Management Server Settings.

To configure the console or tray icon to connect to a remote service installation, see Service Connections. Server Manager is deployed through a single installer that always installs the service,

console and tray icon. If you only plan to use the console and/or tray icon, you can disable the SpectorSoft Server Manager service via the Windows Service Control Manager.

Related Topics

(12)

System Requirements

Supported Operating Systems

§ Windows Server 2012, 2008 R2, 2008, or 2003 § Windows 8, 7, Vista, or XP

Supported CPUs (64-Bit / 32-Bit)

Server Manager is offered in both 64-bit and 32-bit Windows installers. Be sure to install the 64-bit installer when targeting 64-bit hardware as the 64-bit installer includes 64-bit binaries.

Memory

4 GBs of available memory, 8 GBs suggested for large networks.

Microsoft .NET Framework 3.5 Service Pack 1

The installation detects if the .Net Framework 3.5 Service Pack 1 is already installed. If not, the framework is automatically downloaded from Microsoft and then installed. Please note the framework may take a significant amount of time to install. Please be patient while the installation completes.

Domain Administrator Account

To access and manage remote resources Server Manager requires domain administrator credentials. If off-domain, local administrator credentials. The first time the application is run, you will be prompted to assign administrator credentials to the service.

Windows Management Instrumentation (client and server)

Many functions within Server Manager utilize Microsoft's Windows Management Instrumentation (WMI) API (e.g. Event Log management, CPU, memory, services, processes, Access Permissions Reports).

Optional Components

(13)

Screencasts

SpectorSoft offers video screencast tutorials to help you learn how to use Server Manager.

· Introduction to Server Manager

· Server Manager Actions

· Server Manager Schedules

· Event Log Consolidation and Monitoring using Templates

· Object Access Reports

· Ping Monitoring and Reporting

· Complex Event Log Filtering

Upgrade from Disk Monitor

When installing Server Manager on a server that already has Disk Monitor installed, you will be prompted to upgrade. Server Manager includes an upgrade wizard that automatically imports your license and configurations, and optionally uninstalls Disk Monitor.

Upgrade from Internet Server Monitor

When installing Server Manager on a server that already has Internet Server Monitor installed, you will be prompted to upgrade. Server Manager includes an upgrade wizard that automatically imports your license and configurations, and optionally uninstalls Internet Server Monitor.

Upgrade from Log Manager

(14)

Licensing and Registration

Server Manager is licensed by the number of nodes being monitored. A node is defined as a unique IP address and/or hostname that is monitored, scanned, or otherwise managed by the Software. You can apply as many Templates (e.g. CPU, memory, disk space, web content, etc.) to each node as necessary.

A simple licensing sample:

If monitoring a single physical server called mycompany that hosts a web server (www.mycompany.com) and mail server (mail.mycompany.com), 3 nodes within your license will be required for each of the 3 addressable names:

§ mycompany (e.g. Ping monitor)

§ www.mycompany.com (e.g. HTTP monitor) § mail.mycompany.com (e.g. SMTP monitor)

If each of the 3 addressable names are on the same IP address, using the IP address instead of the addressable names will reduce the required hosts from 3 to 1.

To register your license:

(15)

3. Select Edit > Server Manager Properties. The Server Manager Properties view displays.

4. Select the Licensing tab then click Register License. The Register License dialog displays.

3. Specify the email address used when purchasing.

(16)

Licensing and Registration

If you are running on an isolated network, you can register your license at:

www.spectorsoft.com/support/registernodessm.asp

Fill out the license registration form. Once complete a license key file will be automatically emailed to you.

When moving this software from one server to another or when waiting for your

purchasing department to upgrade an existing license, SpectorSoft offers users the option to register up to 10% over the current number of nodes purchased.

Anytime your registered node count exceeds the number of nodes you purchased, you will receive a nightly notification email reminding you to reduce the number of registered nodes.

To set the maximum node count:

The Server Manager licensing enables you to install the Server Manager Service on multiple servers. For example, if you purchased a 100 node license, you could install Server Manager on three different servers potentially located at 3 different sites then configure each installation to monitor 33 nodes. Finally, a forth instance of Server Manager could be installed in a DMZ to monitor a single server within the DMZ for a total of 100 nodes. To set the number of nodes associated with a specific Server Manager installation:

1. Select Edit > Server Manager Properties. The Server Manager Properties view displays. 2. Select the Licensing tab.

3. From the Installed Licenses list, select the serial number to update. 4. From the Registration List, select the Host to update.

5. Click Set Maximum Node Count. The Set Maximum Nodes view displays. 6. Set the maximum number of nodes which you would like to manage.

If the target host is another remote installation, the target Server Manager Service will automatically update at midnight or can be manually updated by restarting the SpectorSoft Server Manager Service on the effected server.

When moving this software from one server to another or when waiting for your

purchasing department to upgrade an existing license, SpectorSoft offers users the option to register up to 10% over the current number of nodes purchased.

Anytime your registered node count exceeds the number of nodes you purchased, you will receive a nightly notification email reminding you to reduce the number of registered nodes.

To reset your license:

(17)

3. From the Installed Licenses list, select the serial number to return.

4. From the Registration List, select the Host you are no longer using then click Return License. 5. When prompted to confirm to return the license and disable all associated monitors, click Yes.

If the target host is another remote installation, the target Server Manager Service will automatically update at midnight or can be manually updated by restarting the SpectorSoft Server Manager Service on the effected server.

To renew your maintenance:

When your maintenance is about to expire, you can upgrade through the Management Console. 1. Select Edit > Server Manager Properties. The Server Manager Properties view displays. 2. Select the Licensing tab.

3. From the Installed Licenses list, select the serial number to renew then click Renew Maintenance. You will be re-directed to your Internet browser where you can then renew online.

If the server you are on does not have internet access you can renew at:

www.spectorsoft.com/purchase/renewal.asp

To upgrade or add more nodes to your license:

If your license only provides access to a sub-set of Templates and/or Reports or you would like to add more hosts to your current installation, you can upgrade through the Management Console.

3. From the Installed Licenses list, select the serial number to upgrade then click Upgrade License. You will be re-directed to your Internet browser where you can then upgrade online.

If the server you are on does not have internet access you can upgrade at:

(18)

Application Program Interface

Server Manager enables users to write custom applications to view monitor history data. For example, a user could create an application that shows ping response times or disk utilization over a period of time.

Consumption of history data can obtained when saving history to SQL Server, MySQL or Oracle. At this time there is no API to access file system based history.

Server Manager saves each monitor's history to a unique table. The table name for each monitor uses the following format:

M[HOST_ID]_[TEMPLATE_ID]

Host ID The internal object ID. Template ID The internal object ID. For example: H100_200

To view a Host ID:

1. From the Object Explorer, navigate to the target computer, device or host. 2. Right-click and select Host Properties. The Host Properties dialog displays. 3. The Host ID is listed within the General tab.

To view a Template ID:

1. From the Object Explorer, navigate to the target Template or Monitor.

2. Right-click and select Template Properties. The Template Properties view displays. 3. The Template ID is listed within the General tab.

PCI DSS Compliance

Server Manager provides software solutions to meet PCI DSS compliance requirements as defined in v2.0 section 10 of the PCI Data Security Standard.

Section Requirement Solution

10.2 Implement automated audit trails for all system components to reconstruct the following events.

Out-of-the-box Security Event Log filters and Reports such as:

(19)

Access Security Event Log entries. 10.4 Using time-synchronization technology,

synchronize all critical system clocks and times and ensure that the following is implemented for acquiring, distributing, and storing time. Note: One example of time synchronization technology is Network Time Protocol (NTP).

Pre-installed Synchronize Clocks Template which uses NTP to synchronize clocks on all discovered Windows servers.

10.5 Secure audit trails so they cannot be altered. Pre-installed Event Log File Backup Template which can be scheduled to consolidate to a central log server then encrypt, password protect and digitally sign output files ensuring file integrity.

Includes a File Consolidation Template which can be scheduled to consolidate to a central log server any set of files then encrypt, password protect and digitally sign output files ensuring file integrity. Pre-installed Syslog Backup Template which can be scheduled to archive consolidated Syslog messages to a central log server then encrypt, password protect and digitally sign output files ensuring file integrity.

10.5.3 Promptly back up audit trail files to a

centralized log server or media that is difficult to alter.

Pre-installed Event Log Consolidation Template which can be scheduled to download Event Logs to a central log server then save to SQL Server, MySQL, Oracle or our own binary file format.

Includes a Syslog Server that is pre-configured to save all received Syslog messages. Optionally supports saving messages to SQL Server, MySQL or Oracle. Includes several Text Log Monitoring Templates that can be configured to save all entries to a central log server. Supported output includes: SQL Server, MySQL, Oracle and our own binary file format. 10.6 Review logs for all system components at least

daily. Log reviews must include those servers that perform security functions like intrusion-detection system (IDS) and authentication, authorization, and accounting protocol (AAA) servers (for example, RADIUS).

Note: Log harvesting, parsing, and alerting tools may be used to meet compliance with

Requirement 10.6.

Includes:

· Numerous log viewers that enable users to page through large volumes of data, hide duplicate entries, filter and merge multiple logs into a single view. · Out-of-the-box filters.

· Customizable filters with AND, OR, NOT, criteria nesting and regular expression support.

· Automated and on-demand Reporting.

Related Topics

(20)

Terminology

Term Definition

Action A configurable object that executes a function when:

· A monitor triggers, recovers, errors or completes. · A Report is complete or errors

· An Auto Configurator is complete or errors Auto

Configurator A configurable object used to monitor new servers and workstations. When utilized in large environments, Auto Configurators can be a very powerful tool enabling Server Manager to automatically monitor new and renamed servers without any interaction.

Desktop Action Desktop Actions are defined as Actions that are executed within a user's Windows desktop (e.g. message box alerts, sound alerts and optionally interactive file execution)

Filter A configurable object used to target or limit specific log entries or computers from real-time and consolidated log views, Monitors and Reports. Filters can also be used when manually searching computers in Active Directory or through an Auto Configurator.

Host Term used to refer to either a computer, a device (e.g. switch, router or firewall) or a hostname (e.g. www.spectorsoft.com).

Log Repository A database or file system location where log entries are saved.

· Primary Log Repository - Contains the LATEST consolidated log entries.

· Archive Log Repository - Contains ARCHIVED consolidated log entries previously saved to the Primary Log Repository

· Auxiliary Log Repository - Contains AUXILIARY or BACKUP consolidated logs. Typically used to view old database backups for auditing purposes.

Monitor The result of a host-Template assignment causing the function to execute on a scheduled basis (e.g a ping monitor).

Report A configurable object that enables users to receive summarized data on-demand or on a scheduled frequency. Reports typically output to an HTML file or email.

Schedule A configurable object that defines the frequency to execute a Monitor, Report or Auto Configurator (e.g. daily at 6:00 AM or every 5 minutes).

Management

Console The client application used to configure the service, view logs and manually execute Monitors, Reports and Auto Configurators. Server Manager

Service The server application responsible for executing Monitors, Reports and Auto Configurators. The service is implemented as a Windows Service. Server Manager

Tray Icon The client application that enables your Windows desktop to display system status, receive desktop notifications (e.g. message box alerts, sound alerts and optionally interactive file execution) and launch the Console.

(21)

Tutorials

Tutorials

The following tutorials are available:

· Configure Server Manager to use SQL Server

· Configure Server Manager to use MySQL

· Migrate to a New Server

· Monitor a Rolling Text Log File

· Monitor CSV Files

· Use Gmail as a Backup Email Server

Forum

If none of these topics help, please see our online forum at:

http://spectorlive.com/phpbb3/

Screencasts

SpectorSoft offers several video screencast tutorials to help you learn how to use Server Manager. The screencasts can be found at:

(22)

Configure Server Manager to use MySQL

In this tutorial, we walk you through the process of downloading, installing and configuring MySQL. Once completed, we will configure Server Manager to use MySQL when saving history and log entries. Lastly, we will download logs to the MySQL database and verify entries were written to the database.

Step 1: Download and install MySQL Community Server

Download and install MySQL Community Server from:

http://mysql.com/downloads/mysql/

Step 2: Download and install MySQL Workbench

The MySQL Workbench enables you to configure and manage MySQL. Download and install from:

http://mysql.com/downloads/workbench/

Step 3: Create new server instance

The first time you open the workbench you must add the connection to your database. From the Home page select New Server Instance. Follow the wizard adding in your connection information.

Step 4: Create databases

1. From the Home page, under the SQL Developmentcolumn, double-click on the connection to your database. The SQL Editor view is displayed.

2. From the toolbar click the button. The new_schema - Schema tab displays. 3. From the Name text box type CBSM

4. From the Collation drop-down select utf8 - default collation. 5. Click OK. The Apply SQL Script to Database dialog displays. 6. Click Apply then Finish.

(23)

Step 5: Create the database user and assign privileges

1. From the Home page, under the Server Administrationcolumn, double-click on the sever instance. The

Admin view is displayed.

2. From the Task and Object Browser view, select Users and Privileges. The Users and Privileges view displays.

3. From the Server Access Management tab, click Add Account 4. Set the Login Name to cbsmuser.

5. Enter a Password then duplicate the password in the Confirm Password text box. 6. Select the Administrative Roles tab.

7. From the Role list check DBA.

8. Click Apply. The MySQL configuration process is now complete.

Step 6: Configure the Log Repositories and History

1. From Server Manager, select Edit > Server Manager Properties. The Server Manager Properties

view displays.

2. Select the Databases tab.

3. Create the Primary Log Repository. a) Click the button.

b) From the Role drop-down select Log Repository. c) Specify a Name (e.g. MySQL Primary Log Repository). d) From the Provider drop-down select MySQL.

(24)

Configure Server Manager to use MySQL

f) Set the User name to cbsmuser. g) Specify the Password you set earlier. h) Set the Database to CBSM.

i) Click the button. The database is automatically initialized.

4. Create the Archive Log Repository. Follow the the instructions above, however; a) Set the Name to MySQL Archive Log Repository.

b) Set the Role to ArchiveLogRepository. c) Set the Database to CBSM_ARCHIVE.

5. Create the History database. Follow the the instructions above, however; a) Set the Name to MySQL History.

b) Set the Role to History.

c) Set the Database to CBSM_HISTORY.

Step 7: Test and verify the configuration

1. From the Object Explorer, add a new computer.

2. Assign the sample Event Log Consolidation and Monitoring Template.

3. Right-click on the Monitor you just created under your new computer and select Execute Now

(Verbose).

(25)

5. From the Object Explorer, expand Log Repositories > SQL Server Log Repository then navigate to the computer you just downloaded the logs from.

6. Expand the computer to find the Event Logs node.

7. Expand the Event Logs to find the Application, System and Security nodes.

8. Right-click on the Application node and select View Top 10000 Consolidated Log Entries. The Select

Display Filters dialog displays.

9. Check the Information, Warning and Error options then, if a filter is selected, click the button to clear the filter. Finally click OK. The Log Viewer displays.

10. Verify entries are displayed in the view.

11. From MySQL Workbench, within the SQL Editor, right-click then select Refresh All. The 3 databases you created are now listed.

12. Expand the CBSM > Tables node. Several table display including a table for each consolidated log. 13. You should now see a new table called [servername]_evt_application where [servername] is the name

of the server you downloaded the logs from. If you see this table, you have successfully downloaded the Event Log and saved it to your MySQL database, otherwise the Primary Log Repository is not configured to use this database. Check the Server Manager configurations and try again.

MySQL Log Repository Schema Defined

The Primary and Archive Log Repositories require the following tables: Table Description

level Contains a list of the Event Log levels (Information, Warning, Error, Audit Success, and Audit Failure).

facility Contains a list of the Syslog facilities. priority Contains a list of the Syslog priorities.

event_logs Contains an index of consolidated Event Logs. syslogs Contains an index of consolidated Syslogs. text_logs Contains an index of consolidated Text Logs.

Each log file is consolidated to its own table using the following naming conventions: Log Type Table

Event Log [host]_evt_[log] Syslog [host]_syslog

Text Log [GUID] - Since the only thing that uniquely identifies a text log is the filename and a filename can easily exceed the maximum length of a table name, a GUID is used in place of the filename. The

text_logs table maps the consolidated text log s filename to the GUID enabling the software to

identify which table to read and write entries from.

Related Topics

(26)

Configure Server Manager to use SQL Server

Log Repository Retention Policy

View Logs

Configure Server Manager to use SQL Server

In this tutorial, we walk you through the process of configuring SQL Server. Once completed, we will configure Server Manager to use SQL Server when saving history and log entries. Lastly, we will download logs to the SQL Server database and verify entries were written to the database.

Step 1: Create the databases

1. Open Microsoft SQL Server Management Studio. 2. From the Object Explorer, expand Databases. 3. Right-click then select New Database. 4. From the Database name text box type CBSM

5. Optionally, set the autogrowth to 100 MBs then click OK. The database is created.

6. Create 2 more databases, one for the Archive Log Repository named CBSM_ARCHIVE and the other for the History database named CBSM_HISTORY.

Step 2: Create the database user

1. From the Object Explorer, expand Security.

2. Right-click then select New Login. The New Login dialog displays. 3. From the Login name text box type cbsmuser.

4. Check SQL Server authentication. 5. Type a password.

6. Un-check Enforce password policy. 7. Click OK. The user is created.

Step 3: Assign the user to the databases

1. From the Object Explorer, expand Databases > CBLM > Security. 2. Right-click then select New User.

3. From the User name text box type cbsmuser. 4. From the Login name text box type cbsmuser.

5. From the Select a page view, select Membership. The Database role membership view displays. 6. Check db_owner.

7. Click OK. The user is assigned.

8. Repeat these steps for the CBSM_ARCHIVE and CBSM_HISTORY databases.

(27)

b) From the Role drop-down select Log Repository.

c) Specify a Name (e.g. SQL Server Primary Log Repository). d) From the Provider drop-down select SqlServer.

e) Specify the Server name. f) Set the User name to cblmuser. g) Specify the Password you set earlier. h) Set the Database to CBSM.

i) Click the button. The database is automatically initialized.

4. Create the Archive Log Repository. Follow the the instructions above, however; a) Set the Name to SQL Server Archive Log Repository.

b) Set the Role to ArchiveLogRepository. c) Set the Database to CBSM_ARCHIVE.

5. Create the History database. Follow the the instructions above, however; a) Set the Name to SQL Server History.

b) Set the Role to History.

(28)

Configure Server Manager to use SQL Server

(Verbose).

4. The Application, System and Security Event Logs are downloaded and saved to the SQL Server Primary Log Repository you just created and configured.

5. From the Object Explorer, expand Log Repositories > SQL Server Log Repository then navigate to the computer you just downloaded the logs from.

6. Expand the computer to find the Event Logs node.

7. Expand the Event Logs to find the Application, System and Security nodes.

11. From SQL Server Management Studio, within the Object Explorer, right-click then select Refresh. 12. Expand the Databases > CBSM > Tables node. Several table display including a table for each

consolidated log.

13. You should now see a new table called [servername]_evt_application where [servername] is the name of the server you downloaded the logs from. If you see this table, you have successfully downloaded the Event Log and saved it to your SQL Server database, otherwise the Primary Log Repository is not configured to use this database. Check the Server Manager configurations and try again.

SQL Server Log Repository Schema Defined

The Primary and Archive Log Repositories require the following tables: Table Description

level Contains a list of the Event Log levels (Information, Warning, Error, Audit Success, and Audit Failure).

facility Contains a list of the Syslog facilities. priority Contains a list of the Syslog priorities.

event_logs Contains an index of consolidated Event Logs. syslogs Contains an index of consolidated Syslogs. text_logs Contains an index of consolidated Text Logs.

Each log file is consolidated to its own table using the following naming conventions: Log Type Table

(29)

Text Log [GUID] - Since the only thing that uniquely identifies a text log is the filename and a filename can easily exceed the maximum length of a table name, a GUID is used in place of the filename. The

text_logs table maps the consolidated text log s filename to the GUID enabling the software to

identify which table to read and write entries from.

Related Topics

Conserve Disk Space Database Settings

View Logs

Configure Server Manager to use the file system

In this tutorial, we walk you through the process of configuring Server Manager to use the file system to save history and log entries. Lastly, we will download logs to the file system and verify entries were written to the directory.

Step 1: Create the directory

1. Open Windows Explorer.

2. Create 3 directories. One for the History, Primary Log Repository and the Archive Log Repository.

1. From Server Manager, select Edit > Server Manager Properties. The Server Manager Properties view displays.

2. Select the Databases tab.

b) From the Role drop-down select Log Repository. c) Specify a Name (e.g. Primary Log Repository). d) From the Provider drop-down select FileSystem. e) Specify the Path (e.g. c:\logs\Primary Log Repository).

f) Choose the Encoding. The default is UTF-8. Use UTF-16 when the primary language requires Unicode (e.g. Japanese).

(30)

Configure Server Manager to use the file system

4. Create the Archive Log Repository. Follow the the instructions above, however; a) Set the Name to Archive Log Repository.

b) Set the Role to ArchiveLogRepository.

c) Set the Path (e.g. c:\logs\Archive Log Repository).

5. Create the History directory. Follow the the instructions above, however; a) Set the Name to History.

b) Set the Role to History.

c) Set the Path (e.g. c:\logs\History).

(Verbose).

4. The Application, System and Security Event Logs are downloaded and saved to the SQL Server Primary Log Repository you just created and configured.

5. From the Object Explorer, expand Log Repositories > Primary Log Repository then navigate to the computer you just downloaded the logs from.

(31)

11. From Windows Explorer, navigate to Primary Log Repository directory. 12. From the list view, you should see a file for each consolidated log.

13. You should now see a new table called [servername]_evt_application.elf where [servername] is the name of the server you downloaded the logs from. If you see this table, you have successfully

downloaded the Event Log and saved it to your file system, otherwise the Primary Log Repository is not configured to use this directory. Check the Server Manager configurations and try again.

Each log file is consolidated to its own file using the following naming conventions: Log Type Table

Event Log [host]_[log].elf Syslog [host].slf

Text Log [GUID] - A GUID is used in place of the filename. The text_logs.dat file maps the consolidated text log's filename to the GUID enabling the software to identify which table to read and write entries from.

Related Topics

Conserve Disk Space Database Settings

(32)

Conserve Disk Space

When saving Event Logs to the Log Repository and using the File System format, new entries are downloaded and saved to a temporary file. Once the download is complete, the previously downloaded entries are appended to the temporary file. If saving data for a long period of time or if a server is generating large Event Logs over a short period of time, such as the Security Event Logs for example, these temporary files may get large (around 20 GB).

To optimize Server Manager to conserve disk space:

· From the Database Settings properties page, configure Server Manager to use SQL Server.

· Use Range Schedules to evenly distribute Event Log downloads over time. The end result is a process that regularly downloads Event Logs rather than a process that fires off 90 downloads all at once. The default Event Log Consolidation Template uses an Hourly Range Schedule that automatically

distributes Event Log downloads every hour.

· Limit the log retention policy to a manageable period. For example, save entries for 15 days in the Primary Log Repository and another 45 days in the Archive Log Repository for a total of 60 days. Every month at the end of the month make a database backup of the Archive Log Repository and save it to your organization's archives.

· When using an Event Log Consolidation and Monitoring Template, limit Post Consolidation Filter use. Instead, use Reports to access data on a daily basis rather than using post consolidation filters, which can result in frequent emails.

Related Topics

Database Settings Filters

Log Repository Retention Policy Schedules

Migrate to a New Server

When necessary, Server Manager can be moved to a another server.

To move your installation of Server Manager to another server:

1. Install the latest version of the software on the current server.

a) From the server the Server Manager Service is installed, ensure the latest version of Server Manager is running. From the local Console, select Help > Check for Update.

b) Once you have verified the latest version is running, backup the current configuration. From the local Console, select Tools > Backup Configuration. The Browse for Folder dialog displays.

(33)

d) Click OK. 2. Return the license.

a) After purchasing a license from SpectorSoft, you will receive a license key or set of keys via email.

b) Install and run Server Manager.

c) Select Edit > Server Manager Properties. The Server Manager Properties view displays. d) Select the Licensing tab then click Register License. The Register License Key dialog displays. e) Specify the email address used when purchasing and the license key you received via email. f) Click Submit.

3. Install, register and import the backed up configuration files on the new server. a) From the new server, download and install the latest version from

http://www.spectorsoft.com/support/downloads.asp?ItemID=41.

b) Select Edit > Server Manager Properties. The Server Manager Properties view displays. c) Select the Licensing tab then click Register License. The Register License Key dialog displays. d) Specify the email address used when purchasing and the license key you received via email. e) Click Submit.

f) If you were previously using local databases to store history and/or log entries, use your database tools to restore the databases to the new server.

g) Select Tools > Restore Configuration. When prompted to confirm to overwrite the current configurations, click Yes. The Browse for Folder dialog displays.

h) Select the folder that contains the configuration files you previously backed up. i) Click OK.

j) If you were previously using local databases to store history and/or log entries, select Edit >

(34)

Monitor a Rolling Text Log File (IIS)

Many applications such as Internet Information Services (IIS) Manager, log to a daily log file. Each day the application creates a new file that contains the date within the name, for example ex100625.log or 2010 June 25th. This format is simple to implement and enables system administrators to easily archive log files. This tutorial shows you how to monitor rolling text log files by configuring Server Manager to monitor IIS logs. After verifying the requirements, check the location the log files reside on the IIS server, then configure the Text Log Consolidation Template in Server Manager.

Requirements:

· Server 2012

· Internet Information Services (IIS) version 8.x

To check the log file location on the IIS server:

1. Logon to the target server.

2. From the Start menu select Administrative Tools > Internet Information Services (IIS) Manager. 3. From the left pane, select the target web site.

4. From the right pane, double-click Logging.

5. The log file path is listed within the Directory text box. By default the path is: %SystemDrive%\inetpub\logs\LogFiles,

which expands to:

c:\inetpub\logs\LogFiles.

IIS writes the log files to a sub-directory called: W3SVC1

This is the directory you want to monitor. Now that you have the location, you need to configure Server Manager to monitor the directory.

To configure the Text Log Consolidation Template:

1. Select File > New > Template. The Select Template Type dialog displays. 2. From the menu tree, expand Log Management > Text Log Management. 3. Double-click Text Log Consolidation. The Template Properties dialog displays. 4. From the General tab, set the Name to IIS Log Monitor. Use the default settings. 5. Select the Logs tab.

6. From the Servers/Workstations drop-down, select the server where IIS is installed.

7. From the Available Files tree, select the directory where the log files are located. The path displays in the text box below.

(35)

(36)

10. When prompted to add the mask, click Yes. The mask is added to the Assigned Files list.

11. Select the Function tab.

12. Use the Logical Name tab to specify a logical name which to consolidate all discovered log files. If you do not specify a Logical Name, each discovered file is saved to a unique database table.

Automated Text Log Reports and Log Repository Retention Policy Templates require masked directory monitors to consolidate to a logical name.

13. Check Use logical filename then type: u_ex.log

14. Use the Entry Pattern tab to define how Server Manager decyphers unique log entries. Since IIS log entries are limited to a single line, leave the Enable entry pattern recognition option disabled. 15. Use the Read Method tab to define how each file is read the first time the file is discovered or

updated. Use the default option Beginning of file. This read method will read all current entries in a newly discovered/monitored files, then consecutively read from the last known position.

16. Use the Consolidation, Filters and Actions tab to apply a consolidation filter, Log Repository Retention Policy Template and post consolidation Filters and Actions (e.g. to trigger an email alert when a specific entry is read).

Create a filter that passes all "HTTP GET" requests and assign an action. a) Click Add. The Assign Filter and Action dialog displays.

(37)

d) Click New Criteria.

e) From the Value text box, type GET. f) Check Match case.

g) From the Criteria control group click Apply. The criteria is added to the Group and Criteria Tree.

h) Click OK. The Filter is assigned.

(38)

1. Verify an email address is assigned. If one is not, add a valid email address. Click OK.

2. Click OK. The Filter and Action are added to the Post Consolidation Filter and Actions list.

(39)

b) Locate and expand your localhost. The IIS Log Monitor node displays. c) Right-click and select Explore. The Monitor Detail view displays.

d) This view should show the monitor is running and every minute a new history line item should be added showing the monitor's results.

e) From the Object Explorer, expand Log Repositories.

f) Locate and expand your localhost. The u_ex.log node should now display. If the node is not visible press F5. If the node is still not visible, verify the IIS log contains data and the Log Repositories have been configured correctly.

19. Test the Monitor, Filter, and Action.

a) Open your Internet browser then navigate to: http://localhost.

(40)

(41)

(42)

Monitor CSV Files

Server Manager enables you to monitor string as well as decimal values contained within CSV (comma separated value) files. For example, one of our customers monitors water flow rates through dams. The customer is able to receive notification when water flow rates fall outside expected values. Another more typical example is the monitoring of stock trading files. When monitored, you can receive notification when a stock exceeds or falls below a specific value.

To create a CSV file monitor:

1. Select File > New > Template. The Select Template Type dialog displays. 2. From the menu tree, expand Log Management > Text Log Management. 3. Double-click Text Log Monitor. The Template Properties dialog displays. 4. Use the General tab to configure the frequency to scan the file for new entries. 5. Select the Logs tab.

6. From the Servers/Workstations drop-down, select the server the file resides.

7. From the Available Files tree, select the file then click Add. The file is added to the Assigned Files list.

(43)

13. Use the Comma delimiter drop-down to select the character the column delimiter. The default is

COMMA.

14. Click Load then select the target file. The Load CSV Column Headers dialog displays.

(44)

Monitor CSV Files

16. Click OK. The file is read and an attempt is made to determine the data type of each column. Each column is added to the Column definition.

17. Assign filter criteria.

a) Click New Criteria. The Criteria control group is enabled. b) From the Attribute drop-down, select the column to monitor.

(45)

1. From the Criteria control group click Apply. The criteria is added to the Group and Criteria

Tree.

(46)

Monitor CSV Files

4. Click OK. The Filter and Action are added to the Filters and Actions list.

(47)

Use Gmail as a Backup Email Server

You can configure Server Manager to use your Gmail account to send email alerts when your primary email server is unavailable or unable to send.

To configure Gmail as a backup email server:

1. Select Edit > Server Manager Properties. The Server Manager Properties view displays. 2. Select the Email tab.

3. Check the Backup Email Server option then click Configure Backup. The Configure Backup Email

Server Connection dialog displays.

4. Use the following values: Servername smtp.gmail.com

TCP Port Use port 465 for SSL/TLS Use port 587 for STARTTLS

Username Enter your Gmail email address (e.g. [email protected]) Password Enter your Gmail password

5. From the Send test email to field, enter a non-gmail email address then click Test. A test email is sent. 6. Click OK.

(48)

Management Console

Management Console

Management Console

Server Manager is configured through the Management Console. The Console is a Windows client user interface application that enables you to remotely configure Server Manager, view log entries, view Monitor/Report detail and manually execute Monitors/Reports.

Navigation

The Console contains several views: Pane Description

Object Explorer The central navigation view that contains all of Server Manager's configurable objects. Use the Object Explorer to create objects, assign objects, update objects, view object detail and delete objects.

Service Output Tails the Server Manager log file containing errors, triggers, general activity, and verbose output. Use the Service Output pane to watch activity and troubleshoot monitors. Document View Displays object properties, Reports and Monitor detail.

Remote Access

(49)

Object Explorer

The Object Explorer is the central navigation view that contains all of Server Manager's configurable objects. Use the Object Explorer to create objects, assign objects, update objects, view object detail and delete objects. These objects include:

Nodes Description

Root Each configured Server Manager connection is added to the root.

Computers, Devices and Hosts Contains all of the managed hosts and their monitors. This includes physical computers, hardware devices and network addressable applications (e.g. web sites and SQL Server instances).

Monitors From within the Computers, Devices and Hosts node when viewing a host, assigned Templates appear under each host. Assigned Templates are referred to as Monitors. Monitors are a representation of a host-Template assignment or the result of a host group or Template group-Template assignment.

Templates Contains assignable monitor configurations (e.g. ping every 5 seconds and upon 20% failure rate fire an email alert).

Monitor Hierarchy Contains Monitor Hierarchy rules (e.g. when a ping monitor triggers, drop all corresponding Monitor error Actions).

Reports Contains reports (e.g. daily Summary, Object Access, and Largest Files Reports). Log Repositories Contains consolidated log entries (e.g. domain controller Security Event Logs). Schedules Contains the frequency to execute Monitors, Reports and Auto Configurators

(e.g. Daily, Hourly, Every Minute).

Filters Contains Active Directory and log monitoring filters (e.g. only show error events).

Actions Contains the actions, alerts, and notifications (e.g. email the systems administrators).

Auto Configurators Contains the Auto Configurators (e.g. every week scan Active Directory and add newly discovered servers to Server Manager).

To search the Object Explorer for a specific object:

1. From the Object Explorer, navigate to the location within the tree you would like to begin your search. 2. Press Ctrl + F. The Find dialog displays.

3. Enter the text you would like to search for. 4. Optionally, select Match case.

5. Optionally, select Use regular expressions (e.g. to search for 2 computers use the following regular expression syntax: (server01|server02).

6. Optionally, select Search up.

(50)

Options

Click Find All. The Find Results view displays. From this view, right-click on a result to view a list of menu items.

Related Topics

Actions, Alerts and Notifications Auto Configurators

Computers, Devices and Hosts Filters Groups Monitor Hierarchy Reports Schedules Templates

Options

The Options dialog enables you to set user preferences for the Management Console. For example, automatically displaying the dashboard at startup.

To modify the Server Manager Options:

Select Tools > Options. The Options dialog displays. The following options are available:

· Startup Windows: select any of the following to be displayed when a new connection is established: o Dashboard

o Service Output o Syslog Viewer o SNMP Trap Viewer o Error Report

· WMI Proxying: proxy WMI calls through the Server Manager Service · Tray Icon: disable the tray icon

· Log Viewer: configure the log viewer options and fonts Related Topics

Log Viewers

(51)

Service Connections

Server Manager is implemented using client/server architecture. The Management Console enables you to connect to remote installations of the service. The Connect to Service dialog provides the controls to create these connections.

If you are only using the Console and/or Tray Icon, you can disable the SpectorSoft Server Manager service via the Windows Service Control Manager.

License key registration is only required on the server the service is running. Neither the Console nor the Tray Icon require a license key registration.

To configure the Management Console and Tray Icon to connect to a remote service installation:

1. Install Server Manager on the computer you want to connect from.

2. Once installed, from that computer, select File > New > Server Manager Connection. The Connect to

Service dialog displays.

3. Specify a unique Connection name. 4. Specify the Server name or IP address.

5. Specify the TCP port. The default is 6766. For more information see Management Server Settings. 6. Specify a Windows domain administratorUsername, Password and Domain.

If the service is installed on another domain or within a workgroup, specify administrator credentials that reside on the target domain or server.

If the service is installed on an off-domain computer or within a workgroup either clear the Domain field or within the Domain field specify the computer name where the service is installed.

If left blank, your current Windows login credentials are used.

9. Choose to Encrypt packets then specify the private Key.

Encryption must first be configured on the server where the service is running. For more information see Management Server Settings.

10. Click Test. If the connection fails, check the settings on both the remote server and the local computer and verify all firewalls are allowing traffic on the configured port.

11. To auto generate a connection name, click Generate Name. 12. Click Connect.

Related Topics

Client Server Architecture Console

(52)

Enable and Disable Objects

When using Server Manager you will likely find times you need to disable a Monitor, Report or Auto

Configurator. For example, if you would like to shutdown all monitoring on a particular server while you apply operating system patches you can disable the host for a pre-determined period of time such as the next 30 minutes. Server Manager enables you to temporarily or permanently disable hosts, Templates, Reports and Auto Configurators.

To disable an object:

1. From the Object Explorer, navigate to the target object (e.g. host group, host, Template, Report or Auto Configurator).

2. Right-click then select Disable. The Enable/Disable Properties dialog displays. If the Disable menu item is not available, the object is already disabled.

By default objects are set to re-enable after 5 minutes.

When disabling multiple objects, use the Selected [Object Type] drop-down to fine tune specific object settings.

5. To permanently disable the object, un-check Enabled.

6. To automatically re-enable the object, check Temporarily disable this object then check Automatically

re-enable after. Set the period and units (e.g. 5 minutes).

7. Click Apply.

To enable an object:

1. From the Object Explorer, navigate to the target object (e.g. host group, host, Template, Report or Auto Configurator).

2. Right-click then select Enable.

If the Enable menu item is not available, the object is already enabled.

Related Topics

Batch Functions

(53)

Monitor Hierarchy

Depending on the state of the directly assigned monitors, hierarchy rules enable you to suppress child group trigger and/or recovery Actions.

To configure the monitor hierarchy:

1. From the Object Explorer, right-click on the Monitor Hierarchy node and select New Group. The

Create New Monitor Group dialog displays.

2. Enter a Name for the group.

3. Optionally, select Suppress child group monitor trigger Actions when all directly assigned monitors

have triggered.

4. Optionally, select Suppress child group monitor recovery Actions immediately preceding the recovery

of any directly assigned monitors.

5. Click OK.

6. From the Object Explorer, drag and drop each Monitor to the parent and child groups where appropriate.

Registry Explorer

The Registry Explorer allows you to view, modify, create, delete, and search remote registry keys and values.

To view the Registry Explorer:

1. From the Object Explorer, navigate to the target computer.

2. Right-click and select Registry Explorer. The Registry Explorer view displays.

To search for a registry key:

1. From the Registry Explorer, navigate to the location within the tree you would like to begin your search.

2. Press Ctrl + F. The Find dialog displays. 3. Enter the text you would like to search for. 4. Choose to search Keys, Values and/or Data. 5. Optionally, select Match case.

6. Optionally, select Match whole string only.

7. Optionally, select Use regular expressions (e.g. to search for 2 strings use the following regular expression syntax: (string01|string02).

8. Click Find Next. To continue searching press F3.

To modify a registry value:

1. From the Registry Explorer, navigate to the target registry key.

(54)

Import a Disk List

3. Update the value and click OK.

To create a new registry key:

1. From the Registry Explorer, navigate to the target parent registry key. 2. Right-click and select New > Key. The New Key dialog displays. 3. Enter the Name and click OK.

To create a new registry value:

1. From the Registry Explorer, navigate to the registry key.

2. Right-click and select New > [Type] Value where [Type] is one of the following: o String Value

o Expandable String Value o Multi-String-Value o DWORD Value o QWORD Value o Binary Value 3. Enter the value and click OK.

To delete a registry key or value:

1. From the Registry Explorer, navigate to the target registry key or value. 2. Press Del.

Import a Disk List

If you have a list of disks or shares in a spreadsheet, CSV (comma separated values), or text file, you can import your list into Server Manager. When imported disk monitor Templates are created and assigned to each computer, you have the option of creating a single Template per computer or a Template for each disk or share listed in your file.

If you have a list of computers, devices and/or hosts you would like to import see Import a

Host List.

To import a disk list:

1. Select File > Import > Disk List.

2. Follow the instructions found within the wizard. Related Topics

(55)

Filename Masks

When configuring some of the directory based Templates (e.g. Directory Cleaner, Directory Watcher or File Consolidation), you have the option to target or exclude specific filenames. Server Manager supports the standard Windows filter criteria (e.g. *.*) as well as our own date and time tag format enabling you to target or exclude files which the names contain the current date and/or time. The following tags are supported:

Variable Tag Description

Year yy or yyyy Use to replace the current year. Month M or MM Use to replace the current month. Day d or dd Use to replace the current day. Hour h or hh Use to replace the current hour.

When specifying date and time tags wrap the tags with <>.

For example:

*.log

(56)

Filename Masks

Server Manager Properties

The Server Manager Properties view enables you to configure the Server Manager Service (e.g. configure email server connection settings and backend databases).

To view the Server Manager Properties:

· Select Edit > Server Manager Properties. The Server Manager Properties view displays. The following tabs are available:

o Licensing

o Email

o Databases

o Active Directory

o Syslog Server

o Web Server Publishing

o Management Server

o HTML and Email Templates

(57)

Email Settings

Server Manager supports sending alerts, notifications, and Reports through email. Use the Email properties page to configure the outgoing email server connection settings.

To configure the email settings:

1. Select Edit > Server Manager Properties. The Server Manager Properties view displays. 2. Select the Email tab.

3. Enter the Server Information for the email server that will be sending messages.

4. Enter the Login Information to enable relay. If using Exchange Server and left blank, the login information defaults to the account the service is running under.

5. Optionally, modify the From Information to specify the name and from address to appear in outgoing mail.

6. Optionally, set and modify the Email Limiter to limit the number of emails sent over a period of time (e.g. seconds, minutes or hours). Once the limit is reached, messages are dropped for the remainder of the period. Dropped messages are logged to the service log file.

7. Enter an email address to receive a test message then click Test.

8. To use a backup email server when the configured email server is unavailable or unable to send an email, check the Backup Email Server option then click Configure Backup. The Configure Backup Email

Server Connection dialog displays. Use the dialog to configure the backup email server (repeat steps

3-7) then click OK.

9. Once you are able to successfully send a test message, click Close. Related Topics

(58)

Database Settings

Server Manager uses 5 database schemas to retain data:

Schema/Role Description

History Contains Monitor, Report and Auto Configurator history (e.g.

execution time, state, results such as consumed disk space). Primary Log Repository/LogRepository Contains the LATEST consolidated log entries. (e.g. log entries

less than 15 days old).

Archive Log Repository/ArchiveLogRepository Contains ARCHIVED consolidated log entries previously saved to the Primary Log Repository (e.g. log entries 15 days and older).

Auxiliary Log Repository/AuxiliaryLogRepository Contains AUXILIARY or BACKUP consolidated logs. Typically used to view old database backups for auditing purposes.

Undefined This database is not used. The Undefined setting allows you to

disable a database while maintaining the connection settings for later use.

Server Manager supports SQL Server, MySQL, Oracle as well as our own file system format (Local File System) when a database is not an option. When consolidating log entries you will notice significantly better

performance using SQL Server over our file system format. Server Manager has been optimized for SQL Server 2012/8/5.

To change the data provider type:

1. Select Edit > Server Manager Properties. The Server Manager Properties view displays. 2. Select the Databases tab.

3. From the Databases drop-down, select History or the equivalent entry whose Role is set to History. 4. From the Provider drop-down, select SqlServer or other target data provider. A provider specific view

displays.

5. Configure the provider specific properties. For detailed instructions see the appropriate tutorial:

o Configure Server Manager to use SQL Server.

o Configure Server Manager to use MySQL.

o Configure Server Manager to use the file system.

6. Click the button. The database is automatically initialized.

7. Repeat these steps for the LogRepository and ArchiveLogRepository roles.

When configuring SQL Server or MySQL, Server Manager will automatically create the database if it does not already exist; however, the default database options are used. To create a database from within the database specific management tools, see Configuring

Server Manager to use SQL Server or Configuring Server Manager to use MySQL.