Manage Applications


This module lets you manage the applications being monitored by EventLog Analyzer. Applications such as IIS Servers, Microsoft SQL Servers, Oracle databases, print servers, and terminal servers can be added, deleted, and viewed.

Adding MySQL Server

To add a MySQL server for monitoring:

Note: If the name of the MySQL server is manually entered, the port number has to be filled. For the MySQL servers selected from the list of discovered servers, the port number will be filled in automatically.

Advanced Settings

To make changes to the time zone and file encoding, click on the Advanced button and choose the relevant option from the drop downs provided.

Prerequisites to Discover MySQL Servers

Discovering MySQL servers in UNIX or Linux devices:

The MySQL server configuration file is found using the mysqld process.

Discovering MySQL servers in Windows devices:

The MySQL server configuration file is found using the mysqld.exe process.

In addition, the configuration file parameters are explored in the order:

--defaults-extra-file
--defaults-file

If the MySQL configuration file is not found with the mysqld or mysqld.exe process, then the following occurs:

UNIX or Linux: The configuration file location defaults to the location 

Windows: The configuration file location defaults to the following locations

From the command line parameters and the configuration file, the MySQL server General log path and Error log path are discovered.

Credentials for discovery:

For Windows devices, credentials for discovery is picked in the following order:

  1. Domain/workgroup credential if a device is under a domain or a workgroup.
  2. Device credential, if it is provided in the "Manage Devices" page.
  3. Logon credential.

For Linux devices, the credentials used while configuring auto log forward will be used for MySQL discovery. 

Note: In Linux installations, MySQL server discovery on Windows devices is not possible.

Adding an IIS server

  1. Navigate to Settings > Configuration > Manage Application Sources.
  2. In the Application Source Management page, click the + Add IIS server button.
  3. Click the + icon to browse and add IIS servers.
  4. If you wish to use the default credentials, select the check-box (Default credentials could be the device or domain or logged on credentials). Alternatively, you can enter a username and password in the credentials field.
  5. Select the time-zone from the dropdown menu and enter the desired monitoring interval.
  6. Note: The time-zone selected must be the same as that of the IIS server. Also, EventLog Analyzer uses port 445 (TCP) to read IIS log files using the Server Message Block (SMB) protocol.
  7. Click on + Add Sites. From the list of discovered sites, choose the sites you wish to monitor.

    Alternatively, you can manually add a site by entering the site name, protocol, and log file path in the pop-up that appears. Choose the file encoding scheme and schedule the log file rollover.

  8. Click Add and then Configure to start monitoring the site.

 

IIS Configuration Change Logs

Configuration change logs are collected in the IIS similar to how logs are collected for Windows. These logs are collected through the Microsoft-IIS-Configuration/Operational event source file.

Troubleshooting steps:

  1. Ensure that configuration log has been successfully configured. If not, you must configure it.
  2. The device that has been configured must be enabled. This can be done in the Manage Devices tab.
  3. Ensure that the Microsoft-IIS-Configuration/Operational option is enabled in the configure event source file for the device. This option can be enabled in the Manage Devices tab.
  4. The credentials provided must have the WMI access.

Adding a Microsoft SQL Server

  1. Navigate to Settings > Configuration > Manage Application Sources.
  2. In the Application Source Management page, click + Add SQL Server Instance. The SQL server instances are automatically discovered and listed out.
  3. Select the SQL Server instance(s) you wish to monitor and click Next. You will be taken to the Credential Configuration page and prompted to enter valid credentials.
  4. If you wish to use the default credentials, select the check-box (default credentials could be the device or domain or logged on credentials). Alternatively, you can enter a username and password in the credentials field and click Save.

If the SQL Server instance you wish to add for monitoring is not discovered automatically, click + Add Manually and you will be prompted to enter details for Windows Server configuration and SQL Server instance configuration.


Steps to add a SQL Server instance manually


(a) Windows server configuration

(b) SQL Server instance configuration
Get download link