Discovery and Inventory Group

Inventory Database Schema 7.5, Part 7 - Inventory Pack for Servers Database and Web 

10-21-2014 05:01 PM

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:

  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_Database
    • Inv_Oracle_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

01_6.png

 

Inv_Oracle_Database – SUB Class

02_5.png

 

Inv_Database_Service – BASE Class

03_5.png

 

Inv_Oracle_Database_Service – SUB Class

04_5.png

 

Inv_Database_Storage_Area – STANDARD Class

05_5.png

 

Inv_Database_System – STANDARD Class

06_3.png

 

Inv_Database_User – STANDARD Class

07_3.png

 

Inv_Associate_Database_Service_To_Storage – ASSOCIATION Class

08_3.png

 

Inv_Associate_Database_System_To_Service – ASSOCIATION Class

09_3.png

 

Inv_Associate_Database_To_Service – ASSOCIATION Class

10_5.png

 

Inv_Associate_Database_To_Storage – ASSOCIATION Class

11_4.png

 

Inv_Associate_Database_User_To_Database – ASSOCIATION Class

12_5.png

 

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

13_5.png

 

Inv_Apache_Http_Directory_Setting_Data – SUB Class

14_4.png

 

Inv_Apache_Http_Alias_Setting_Data – SUB Class

15_4.png

 

Inv_Apache_Http_Redirect_Setting_Data – SUB Class

16_4.png

 

Inv_Http_Host_Setting_Data – BASE Class

17_4.png

 

Inv_Apache_Http_Host_Configuration_Data – SUB Class

18_4.png

 

Inv_Http_Server_Setting_Data – BASE Class

19_4.png

 

Inv_Apache_Http_Server_Setting_Data – SUB Class

20_4.png

 

Inv_Http_Host – STANDARD Class

21_3.png

 

Inv_Apache_MPM_Http_Server_Setting_Data – STANDARD Class

22_3.png

 

Inv_Http_Host_Binding – STANDARD Class

23_2.png

 

Inv_Http_Server – STANDARD Class

24_2.png

 

Inv_Http_Host_Host_Binding – ASSOCIATION Class

25_1.png

 

Inv_Apache_Http_Host_Settings – ASSOCIATION Class

26_1.png

 

Inv_Http_Host_Secure_Host_Binding – ASSOCIATION Class

27_1.png

 

Inv_Installed_Http_Server – ASSOCIATION Class

28_0.png

 

Inv_MPM_Settings_Define_Apache_Http_Server – ASSOCIATION Class

29_0.png

 

Inv_Provided_Http_Host – ASSOCIATION Class

30_0.png

 

Inv_Settings_Define_Http_Host – ASSOCIATION Class

31_0.png

 

Inv_Settings_Define_Http_Server – ASSOCIATION Class

32_1.png

 

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

Statistics
0 Favorited
1 Views
1 Files
0 Shares
0 Downloads
Attachment(s)

Tags and Keywords

Related Entries and Links

No Related Resource entered.