About the database file structure

The schema in Figure: External relational database tables depicts the relationships among the tables in the external relational database.

Figure: External relational database tables

The ID fields define the relationships in the database tables. For example, the value in the managerID field corresponds to a specific manager record in the manager table.

The tables and keys in the database are set up to enable logical relationship queries.

About suppressing a Security report item lists the tables in the external relational database.

Table: External relational database tables

Table name	Summary of stored data
ESMAgent	Agent properties including name and operating system.
ESMCheck	Security check properties including name, name list type, and description.
ESMCheckNameValue	Relation table for the PolicyCheckStateID/NameValue one to many relationship
ESMCheckValue	Relation table for the PolicyCheckStateID/ValueTitle one to one relationship
ESMDomain	Domain properties including name and manager
ESMDomainAgent	Relation table for the Domain/Agent many to many relationship
ESMJobRun	Policy run properties including start time, finish time, status, and maximum errors
ESMJobRunCheckResult	Policy run results for each enabled check
ESMManager	Manager name
ESMMessage	Module message properties including title, level, update, and message text
ESMOSVer	Operating system description
ESMPolicy	Policy name
ESMPolicyCheck	Policy check properties including module name and operating system
ESMPolicyCheckState	Policy check enabled or disabled
ESMSuppression	Suppression properties including creator name and date, expiration date, enabled or disabled, and last used date