WmiInstance

Each entity is an instance of a class scanned on a particular machine.

erDiagram
    InformationSource ||--o{ WmiInstance : "InformationSourceID"
    Machine ||--o{ WmiInstance : "MachineID"
    WmiClass ||--o{ WmiInstance : "WmiClassID"
    WmiInstance ||--o{ WmiInstanceProperty : "WmiInstanceID"

Fields

Field	Type	Description
BulkInsertID	numeric	Internal ID used for bulk insert operations
Guid	guid	A unique ID that can be used to link to this WmiInstance object by external applications
ID	numeric	Internal ID for the WmiInstance entity (Primary Key)
ID	numeric	Internal ID for the WmiInstance entity (Primary Key)
ImporterInstance	string	Name of the importer Instance if multiple importers are active
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 of last scan that generated the instance information
LastScanGUID	guid	GUID of scan file that generated the instance information
MachineID	numeric	Internal ID that references the Machine entity (Foreign Key)
Name	string	Instance Name
ServiceNowLastExport	datetime	Date/Time of last export to ServiceNow
ServiceNowLastImport	datetime	Date/Time of last import from ServiceNow
ServiceNowSysID	guid	ServiceNow: sys_id of the replicated object
ServiceNowTargetClass	string	ServiceNow: class of the replicated object
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
MachineID	Machine	Basic machine information. A machine is a physical or virtual device that can be scanned by OctoSAM Inventory. A machine can also be a mobile device such as a phone or tablet.
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
WmiInstanceProperty	WmiInstanceID	Each entity is a property scanned for a particular instance of a WMI class per machine