Discovery and Inventory Group

 View Only

Inventory Pack for Servers Database Schema 7.1: Part 1, Virtual Data 

Mar 12, 2013 11:11 AM

Note: Please refer to the attached document for the article contents and all live links contained in this article.

This is Part 1 of a 2 part article series detailing the data classes for Inventory Pack for Servers 7.1, providing administrators the knowledge they need to report on the newly expanded data set provided by this Solution.

Find Part 2 here: Inventory Pack for Servers Database Schema 7.1: Part 2, Database and Web

Introduction

Documenting database schema is not an easy task.  SQL can provide a table-column view of all selected tables, but this does not account for any interdependencies between tables in a normalized environment.  In 7.1 for Inventory Pack for Servers, Normalization includes dependencies on base-class tables, or, in other words, subsequent tables are extensions of the base table.  Association tables are also in use.

NOTE: The information in this document may change, though at the time of publication this is believed to be the accurate information for Inventory Pack for Servers 7.1.

Database Schema

The following list reveals data classes and their structure.  First, the name of the table is given, followed by a designation as a Base or Sub Class data class.  The following label system is used:

  • BASE Class – This is a data class that has no dependencies on other Inventory data classes
  • SUB Class – This is a data class that has 1 dependency on a BASE data class
  • STANDARD Class – This is a data class that contains no dependencies or sub classes
  • ASSOCIATION Class – This data class associates two other data classes’ rows together (not dependencies)

Note the following when reviewing the grids:

  1. Display Name represents how the column will be labeled when working within the Symantec Management Console, including reports, Resource Manager details, Pickers, etc.
  2. Not all values have descriptions, but the label of the table and column should provide data on what’s stored therein.
  3. When a BASE Class is listed, all subsequent SUB classes are tied to that BASE Class, sequentially, below.
  4. Qualifiers per Column/Value are provided based on applicability.

 

For help in navigating dependent data classes, use the following guide:

  • Inv_UNIX_Connectivity_Collection
    • Inv_UNIX_VMware_ESX_Connectivity_Collection
  • Inv_UNIX_Virtual_System_Setting_Data
    • Inv_UNIX_VMware_Virtual_System_Setting_Data
  • Inv_UNIX_VMware_ESX_Storage_Extent
    • Inv_UNIX_VMware_ESX_NFS_Extent
  • Inv_UNIX_Virtual_Logical_Device
    • Inv_UNIX_VMware_Virtual_SCSI_Controller
    • Inv_UNIX_VMware_Virtual_Storage
    • Inv_UNIX_VMware_Virtual_Network_Port
    • Inv_UNIX_VMware_Virtual_Parallel_Port
    • Inv_UNIX_VMware_Virtual_Serial_Port

 

Inv_UNIX_Connectivity_Collection – BASE Class

Name

Data Type

Qualifiers

Name

Value

_id

bigint

 

 

 

 

 

Description

Column ID for entries in the table

Key

true

_ResourceGuid

uniqueidentifier

 

 

 

 

 

Description

The reporting system’s GUID

Key

true

ElementName

string(256)

 

 

 

 

 

Description

User-friendly name of the connectivity collection.

DisplayName

Element Name

InstanceID

string(256)

 

 

 

 

 

Description

Unique identifier of the port group within the computer.

DisplayName

Instance ID

Key

true

Name

string(128)

 

 

 

 

 

Description

Identifying name of the collection.

DisplayName

Name

 

Inv_UNIX_VMware_ESX_Connectivity_Collection – SUB Class

Name

Data Type

Qualifiers

Name

Value

_id

bigint

 

 

 

 

 

Description

Column ID for entries in the table

Key

true

_ResourceGuid

uniqueidentifier

 

 

 

 

 

Description

The reporting system’s GUID

Key

true

CollectionType

uint16

 

 

 

 

 

Description

Type of the ports that are meant to be connected to the collection.

DisplayName

Collection Type

ValueMap

0, 1, 2, 3

Values

Unknown, Virtual Machine, Service Console, VMkernel

VLAN

uint32

 

 

 

 

 

Description

Identifier of the virtual local area network (VLAN).

DisplayName

VLAN

InstanceID

string(256)

 

 

 

 

 

Description

Unique identifier of the port group within the computer.

DisplayName

Instance ID

Key

true

 

Inv_UNIX_Virtual_System_Setting_Data – BASE Class

Name

Data Type

Qualifiers

 

Name

Value

 

_id

bigint

 

 

 

 

 

Description

Column ID for entries in the table

Key

true

_ResourceGuid

uniqueidentifier

 

 

 

 

 

Description

The reporting system’s GUID

Key

true

AutomaticShutdownAction

uint16

 

 

 

 

 

 

Description

Specifies what should happen to the virtual machine if host supports and allows shutting down virtual machines during its own shutdown.

 

DisplayName

Automatic Shutdown Action

 

ValueMap

2, 3, 4

 

Values

Turn Off, Save State, Shutdown

 

AutomaticShutdownDelay

uint32

 

 

 

 

 

 

Description

Specifies the default amount of time (in seconds) that should be granted to the virtual machine to shutdown before the next machine shutdown is initiated.

 

DisplayName

Automatic Shutdown Delay

 

AutomaticStartupAction

uint16

 

 

 

 

 

 

Description

Specifies what should happen to the virtual machine if host supports and allows starting virtual machines during its own start-up.

 

DisplayName

Automatic Startup Action

 

ValueMap

2, 4

 

Values

None, Always Startup

 

AutomaticStartupActionSequenceNumber

uint16

 

 

 

 

 

 

Description

Order in which the virtual machine is started or shut down in comparison to other virtual machines. The lower the value is the earlier startup is performed. Value of 0 indicates that any startup order is ok. Shutdown is performed in the reverse order.

 

DisplayName

Automatic Startup Action Sequence Number

 

AutomaticStartupDelay

uint32

 

 

 

 

 

 

Description

Specifies the default amount of time (in seconds) that should be granted to a virtual machine to startup before the next machine startup is initiated.

 

DisplayName

Automatic Startup Delay

 

ConfigurationDataRoot

string(1024)

 

 

 

 

 

 

Description

Absolute path to the directory containing the virtual machine configuration.

 

DisplayName

Configuration Data Root

 

ConfigurationFile

string(1024)

 

 

 

 

 

 

Description

Absolute path to the file containing configuration for the virtual machine.

 

DisplayName

Configuration File

 

ConfigurationID

string(128)

 

 

 

 

 

 

Description

Unique identifier of the current state of the configuration. This is important for the hierarchy of snapshots.

 

DisplayName

Configuration ID

 

CreationTime

datetime

 

 

 

 

 

 

Description

Date and time when the configuration settings were created or last modified.

 

DisplayName

Creation Time

 

ElementName

string(256)

 

 

 

 

 

 

Description

User-friendly name of the virtual machine.

 

DisplayName

Element Name

 

InstanceID

string(256)

 

 

 

 

 

 

Description

Unique identifier of the virtual machine configuration (computer-wide).

 

DisplayName

Instance ID

 

Key

true

 

LogFileDataRoot

string(1024)

 

 

 

 

 

 

Description

Absolute path to the directory containing log file for the virtual machine.

 

DisplayName

Log File Data Root

 

Notes

string

 

 

 

 

 

 

Description

Additional notes left by a user about the Virtual Machine.

 

DisplayName

Notes

 

SnapshotDataRoot

string(1024)

 

 

 

 

 

 

Description

Absolute path to the directory where the snapshot data for the virtual machine is stored.

 

DisplayName

Snapshot Data Root

 

SuspendDataRoot

string(1024)

 

 

 

 

 

 

Description

Absolute path to the directory where the suspended state data for the virtual machine is stored.

 

DisplayName

Suspend Data Root

 

SwapFileDataRoot

string(1024)

 

 

 

 

 

 

Description

Absolute path to the directory containing swap data for the virtual machine is stored.

 

DisplayName

Swap File Data Root

 

VirtualSystemIdentifier

string(128)

 

 

 

 

 

 

Description

Some kind of identifier for the virtual machine that can be used to map the configuration to the Computer Resource through the Inv_AeX_AC_VirtualMachine table.

 

DisplayName

Virtual System Identifier

 

VirtualSystemType

string(128)

 

 

 

 

 

 

Description

Type of the operating system running in the virtual machine.

 

DisplayName

Virtual System Type

 

 

Inv_UNIX_VMware_Virtual_System_Setting_Data – SUB Class

Name

Data Type

Qualifiers

 

Name

Value

 

_id

bigint

 

 

 

 

 

Description

Column ID for entries in the table

Key

true

_ResourceGuid

uniqueidentifier

 

 

 

 

 

Description

The reporting system’s GUID

Key

true

AccelerationDisabled

boolean

 

 

 

 

 

 

Description

Whether acceleration is disabled for the virtual machine.

 

DisplayName

Acceleration Disabled

 

AutomaticStartupWaitForHeartbeat

boolean

 

 

 

 

 

 

Description

Whether automatic startup of virtual machines should immediately continue if heartbeat from VMware Tools installed inside the virtual machine is detected.

 

DisplayName

Automatic Startup Wait For Heartbeat

 

ConfigurationFileVersion

string(64)

 

 

 

 

 

 

Description

Version of the VMX configuration file layout.

 

DisplayName

Configuration File Version

 

ConfigurationName

string(256)

 

 

 

 

 

 

Description

User-supplied name of the configuration settings (e.g. snapshot name).

 

DisplayName

Configuration Name

 

ConfigurationNotes

string

 

 

 

 

 

 

Description

User-supplied details notes for the configuration settings (e.g. snapshot description).

 

DisplayName

Configuration Notes

 

HyperThreadingSharing

uint16

 

 

 

 

 

 

Description

Controls access to a processor core that supports hyperthreadning.

 

DisplayName

HyperThreading Sharing

 

ValueMap

0, 1, 2, 3

 

Values

Unknown, Any, None, Internal

 

LocationID

string(38)

 

 

 

 

 

 

Description

Unique identifier for the virtual machine. On ESX 3.0.x this is generated when the virtual machine boots for the first time.

 

DisplayName

Location ID

 

LoggingEnabled

boolean

 

 

 

 

 

 

Description

Whether logging is enabled for the virtual machine.

 

DisplayName

Logging Enabled

 

MonitorMode

uint16

 

 

 

 

 

 

Description

Mode in which the virtual machine runs.

 

DisplayName

Monitor Mode

 

ValueMap

0, 1, 2

 

Values

Unknown, Release, Debug

 

PowerOffBehavior

uint16

 

 

 

 

 

 

Description

What should happen to the virtual machine when it is powered off.

 

DisplayName

Power Off Behavior

 

ValueMap

0, 1, 2

 

Values

Unknown, Hard, Soft

 

ResetBehavior

uint16

 

 

 

 

 

 

Description

What should happen to the virtual machine when it is reset.

 

DisplayName

Reset Behavior

 

ValueMap

0, 1, 2

 

Values

Unknown, Hard, Soft

 

SavedOperatingStatus

uint16

 

 

 

 

 

 

Description

Operating status that the virtual machine will have after the configuration is applied to the virtual machine (i.e. becomes active).

 

DisplayName

Operating Status

 

ValueMap

0, 5, 16, 0xC000, 0xC001

 

Values

Unknown, Stopped, In Service, Suspended, Not Applicable

 

SuspendBehavior

uint16

 

 

 

 

 

 

Description

What should happen to the virtual machine when it is suspended.

 

DisplayName

Suspend Behavior

 

ValueMap

0, 1, 2

 

Values

Unknown, Hard, Soft

 

VirtualHardwareVersion

string(64)

 

 

 

 

 

 

Description

Version of the virtual hardware defined in VMX. Also known as version of the virtual machine.

 

DisplayName

Virtual Hardware Version

 

VMwareToolsRunAfterPowerOn

boolean

 

 

 

 

 

 

Description

Boolean flag indicating whether VMware Tools scripts installed inside the virtual machine should run after the virtual machine is power on.

 

DisplayName

VMware Tools Run After Power On

 

VMwareToolsRunAfterResume

boolean

 

 

 

 

 

 

Description

Boolean flag indicating whether VMware Tools scripts installed inside the virtual machine should run after the virtual machine is resumed from suspended mode.

 

DisplayName

VMware Tools Run After Resume

 

VMwareToolsRunBeforePowerOff

boolean

 

 

 

 

 

 

Description

Boolean flag indicating whether VMware Tools scripts installed inside the virtual machine should run before the virtual machine is powered off.

 

DisplayName

VMware Tools Run Before Power Off

 

VMwareToolsRunBeforeSuspend

boolean

 

 

 

 

 

 

Description

Boolean flag indicating whether VMware Tools scripts installed inside the virtual machine should run before the virtual machine is suspended.

 

DisplayName

VMware Tools Run Before Suspend

 

VMwareToolsSyncTime

boolean

 

 

 

 

 

 

Description

Boolean flag indicating whether VMware Tools running on guest should synchronize system time with the host.

 

DisplayName

VMware Tools Sync Time

 

InstanceID

string(256)

 

 

 

 

 

 

Description

Unique identifier of the port group within the computer.

 

DisplayName

Instance ID

 

Key

true

 

                               

 

Inv_UNIX_VMware_ESX_Storage_Extent – BASE Class

Name

Data Type

Qualifiers

 

Name

Value

 

_id

bigint

 

 

 

 

 

Description

Column ID for entries in the table

Key

true

_ResourceGuid

uniqueidentifier

 

 

 

 

 

Description

The reporting system’s GUID

Key

true

InstanceID

string(256)

 

 

 

 

 

 

Description

Unique identifier of the storage extent within the computer.

 

DisplayName

Instance ID

 

Key

true

 

                         

 

Inv_UNIX_VMware_ESX_NFS_Extent – SUB Class

Name

Data Type

Qualifiers

 

Name

Value

 

_id

bigint

 

 

 

 

 

Description

Column ID for entries in the table

Key

true

_ResourceGuid

uniqueidentifier

 

 

 

 

 

Description

The reporting system’s GUID

Key

true

Accessible

boolean

 

 

 

 

 

 

Description

Whether the extent is currently accessible.

 

DisplayName

Accessible

 

Host

string(256)

 

 

 

 

 

 

Description

Host that the extent is mounted from.

 

DisplayName

Host

 

HostIP

string(64)

 

 

 

 

 

 

Description

IP address of the Host.

 

DisplayName

Host IP

 

Mounted

boolean

 

 

 

 

 

 

Description

Whether the extent is currently mounted.

 

DisplayName

Mounted

 

ReadOnly

boolean

 

 

 

 

 

 

Description

Whether the extent is mounted in read-only mode.

 

DisplayName

Read Only

 

ShareName

string(1024)

 

 

 

 

 

 

Description

Name of the share on NFS host.

 

DisplayName

Share Name

 

InstanceID

string(256)

 

 

 

 

 

 

Description

Unique identifier of the port group within the computer.

 

DisplayName

Instance ID

 

Key

true

 

 

Inv_UNIX_Virtual_Logical_Device – BASE Class

Name

Data Type

Qualifiers

 

Name

Value

 

_id

bigint

 

 

 

 

 

Description

Column ID for entries in the table

Key

true

_ResourceGuid

uniqueidentifier

 

 

 

 

 

Description

The reporting system’s GUID

Key

true

DeviceType

uint16

 

 

 

 

 

 

Description

Type of the virtual hardware device.

 

DisplayName

Device Type

 

ValueMap

0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13

 

Values

Unknown, Processor, Memory, IDE Controller, SCSI Controller, Storage, CD/DVD Drive, Floppy Drive, Generic SCSI Device, Ethernet Network Adapter, Serial Port, Parallel Port, USB Controller, Sound Adapter

 

InstanceID

string(256)

 

 

 

 

 

 

Description

Unique identifier for the virtual logical device (computer-wide).

 

DisplayName

Instance ID

 

Key

true

 

Name

string(128)

 

 

 

 

 

 

Description

Name of the device as defined in the configuration.

 

DisplayName

Name

 

                         

 

Inv_UNIX_VMware_Virtual_SCSI_Controller – SUB Class

Name

Data Type

Qualifiers

 

Name

Value

 

_id

bigint

 

 

 

 

 

Description

Column ID for entries in the table

Key

true

_ResourceGuid

uniqueidentifier

 

 

 

 

 

Description

The reporting system’s GUID

Key

true

VirtualDevice

uint16

 

 

 

 

 

 

Description

Type of the SCSI virtual controller.

 

DisplayName

Virtual Device

 

ValueMap

0, 1, 2

 

Values

Unknown, LSI Logic, BUS Logic

 

Instance ID

nvarchar

 

 

 

 

 

Description

Provides the ID of the VM Instance for a given database.

DisplayName

 

                           

 

Inv_UNIX_VMware_Virtual_Storage – SUB Class

Name

Data Type

Qualifiers

 

Name

Value

 

_id

bigint

 

 

 

 

 

Description

Column ID for entries in the table

Key

true

_ResourceGuid

uniqueidentifier

 

 

 

 

 

Description

The reporting system’s GUID

Key

true

AdapterType

uint16

 

 

 

 

 

 

Description

Type of the adapter that the virtual disk can be attached to.

 

DisplayName

Adapter Type

 

ValueMap

0, 1, 2, 3

 

Values

Unknown, LSI Logic, BUS Logic, IDE

 

StorageMode

uint16

 

 

 

 

 

 

Description

Policy for what should happen to the virtual hard disk when the virtual machine is powered off or when a snapshot is taken from it.

 

DisplayName

Storage Mode

 

ValueMap

0, 1, 2, 3

 

Values

Unknown, Persistent, Independent Non-Persistent, Independent Persistent

 

StorageType

uint16

 

 

 

 

 

 

Description

Type of the virtual disk backend.

 

DisplayName

Storage Type

 

ValueMap

0, 1, 2, 3, 4, 5, 6, 7, 8, 9

 

Values

Unknown, VMFS Thin, VMFS Thick, VMFS Raw Device Map, VMFS Passthrough Raw Device Map, VMFS Sparse, 2GB Extent Sparse, 2GB Extent Flat, Monolithic Sparse, Monolithic Flat

 

UniqueID

string(38)

 

 

 

 

 

 

Description

Unique identifier of the hard disk.

 

DisplayName

Unique ID

 

VirtualHardwareVersion

string(64)

 

 

 

 

 

 

Description

Version of the VMware virtual hardware defined in VMDK.

 

DisplayName

Virtual Hardware Version

 

Instance ID

nvarchar

 

 

 

 

 

Description

Provides the ID of the VM Instance for a given database.

DisplayName

 

 

Inv_UNIX_VMware_Virtual_Network_Port – SUB Class

Name

Data Type

Qualifiers

 

Name

Value

 

_id

bigint

 

 

 

 

 

Description

Column ID for entries in the table

Key

true

_ResourceGuid

uniqueidentifier

 

 

 

 

 

Description

The reporting system’s GUID

Key

true

MACAddressType

uint16

 

 

 

 

 

 

Description

Specifies the source for the MAC address for the network adapter.

 

DisplayName

MAC Address Type

 

ValueMap

0, 1, 2

 

Values

Unknown, Static, Generated

 

VirtualDevice

uint16

 

 

 

 

 

 

Description

Type of the virtual network adapter.

 

DisplayName

Virtual Device

 

ValueMap

0, 1, 2, 3, 4

 

Values

Unknown, vlance, vmxnet, vmxnet Enhanced, e1000

 

Instance ID

nvarchar

 

 

 

 

 

Description

Provides the ID of the VM Instance for a given database.

DisplayName

 

                               

 

Inv_UNIX_VMware_Virtual_Parallel_Port – SUB Class

Name

Data Type

Qualifiers

 

Name

Value

 

_id

bigint

 

 

 

 

 

Description

Column ID for entries in the table

Key

true

_ResourceGuid

uniqueidentifier

 

 

 

 

 

Description

The reporting system’s GUID

Key

true

Bidirectional

boolean

 

 

 

 

 

 

Description

Whether communication through the parallel port can be bidirectional.

 

DisplayName

Bidirectional

 

Instance ID

nvarchar

 

 

 

 

 

Description

Provides the ID of the VM Instance for a given database.

DisplayName

 

                                   

 

Inv_UNIX_VMware_Virtual_Serial_Port – SUB Class

Name

Data Type

Qualifiers

 

Name

Value

 

_id

bigint

 

 

 

 

 

Description

Column ID for entries in the table

Key

true

_ResourceGuid

uniqueidentifier

 

 

 

 

 

Description

The reporting system’s GUID

Key

true

PipeFarEnd

uint16

 

 

 

 

 

 

Description

In case serial port is using a named pipe for the backend, type of the far end of the pipe.

 

DisplayName

Pipe Far End

 

ValueMap

0, 1, 2, 3

 

Values

Unknown, None, Virtual Machine, Application

 

PipeNearEnd

uint16

 

 

 

 

 

 

Description

In case serial port is using a named pipe for the backend, type of the near end of the pipe.

 

DisplayName

Pipe Near End

 

ValueMap

0, 1, 2, 3

 

Values

Unknown, None, Client, Server

 

PolledModeEnabled

boolean

 

 

 

 

 

 

Description

Whether the guest is allowed to use the serial port in polled mode.

 

DisplayName

Polled Mode Enabled

 

                     

 

Inv_UNIX_Resource_Pool – STANDARD Class

Name

Data Type

Qualifiers

 

Name

Value

 

_id

bigint

 

 

 

 

 

Description

Column ID for entries in the table

Key

true

_ResourceGuid

uniqueidentifier

 

 

 

 

 

Description

The reporting system’s GUID

Key

true

AllocationUnits

string(64)

 

 

 

 

 

 

Description

Units in which the capacity of the pool is measured.Possible values are described in Attachment C.1 in the following document: http://www.dmtf.org/standards/published_documents/DSP0004_2.4.0.pdf

 

DisplayName

Allocation Units

 

Capacity

uint64

 

 

 

 

 

 

Description

Total capacity of the resource pool measured in Allocation Units.

 

DisplayName

Capacity

 

ElementName

string(256)

 

 

 

 

 

 

Description

User-friendly name of the Resource Pool.

 

DisplayName

ElementName

 

InstanceID

string(256)

 

 

 

 

 

 

Description

Universally unique ID of the resource pool within the Computer Resource. This is the same as Resource Pool ID, but should handle cases when there can be multiple pools having same Resource Pool ID, but differing otherwise (either by types of resources or by belonging to Virtualization Product installations).

 

DisplayName

Instance ID

 

Key

true

 

PoolID

string(256)

 

 

 

 

 

 

Description

Unique ID of the resource pool within the Virtualization Product installation.

 

DisplayName

Pool ID

 

Primordial

boolean

 

 

 

 

 

 

Description

Indicates that this Resource Pool is a base from which resources are drawn and returned in the activity of resource management. Being primordial means that this Resource Pool shall not be created or deleted by consumers of this model.

 

DisplayName

Primordial

 

Reserved

uint64

 

 

 

 

 

 

Description

Amount of resource measured in Allocation Units that is reserved by resource allocations made from this pool.

 

DisplayName

Reserved

 

ResourceType

uint16

 

 

 

 

 

 

Description

Type of the resources serviced by the resource pool.

 

DisplayName

Resource Type

 

ValueMap

1, 3, 4

 

Values

Other, Processor, Memory

 

                       

 

Inv_UNIX_Switch_Port – STANDARD Class

Name

Data Type

Qualifiers

 

Name

Value

 

_id

bigint

 

 

 

 

 

Description

Column ID for entries in the table

Key

true

_ResourceGuid

uniqueidentifier

 

 

 

 

 

Description

The reporting system’s GUID

Key

true

InstanceID

string(256)

 

 

 

 

 

 

Description

Unique identifier of the switch port within the computer.

 

DisplayName

Instance ID

 

Key

true

 

Name

string(128)

 

 

 

 

 

 

Description

Identifying name of the switch.

 

DisplayName

Name

 

TotalPorts

uint32

 

 

 

 

 

 

Description

Total number of ports in the virtual switch.

 

DisplayName

Total Ports

 

UsedPorts

uint32

 

 

 

 

 

 

Description

Total number of ports in the virtual switch that are currently in-use.

 

DisplayName

Used Ports

 

                         

 

Inv_UNIX_Virtual_Computer_System – STANDARD Class

Name

Data Type

Qualifiers

 

Name

Value

 

_id

bigint

 

 

 

 

 

Description

Column ID for entries in the table

Key

true

_ResourceGuid

uniqueidentifier

 

 

 

 

 

Description

The reporting system’s GUID

Key

true

Name

string(128)

 

 

 

 

 

 

Description

Unique identifier for the virtual machine.

 

DisplayName

Name

 

Key

true

 

OperatingStatus

uint16

 

 

 

 

 

 

Description

Indicates the current status of the virtual machine. Value "Stopped" indicates that the VM is not running. Value "In Service" indicates that the VM is up and running. "Suspended" means that the VM is not running, but memory state is available for resuming. "Stuck" means that the VM is paused because the hosting Virtualization Product requires some information from user.

 

DisplayName

Operating Status

 

ValueMap

0, 5, 16, 0xC000, 0xC001

 

Values

Unknown, Stopped, In Service, Suspended, Stuck

 

                       

 

Inv_UNIX_Virtualization_Provider – STANDARD Class

Name

Data Type

Qualifiers

 

Name

Value

 

_id

bigint

 

 

 

 

 

Description

Column ID for entries in the table

Key

true

_ResourceGuid

uniqueidentifier

 

 

 

 

 

Description

The reporting system’s GUID

Key

true

InstanceID

string(256)

 

 

 

 

 

 

Description

Unique identifier of the virtualization product installation.

 

DisplayName

Instance ID

 

Key

true

 

OperatingStatus

uint16

 

 

 

 

 

 

Description

Indicates the current status of the Virtualization Product. Value "Servicing" means that the product is currently undergoing some maintenance. Value "Stopped" indicates that the virtualization product is now not working. Value "In Service" indicates that the product is fully up and running.

 

DisplayName

Operating Status

 

ValueMap

2, 5, 16

 

Values

Servicing, Stopped, In Service

 

                       

 

Inv_UNIX_VMware_ESX_Advanced_Configuration_Data – STANDARD Class

Name

Data Type

Qualifiers

 

Name

Value

 

_id

bigint

 

 

 

 

 

Description

Column ID for entries in the table

Key

true

_ResourceGuid

uniqueidentifier

 

 

 

 

 

Description

The reporting system’s GUID

Key

true

DefaultValue

string

 

 

 

 

 

 

Description

Default value of the configuration option.

 

DisplayName

Default Value

 

Description

string

 

 

 

 

 

 

Description

Detailed information about what the option is meant for.

 

DisplayName

Description

 

ElementName

string(1024)

 

 

 

 

 

 

Description

Name of the advanced configuration option as it appears to user.

 

DisplayName

Element Name

 

InstanceID

string(256)

 

 

 

 

 

 

Description

Unique identifier of the advanced configuration setting.

 

DisplayName

Instance ID

 

Key

true

 

MaxValue

string

 

 

 

 

 

 

Description

Maximal value allowed for the configuration option.

 

DisplayName

Maximal Value

 

MinValue

string

 

 

 

 

 

 

Description

Minimal value allowed for the configuration option.

 

DisplayName

Minimal Value

 

OptionType

uint16

 

 

 

 

 

 

Description

Type of the data that can be used for option's value.

 

DisplayName

Option Type

 

ValueMap

0, 1, 2, 3

 

Values

Unknown, Integer, String, Boolean

 

Value

string

 

 

 

 

 

 

Description

Current (active) value of the configuration option.

 

DisplayName

Value

 

 

Inv_UNIX_VMware_ESX_Network_Policy – STANDARD Class

Name

Data Type

Qualifiers

 

Name

Value

 

_id

bigint

 

 

 

 

 

Description

Column ID for entries in the table

Key

true

_ResourceGuid

uniqueidentifier

 

 

 

 

 

Description

The reporting system’s GUID

Key

true

AverageBandwidth

uint64

 

 

 

 

 

 

Description

If Traffic Shaping is enabled, average allowed bandwidth (in bits per second).

 

DisplayName

Average Bandwidth

 

BurstSize

uint64

 

 

 

 

 

 

Description

If Traffic Shaping is enabled, the maximum number of bytes to allow in a burst. If a burst exceeds the burst size parameter, excess packets are queued for later transmission. If the queue is full, the packets are dropped. When you specify values for these two characteristics, you indicate what you expect the vSwitch to handle during normal operation.

 

DisplayName

Burst Size

 

FallbackPolicy

uint16

 

 

 

 

 

 

Description

If Fallback, the adapter is returned to active duty immediately on recovery, displacing the standby adapter that took over its slot, if any. If Replace, a failed adapter is left inactive even after recovery until another active adapter fails, requiring its replacement.

 

DisplayName

Fallback Policy

 

ValueMap

0, 1, 2

 

Values

Unset, Fallback, Replace

 

ForgedTransmits

uint16

 

 

 

 

 

 

Description

Whether forged transmits are enabled.

 

DisplayName

Forged Transmits

 

ValueMap

0, 1, 2

 

Values

Unset, Reject, Accept

 

InstanceID

string(256)

 

 

 

 

 

 

Description

Unique identifier of the network policy.

 

DisplayName

Instance ID

 

Key

true

 

LoadBalancingPolicy

uint16

 

 

 

 

 

 

Description

Determines how outgoing traffic is distributed among the assigned network adapters.

 

DisplayName

Load Balancing Policy

 

ValueMap

0, 1, 2, 3, 4

 

Values

Unset, SourcePortID, IP_Hash, MAC_Hash, Explicit

 

MACAddressChanges

uint16

 

 

 

 

 

 

Description

Whether changing of MAC address is allowed.

 

DisplayName

MAC Address Changes

 

ValueMap

0, 1, 2

 

Values

Unset, Reject, Accept

 

NetworkFailoverDetection

uint16

 

 

 

 

 

 

Description

Specifies how network failures are to be detected.

 

DisplayName

Network Failover Detection

 

ValueMap

0, 1, 2

 

Values

Unset, LinkStatusOnly, BeaconProbing

 

NotifySwitches

uint16

 

 

 

 

 

 

Description

If value is Yes, whenever a virtual NIC is connected to the vSwitch or whenever that virtual NIC's traffic is routed over a different physical NIC in the team because of a failover event, a notification is sent over the network to update the lookup tables on the physical switches.

 

DisplayName

Notify Switches

 

ValueMap

0, 1, 2

 

Values

Unset, Yes, No

 

PeakBandwidth

uint64

 

 

 

 

 

 

Description

If Traffic Shaping is enabled, maximum allowed bandwidth (in bits per second).

 

DisplayName

Peak Bandwidth

 

PromiscuousMode

uint16

 

 

 

 

 

 

Description

Whether the promiscuous mode is enabled for the connectivity.

 

DisplayName

Promiscuous Mode

 

ValueMap

0, 1, 2

 

Values

Unset, Reject, Accept

 

TrafficShapingPolicy

uint16

 

 

 

 

 

 

Description

Whether traffic shaping (bandwidth throttling) is enabled.

 

DisplayName

Traffic Shaping Policy

 

ValueMap

0, 1, 2

 

Values

Unset, Enabled, Disabled

 

                     

 

Inv_UNIX_VMware_ESX_Setting_Data – STANDARD Class

Name

Data Type

Qualifiers

 

Name

Value

 

_id

bigint

 

 

 

 

 

Description

Column ID for entries in the table

Key

true

_ResourceGuid

uniqueidentifier

 

 

 

 

 

Description

The reporting system’s GUID

Key

true

AutomaticShutdownAction

uint16

 

 

 

 

 

 

Description

Specifies what should happen (by default) to a virtual machine when the host is shutting down: Turn Off (hard power off), Save State (suspend) or Shutdown (ask guest to shut down).

 

DisplayName

Automatic Shutdown Action

 

ValueMap

2, 3, 4

 

Values

Turn Off, Save State, Shutdown

 

AutomaticShutdownDelay

uint32

 

 

 

 

 

 

Description

Specifies the default amount of time (in seconds) that should be granted to the virtual machine to shutdown before the next machine shutdown is initiated.

 

DisplayName

Automatic Shutdown Delay

 

AutomaticStartupDelay

uint32

 

 

 

 

 

 

Description

Specifies the default amount of time (in seconds) that should be granted to a virtual machine to startup before the next machine startup is initiated.

 

DisplayName

Automatic Startup Delay

 

AutomaticStartupEnabled

boolean

 

 

 

 

 

 

Description

Boolean flag indicating whether virtual machines are allowed to start during host startup.

 

DisplayName

Automatic Startup Enabled

 

AutomaticStartupWaitForHeartbeat

boolean

 

 

 

 

 

 

Description

Boolean flag indicating whether automatic startup of virtual machines should immediately continue (without waiting for the startup delay) if VMware tools heartbeat is received from the virtual machine.

 

DisplayName

Automatic Startup Wait For Heartbeat

 

ServiceConsoleMemoryAmount

uint64

 

 

 

 

 

 

Description

Part of the total physical memory allocated to the Service Console part of the ESX Server (in megabytes). This is the effective value. Admin can configure a different value, which will become effective after host is rebooted.

 

DisplayName

Service Console Memory Amount

 

SystemMemoryAmount

uint64

 

 

 

 

 

 

Description

Part of the VMkernel Memory (Physical Memory Service Console Memory) allocated for the actual VMkernel, device drivers, and the virtualization layer (in megabytes). This is the effective value; it may change after a reboot in case Admin changed the amount of memory allocated to Service Console.

 

DisplayName

System Memory Amount

 

SystemUUID

string(38)

 

 

 

 

 

 

Description

Unique identifier for the ESX Server installation.

 

DisplayName

System UUID

 

Key

true

 

VirtualMachinesMemoryAmount

uint64

 

 

 

 

 

 

Description

Part of VMkernel Memory (Physical Memory Service Console Memory) actually available for virtualization (in megabytes). This is the effective value; it may change after a reboot in case Admin changed the amount of memory allocated to Service Console.

 

DisplayName

Virtual Machines Memory Amount

 

VMkernelUUID

string(38)

 

 

 

 

 

 

Description

Identifier for the ESX Server VMkernel.

 

DisplayName

VMkernel UUID

 

                         

 

Inv_UNIX_VMware_ESX_Storage_Volume – STANDARD Class

Name

Data Type

Qualifiers

 

Name

Value

 

_id

bigint

 

 

 

 

 

Description

Column ID for entries in the table

Key

true

_ResourceGuid

uniqueidentifier

 

 

 

 

 

Description

The reporting system’s GUID

 

Key

true

BlockSize

uint64

 

 

 

 

 

 

Description

Size of the file system block in bytes.

 

DisplayName

Block Size

 

ConsolePath

string(1024)

 

 

 

 

 

 

Description

Path to the storage on Service Console.

 

DisplayName

Console Path

 

ElementName

string(256)

 

 

 

 

 

 

Description

User-visible name of the storage volume.

 

DisplayName

Element Name

 

FileSystemType

uint16

 

 

 

 

 

 

Description

Type of the file system used on the storage volume.

 

DisplayName

File System Type

 

ValueMap

0, 1, 2

 

Values

Unknown, VMFS, NFS

 

FileSystemVersion

string(64)

 

 

 

 

 

 

Description

Version of the file system used on the storage volume.

 

DisplayName

File System Version

 

FreeBlocks

uint64

 

 

 

 

 

 

Description

Total amount of unused file system blocks on the storage volume.

 

DisplayName

Free Blocks

 

FreeSize

uint64

 

 

 

 

 

 

Description

Indicates how much free space (in bytes) is left on the storage volume.

 

DisplayName

Free Size

 

InstanceID

string(256)

 

 

 

 

 

 

Description

Unique identifier of the storage within the computer.

 

DisplayName

Instance ID

 

Key

true

 

Name

string(128)

 

 

 

 

 

 

Description

Unique identifier of the storage volume.

 

DisplayName

Name

 

TotalBlocks

uint64

 

 

 

 

 

 

Description

Total amount of file system blocks available on the storage volume.

 

DisplayName

Total Blocks

 

TotalSize

uint64

 

 

 

 

 

 

Description

Total size of the storage volume in bytes.

 

DisplayName

Total Size

 

                     

 

Inv_UNIX_VMware_ESX_Standby_Uplink – STANDARD Class

Name

Data Type

Qualifiers

 

Name

Value

 

_id

bigint

 

 

 

 

 

Description

Column ID for entries in the table

Key

true

_ResourceGuid

uniqueidentifier

 

 

 

 

 

Description

The reporting system’s GUID

Key

true

FallbackOrder

uint32

 

 

 

 

 

 

Description

Comparable number which defines the order in which physical adapters will become active in case of a failover situation. Lower number shows that the physical network port will be used earlier.

 

DisplayName

Fallback Order

 

                         

 

Inv_UNIX_VMware_ESX_VM_kernel_Network_Port – STANDARD Class

Name

Data Type

Qualifiers

 

Name

Value

 

_id

bigint

 

 

 

 

 

Description

Column ID for entries in the table

Key

true

_ResourceGuid

uniqueidentifier

 

 

 

 

 

Description

The reporting system’s GUID

Key

true

Gateway

string(64)

 

 

 

 

 

 

Description

Default gateway for the VMkernel connections.

 

DisplayName

Default Gateway

 

InstanceID

string(256)

 

 

 

 

 

 

Description

Unique identifier of the port within the computer.

 

DisplayName

Instance ID

 

Key

true

 

IPAddress

string(64)

 

 

 

 

 

 

Description

IP address assigned for the VMkernel virtual network interface.

 

DisplayName

IP Address

 

MACAddress

string(64)

 

 

 

 

 

 

Description

MAC address of the VMkernel virtual network adapter.

 

DisplayName

MAC Address

 

Name

string(128)

 

 

 

 

 

 

Description

Identifying name of the network port.

 

DisplayName

Name

 

Netmask

string(64)

 

 

 

 

 

 

Description

Mask defining the sub-net that VMkernel virtual network interface is connected to.

 

DisplayName

Network Mask

 

VMotionEnabled

boolean

 

 

 

 

 

 

Description

Whether the VMkernel network port supports the VMotion functionality.

 

DisplayName

VMotion Enabled

 

                       

 

Inv_UNIX_VMware_License_Setting_Data – STANDARD Class

Name

Data Type

Qualifiers

 

Name

Value

 

_id

bigint

 

 

 

 

 

Description

Column ID for entries in the table

Key

true

_ResourceGuid

uniqueidentifier

 

 

 

 

 

Description

The reporting system’s GUID

Key

true

Edition

string(128)

 

 

 

 

 

 

Description

Code name for the edition licensed for the ESX Server.

 

DisplayName

Edition

 

Features

string(1024)

 

 

 

 

 

 

Description

List of additional features licensed for the ESX Server.

 

DisplayName

Features

 

InstanceID

string(256)

 

 

 

 

 

 

Description

Unique identifier of the licensing settings on the computer.

 

DisplayName

Instance ID

 

Key

true

 

LicenseServer

string(256)

 

 

 

 

 

 

Description

Host that is serving licenses to the ESX Server.

 

DisplayName

License Server

 

LicenseServerPort

uint16

 

 

 

 

 

 

Description

Port on the host that is serving licenses to the ESX Server.

 

DisplayName

License Server Port

 

LicenseSource

uint16

 

 

 

 

 

 

Description

Where the license for the VMware product is coming from.

 

DisplayName

License Source

 

ValueMap

0, 1, 2, 3, 4

 

Values

Unknown, None, File, Server, Evaluation

 

                     

Conclusion

Because of the complexity of the Virtual Machine data, the data classes above are necessarily complex.  Hopefully this provides a guide that will allow you to upgrade or implement Inventory Pack for Servers 7.1 armed with the necessary data to manage your reports, filters, or anything else based off of Detailed VM data.

Statistics
0 Favorited
0 Views
1 Files
0 Shares
0 Downloads
Attachment(s)
doc file
Inventory Pack for Servers Database Schema - Part 1 - Vir....doc   1.07 MB   1 version
Uploaded - Feb 25, 2020

Tags and Keywords

Related Entries and Links

No Related Resource entered.