WmiInstanceHistory

Each entity is an instance of a class scanned in a particular MachineUserHistory context. This table together with WmiInstanceHistoryProperty holds historized WMI data for each scan. See WmiInstance for description of the columns.

erDiagram
    InformationSource ||--o{ WmiInstanceHistory : "InformationSourceID"
    MachineUserHistory ||--o{ WmiInstanceHistory : "MachineUserHistoryID"
    WmiClass ||--o{ WmiInstanceHistory : "WmiClassID"
    WmiInstanceHistory ||--o{ WmiInstanceHistoryProperty : "WmiInstanceHistoryID"

Fields

Field	Type	Description
BulkInsertID	numeric	Internal ID used for bulk inserts
ID	numeric	Internal ID for the WmiInstanceHistory entity (Primary Key)
ImporterInstance	string	Name of the importer instance that created this entry
ImportSourceID	numeric	Id of the import module. 1 for OctoscanImportService or OctoscanImportUtil.
InformationSourceID	numeric	Internal ID that references the InformationSource entity (Foreign Key)
LastScan	datetime	Date/Time this instance history item was scanned
LastScanGUID	guid	UUID of the scan of this history item
MachineUserHistoryID	numeric	Internal ID that references the MachineUserHistory entity (Foreign Key)
Name	string	Instance name
WmiClassID	numeric	Internal ID that references the WmiClass entity (Foreign Key)

References

Column Name	Referenced Table	Description
InformationSourceID	InformationSource	Defines different information sources in the case that different scanners update information for the same machine
MachineUserHistoryID	MachineUserHistory	User logon history information
WmiClassID	WmiClass	Holds a row for each unique WMI class scanned (for systems that do not support WMI/CIM, OctoSAM defines a set of own classes such as Linux_ Aix_ or Mac_ classes).

Referenced by

Table	Column Name	Description
WmiInstanceHistoryProperty	WmiInstanceHistoryID	See WmiInstanceProperty for description of the columns