Client Management Suite

 View Only
Back to Library

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

Jan 29, 2009 06:04 PM

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 2 of a 2 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). 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:

  • Altiris_DB_Database
    • Altiris_DB_OracleDatabase
  • Altiris_DB_DatabaseService
    • Altiris_DB_OracleDatabaseService
  • Altiris_WEB_ApacheHttpHostSettingData
    • Altiris_WEB_ApacheHttpDirectorySettingData
    • Altiris_WEB_ApacheHttpAliasSettingData
    • Altiris_WEB_ApacheHttpRedirectSettingData
  • Altiris_WEB_HttpHostSettingData
    • Altiris_WEB_ApacheHttpHostConfigurationData
  • Altiris_WEB_HttpServerSettingData
    • Altiris_WEB_ApacheHttpServerSettingData

Database Data Classes

The following data classes are for the Database information retrieved by the Server Inventory Agent.

Altiris_DB_Database - BASE Class

Name Data Type Qualifiers
Name Value
CreatedDate datetime  
Description Time when database was created.
DisplayName Created Date
InstanceID string  
Description InstanceID opaquely and uniquely identifies an instance of this class. For Oracle this should be the Global Database Name, for MS SQL the name of the database and for MySQL the path to the database.
DisplayName Instance ID
Key true
Language string(512)  
Description An characterset of database. This setting will specify the formatting and parsing of dates, times, numbers, and currencies, etc. Also this field will contain collation for MS SQL database.
DisplayName Language
Name string  
Description Name of the database.
DisplayName Name
SizeAllocated uint32  
Description The estimated amount of disk space (in units) that has been reserved for database use. Current database size will be reported for MySQl databases.
DisplayName Size Allocated

Altiris_DB_OracleDatabase - SUB Class

Name Data Type Qualifiers
Name Value
BlockSize uint32  
Description This is fundamental database parameter. The block size cannot be changed after database creation, except by re-creating the database. This setting is used tune the performance of database.
DisplayName Block Size
MaxUsers uint32  
Description Specifies the maximum number of users you can create in the database. When you reach this limit, you cannot create more users.
DisplayName Max Users
Size uint32  
Description Estimates the overall database size. The biggest portion of a database's size comes from the datafiles also we should add the size of temp files and redo logs.
DisplayName Size

Altiris_DB_DatabaseService - BASE Class

Name Data Type Qualifiers
Name Value
ConnectionLimit uint32  
Description The maximum number of active inbound connections that can be concurrently opened on the service.
DisplayName Connection Limit
Name string(256)  
Description The Name property uniquely identifies the Service and provides an indication of the functionality that is managed.
DisplayName Name
Key true
OperationalStatus uint16  
Description This property contains the operational status of the database service.
DisplayName Operational Status
ValueMap 0, 1, 2, 8, 9, 10
Values Unknown, Other, OK, Starting, Stopping, Stopped
StartMode string(10)  
Description This property indicates whether the database service startup is manual or automatic.
DisplayName Start Mode
ValueMap Unknown, Automatic, Manual

Altiris_DB_OracleDatabaseService - SUB Class

Name Data Type Qualifiers
Name Value
PgaTargetSize uint64  
Description Specifies the target aggregate PGA memory available to all server processes attached to the instance.
DisplayName PGA Target Size
SgaTargetSize uint64  
Description Specifies the total size of all System Global Area conmponents.
DisplayName SGA target size
SharedPoolSize uint64  
Description Specifies the total size of all System Global Area conmponents.
DisplayName Shared Pool Size
UsersHighWatermark uint32  
Description Specified the highest number of concurrent session since the instance started.
DisplayName Users High Watermark

Altiris_DB_DatabaseStorageArea - STANDARD Class

Name Data Type Qualifiers
Name Value
BlockSize uint64  
Description Physically information is stored by blocks. This property captures the block size for data storage and retrieval.
DisplayName Block Size
FileSystemSize uint64  
Description The FileSystemSize property stores the total size of the entity in bytes.
DisplayName File System Size
FileSystemType string(256)  
Description String describing the type of filesystem. For example, File, OCFS or "S5" may be listed as well as any additional information on the FileSystem's implementation
DisplayName File System Type
Name string  
Description Identifies the instance of storage area. This might by the path to the file or to the device.
DisplayName Name
Key true

Altiris_DB_DatabaseSystem - STANDARD Class

Name Data Type Qualifiers
Name Value
Name string(256)  
Description The Name property serves as the key of a Database System instance in an enterprise environment.
DisplayName Name
Key true
Path string  
Description The location in the computer's filesystem where the particaular database system has been installed.
DisplayName Path
Vendor string(256)  
Description The name of the organization produced the database system (e.g. Microsoft, Oracle, Sun)
DisplayName Vendor
Version string  
Description The version identifying particaular release and edition of the database system (e.g. Oracle Database Enterprise Edition 9.2.0.4, Microsoft SQL Server 2005 Standard Edition).
DisplayName Version

Altiris_DB_DatabaseUser - STANDARD Class

Name Data Type Qualifiers
Name Value
Name string(256)  
Description The user available in the database.
DisplayName Name
Key true

Altiris_DB_AssociateDatabaseServiceToStorage - ASSOCIATION Class

Name Class Origin Reference Class Description
Database Service Altiris_DB_Associate DatabaseService ToStorage Altiris_DB_ DatabaseService The database service that makes use of the associated storage areas.
Storage Area Altiris_DB_Associate DatabaseService ToStorage Altiris_DB_ DatabaseStorage Area A storage area that is used by the associated database service. A storage area must only be used by a single service.

Altiris_DB_AssociateDatabaseSystemToService - ASSOCIATION Class

Name Class Origin Reference Class Description
Service Altiris_DB_Associate DatabaseSystem ToService Altiris_DB_Database Service The database service hosting some databases.
System Altiris_DB_Associate DatabaseSystem ToService Altiris_DB_Database System The database system that installed the database service.

Altiris_DB_AssociateDatabaseToService - ASSOCIATION Class

Name Class Origin Reference Class Description
Database Altiris_DB_Associate DatabaseTo Service Altiris_DB_ Database The database that can use the Service.
Service Altiris_DB_Associate DatabaseTo Service Altiris_DB_Database Service The Service that is available.

Altiris_DB_AssociateDatabaseToStorage - ASSOCIATION Class

Name Class Origin Reference Class Description
Database Altiris_DB_Associate DatabaseTo Storage Altiris_DB_Database The database that makes use of the associated storage areas.
Storage Area Altiris_DB_Associate DatabaseTo Storage Altiris_DB_Database StorageArea A storage area that is used by the associated database. A storage area must only be used by a single database.

Altiris_DB_AssociateDatabaseUserToDatabase - ASSOCIATION Class

Name Class Origin Reference Class Description
Database Altiris_DB_Associate DatabaseUser ToDatabase Altiris_DB_Database The database that contain the collection of users.
User Altiris_DB_Associate DatabaseUser ToDatabase Altiris_DB_Database User The user available in the database.

Web Data Classes

The following data classes are for the Web Services information retrieved by the Server Inventory Agent.

Altiris_WEB_ApacheHttpHostSettingData - BASE Class

Name Data Type Qualifiers
Name Value
InstanceID string(256)  
Description Unique identifier of the setting.
DisplayName Instance ID
Key true

Altiris_WEB_ApacheHttpDirectorySettingData - SUB Class

Name Data Type Qualifiers
Name Value
AllowOverride string(1024)  
Description Types of directives that are allowed in .htaccess files.
DisplayName Allow Override
AuthName string(1024)  
Description Authorization realm for use in HTTP authentication.
DisplayName Auth Name
AuthType uint16  
Description Type of user authentication.
DisplayName Auth Type
ValueMap 0, 1, 2, 3
Values Unknown, None, Basic, Digest
DirectoryIndex string(1024)  
Description List of resources to look for when the client requests a directory.
DisplayName Directory Index
DirectorySlash boolean  
Description Toggle trailing slash redirects on or off.
DisplayName Directory Slash
MatchType uint16  
Description How the section name is applied to a path.
DisplayName Match Type
ValueMap 0, 1, 2
Values Unknown, Literal, RegularExpression
Name string(1024)  
Description What the section is applied to (for example, an URL path or a regular expression).
DisplayName Name
Options string(1024)  
Description Configures what features are available in a particular directory.
DisplayName Options
RequireSSL boolean  
Description Deny access when SSL is not used for the HTTP request.
DisplayName Require SSL
SectionType uint16  
Description Type of the directory-context section.
DisplayName Section Type
ValueMap 0, 1, 2
Values Unknown, Directory, Location
SSLVerifyClient uint16  
Description Type of Client Certificate verification.
DisplayName SSL Verify Client
ValueMap 0, 1, 2, 3, 4
Values Unknown, None, Optional, Required, OptionalNoCA
SSLVerifyDepth uint16  
Description Maximum depth of CA Certificates in Client Certificate verification.
DisplayName SSL Verify Depth
   

Altiris_WEB_ApacheHttpAliasSettingData - SUB Class

Name Data Type Qualifiers
Name Value
AliasType uint16  
Description Type of the alias.
DisplayName Alias Type
ValueMap 0, 1, 2
Values Unknown, FileSystem, Script
MatchType uint16  
Description How the alias name is applied to an URL.
DisplayName Match Type
ValueMap 0, 1, 2
Values Unknown, Literal, RegularExpression
Name string(1024)  
Description URL path that the alias is applied to (literal path or a regular expression.
DisplayName Name
Target string(1024)  
Description Where the alias maps URL to on the file system.
DisplayName Target

Altiris_WEB_ApacheHttpRedirectSettingData - SUB Class

Name Data Type Qualifiers
Name Value
CustomStatusType string(64)  
Description In case StatusType is Other, the custom HTTP response status to be returned to the client.
DisplayName Custom Status Type
MatchType uint16  
Description How the alias name is applied to an URL.
DisplayName Match Type
ValueMap 0, 1, 2
Values Unknown, Literal, RegularExpression
Name string(1024)  
Description URL path that the redirect is applied to (literal path or a regular expression.
DisplayName Name
StatusType uint16  
Description Type of the alias.
DisplayName Status Type
ValueMap 0, 1, 2, 3, 4, 5
Values Unknown, Other, Permanent, Temporary, SeeOther, Gone
Target string(1024)  
Description Where the redirect respond forward the client to.
DisplayName Target

Altiris_WEB_HttpHostSettingData - BASE Class

Name Data Type Qualifiers
Name Value
AllowKeepAlive boolean  
Description Whether persistent connections are allowed.
DisplayName Allow Keep Alive
ConnectionTimeout uint16  
Description The amount of time (in seconds) that the server waits before disconnecting an inactive connection.
DisplayName Connection Timeout
DocumentRoot string(1024)  
Description Directory that forms the main document tree visible from the web.
DisplayName Document Root
HeaderWaitTimeout uint16  
Description The amount of time (in seconds) the server waits for all HTTP headers for the request (indicated by a double carriage return) to be received before disconnecting the client.
DisplayName Header Wait Timeout
InstanceID string(256)  
Description Unique identifier of the http host configuration.
DisplayName Instance ID
Key true
ListenTimeout uint16  
Description The amount of time (in seconds) the server waits for a client to send data. After the allotted amount of time passes, the server disconnects the client.
DisplayName Listen Timeout
SecureAccessMode uint16  
Description Mode which specifies how SSL-based (HTTPS) connections are to be processed by the host.
DisplayName Secure Access Mode
ValueMap 0, 1, 2
Values Off, Required, Optional

Altiris_WEB_ApacheHttpHostConfigurationData - SUB Class

Name Data Type Qualifiers
Name Value
AccessFileName string(1024)  
Description Name of the distributed configuration file (e.g. .htaccess).
DisplayName Access File Name
ErrorLog string(1024)  
Description Path to the log file containing errors for the host.
DisplayName Error Log
KeepAliveTimeout uint16  
Description Amount of time (in seconds) the server will wait for subsequent requests on a persistent connection.
DisplayName Keep Alive Timeout
LimitInternalRecursion uint16  
Description Determine maximum number of internal redirects and nested subrequests.
DisplayName Limit Internal Recursion
LogLevel uint16  
Description Controls the verbosity of the ErrorLog.
DisplayName Log Level
ValueMap 0, 1, 2, 3, 4, 5, 6, 7, 8
Values Unknown, Debug, Info, Notice, Warning, Error, Critical, Alert, Emergency
MaxKeepAliveRequests uint32  
Description Number of requests allowed on a persistent connection.
DisplayName Max Keep Alive Requests
ServerAdmin string(256)  
Description Email address that the server includes in error messages sent to the client.
DisplayName Server Admin
SSLCACertificateFile string(1024)  
Description File of concatenated PEM-encoded CA Certificates for Client Auth.
DisplayName SSL CA Certificate File
SSLCACertificatePath string(1024)  
Description Directory of PEM-encoded CA Certificates for Client Auth.
DisplayName SSL CA Certificate Path
SSLCertificateFile string(1024)  
Description Server PEM-encoded X.509 Certificate file.
DisplayName SSL Certificate File
SSLCertificateKeyFile string(1024)  
Description Server PEM-encoded Private Key file.
DisplayName SSL Certificate Key File

Altiris_WEB_HttpServerSettingData - BASE Class

Name Data Type Qualifiers
Name Value
InstanceID string(256)  
Description Unique identifier of the http server configuration.
DisplayName Instance ID
Key true

Altiris_WEB_ApacheHttpServerSettingData - SUB Class

Name Data Type Qualifiers
Name Value
ExtendedStatus string  
Description Keep track of extended status information for each request.
DisplayName Extended Status
LimitRequestFields uint32  
Description Limits the number of HTTP request header fields that will be accepted from the client.
DisplayName Limit Request Fields
LimitRequestFieldSize uint32  
Description Limits the size of the HTTP request header allowed from the client.
DisplayName Limit Request Field Size
LimitRequestLine uint32  
Description Limit the size of the HTTP request line that will be accepted from the client.
DisplayName Limit Request Line
RunAsGroup string(256)  
Description Group under which the server will answer requests.
DisplayName Run As Group
RunAsUser string(256)  
Description The userid under which the server will answer requests.
DisplayName Run As User
ServerRoot string(1024)  
Description Base directory for the server installation.
DisplayName Server Root

Altiris_WEB_HttpHost - STANDARD Class

Name Data Type Qualifiers
Name Value
HostState sint32  
Description Current state of the host.
DisplayName Host State
ValueMap 0, 1, 2, 3, 4, 5, 6, 7
Values Unknown, Starting, Started, Stopping, Stopped, Pausing, Paused, Continuing
InstanceID string(256)  
Description Unique identifier of the http host provided by a HTTP server.
DisplayName Instance ID
Key true

Altiris_WEB_ApacheMpmHttpServerSettingData - STANDARD Class

Name Data Type Qualifiers
Name Value
GracefulShutdownTimeout uint16  
Description Specify a timeout after which a gracefully shutdown server will exit.
DisplayName Graceful Shutdown Timeout
InstanceID string(256)  
Description Unique identifier for the MPM settings.
DisplayName Instance ID
Key true
MaxClients uint32  
Description Maximum number of child processes that will be created to serve requests.
DisplayName Max Clients
MaxRequestsPerChild uint32  
Description Limit on the number of requests that an individual child server will handle during its life.
DisplayName Max Requests Per Child
MaxRequestsPerThread uint32  
Description Limit on the number of requests that an individual thread will handle during its life.
DisplayName Max Requests Per Thread
MaxSpareServers uint32  
Description Maximum number of idle child server processes.
DisplayName Max Spare Servers
MaxSpareThreads uint32  
Description Maximum number of idle threads.
DisplayName Max Spare Threads
MaxThreads uint32  
Description Set the maximum number of worker threads.
DisplayName Max Threads
MinSpareServers uint32  
Description Minimum number of idle child server processes.
DisplayName Min Spare Servers
MinSpareThreads uint32  
Description Minimum number of idle threads available to handle request spikes.
DisplayName Min Spare Threads
MpmType uint16  
Description Type of the used MPM module.
DisplayName MPM Type
ValueMap 0, 1, 2, 3, 4
Values Unknown, Prefork, Worker, Event, WinNT
ServerLimit uint32  
Description Upper limit on configurable number of processes.
DisplayName Server Limit
StartServers uint32  
Description Number of child server processes created at startup.
DisplayName Start Servers
StartThreads uint32  
Description Number of threads created on startup.
DisplayName Start Threads
ThreadLimit uint32  
Description Sets the upper limit on the configurable number of threads per child process.
DisplayName Thread Limit
ThreadsPerChild uint32  
Description Number of threads created by each child process.
DisplayName ThreadsPerChild

Altiris_WEB_HttpHostBinding - STANDARD Class

Name Data Type Qualifiers
Name Value
BindingType uint16  
Description Specifies how the host is distinguished from other host on the same server.
DisplayName Binding Type
ValueMap 0, 1, 2
Values Unknown, AddressBased, HostnameBased
HostName string(256)  
Description Name of the host that is used for distinguishing from other hosts listening on the same IP address and port.
DisplayName Host Name
InstanceID string(256)  
Description Unique identifier of the host binding.
DisplayName Instance ID  
Key true
IPAddress string(256)  
Description IP (either version 4 or version 6) that the host is listening to. This can also be a hostname (in which case it is assumed that the host is listening to the IP address that the hostname resolves to) or even refer to some special, HTTP Server specific, values, such as * and _default_ for Apache.
DisplayName IP Address
Port uint16  
Description TCP port that the host is listening to.
DisplayName Port

Altiris_WEB_HttpServer - STANDARD Class

Name Data Type Qualifiers
Name Value
InstanceID string(256)  
Description Unique identifier of the http server available on the computer.
DisplayName Instance ID
Key true

Altiris_WEB_HttpHost_HostBinding - ASSOCIATION Class

Name Class Origin Reference Class Description
Host Binding Altiris_WEB_ HttpHost_ HostBinding Altiris_WEB_ HttpHost Binding Address binding information for the host.
HttpHost Altiris_WEB_ HttpHost_ HostBinding Altiris_WEB_ HttpHost Host which the binding applies to.

Altiris_WEB_ApacheHttpHostSettings - ASSOCIATION Class

Name Class Origin Reference Class Description
HostSettings Altiris_WEB_ ApacheHttp HostSettings Altiris_WEB_ ApacheHttpHost ConfigurationData Base Apache Host configuration that the settings are part of.
SettingData Altiris_WEB_ ApacheHttp HostSettings Altiris_WEB_ ApacheHttpHost SettingData Specific setting group that extends the core host configuration.

Altiris_WEB_HttpHost_SecureHostBinding - ASSOCIATION Class

Name Class Origin Reference Class Description
HostBinding Altiris_WEB_ HttpHost_Secure HostBinding Altiris_WEB_ HttpHostBinding Address binding information for the host.
HttpHost Altiris_WEB_ HttpHost_Secure HostBinding Altiris_WEB_ HttpHost Host which the binding applies to.

Altiris_WEB_InstalledHttpServer - ASSOCIATION Class

Name Class Origin Reference Class Description
HttpServer Altiris_WEB_ InstalledHttp Server Altiris_WEB_ HttpServer Http Server provided by the software component.
Software Component Altiris_WEB_ InstalledHttp Server Inv_Installed Software Information about the software providing functionality of Http Server in SRM.

Altiris_WEB_MpmSettingsDefineApacheHttpServer - ASSOCIATION Class

Name Class Origin Reference Class Description
HttpServer Altiris_WEB_ MpmSettingsDefine ApacheHttpServer Altiris_WEB_ HttpServer Server which the settings apply to.
MpmSettings Altiris_WEB_ MpmSettingsDefine ApacheHttpServer Altiris_WEB_ ApacheMpmHttp ServerSetting Data Settings for the MPM Apache Server.

Altiris_WEB_ProvidedHttpHost - ASSOCIATION Class

Name Class Origin Reference Class Description
HttpHost Altiris_WEB_ ProvidedHttpHost Altiris_WEB_ HttpHost Individual Http Host (web-site) provided by the Server.
HttpServer Altiris_WEB_ ProvidedHttpHost Altiris_WEB_ HttpServer Http Server that provides Http Hosts.

Altiris_WEB_SettingsDefineHttpHost - ASSOCIATION Class

Name Class Origin Reference Class Description
HttpHost Altiris_WEB_ SettingsDefine HttpHost Altiris_WEB_ HttpHost Host which the settings apply to.
HttpHost Settings Altiris_WEB_ SettingsDefine HttpHost Altiris_WEB_ HttpHostSetting Data Settings for the host.

Altiris_WEB_SettingsDefineHttpServer - ASSOCIATION Class

Name Class Origin Reference Class Description
HttpServer Altiris_WEB_ SettingsDefine HttpServer Altiris_WEB_ HttpServer Server which the settings apply to.
HttpServer Settings Altiris_WEB_ SettingsDefine HttpServer Altiris_WEB_ HttpServer SettingData Settings for the server.

Conclusion

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 Web or Database data.

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

Statistics
0 Favorited
0 Views
1 Files
0 Shares
0 Downloads
​
Attachment(s)
jpg file
11151.jpg   3 KB   1 version
Uploaded - Feb 25, 2020
 
Download

Tags and Keywords

Comments

edwardortegas
Apr 25, 2016 11:37 AM

Hello, I would like to know which is estimated to report a computer console Altiris my time.

Thank you.

Migration User
Mar 16, 2011 11:54 AM

Hi Joel. Good information.

My question is, in looking at the Reports available in Altiris 7 now, I have the Inventory Pack for Servers 7 installed but don't any reports for Apache Web servers on a Unix/Linux platform.

When we start installing Altiris 7 agents on our Apache web servers, how do I get those reports to view the information in the databse of these data classes?

 

Richard West

Northrop Grumman

rb.west@ngc.com

Related Entries and Links

No Related Resource entered.