Discovery and Inventory Group

 View Only

Inventory Solution 7.1 Database Schema – Part 1: Operating System Inventory 

Mar 27, 2013 01:35 PM

Whether you need to create a custom report, or a custom computer filter based on Inventory Data in Inventory Solution 7.1, knowing the database schema is crucial. This document provides technical details on the data structure.  In Part 1 the Operating System data classes will be covered.

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.1 Normalization includes dependencies on base-class tables, or, in other words, subsequent tables are extensions of the base table.

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
  • TERTIARY Class – This is a data class that has two dependent data class in the hierarchy (Not used for Operating System data classes)
  • STANDARD Class – This is a data class that contains no dependencies or sub classes

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 or TERTIARY classes subsequently listed 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_OS_Operating_System
    • Inv_OS_Operating_System_Windows
  • Inv_OS_File_Share
    • Inv_OS_File_Share_Windows
  • Inv_OS_Job
    • Inv_OS_Job_Unix
    • Inv_OS_Job_Windows

 

Inv_OS_Operating_System – 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

Boot Device

string(256)

 

 

 

 

 

Description

Name of the disk drive from which the Windows operating system starts. Example: "\Device\Harddisk0".

Display Name

Boot Device

Country Code

string(6)

 

 

 

 

 

Description

Code for the country/region that an operating system uses. Values are based on international phone dialing prefixes-also referred to as IBM country/region codes. The property can use a maximum of six characters to define the country/region code value. Example: 1 (United States)

Display Name

Country Code

Install Date

datetime

 

 

 

 

 

Description

A datetime value that indicates when the object was installed. Lack of a value does not indicate that the object is not installed – rather it indicates the data is unavailable

Display Name

Install Date

Last Boot Up Time

datetime

 

 

 

 

 

Description

Time when the Operating System was last booted.

Display Name

Last Boot Up Time

Max Process Memory Size

uint64

 

 

 

 

 

Description

Maximum number of Kbytes of memory that can be allocated to a Process. For Operating Systems with no virtual memory, this value is typically equal to the total amount of physical Memory minus memory used by the BIOS and OS. For some Operating Systems, this value may be infinity - in which case, 0 will be entered. In other cases, this value could be a constant - for example, 2G or 4G.

Display Name

Max Process Memory Size (KiloBytes)

Units

KiloBytes

Name

string(256)

 

 

 

 

 

Description

Name serves as key of an Operating System instance within a Computer System.

Key

true

Number Of Licensed Users

uint32

 

 

 

 

 

Description

Number of user licenses for the Operating System. If unlimited, 0 will be used.

Display Name

Number Of Licensed Users

Number Of Processors

uint32

 

 

 

 

 

Description

The number of processors currently available on the system. This is the number of processors whose status is "enabled" - versus simply the number of processors for the computer system. For systems with multi-core processors this value will indicate the number of enabled processor cores.

Display Name

Number Of Processors

OS Architecture

string(64)

 

 

 

 

 

Description

Architecture of the operating system, as opposed to the processor. Example: 32-bit.  This distinction is made as 32-bit Operating Systems can be installed on a 64-bit platform

Display Name

OS Architecture

Registered User

string(256)

 

 

 

 

 

Description

Name of the registered user of the operating system. Example: "Ben Smith"

Display Name

Registered User

Serial Number

string(64)

 

 

 

 

 

Description

Operating system product serial identification number.

Display Name

Serial Number

Total Swap Space Size

uint64

 

 

 

 

 

Description

Total swap space in Kbytes. This value may be NULL (unspecified) if swap space is not distinguished from page files. However, some Operating Systems distinguish these concepts. For example, in UNIX, whole processes can be 'swapped out' when the free page list falls and remains below a specified amount.

Display Name

Total Swap Space Size (KiloBytes)

Units

KiloBytes

Total Visible Memory Size

uint64

 

 

 

 

 

Description

The total amount of physical memory (in Kbytes) available to the Operating System. This value does not necessarily indicate the true amount of physical memory, but what is reported to the Operating System as available to it.

Display Name

Total Visible Memory Size (KiloBytes)

Units

KiloBytes

                       

 

Inv_OS_Operating_System_Windows – SUB Class

Dependent on Inv_OS_Operating_System

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

Name serves as key of an Operating System instance within a Computer System.

Key

true

Encryption Level

uint32

 

 

 

 

 

Description

Encryption level for secure transactions: 40-bit, 128-bit, or n-bit.

Display Name

Encryption Level (Bits)

Units

Bits

Locale

string(64)

 

 

 

 

 

Description

Language identifier used by the operating system. A language identifier is a standard international numeric abbreviation for a country/region. Each language has a unique language identifier (LANGID), a 16-bit value that consists of a primary language identifier and a secondary language identifier.

OS Product Suite

uint32

 

 

 

 

 

BitValues

Possible values: Small Business, Enterprise, BackOffice, Communication Server, Terminal Server, Small Business(Restricted), Embedded NT, Data Center

Description

The OSProductSuite property identifies installed and licensed system product additions to the operating system.

Display Name

OS Product Suite

System Directory

string(256)

 

 

 

 

 

Description

The SystemDirectory property indicates the system directory of the operating system. Example: C:\WINDOWS\SYSTEM32

Display Name

System Directory

System Drive

string(64)

 

 

 

 

 

Description

The SystemDrive property contains the letter of the disk drive that the operating system resides on. Example: C:

Display Name

System Drive

Windows Directory

string(256)

 

 

 

 

 

Description

The WindowsDirectory property indicates the Windows directory of the operating system. Example: C:\WINDOWS

Display Name

Windows Directory

                         

 

Inv_OS_File_Share – 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

Description

string

 

 

 

 

 

Description

A textual description of the share.

File Sharing Protocol

string

 

 

 

 

 

Description

File sharing protocol that this share can support. Possible values: SMB (also known as CIFS), NFS (Network file system), AFP (Apple Filing Protocol). For Windows it will be always SMB

Display Name

File Sharing Protocol

Instance ID

string(256)

 

 

 

 

 

Description

Uniquely identifies an instance of this class. The combination of share protocol and name will used. Example: SMB:share

Display Name

Instance ID

Key

true

Name

string(256)

 

 

 

 

 

Description

Defines the shared name (alias) by which the shared object is exported. For NFS shares this will be the same as Path.

Path

string(256)

 

 

 

 

 

Description

The local path of the share.

Protocol Versions

string(256)

 

 

 

 

 

Description

The versions of the file sharing protocol that can be supported by this share. For Windows Vista and Windows Server 2008 it will be "1.0/2.0" since they will support both SMB versions, for other Windows platforms it will be "1.0".

Display Name

Protocol Versions

                       

 

Inv_OS_File_Share_Windows – SUB Class

Dependent on Inv_OS_File_Share

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

Type

Nvarchar(256)

 

 

 

 

 

Description

The Type of drive the file share represents

Key

False

Max Connections

Nvarchar(1024)

 

 

 

 

 

Description

How many connections are allowed to connect to the share

Key

False

Instance ID

Nvarchar(256)

 

 

 

 

 

Description

The share identification, including its Name

Key

False

                     

 

Inv_OS_Job – 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

Command

nvarchar(256)

 

 

 

 

 

Description

Name of the command and command line arguments that the scheduled service uses to invoke the job.

Job ID

nvarchar(256)

 

 

 

 

 

Description

Uniquely identifies this Job instance.

Display Name

Job ID

Key

true

Name

nvarchar(1024)

 

 

 

 

 

Description

The Name property defines the label by which the object is known.

Owner

nvarchar(256)

 

 

 

 

 

Description

The User that submitted the Job, or the Service or method name that caused the job to be created.

                     

 

Inv_UNIX_Job_UNIX – SUB Class

Dependent on Inv_OS_Job

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

Run Day Of Month

nvarchar(256)

 

 

 

 

 

Description

The days of month (1-31) when the job is scheduled to run. May have values: number, asterisk (*), lists (1,2), ranges of numbers (5-9).

Display Name

Run Day Of Month

Run Day Of Week

nvarchar(256)

 

 

 

 

 

Description

The days of the week (0-7; 0 or 7 is Sunday) when the job is scheduled to run. May have values: number, asterisk (*), lists (1,2), ranges of numbers (3-6), day of week names (Sun, Mon).

Display Name

Run Day Of Week

Run Hour

nvarchar(256)

 

 

 

 

 

Description

The hour (0-23) when the Job should be processed. May have values: number, asterisk (*), lists (1,2), ranges of numbers (5-9).

Display Name

Run Hour

Run Minute

nvarchar(256)

 

 

 

 

 

Description

The minute (0-59) when the Job should be processed. May have values: number, asterisk (*), lists (1,2), ranges of numbers (5-9).

Display Name

Run Minute

Run Month

nvarchar(256)

 

 

 

 

 

Description

The month (1-12) during which the Job should be processed. 0 for January, 1 for February, and so on. May have values: number, asterisk (*), lists (1,2), ranges of numbers (5-9), month names (Jan, Feb).

Display Name

Run Month

Job ID

nvarchar(256)

 

 

 

 

 

Description

The identifier for the Job instance

Display Name

Job ID

                     

 

Inv_OS_Job_Windows – SUB Class

Dependent on Inv_OS_Jobs

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

Interact With Desktop

boolean

 

 

 

 

 

Description

Specified job is interactive, which means that a user can give input to a scheduled job while it is executing.

Display Name

Interact With Desktop

Job ID

nvarchar(256)

 

 

 

 

 

Description

The identifier for the Job instance

Display Name

Job ID

                           

 

Standard Classes

The following data classes are considered Stand-alone.

Inv_OS_ACLs_Windows – 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

Share Permission

nvarchar(256)

 

 

 

 

 

Description

This specifies the access rights of a resource.

Domain

nvarchar(256)

 

 

 

 

 

Key

true

Instance ID

nvarchar(256)

 

 

 

 

 

Display Name

Resource ID

Key

true

Share Name

nvarchar(256)

 

 

 

 

 

Description

The name of the designated share

Display Name

Share Name

Key

true

Resource Type

nvarchar(256)

 

 

 

 

 

Description

The computer this data relates to

Display Name

Resource Type

Key

true

User

nvarchar(256)

 

 

 

 

 

Description

The user the associated data is about

Key

true

                   

 

Inv_OS_Active_Tcp_Udp_Ports – 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

 

Local Address

nvarchar(255)

 

 

 

 

 

 

 

 

 

Display Name

Local Address

 

Local Port

nvarchar (25)

 

 

 

 

 

 

 

 

 

Display Name

Local Port

 

Key

true

 

Process Name

nvarchar (256)

 

 

 

 

 

 

 

 

 

Display Name

Process Name

 

Protocol Name

nvarchar (4)

 

 

 

 

 

 

 

 

 

Display Name

Protocol Name

 

Remote Address

nvarchar (255)

 

 

 

 

 

 

 

 

 

Display Name

Remote Address

 

Remote Port

nvarchar (25)

 

 

 

 

 

 

 

 

 

Display Name

Remote Port

 

State

nvarchar (25)

 

 

 

 

 

 

 

 

 

 

 

 

                   

 

Inv_UG_Admin_Group_Members – 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

Domain

string(256)

 

 

 

 

 

Description

This specifies the domain name of the Admin group.

Key

true

Name

string(256)

 

 

 

 

 

Description

This specifies the name of the Admin group.

                     

 

Inv_Inventory_Results – 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

Class Count

int

 

 

 

 

 

Description

The number of classes the inventory was collected for.

Display Name

Class Count

Collection Time

datetime

 

 

 

 

 

Description

A datetime value that indicates when the inventory was collected.

Display Name

Collection Time

Key

true

Version

nvarchar(256)

 

 

 

 

 

Description

Inventory agent version.

Agent

nvarchar(256)

 

 

 

 

 

Description

What Inventory plug-in is being used, i.e. Server Inventory versus standard Inventory

                     

 

Inv_OS_MDAC_Windows – 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

Full Install Version

nvarchar(1024)

 

 

 

 

 

 

 

Display Name

Full Install version

Key

true

Version

nvarchar(256)

 

 

 

 

 

 

 

                   

 

Inv_OS_Network_Provider_Windows – 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

 

 

 

 

 

Description

This gives the name of the network provider.

Key

true

Maxlen

256

                   

 

Inv_OS_ODBC_Windows – 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

API Level

nvarchar(256)

 

 

 

 

 

 

 

Display Name

API Level

Driver ODBC Version

nvarchar (256)

 

 

 

 

 

 

 

Display Name

Driver ODBC Version

Key

true

Driver Path

nvarchar (256)

 

 

 

 

 

 

 

Display Name

Driver Path

Driver Title

nvarchar (256)

 

 

 

 

 

 

 

Display Name

Driver Title

Key

true

File Extensions

nvarchar (256)

 

 

 

 

 

 

 

Display Name

File Extensions

SQL Level

nvarchar (256)

 

 

 

 

 

 

 

Display Name

SQL Level

ODBC Driver

nvarchar (10)

 

 

 

 

 

 

 

Display Name

ODBC Driver

                   

 

Inv_SW_Patch_Windows – 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

Description

nvarchar(256)

 

 

 

 

 

Description

Description of the object.

Installed By

nvarchar(256)

 

 

 

 

 

Description

Person who installed the update. If this value is unknown, the property is empty.

Display Name

Installed By

Installed Date

datetime

 

 

 

 

 

Description

Object was installed.

Display Name

Installed Date

Patch ID

Nvarchar(1024)

 

 

 

 

 

Description

Unique identifier associated with a particular update.

Display Name

Patch ID

Key

true

Registry Key

nvarchar(256)

 

 

 

 

 

Description

This specifies the unique registration key.

Display Name

Reg Key

Service Pack

nvarchar(256)

 

 

 

 

 

Description

Service pack in effect when the update was applied.

Display Name

Service Pack

Type

nvarchar(256)

 

 

 

 

 

Description

This specifies the type of services and hot-fixes installed on the computer.

                   

 

Inv_OS_Service_Windows – 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

Accept Pause

bit

 

 

 

 

 

Description

The Service can be paused.

Display Name

Accept Pause

Accept Stop

bit

 

 

 

 

 

Description

The Service can be stopped.

Display Name

Accept Stop

Desktop Interact

bit

 

 

 

 

 

Description

Service can create or communicate with windows on the desktop.

Display Name

Desktop Interact

Exit Code

int

 

 

 

 

 

Description

Windows error code that defines errors encountered in starting or stopping the service.

Display Name

Exit Code

Install Date

datetime

 

 

 

 

 

Description

Date object is installed.

Display Name

Install Date

Name

nvarchar(256)

 

 

 

 

 

Description

Unique identifier of the service that provides an indication of the functionality that is managed.

Key

true

Service Type

nvarchar(256)

 

 

 

 

 

Description

Type of service provided to calling processes.

Display Name

Service Type

Started

bit

 

 

 

 

 

Description

Service has been started.

Display Name

Started

State

nvarchar(256)

 

 

 

 

 

Description

Current state of the base service.

Display Name

State

                   

 

Inv_OS_System_Device_Windows – STANDARD Class

Name

Data Type

Qualifiers

Name

Value

_id

bigint

 

 

 

 

 

Description

Column ID for entries in the table

Key

true

_id

bigint

 

 

 

 

 

Description

Column ID for entries in the table

Key

true

_ResourceGuid

uniqueidentifier

 

 

 

 

 

Description

The reporting system’s GUID

Key

true

Class

nvarchar(256)

 

 

 

 

 

Description

This gives the class type of the physical device.

Display Name

Class

Description

nvarchar(256)

 

 

 

 

 

Description

This gives a description of the physical device.

Device ID

int

 

 

 

 

 

Description

This specifies the unique index used to identify the physical devices.

Display Name

Device ID

Key

true

Enumeration

nvarchar(256)

 

 

 

 

 

Description

This specifies the category of the physical device.

Manufacturer

nvarchar(256)

 

 

 

 

 

Description

This specifies the manufacturer name of the physical device.

Type

nvarchar(256)

 

 

 

 

 

Description

This specifies the type of physical device.

                   

 

Inv_OS_Task_Scheduler_Windows – 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

Account Name

nvarchar(256)

 

 

 

 

 

 

 

Display Name

Account Name

Application

nvarchar(256)

 

 

 

 

 

Description

This specifies the task application.

Comment

nvarchar(256)

 

 

 

 

 

Description

This specifies the task comments.

Creator

nvarchar(256)

 

 

 

 

 

Description

User that created the job.

Last Run Time

datetime

 

 

 

 

 

Description

This specifies the last run time of the task.

Display Name

Last Run Time

Next Run Time

datetime

 

 

 

 

 

Description

This specifies the next run time of the task.

Display Name

Next Run Time

Parameters

nvarchar(256)

 

 

 

 

 

 

 

Priority

nvarchar(256)

 

 

 

 

 

Description

This specifies the priority of the tasks.

Schedule

nvarchar(256)

 

 

 

 

 

Description

This specifies a schedule for the task.

Status

nvarchar(256)

 

 

 

 

 

Description

This specifies the task status.

Task Id Name

nvarchar(256)

 

 

 

 

 

Description

Identifying number of the job.

Display Name

Task Id Name

Key

true

Working Directory

nvarchar(256)

 

 

 

 

 

Description

This specifies the working directory of the tasks.

Display Name

Working Directory

                   

 

Inv_OS_Timezone – 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

Daylight Name

nvarchar(256)

 

 

 

 

 

Description

Time zone being represented when daylight saving time is in effect.

Display Name

Daylight Name

Daylight Offset (Minutes)

int

 

 

 

 

 

Description

Bias value to be used during local time translations that occur during daylight saving time.

Display Name

Daylight Offset(Minutes)

Units

Minutes

Standard Caption

nvarchar(256)

 

 

 

 

 

Description

Short description of the object.

Display Name

Standard Caption

Daylight Caption

nvarchar(256)

 

 

 

 

 

Description

Short description of the object.

Display Name

Daylight Caption

Standard Name

nvarchar(256)

 

 

 

 

 

Description

Name of the time zone being represented when standard time is in effect.

Display Name

Standard Name

Key

true

Standard Offset (Minutes)

int

 

 

 

 

 

Description

Current bias for local time translation.

Display Name

Standard Offset(Minutes)

Units

Minutes

                   

 

Conclusion

This updated version now contains the correct table names and updated Table, columns, and data types found in version 7.1. This version was built off of 7.1 SP2 MR1.1, so there may be minor differences based on the history of fixes, etc.

Statistics
0 Favorited
0 Views
1 Files
0 Shares
0 Downloads
Attachment(s)
doc file
Inventory Solution 7.1 Operation System Database Schema.doc   561 KB   1 version
Uploaded - Feb 25, 2020

Tags and Keywords

Related Entries and Links

No Related Resource entered.