Skip to content

VirtualMachineHistory

Holds information about the scan history of a virtual machine. Mainly used to detect frequent change of host (license mobility).

erDiagram
    Machine ||--o{ VirtualMachineHistory : "HostMachineID"
    Machine ||--o{ VirtualMachineHistory : "MachineID"
    VirtualMachine ||--o{ VirtualMachineHistory : "VirtualMachineID"

Fields

Field Type Description
Created datetime Date/Time this history entity was created
DaysSinceLastHostChange numeric Number of days since this virtual machine was last migrated from another host
GuestScan boolean True if update to history is caused by a guest scan
HostChange boolean Host machine changed between prior scan and this scan
HostMachineID numeric Internal ID that references the Machine entity (Foreign Key)
ID numeric Internal ID for the VirtualMachineHistory entity (Primary Key)
MachineID numeric Internal ID that references the Machine entity (Foreign Key)
MemoryMB numeric Configured memory at time of scan
PoweredOn boolean True if virtual machine was powered on during this scan
Scan datetime Date/Time this history entity was scanned
ScanGUID guid Uuid of the scan that created this entity
UsedSpace decimal Used disk space at time of scan
VirtualCores numeric Virtual cores at time of scan
VirtualMachineID numeric Internal ID that references the VirtualMachine entity (Foreign Key)

References

Column Name Referenced Table Description
HostMachineID 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.
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.
VirtualMachineID VirtualMachine Holds information for virtual machines. For Hyper-V specific columns see MSDN WMI Msvm_ComputerSystem class.