This is Part 7 of a 7 part article series detailing the data classes for Inventory, including Inventory Pack for Servers 7.5, providing administrators the knowledge they need to report on the newly expanded data set provided by this Solution. This Pack provides add on data to what is already gathered by Inventory Solution and should be considered an extension, not a replacement, of the main Solution.
Contents
Introduction
Database Schema
Database Data Classes
Inv_Database – BASE Class
Inv_Oracle_Database – SUB Class
Inv_Database_Service – BASE Class
Inv_Oracle_Database_Service – SUB Class
Inv_Database_Storage_Area – STANDARD Class
Inv_Database_System – STANDARD Class
Inv_Database_User – STANDARD Class
Inv_Associate_Database_Service_To_Storage – ASSOCIATION Class
Inv_Associate_Database_System_To_Service – ASSOCIATION Class
Inv_Associate_Database_To_Service – ASSOCIATION Class
Inv_Associate_Database_To_Storage – ASSOCIATION Class
Inv_Associate_Database_User_To_Database – ASSOCIATION Class
Web Data Classes
Inv_Apache_Http_Host_Setting_Data – BASE Class
Inv_Apache_Http_Directory_Setting_Data – SUB Class
Inv_Apache_Http_Alias_Setting_Data – SUB Class
Inv_Apache_Http_Redirect_Setting_Data – SUB Class
Inv_Http_Host_Setting_Data – BASE Class
Inv_Apache_Http_Host_Configuration_Data – SUB Class
Inv_Http_Server_Setting_Data – BASE Class
Inv_Apache_Http_Server_Setting_Data – SUB Class
Inv_Http_Host – STANDARD Class
Inv_Apache_MPM_Http_Server_Setting_Data – STANDARD Class
Inv_Http_Host_Binding – STANDARD Class
Inv_Http_Server – STANDARD Class
Inv_Http_Host_Host_Binding – ASSOCIATION Class
Inv_Apache_Http_Host_Settings – ASSOCIATION Class
Inv_Http_Host_Secure_Host_Binding – ASSOCIATION Class
Inv_Installed_Http_Server – ASSOCIATION Class
Inv_MPM_Settings_Define_Apache_Http_Server – ASSOCIATION Class
Inv_Provided_Http_Host – ASSOCIATION Class
Inv_Settings_Define_Http_Host – ASSOCIATION Class
Inv_Settings_Define_Http_Server – ASSOCIATION Class
Conclusion
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 Inventory Solution 7.5.
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). This class type may include tables not a part of Server Inventory
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:
- Inv_Database
- Inv_Database_Service
- Inv_Oracle_Database_Service
- Inv_Apache_Http_Host_Setting_Data
- Inv_Apache_Http_Directory_Setting_Data
- Inv_Apache_Http_Alias_Setting_Data
- Inv_Apache_Http_Redirect_Setting_Data
- Inv_Http_Host_Setting_Data
- Inv_Apache_Http_Host_Configuration_Data
- Inv_Http_Server_Setting_Data
- Inv_Apache_Http_Server_Setting_Data
Database Data Classes
The following data classes are for the Database information retrieved by the Server Inventory Agent.
Inv_Database – BASE Class
Inv_Oracle_Database – SUB Class
Inv_Database_Service – BASE Class
Inv_Oracle_Database_Service – SUB Class
Inv_Database_Storage_Area – STANDARD Class
Inv_Database_System – STANDARD Class
Inv_Database_User – STANDARD Class
Inv_Associate_Database_Service_To_Storage – ASSOCIATION Class
Inv_Associate_Database_System_To_Service – ASSOCIATION Class
Inv_Associate_Database_To_Service – ASSOCIATION Class
Inv_Associate_Database_To_Storage – ASSOCIATION Class
Inv_Associate_Database_User_To_Database – ASSOCIATION Class
Web Data Classes
The following data classes are for the Web Services information retrieved by the Server Inventory Agent.
Inv_Apache_Http_Host_Setting_Data – BASE Class
Inv_Apache_Http_Directory_Setting_Data – SUB Class
Inv_Apache_Http_Alias_Setting_Data – SUB Class
Inv_Apache_Http_Redirect_Setting_Data – SUB Class
Inv_Http_Host_Setting_Data – BASE Class
Inv_Apache_Http_Host_Configuration_Data – SUB Class
Inv_Http_Server_Setting_Data – BASE Class
Inv_Apache_Http_Server_Setting_Data – SUB Class
Inv_Http_Host – STANDARD Class
Inv_Apache_MPM_Http_Server_Setting_Data – STANDARD Class
Inv_Http_Host_Binding – STANDARD Class
Inv_Http_Server – STANDARD Class
Inv_Http_Host_Host_Binding – ASSOCIATION Class
Inv_Apache_Http_Host_Settings – ASSOCIATION Class
Inv_Http_Host_Secure_Host_Binding – ASSOCIATION Class
Inv_Installed_Http_Server – ASSOCIATION Class
Inv_MPM_Settings_Define_Apache_Http_Server – ASSOCIATION Class
Inv_Provided_Http_Host – ASSOCIATION Class
Inv_Settings_Define_Http_Host – ASSOCIATION Class
Inv_Settings_Define_Http_Server – ASSOCIATION Class
Conclusion
Hopefully this provides a guide that will allow you to upgrade or implement Inventory Pack for Servers 7.5 armed with the necessary data to manage your reports, filters, or anything else based off of Web or Database data.
Inventory Database Schema 7.5 Part 1 - Basic Inventory
Inventory Database Schema 7.5 Part 2 - Hardware
Inventory Database Schema 7.5 Part 3 - Operation System
Inventory Database Schema 7.5 Part 4 - Software and User
Inventory Database Schema 7.5 Part 5 - Network Devices
Inventory Database Schema 7.5 Part 6 - Inventory Pack for Servers Virtual Machine Data