Note: Please refer to the attached document for the article contents and all live links contained in this article.
This is Part 2 of a 2 part article series detailing the data classes for Inventory Pack for Servers 7.1, providing administrators the knowledge they need to report on the newly expanded data set provided by this Solution.
Find Part 1 here: Inventory Pack for Servers Database Schema 7.1: Part 1, Virtual Data
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.1.
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
|
Name
|
Data Type
|
Qualifiers
|
|
Name
|
Value
|
|
_id
|
bigint
|
|
|
|
|
|
|
Description
|
Column ID for entries in the table
|
|
Key
|
true
|
|
_ResourceGuid
|
uniqueidentifier
|
|
|
|
|
|
|
Description
|
The reporting system’s GUID
|
|
Key
|
true
|
|
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
|
Inv_Oracle_Database – SUB Class
|
Name
|
Data Type
|
Qualifiers
|
|
|
Name
|
Value
|
|
_id
|
bigint
|
|
|
|
|
|
|
Description
|
Column ID for entries in the table
|
|
Key
|
true
|
|
_ResourceGuid
|
uniqueidentifier
|
|
|
|
|
|
|
Description
|
The reporting system’s GUID
|
|
Key
|
true
|
|
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
|
|
Instance ID
|
nvarchar
|
|
|
|
|
|
|
Description
|
Provides the ID of the Oracle Instance for a given database.
|
|
DisplayName
|
|
| |
|
|
|
|
|
|
|
|
Inv_Database_Service – BASE Class
|
Name
|
Data Type
|
Qualifiers
|
|
|
Name
|
Value
|
|
|
_id
|
bigint
|
|
|
|
|
|
|
Description
|
Column ID for entries in the table
|
|
Key
|
true
|
|
_ResourceGuid
|
uniqueidentifier
|
|
|
|
|
|
|
Description
|
The reporting system’s GUID
|
|
Key
|
true
|
|
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
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
Inv_Oracle_Database_Service – SUB Class
|
Name
|
Data Type
|
Qualifiers
|
|
|
Name
|
Value
|
|
|
_id
|
bigint
|
|
|
|
|
|
|
Description
|
Column ID for entries in the table
|
|
Key
|
true
|
|
_ResourceGuid
|
uniqueidentifier
|
|
|
|
|
|
|
Description
|
The reporting system’s GUID
|
|
Key
|
true
|
|
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 components.
|
|
|
DisplayName
|
SGA target size
|
|
|
SharedPoolSize
|
uint64
|
|
|
|
|
|
|
|
Description
|
Specifies the total size of all System Global Area components.
|
|
|
DisplayName
|
Shared Pool Size
|
|
|
UsersHighWatermark
|
uint32
|
|
|
|
|
|
|
|
Description
|
Specified the highest number of concurrent session since the instance started.
|
|
|
DisplayName
|
Users High Watermark
|
|
| |
|
|
|
|
|
|
|
|
|
|
Inv_Database_Storage_Area – STANDARD Class
|
Name
|
Data Type
|
Qualifiers
|
|
|
Name
|
Value
|
|
|
_id
|
bigint
|
|
|
|
|
|
|
Description
|
Column ID for entries in the table
|
|
Key
|
true
|
|
_ResourceGuid
|
uniqueidentifier
|
|
|
|
|
|
|
Description
|
The reporting system’s GUID
|
|
Key
|
true
|
|
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
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
Inv_Database_System – STANDARD Class
|
Name
|
Data Type
|
Qualifiers
|
|
|
Name
|
Value
|
|
|
_id
|
bigint
|
|
|
|
|
|
|
Description
|
Column ID for entries in the table
|
|
Key
|
true
|
|
_ResourceGuid
|
uniqueidentifier
|
|
|
|
|
|
|
Description
|
The reporting system’s GUID
|
|
Key
|
true
|
|
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
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
Inv_Database_User – STANDARD Class
|
Name
|
Data Type
|
Qualifiers
|
|
|
Name
|
Value
|
|
|
_id
|
bigint
|
|
|
|
|
|
|
Description
|
Column ID for entries in the table
|
|
Key
|
true
|
|
_ResourceGuid
|
uniqueidentifier
|
|
|
|
|
|
|
Description
|
The reporting system’s GUID
|
|
Key
|
true
|
|
Name
|
string(256)
|
|
|
|
|
|
|
|
Description
|
The user available in the database.
|
|
|
DisplayName
|
Name
|
|
|
Key
|
true
|
|
| |
|
|
|
|
|
|
|
|
|
|
Inv_Associate_Database_System_To_Service – ASSOCIATION Class
|
Name
|
Class Origin
|
Reference Class
|
Description
|
|
|
Service
|
Inv_Associate_Database_System_To_Service
|
Inv_Database_Service
|
The database service hosting some databases.
|
|
|
System
|
Inv_Associate_Database_System_To_Service
|
Inv_Database_System
|
The database system that installed the database service.
|
|
|
_id
|
bigint
|
|
|
|
|
|
|
Description
|
Column ID for entries in the table
|
|
Key
|
true
|
|
_ResourceGuid
|
uniqueidentifier
|
|
|
|
|
|
|
Description
|
The reporting system’s GUID
|
|
Key
|
true
|
| |
|
|
|
|
|
|
|
|
|
Inv_Associate_Database_To_Service – ASSOCIATION Class
|
Name
|
Class Origin
|
Reference Class
|
Description
|
|
|
Database
|
Inv_Associate_Database_To_Service
|
Inv_Database
|
The database that can use the Service.
|
|
|
Service
|
Inv_Associate_Database_To_Service
|
Inv_Database_Service
|
The Service that is available.
|
|
|
_id
|
bigint
|
|
|
|
|
|
|
Description
|
Column ID for entries in the table
|
|
Key
|
true
|
|
_ResourceGuid
|
uniqueidentifier
|
|
|
|
|
|
|
Description
|
The reporting system’s GUID
|
|
Key
|
true
|
| |
|
|
|
|
|
|
|
|
|
Inv_Associate_Database_To_Storage – ASSOCIATION Class
|
Name
|
Class Origin
|
Reference Class
|
Description
|
|
|
Database
|
Inv_Associate_Database_To_Storage
|
Inv_Database
|
The database that makes use of the associated storage areas.
|
|
|
StorageArea
|
Inv_Associate_Database_To_Storage
|
Inv_Database_Storage_Area
|
A storage area that is used by the associated database. A storage area must only be used by a single database.
|
|
|
_id
|
bigint
|
|
|
|
|
|
|
Description
|
Column ID for entries in the table
|
|
Key
|
true
|
|
_ResourceGuid
|
uniqueidentifier
|
|
|
|
|
|
|
Description
|
The reporting system’s GUID
|
|
Key
|
true
|
| |
|
|
|
|
|
|
|
|
|
Inv_Associate_Database_User_To_Database – ASSOCIATION Class
|
Name
|
Class Origin
|
Reference Class
|
Description
|
|
|
Database
|
Inv_Associate_Database_User_To_Database
|
Inv_Database
|
The database that contain the collection of users.
|
|
|
User
|
Inv_Associate_Database_User_To_Database
|
Inv_DatabaseUser
|
The user available in the database.
|
|
|
_id
|
bigint
|
|
|
|
|
|
|
Description
|
Column ID for entries in the table
|
|
Key
|
true
|
|
_ResourceGuid
|
uniqueidentifier
|
|
|
|
|
|
|
Description
|
The reporting system’s GUID
|
|
Key
|
true
|
| |
|
|
|
|
|
|
|
|
|
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
|
Name
|
Data Type
|
Qualifiers
|
|
|
Name
|
Value
|
|
|
_id
|
bigint
|
|
|
|
|
|
|
Description
|
Column ID for entries in the table
|
|
Key
|
true
|
|
_ResourceGuid
|
uniqueidentifier
|
|
|
|
|
|
|
Description
|
The reporting system’s GUID
|
|
Key
|
true
|
|
InstanceID
|
string(256)
|
|
|
|
|
|
|
|
Description
|
Unique identifier of the setting.
|
|
|
DisplayName
|
Instance ID
|
|
|
Key
|
true
|
|
| |
|
|
|
|
|
|
|
|
|
Inv_Apache_Http_Directory_Setting_Data – SUB Class
|
Name
|
Data Type
|
Qualifiers
|
|
|
Name
|
Value
|
|
|
_id
|
bigint
|
|
|
|
|
|
|
Description
|
Column ID for entries in the table
|
|
Key
|
true
|
|
_ResourceGuid
|
uniqueidentifier
|
|
|
|
|
|
|
Description
|
The reporting system’s GUID
|
|
Key
|
true
|
|
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
|
|
| |
|
|
|
|
|
|
|
|
|
|
Inv_Apache_Http_Alias_Setting_Data – SUB Class
|
Name
|
Data Type
|
Qualifiers
|
|
|
Name
|
Value
|
|
|
_id
|
bigint
|
|
|
|
|
|
|
Description
|
Column ID for entries in the table
|
|
Key
|
true
|
|
_ResourceGuid
|
uniqueidentifier
|
|
|
|
|
|
|
Description
|
The reporting system’s GUID
|
|
Key
|
true
|
|
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
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
Inv_Apache_Http_Redirect_Setting_Data – SUB Class
|
Name
|
Data Type
|
Qualifiers
|
|
|
Name
|
Value
|
|
|
_id
|
bigint
|
|
|
|
|
|
|
Description
|
Column ID for entries in the table
|
|
Key
|
true
|
|
_ResourceGuid
|
uniqueidentifier
|
|
|
|
|
|
|
Description
|
The reporting system’s GUID
|
|
Key
|
true
|
|
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
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
Inv_Http_Host_Setting_Data – BASE Class
|
Name
|
Data Type
|
Qualifiers
|
|
|
Name
|
Value
|
|
|
_id
|
bigint
|
|
|
|
|
|
|
Description
|
Column ID for entries in the table
|
|
Key
|
true
|
|
_ResourceGuid
|
uniqueidentifier
|
|
|
|
|
|
|
Description
|
The reporting system’s GUID
|
|
Key
|
true
|
|
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
|
HeaderWaitTimeout
|
|
|
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
|
|
| |
|
|
|
|
|
|
|
|
|
|
Inv_Apache_Http_Host_Configuration_Data – SUB Class
|
Name
|
Data Type
|
Qualifiers
|
|
|
Name
|
Value
|
|
|
_id
|
bigint
|
|
|
|
|
|
|
Description
|
Column ID for entries in the table
|
|
Key
|
true
|
|
_ResourceGuid
|
uniqueidentifier
|
|
|
|
|
|
|
Description
|
The reporting system’s GUID
|
|
Key
|
true
|
|
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
|
|
| |
|
|
|
|
|
|
|
|
|
|
Inv_Http_Server_Setting_Data – BASE Class
|
Name
|
Data Type
|
Qualifiers
|
|
|
Name
|
Value
|
|
|
_id
|
bigint
|
|
|
|
|
|
|
Description
|
Column ID for entries in the table
|
|
Key
|
true
|
|
_ResourceGuid
|
uniqueidentifier
|
|
|
|
|
|
|
Description
|
The reporting system’s GUID
|
|
Key
|
true
|
|
InstanceID
|
string(256)
|
|
|
|
|
|
|
|
Description
|
Unique identifier of the http server configuration.
|
|
|
DisplayName
|
Instance ID
|
|
|
Key
|
true
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
Inv_Apache_Http_Server_Setting_Data – SUB Class
|
Name
|
Data Type
|
Qualifiers
|
|
|
Name
|
Value
|
|
|
_id
|
bigint
|
|
|
|
|
|
|
Description
|
Column ID for entries in the table
|
|
Key
|
true
|
|
_ResourceGuid
|
uniqueidentifier
|
|
|
|
|
|
|
Description
|
The reporting system’s GUID
|
|
Key
|
true
|
|
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
|
|
| |
|
|
|
|
|
|
|
|
|
|
Inv_Http_Host – STANDARD Class
|
Name
|
Data Type
|
Qualifiers
|
|
|
Name
|
Value
|
|
|
_id
|
bigint
|
|
|
|
|
|
|
Description
|
Column ID for entries in the table
|
|
Key
|
true
|
|
_ResourceGuid
|
uniqueidentifier
|
|
|
|
|
|
|
Description
|
The reporting system’s GUID
|
|
Key
|
true
|
|
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
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
Inv_Apache_MPM_Http_Server_Setting_Data – STANDARD Class
|
Name
|
Data Type
|
Qualifiers
|
|
|
Name
|
Value
|
|
|
_id
|
bigint
|
|
|
|
|
|
|
Description
|
Column ID for entries in the table
|
|
Key
|
true
|
|
_ResourceGuid
|
uniqueidentifier
|
|
|
|
|
|
|
Description
|
The reporting system’s GUID
|
|
Key
|
true
|
|
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
|
|
| |
|
|
|
|
|
|
|
|
|
|
Inv_Http_Host_Binding – STANDARD Class
|
Name
|
Data Type
|
Qualifiers
|
|
|
Name
|
Value
|
|
|
_id
|
bigint
|
|
|
|
|
|
|
Description
|
Column ID for entries in the table
|
|
Key
|
true
|
|
_ResourceGuid
|
uniqueidentifier
|
|
|
|
|
|
|
Description
|
The reporting system’s GUID
|
|
Key
|
true
|
|
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
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
Inv_Http_Server – STANDARD Class
|
Name
|
Data Type
|
Qualifiers
|
|
|
Name
|
Value
|
|
|
_id
|
bigint
|
|
|
|
|
|
|
Description
|
Column ID for entries in the table
|
|
Key
|
true
|
|
_ResourceGuid
|
uniqueidentifier
|
|
|
|
|
|
|
Description
|
The reporting system’s GUID
|
|
Key
|
true
|
|
InstanceID
|
string(256)
|
|
|
|
|
|
|
|
Description
|
Unique identifier of the http server available on the computer.
|
|
|
DisplayName
|
Instance ID
|
|
|
Key
|
true
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
Inv_Http_Host_Host_Binding – ASSOCIATION Class
|
Name
|
Class Origin
|
Reference Class
|
Description
|
|
|
HostBinding
|
Inv_Http_Host_Host_Binding
|
Inv_Http_Host_Binding
|
Address binding information for the host.
|
|
|
HttpHost
|
Inv_Http_Host_Host_Binding
|
Inv_Http_Host
|
Host which the binding applies to.
|
|
|
_id
|
bigint
|
|
|
|
|
|
|
Description
|
Column ID for entries in the table
|
|
Key
|
true
|
|
_ResourceGuid
|
uniqueidentifier
|
|
|
|
|
|
|
Description
|
The reporting system’s GUID
|
|
Key
|
true
|
| |
|
|
|
|
|
|
|
|
|
Inv_Http_Host_Secure_Host_Binding – ASSOCIATION Class
|
Name
|
Class Origin
|
Reference Class
|
Description
|
|
|
HostBinding
|
Inv_Http_Host_Secure_Host_Binding
|
Inv_Http_Host_Binding
|
Address binding information for the host.
|
|
|
HttpHost
|
Inv_Http_Host_Secure_Host_Binding
|
Inv_Http_Host
|
Host which the binding applies to.
|
|
|
_id
|
bigint
|
|
|
|
|
|
|
Description
|
Column ID for entries in the table
|
|
Key
|
true
|
|
_ResourceGuid
|
uniqueidentifier
|
|
|
|
|
|
|
Description
|
The reporting system’s GUID
|
|
Key
|
true
|
| |
|
|
|
|
|
|
|
|
|
|
Inv_Installed_Http_Server – ASSOCIATION Class
|
Name
|
Class Origin
|
Reference Class
|
Description
|
|
|
HttpServer
|
Inv_Installed_Http_Server
|
Inv_Http_Server
|
Http Server provided by the software component.
|
|
|
SoftwareComponent
|
Inv_Installed_Http_Server
|
Inv_Installed_Software
|
Information about the software providing functionality of Http Server in SRM.
|
|
|
_id
|
bigint
|
|
|
|
|
|
|
Description
|
Column ID for entries in the table
|
|
Key
|
true
|
|
_ResourceGuid
|
uniqueidentifier
|
|
|
|
|
|
|
Description
|
The reporting system’s GUID
|
|
Key
|
true
|
| |
|
|
|
|
|
|
|
|
|
|
Inv_Provided_Http_Host – ASSOCIATION Class
|
Name
|
Class Origin
|
Reference Class
|
Description
|
|
|
HttpHost
|
Inv_Provided_Http_Host
|
Inv_Http_Host
|
Individual Http Host (web-site) provided by the Server.
|
|
|
HttpServer
|
Inv_Provided_Http_Host
|
Inv_Http_Server
|
Http Server that provides Http Hosts.
|
|
|
_id
|
bigint
|
|
|
|
|
|
|
Description
|
Column ID for entries in the table
|
|
Key
|
true
|
|
_ResourceGuid
|
uniqueidentifier
|
|
|
|
|
|
|
Description
|
The reporting system’s GUID
|
|
Key
|
true
|
| |
|
|
|
|
|
|
|
|
|
Inv_Settings_Define_Http_Host – ASSOCIATION Class
|
Name
|
Class Origin
|
Reference Class
|
Description
|
|
|
HttpHost
|
Inv_Settings_Define_Http_Host
|
Inv_Http_Host
|
Host which the settings apply to.
|
|
|
HttpHostSettings
|
Inv_Settings_Define_Http_Host
|
Inv_Http_Host_Setting_Data
|
Settings for the host.
|
|
|
_id
|
bigint
|
|
|
|
|
|
|
Description
|
Column ID for entries in the table
|
|
Key
|
true
|
|
_ResourceGuid
|
uniqueidentifier
|
|
|
|
|
|
|
Description
|
The reporting system’s GUID
|
|
Key
|
true
|
| |
|
|
|
|
|
|
|
|
|
Conclusion
Hopefully this provides a guide that will allow you to upgrade or implement Inventory Pack for Servers 7.1 armed with the necessary data to manage your reports, filters, or anything else based off of Web or Database data.