Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ServerId | INT | 10 | null |
|
|
The primary key for the server that is reporting in. Foreign Key to the lt_servers table. |
||
| ServerServiceId | INT | 10 | null |
|
|
Identifies the Automate application that is reporting the information. Foreign Key to lt_serverservices table. |
||
| PluginId | INT | 10 | null |
|
|
The primary key for the plugin that is being reporting on. Foreign Key to the plugins table. |
||
| CertificateId | CHAR | 36 | null |
|
|
The unique identifier for the certificate that was used as a signing certificate. This value matches the CertificateId column in the lt_tp_certificates table. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc/Asc/Asc/Asc | ServerId + ServerServiceId + PluginId + CertificateId |
Diagram producer might be missing
No diagrams were produced please see application output for any errors