ConnectedSystem

Records data about systems connected to OctoSAM.

erDiagram
    ConnectedSystemType ||--o{ ConnectedSystem : "ConnectedSystemTypeID"
    ConnectedSystem ||--o{ ConnectedSystemHistory : "ConnectedSystemID"

Fields

Field	Type	Description
AdditionalData	string	Optionally contains JSON formatted additional information about the system
ConnectedSystemTypeID	numeric	Internal ID that references the ConnectedSystemType entity (Foreign Key)
Created	datetime	Date/Time this entity was created
Description	string	Description of the connected system
Guid	guid	Guid of the connected system, as provided by the scanner or import logic
ID	numeric	Internal ID for the ConnectedSystem entity (Primary Key)
LastScan	datetime	Date/Time the connected system was last scanned
Name	string	Name of the connected system
Res1	string	Reserved for future use
Res2	string	Reserved for future use

References

Column Name	Referenced Table	Description
ConnectedSystemTypeID	ConnectedSystemType	Lookup table for connected system types

Referenced by

Table	Column Name	Description
ConnectedSystemHistory	ConnectedSystemID	History about connected systems. This table is used to control and diagnose connections to systems such as ServiceNow, vCenter etc.