ConnectedSystemHistory
History about connected systems. This table is used to control and diagnose connections to systems such as ServiceNow, vCenter etc.
erDiagram
ConnectedSystem ||--o{ ConnectedSystemHistory : "ConnectedSystemID"
Fields
| Field |
Type |
Description |
| AdditionalData |
string |
Additional data for this scan in JSON format |
| Clusters |
numeric |
Cluster count for this scan if provided by the partner system |
| ConnectedSystemID |
numeric |
Internal ID that references the ConnectedSystem entity (Foreign Key) |
| Errors |
numeric |
Errors during import of this scan |
| Filename |
string |
Filename of the import if available |
| Groups |
numeric |
Group count for this scan if provided by the partner system |
| ID |
numeric |
Internal ID for the ConnectedSystemHistory entity (Primary Key) |
| ImportDurationMillis |
numeric |
Duration of the import operation |
| Items |
numeric |
Total number of items for this scan |
| Machines |
numeric |
Machine count for this scan if provided by the partner system |
| Scan |
datetime |
Date/Time of the scan |
| ScanDurationMillis |
numeric |
Duration of the scan operation if provided by the partner system scanner / interface |
| ScanGuid |
guid |
Guid of the scan that created this item if available |
| Users |
numeric |
User count for this scan if provided by the partner system |
| VirtualMachines |
numeric |
Virtual machine count for this scan if provided by the partner system |
| Warnings |
numeric |
Warnings during import of this scan |
References
| Column Name |
Referenced Table |
Description |
| ConnectedSystemID |
ConnectedSystem |
Records data about systems connected to OctoSAM |