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.

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:

• 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

Altiris_VM_VMwareESXConnectivityCollection - SUB Class

Altiris_VM_VirtualSystemSettingData - BASE Class

Altiris_VM_VMwareVirtualSystemSettingData - SUB Class

Altiris_VM_VMwareESXStorageExtent - BASE Class

Altiris_VM_VMwareESXNFSExtent - SUB Class

Altiris_VM_VirtualLogicalDevice - BASE Class

Altiris_VM_VMwareVirtualSCSIController - SUB Class

Altiris_VM_VMwareVirtualStorage - SUB Class

Altiris_VM_VMwareVirtualNetworkPort - SUB Class

Altiris_VM_VMwareVirtualParallelPort - SUB Class

Altiris_VM_VMwareVirtualSerialPort - SUB Class

Altiris_VM_ResourcePool - STANDARD Class

Altiris_VM_SwitchPort - STANDARD Class

Altiris_VM_VirtualComputerSystem - STANDARD Class

Altiris_VM_VirtualizationProvider - STANDARD Class

Altiris_VM_VMwareESXAdvancedConfigurationData - STANDARD Class

Altiris_VM_VMwareESXNetworkPolicy - STANDARD Class

Altiris_VM_VMwareESXSettingData - STANDARD Class

Altiris_VM_VMwareESXStorageVolume - STANDARD Class

Altiris_VM_VMwareESXStandbyUplink - STANDARD Class

Altiris_VM_VMwareESXVMkernelNetworkPort - STANDARD Class

Altiris_VM_VMwareLicenseSettingData - STANDARD Class

Altiris_VM_AdvancedSettingsDefineVMwareESX - ASSOCIATION Class

Altiris_VM_AllocationDefinesResourcePool - ASSOCIATION Class

Altiris_VM_AllocationDefinesVirtualLogicalDevice -ASSOCIATION Class

Altiris_VM_CollectionConnectsToSwitchPort - ASSOCIATION Class

Altiris_VM_ConcreteVirtualComponent - ASSOCIATION Class

Altiris_VM_ConnectedVirtualLogicalDevice - ASSOCIATION Class

Altiris_VM_HostedDependency - ASSOCIATION Class

Altiris_VM_HostedResourcePool - ASSOCIATION Class

Altiris_VM_HostedSwitchPort - ASSOCIATION Class

Altiris_VM_HostedVMwareESXStorageVolume - ASSOCIATION Class

Altiris_VM_InstalledVirtualizationProvider - ASSOCIATION Class

Altiris_VM_LicenseSettingsDefineVMwareProduct - ASSOCIATION Class

Altiris_VM_ResourceAllocationFromConnectivityCollection - ASSOCIATION Class

Altiris_VM_ResourceAllocationFromLogicalDevice - ASSOCIATION Class

Altiris_VM_ResourceAllocationFromPool - ASSOCIATION Class

Altiris_VM_SettingsDefineVirtualComputerSystem - ASSOCIATION Class

Altiris_VM_SettingsDefineVMwareESX - ASSOCIATION Class

Altiris_VM_SettingsDeriveFromSnapshot - ASSOCIATION Class

Altiris_VM_SnapshotOfVirtualSystem - ASSOCIATION Class

Altiris_VM_StoredVMwareESXVirtualComputerSystem - ASSOCIATION Class

Altiris_VM_VMwareESXConnectivityCollectionUplink - ASSOCIATION Class

Altiris_VM_VMwareESXNetworkPolicyAppliesToConnectivityCollection - ASSOCIATION Class

Altiris_VM_VMwareESXNetworkPolicyAppliesToSwitchPort - ASSOCIATION Class

Altiris_VM_VMwareESXServiceConsoleConnectsToCollection - ASSOCIATION Class

Altiris_VM_VMwareESXSettingsDefineResourcePool - ASSOCIATION Class

Altiris_VM_VMwareESXStorageToExtent - ASSOCIATION Class

Altiris_VM_VMwareESXVMkernelConnectsToCollection - ASSOCIATION Class

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