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. |
||
| CertificateId | CHAR | 36 | null |
|
|
A unique identifier generated by the server for the reported certificate. |
||
| IssuerCertificateId | CHAR | 36 | √ | null |
|
|
The unique identifier for the isser certificate (if any) for this certificate. |
|
| Subject | MEDIUMTEXT | 16777215 | null |
|
|
The X509 Subject Name of this certificate. |
||
| ThumbprintSha256 | CHAR | 64 | null |
|
|
The SHA256 thumbprint of the certificate as a hexadecimal string. |
||
| ThumbprintSha1 | CHAR | 40 | null |
|
|
The SHA1 thumbprint of the certificate as a hexadecimal string. |
||
| CertificateBlob | MEDIUMBLOB | 16777215 | null |
|
|
The raw certificate payload. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc/Asc/Asc | ServerId + ServerServiceId + CertificateId |
Diagram producer might be missing
No diagrams were produced please see application output for any errors