Inventory Pack for Servers version 7.0 expands the limited information that was captured in version 6.1. This add-on for Inventory Solution now provides a more robust set of data points targeting Server-related applications. As such the data class structure has grown exponentially. This is Part 1 of a 3 part article series detailing the data classes for Inventory Pack for Servers 7.0, providing administrators the knowledge they need to report on the newly expanded data set provided by this Solution.
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.0 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 the release of Inventory Solution 7.0.
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:
- Display Name represents how the column will be labeled when working within the Symantec Management Console, including reports, Resource Manager details, Pickers, etc.
- Not all values have descriptions, but the label of the table and column should provide data on what's stored therein.
- When a BASE Class is listed, all subsequent SUB classes are tied to that BASE Class, sequentially, below.
- Qualifiers per Column/Value are provided based on applicability.
For help in navigating dependent data classes, use the following guide:
- Altiris_VM_ConnectivityCollection
- Altiris_VM_VMwareESXConnectivityCollection
- Altiris_VM_VirtualSystemSettingData
- Altiris_VM_VMwareVirtualSystemSettingData
- Altiris_VM_VMwareESXStorageExtent
- Altiris_VM_VMwareESXNFSExtent
- Altiris_VM_VirtualLogicalDevice
- Altiris_VM_VMwareVirtualSCSIController
- Altiris_VM_VMwareVirtualStorage
- Altiris_VM_VMwareVirtualNetworkPort
- Altiris_VM_VMwareVirtualParallelPort
- Altiris_VM_VMwareVirtualSerialPort
Altiris_VM_ConnectivityCollection - BASE Class
| Name |
Data Type |
Qualifiers |
| Name |
Value |
| Element Name |
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 |
Altiris_VM_VMwareESXConnectivityCollection - SUB Class
| Name |
Data Type |
Qualifiers |
| Name |
Value |
| Collection Type |
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 |
Altiris_VM_VirtualSystemSettingData - BASE Class
| Name |
Data Type |
Qualifiers |
| Name |
Value |
| Automatic ShutdownAction |
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 |
| Automatic ShutdownDelay |
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 |
| Automatic StartupAction |
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 |
| Automatic StartupAction Sequence Number |
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 |
| Automatic StartupDelay |
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 |
| Configuration DataRoot |
string(1024) |
|
| Description |
Absolute path to the directory containing the virtual machine configuration. |
| DisplayName |
Configuration Data Root |
| Configuration File |
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 |
| LogFile DataRoot |
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 |
| Snapshot DataRoot |
string(1024) |
|
| Description |
Absolute path to the directory where the snapshot data for the virtual machine is stored. |
| DisplayName |
Snapshot Data Root |
| Suspend DataRoot |
string(1024) |
|
| Description |
Absolute path to the directory where the suspended state data for the virtual machine is stored. |
| DisplayName |
Suspend Data Root |
| SwapFile DataRoot |
string(1024) |
|
| Description |
Absolute path to the directory containing swap data for the virtual machine is stored. |
| DisplayName |
Swap File Data Root |
| VirtualSystem Identifier |
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 |
| Virtual SystemType |
string(128) |
|
| Description |
Type of the operating system running in the virtual machine. |
| DisplayName |
Virtual System Type |
Altiris_VM_VMwareVirtualSystemSettingData - SUB Class
| Name |
Data Type |
Qualifiers |
| Name |
Value |
| Acceleration Disabled |
boolean |
|
| Description |
Whether acceleration is disabled for the virtual machine. |
| DisplayName |
Acceleration Disabled |
| AutomaticStartup WaitFor Heartbeat |
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 |
| Configuration FileVersion |
string(64) |
|
| Description |
Version of the VMX configuration file layout. |
| DisplayName |
Configuration File Version |
| Configuration Name |
string(256) |
|
| Description |
User-supplied name of the configuration settings (e.g. snapshot name). |
| DisplayName |
Configuration Name |
| Configuration Notes |
string |
|
| Description |
User-supplied details notes for the configuration settings (e.g. snapshot description). |
| DisplayName |
Configuration Notes |
| HyperThreading Sharing |
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 |
| PowerOff Behavior |
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 |
| SavedOperating Status |
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 |
| VirtualHardware Version |
string(64) |
|
| Description |
Version of the virtual hardware defined in VMX. Also known as version of the virtual machine. |
| DisplayName |
Virtual Hardware Version |
| VMwareTools RunAfter PowerOn |
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 |
| VMwareTools RunAfter Resume |
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 |
| VMwareTools RunBefore PowerOff |
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 |
| VMwareTools RunBefore Suspend |
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 |
| VMwareTools SyncTime |
boolean |
|
| Description |
Boolean flag indicating whether VMware Tools running on guest should synchronize system time with the host. |
| DisplayName |
VMware Tools Sync Time |
Altiris_VM_VMwareESXStorageExtent - BASE Class
| Name |
Data Type |
Qualifiers |
| Name |
Value |
| InstanceID |
string(256) |
|
| Description |
Unique identifier of the storage extent within the computer. |
| DisplayName |
Instance ID |
| Key |
true |
Altiris_VM_VMwareESXNFSExtent - SUB Class
| Name |
Data Type |
Qualifiers |
| Name |
Value |
| 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 |
| |
|
Altiris_VM_VirtualLogicalDevice - BASE Class
| Name |
Data Type |
Qualifiers |
| Name |
Value |
| 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 |
Altiris_VM_VMwareVirtualSCSIController - SUB Class
| Name |
Data Type |
Qualifiers |
| Name |
Value |
| VirtualDevice |
uint16 |
|
| Description |
Type of the SCSI virtual controller. |
| DisplayName |
Virtual Device |
| ValueMap |
0, 1, 2 |
| Values |
Unknown, LSI Logic, BUS Logic |
Altiris_VM_VMwareVirtualStorage - SUB Class
| Name |
Data Type |
Qualifiers |
| Name |
Value |
| 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 |
| VirtualHard wareVersion |
string(64) |
|
| Description |
Version of the VMware virtual hardware defined in VMDK. |
| DisplayName |
Virtual Hardware Version |
| |
|
Altiris_VM_VMwareVirtualNetworkPort - SUB Class
| Name |
Data Type |
Qualifiers |
| Name |
Value |
| MACAddress Type |
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 |
Altiris_VM_VMwareVirtualParallelPort - SUB Class
| Name |
Data Type |
Qualifiers |
| Name |
Value |
| Bidirectional |
boolean |
|
| Description |
Whether communication through the parallel port can be bidirectional. |
| DisplayName |
Bidirectional |
Altiris_VM_VMwareVirtualSerialPort - SUB Class
| Name |
Data Type |
Qualifiers |
| Name |
Value |
| 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 |
| PolledMode Enabled |
boolean |
|
| Description |
Whether the guest is allowed to use the serial port in polled mode. |
| DisplayName |
Polled Mode Enabled |
Altiris_VM_ResourcePool - STANDARD Class
| Name |
Data Type |
Qualifiers |
| Name |
Value |
| Allocation Units |
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 |
Altiris_VM_SwitchPort - STANDARD Class
| Name |
Data Type |
Qualifiers |
| Name |
Value |
| 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 |
Altiris_VM_VirtualComputerSystem - STANDARD Class
| Name |
Data Type |
Qualifiers |
| Name |
Value |
| 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 |
Altiris_VM_VirtualizationProvider - STANDARD Class
| Name |
Data Type |
Qualifiers |
| Name |
Value |
| 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 |
Altiris_VM_VMwareESXAdvancedConfigurationData - STANDARD Class
| Name |
Data Type |
Qualifiers |
| Name |
Value |
| 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 |
Altiris_VM_VMwareESXNetworkPolicy - STANDARD Class
| Name |
Data Type |
Qualifiers |
| Name |
Value |
| Average Bandwidth |
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 |
| LoadBalancing Policy |
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 |
| MACAddress Changes |
uint16 |
|
| Description |
Whether changing of MAC address is allowed. |
| DisplayName |
MAC Address Changes |
| ValueMap |
0, 1, 2 |
| Values |
Unset, Reject, Accept |
| NetworkFailover Detection |
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 |
| Promiscuous Mode |
uint16 |
|
| Description |
Whether the promiscuous mode is enabled for the connectivity. |
| DisplayName |
Promiscuous Mode |
| ValueMap |
0, 1, 2 |
| Values |
Unset, Reject, Accept |
| TrafficShaping Policy |
uint16 |
|
| Description |
Whether traffic shaping (bandwidth throttling) is enabled. |
| DisplayName |
Traffic Shaping Policy |
| ValueMap |
0, 1, 2 |
| Values |
Unset, Enabled, Disabled |
Altiris_VM_VMwareESXSettingData - STANDARD Class
| Name |
Data Type |
Qualifiers |
| Name |
Value |
| Automatic Shutdown Action |
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 |
| Automatic ShutdownDelay |
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 |
| Automatic StartupDelay |
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 |
| Automatic StartupEnabled |
boolean |
|
| Description |
Boolean flag indicating whether virtual machines are allowed to start during host startup. |
| DisplayName |
Automatic Startup Enabled |
| AutomaticStartup WaitForHeartbeat |
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 |
| ServiceConsole MemoryAmount |
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 |
| SystemMemory Amount |
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 |
| VirtualMachines MemoryAmount |
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 |
Altiris_VM_VMwareESXStorageVolume - STANDARD Class
| Name |
Data Type |
Qualifiers |
| Name |
Value |
| 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 |
Altiris_VM_VMwareESXStandbyUplink - STANDARD Class
| Name |
Data Type |
Qualifiers |
| Name |
Value |
| 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 |
Altiris_VM_VMwareESXVMkernelNetworkPort - STANDARD Class
| Name |
Data Type |
Qualifiers |
| Name |
Value |
| 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 |
| VMotion Enabled |
boolean |
|
| Description |
Whether the VMkernel network port supports the VMotion functionality. |
| DisplayName |
VMotion Enabled |
Altiris_VM_VMwareLicenseSettingData - STANDARD Class
| Name |
Data Type |
Qualifiers |
| Name |
Value |
| 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 |
| LicenseServer Port |
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 |
Altiris_VM_AdvancedSettingsDefineVMwareESX - ASSOCIATION Class
| Name |
Class Origin |
Reference Class |
Description |
| Advanced Setting |
Altiris_VM_Advanced SettingsDefine VMwareESX |
Altiris_VM_VMwareESX Advanced ConfigurationData |
An advanced option, which fine-tunes the VMware ESX Server configuration. |
| Configuration Settings |
Altiris_VM_Advanced SettingsDefine VMwareESX |
Altiris_VM_VMware ESXSettingData |
Basic configuration of the VMware ESX Server installation. |
Altiris_VM_AllocationDefinesResourcePool - ASSOCIATION Class
| Name |
Class Origin |
Reference Class |
Description |
| Resource Allocation |
Altiris_VM_Allocation Defines ResourcePool |
Altiris_VM_Resource Allocation SettingData |
Information about the allocation for resource pool. |
| ResourcePool |
Altiris_VM_Allocation Defines ResourcePool |
Altiris_VM_Resource Pool |
Resource Pool provided by the Virtualization Product. |
Altiris_VM_AllocationDefinesVirtualLogicalDevice -ASSOCIATION Class
| Name |
Class Origin |
Reference Class |
Description |
| Resource Allocation |
Altiris_VM_Allocation DefinesVirtual LogicalDevice |
Altiris_VM_Resource AllocationSetting Data |
Information about allocated resources. |
| VirtualDevice |
Altiris_VM_Allocation DefinesVirtual LogicalDevice |
Altiris_VM_Virtual LogicalDevice |
Virtual logical device which the resources are allocated for. |
Altiris_VM_CollectionConnectsToSwitchPort - ASSOCIATION Class
| Name |
Class Origin |
Reference Class |
Description |
| Connectivity Collection |
Altiris_VM_Collection ConnectsTo SwitchPort |
Altiris_VM_Connectivity Collection |
Connectivity collection connected to the virtual switch. |
| SwitchPort |
Altiris_VM_Collection ConnectsTo SwitchPort |
Altiris_VM_SwitchPort |
Switch port that the collection is connected to. |
Altiris_VM_ConcreteVirtualComponent - ASSOCIATION Class
| Name |
Class Origin |
Reference Class |
Description |
| Resource Allocation |
Altiris_VM_Concrete Virtual Component |
Altiris_VM_Resource Allocation SettingData |
Information about allocated resources. |
| VirtualMachine Configuration |
Altiris_VM_Concrete Virtual Component |
Altiris_VM_Virtual SystemSetting Data |
Virtual machine configuration which defines resource allocation. |
Altiris_VM_ConnectedVirtualLogicalDevice - ASSOCIATION Class
| Name |
Class Origin |
Reference Class |
Description |
| Connected Device |
Altiris_VM_Connected Virtual LogicalDevice |
Altiris_VM_Virtual LogicalDevice |
Virtual logical device which is connected to the host. |
| HostDevice |
Altiris_VM_Connected VirtualLogical Device |
Altiris_VM_Virtual LogicalDevice |
Virtual logical device which another device is connected to. |
Altiris_VM_HostedDependency - ASSOCIATION Class
| Name |
Class Origin |
Reference Class |
Description |
| Host |
Altiris_VM_Hosted Dependency |
Altiris_VM_Virtuali zationProvider |
Virtualization Provider that hosts the virtual machine. |
| Virtual Machine |
Altiris_VM_Hosted Dependency |
Altiris_VM_Virtual ComputerSystem |
Virtual Machine that is being hosted. |
Altiris_VM_HostedResourcePool - ASSOCIATION Class
| Name |
Class Origin |
Reference Class |
Description |
| Host |
Altiris_VM_Hosted ResourcePool |
Altiris_VM_Virtuali zationProvider |
Installation of the Virtualization Product that owns the pool. |
| ResourcePool |
Altiris_VM_Hosted ResourcePool |
Altiris_VM_ResourcePool |
Resource Pool provided by the Virtualization Product. |
Altiris_VM_HostedSwitchPort - ASSOCIATION Class
| Name |
Class Origin |
Reference Class |
Description |
| Host |
Altiris_VM_Hosted SwitchPort |
Altiris_VM_Virtuali zationProvider |
Virtualization Provider that provides the virtual switch port. |
| SwitchPort |
Altiris_VM_Hosted SwitchPort |
Altiris_VM_SwitchPort |
Hosted virtual switch port. |
Altiris_VM_HostedVMwareESXStorageVolume - ASSOCIATION Class
| Name |
Class Origin |
Reference Class |
Description |
| Host |
Altiris_VM_Hosted VMwareESXStorageVolume |
Altiris_VM_Virtuali zationProvider |
Virtualization Provider that provides the storage volume. |
| Storage Volume |
Altiris_VM_Hosted VMwareESXStorageVolume |
Altiris_VM_VMware ESXStorageVolume |
Hosted storage volume. |
Altiris_VM_InstalledVirtualizationProvider - ASSOCIATION Class
| Name |
Class Origin |
Reference Class |
Description |
| Software Component |
Altiris_VM_Installed Virtualization Provider |
Inv_InstalledSoftware |
Installed software component that provides virtualization facilities. |
| Virtualization Provider |
Altiris_VM_Installed Virtualization Provider |
Altiris_VM_Virtuali zationProvider |
Virtualization provider available through a software component. |
Altiris_VM_LicenseSettingsDefineVMwareProduct - ASSOCIATION Class
| Name |
Class Origin |
Reference Class |
Description |
| Host |
Altiris_VM_License SettingsDefineVMware Product |
Altiris_VM_Virtuali zationProvider |
Product to which the licensing settings apply. |
| Licensing Settings |
Altiris_VM_License SettingsDefine VMwareProduct |
Altiris_VM_VMware License SettingData |
Licensing settings for the product. |
Altiris_VM_ResourceAllocationFromConnectivityCollection - ASSOCIATION Class
| Name |
Class Origin |
Reference Class |
Description |
| Connectivity Collection |
Altiris_VM_Resource AllocationFrom ConnectivityCollection |
Altiris_VM_Connectivity Collection |
Connectivity collection which the resources are allocated from. |
| Resource Allocation |
Altiris_VM_Resource AllocationFromConnectivity Collection |
Altiris_VM_Resource Allocation SettingData |
Information about the resources allocated from pool. |
Altiris_VM_ResourceAllocationFromLogicalDevice - ASSOCIATION Class
| Name |
Class Origin |
Reference Class |
Description |
| Logical Device |
Altiris_VM_Resource AllocationFrom LogicalDevice |
Altiris_HW_ Logical Device |
Logical device which the resources are allocated from. |
| Resource Allocation |
Altiris_VM_Resource AllocationFrom LogicalDevice |
Altiris_VM_Resource Allocation SettingData |
Information about the allocated resources. |
Altiris_VM_ResourceAllocationFromPool - ASSOCIATION Class
| Name |
Class Origin |
Reference Class |
Description |
| Resource Allocation |
Altiris_VM_Resource Allocation FromPool |
Altiris_VM_Resource AllocationSetting Data |
Information about the resources allocated from pool. |
| ResourcePool |
Altiris_VM_Resource Allocation FromPool |
Altiris_VM_ ResourcePool |
Resource Pool which the resources are allocated from. |
Altiris_VM_SettingsDefineVirtualComputerSystem - ASSOCIATION Class
| Name |
Class Origin |
Reference Class |
Description |
| Configuration Settings |
Altiris_VM_Settings DefineVirtual ComputerSystem |
Altiris_VM_Virtual SystemSettingData |
Active configuration settings for the virtual machine. |
| VirtualMachine |
Altiris_VM_Settings DefineVirtual ComputerSystem |
Altiris_VM_Virtual ComputerSystem |
Virtual machine which the settings are meant for. |
Altiris_VM_SettingsDefineVMwareESX - ASSOCIATION Class
| Name |
Class Origin |
Reference Class |
Description |
| Configuration Settings |
Altiris_VM_Settings Define VMwareESX |
Altiris_VM_VMware ESXSetting Data |
General configuration information for the VMware ESX Server installation. |
| Host |
Altiris_VM_Settings Define VMwareESX |
Altiris_VM_ Virtualization Provider |
VMware ESX Server installation which the configuration is applied to. |
Altiris_VM_SettingsDeriveFromSnapshot - ASSOCIATION Class
| Name |
Class Origin |
Reference Class |
Description |
| ConfigurationSettings |
Altiris_VM_Settings DeriveFrom Snapshot |
Altiris_VM_Virtual SystemSetting Data |
Settings for the virtual machine that are derived from the parent snapshot. |
| Parent Snapshot |
Altiris_VM_Settings DeriveFrom Snapshot |
Altiris_VM_Virtual SystemSetting Data |
Settings which serve as a base for some other settings of a virtual machine. |
Altiris_VM_SnapshotOfVirtualSystem - ASSOCIATION Class
| Name |
Class Origin |
Reference Class |
Description |
| Settings Snapshot |
Altiris_VM_Snapshot OfVirtual System |
Altiris_VM_Virtual SystemSetting Data |
Settings for the virtual machine as well as some additional details about the snapshot. |
| Virtual Machine |
Altiris_VM_Snapshot OfVirtual System |
Altiris_VM_Virtual Computer System |
Virtual Machine which the snapshot was created for. |
Altiris_VM_StoredVMwareESXVirtualComputerSystem - ASSOCIATION Class
| Name |
Class Origin |
Reference Class |
Description |
| Storage Volume |
Altiris_VM_StoredVMware ESXVirtual ComputerSystem |
Altiris_VM_VMware ESXStorage Volume |
Storage volume where the virtual machine resides. |
| Virtual Machine |
Altiris_VM_StoredVMware ESXVirtual ComputerSystem |
Altiris_VM_Virtual Computer System |
Virtual Machine, which data root is located on the storage volume. |
Altiris_VM_VMwareESXConnectivityCollectionUplink - ASSOCIATION Class
| Name |
Class Origin |
Reference Class |
Description |
| Connectivity Collection |
Altiris_VM_VMwareESX Connectivity CollectionUplink |
Altiris_VM_ Connectivity Collection |
Virtual port group connected to a physical network port. |
| NetworkPort |
Altiris_VM_VMwareESX Connectivity CollectionUplink |
Altiris_HW_ LogicalDevice |
Physical network port that the switch is currently connected to. |
Altiris_VM_VMwareESXNetworkPolicyAppliesToConnectivityCollection - ASSOCIATION Class
| Name |
Class Origin |
Reference Class |
Description |
| Connectivity Collection |
Altiris_VM_VMwareESX NetworkPolicy AppliesToConnectivity Collection |
Altiris_VM_ Connectivity Collection |
Virtual port group which the policy applies to. |
| NetworkPolicy |
Altiris_VM_VMwareESX NetworkPolicyApplies ToConnectivity Collection |
Altiris_VM_VMwareESX NetworkPolicy |
Policy for the virtual port group. |
Altiris_VM_VMwareESXNetworkPolicyAppliesToSwitchPort - ASSOCIATION Class
| Name |
Class Origin |
Reference Class |
Description |
| Network Policy |
Altiris_VM_VMwareESX NetworkPolicyApplies ToSwitchPort |
Altiris_VM_VMwareESX NetworkPolicy |
Policy for the virtual switch. |
| SwitchPort |
Altiris_VM_VMwareESX NetworkPolicyApplies ToSwitchPort |
Altiris_VM_SwitchPort |
Virtual switch which the policy applies to. |
Altiris_VM_VMwareESXServiceConsoleConnectsToCollection - ASSOCIATION Class
| Name |
Class Origin |
Reference Class |
Description |
| Connectivity Collection |
Altiris_VM_VMwareESX ServiceConsole ConnectsToCollection |
Altiris_VM_Connectivity Collection |
Connectivity collection where the Service Console network port is connected to. |
| ServiceConsole Connection |
Altiris_VM_VMwareESX ServiceConsoleConnectsTo Collection |
Inv_AeX_AC_TCPIP |
Service console TCP/IPv4 configuration reported by Basic Inventory. |
Altiris_VM_VMwareESXSettingsDefineResourcePool - ASSOCIATION Class
| Name |
Class Origin |
Reference Class |
Description |
| Configuration Settings |
Altiris_VM_VMwareESX SettingsDefine ResourcePool |
Altiris_VM_VMwareESX SettingData |
Configuration for the VMware ESX Server installation. |
| ResourcePool |
Altiris_VM_VMwareESX SettingsDefine ResourcePool |
Altiris_VM_Resource Pool |
Resource Pool defined by the settings. |
Altiris_VM_VMwareESXStorageToExtent - ASSOCIATION Class
| Name |
Class Origin |
Reference Class |
Description |
| StorageExtent |
Altiris_VM_VMwareESX StorageToExtent |
Altiris_VM_VMwareESX StorageExtent |
Storage extent that the volume consists of. |
| StorageVolume |
Altiris_VM_VMwareESX StorageToExtent |
Altiris_VM_VMwareESX StorageVolume |
Storage volume which consists of physical extents. |
Altiris_VM_VMwareESXVMkernelConnectsToCollection - ASSOCIATION Class
| Name |
Class Origin |
Reference Class |
Description |
| Connectivity Collection |
Altiris_VM_VMwareESX VMkernelConnects ToCollection |
Altiris_VM_Connectivity Collection |
Port group where the VMkernel network is connected to. |
| VMkernelPort |
Altiris_VM_VMwareESX VMkernelConnects ToCollection |
Altiris_VM_VMwareESX VMkernelNetworkPort |
Virtual network port for the VMkernel. |
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.0 armed with the necessary data to manage your reports, filters, or anything else based off of Detailed VM data.
Read Inventory Pack for Servers Database Schema, Part 2: Database and Web