Database

All endpoint and log data is synchronized with the LabTech database.

This data can be used to create your own custom reports, monitors, and scripts.

With the exception of Role Detection rules, all plug-in data is contained in tables with the prefix "plugin_eset_ra_"

For example all endpoint threat data is contained in the table plugin_eset_ra_threat.

To use the endpoint-to-agent matches that the plug-in creates and manages you can use a SQL JOIN statement on the plugin_eset_ra_endpoint_weight table using the primary keys (era_id, client_name, and ComputerID)

Database Maintenance

Truncating log tables such as threats, and scans will not harm the plug-in but data will not be re-synchronized with the database.

Logs use datetime values to know what data needs to be requested from the ERA server.

These datetime values are stored in the table plugin_eset_ra_era for each ERA server. IE: last_threat, last_scan

These columns can be modified in the event a backlog sync is needed.