TNT Software server monitoring and event log management solutions

ELM Server Database and Reporting


ELM includes a built-in database engine that provides database support for:

  • Microsoft SQL Server/MSDE

 

ELM stores a variety of information in its database:

  • Alerts
  • Events generated by ELM Server and Agents
  • Software Inventory (Enterprise Manager Only)
  • Event Log Records (Enterprise Manager and Log Manager only)
  • SNMP Traps (Enterprise Manager and Log Manager only)
  • Syslog Messages (Enterprise Manager and Log Manager only)
  • Knowledge Base Articles (Enterprise Manager and Log Manager only)
  • Performance Data (Enterprise Manager and Performance Manager only)

 

During Setup, a Wizard will launch that will step you through the creation of your database. In addition, you will be able to specify an event retention period (e.g., how long collected events remain in your database). By default, ELM is pre-configured at installation with the following data retention defaults:

We recommend you change the first two lines with the * by them as these are set very short for evaluation purposes.
You can specify any other value (e.g., 1 day, 1 week, 2 weeks, 30 days, 1 year, etc.) by editing each line.

NOTE: These settings follow a top down hierarchy which is important to understand. Settings at the top will override the same type of criteria setting lower down on the list (lower priority).

You must first create an empty database to house the collected data. Thereafter, the appropriate tables and indexes will be automatically created.

ELM also includes a robust reporting engine that enables administrators to create and schedule reports without requiring any additional software. Reports in ELM uses ASP.Net to produce and manage reports. Predefined reports are grouped into categories for easy reference. Reports can be viewed through the Console or a web browser. The URL to the Reports folder is defined during setup by specifying the name of the virtual directory.

All reports are stored in the Reports container in the ELM Console. This container, as well as individual reports, support the application of Windows Access Control Lists (ACLs). You can secure the entire container, or secure individual reports.