Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

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

Created: 12 Nov 2008 • Updated: 23 Apr 2009 | 2 comments
Language Translations
Joel Smith's picture
+7 7 Votes
Login to vote

Whether you need to create a custom report, or a custom computer filter based on Inventory Data in Inventory Solution 7.0, knowing the database schema is important. In Inventory Solution 7.0 the data structure for inventory has been completely revamped. If you are familiar with the data structure for Inventory Solution 6.x, or if you are new to Inventory Solution in version 7.0, this document provides technical details on the new 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.0 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:

  • Altiris_OS_OperatingSystem
    • Altiris_OS_OperatingSystem_Windows
  • Altiris_OS_FileShare
    • Altiris_OS_NFSShare
  • Altiris_OS_Job
    • Altiris_OS_Job_Unix
    • Altiris_OS_Job_Windows

Altiris_OS_OperatingSystem - BASE Class

Name Data Type Qualifiers
Name Value
BootDevice string(256)  
Description Name of the disk drive from which the Windows operating system starts. Example: "\Device\Harddisk0".
Display Name Boot Device
CountryCode 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
CurrentTimeZone sint16  
Description CurrentTimeZone indicates the number of minutes the Operating System is offset from Greenwich Mean Time. The number is positive, negative, or zero.
Display Name Current Time Zone (Minutes)
Units Minutes
InstallDate 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
LastBootUpTime datetime  
Description Time when the Operating System was last booted.
Display Name Last Boot Up Time
MaxProcessMemorySize    
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
NumberOfLicensedUsers uint32  
Description Number of user licenses for the Operating System. If unlimited, 0 will be used.
Display Name Number Of Licensed Users
NumberOfProcessors 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
OSArchitecture 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
RegisteredUser string(256)  
Description Name of the registered user of the operating system. Example: "Ben Smith".
Display Name Registered User
SerialNumber string(64)  
Description Operating system product serial identification number.
Display Name Serial Number
TotalSwapSpaceSize 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
TotalVisibleMemorySize 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

Altiris_OS_OperatingSystem_Windows - SUB Class

Dependent on Altiris_OS_OperatingSystem

Name Data Type Qualifiers
Name Value
EncryptionLevel 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.
OSProductSuite 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
SystemDirectory string(256)  
Description The SystemDirectory property indicates the system directory of the operating system. Example: C:\WINDOWS\SYSTEM32
Display Name System Directory
SystemDrive 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
WindowsDirectory string(256)  
Description The WindowsDirectory property indicates the Windows directory of the operating system. Example: C:\WINDOWS
Display Name Windows Directory

Altiris_OS_FileShare - BASE Class

TABLE START

Name Data Type Qualifiers
Name Value
Description string  
Description A textual description of the share.
FileSharingProtocol 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
InstanceID 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.
ProtocolVersions 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

Altiris_OS_NFSShare - SUB Class

Name Data Type Qualifiers
Name Value
Options string(256)  
Description Whitespace-separated list of clients allowed to mount the file system at that point. Each listed client may be immediately followed by a parenthesized, comma-separated list of export options for that client.

Altiris_OS_Job - BASE Class

Name Data Type Qualifiers
Name Value
Command string(256)  
Description
JobID string(256)  
Description Uniquely identifies this Job instance.
Display Name Job ID
Key true
Name string(1024)  
Description The Name property defines the label by which the object is known.
Ownerstring(256)    
Description The User that submitted the Job, or the Service or method name that caused the job to be created.

Altiris_OS_Job_UNIX - SUB Class

Name Data Type Qualifiers
Name Value
RunDayOfMonth string(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
RunDayOfWeek string(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
RunHour string(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
RunMinute string(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
RunMonth string(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

Altiris_OS_Job_Windows - SUB Class

Name Data Type Qualifiers
Name Value
InteractWithDesktop 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

Standard Classes

The following data classes are considered Stand-alone.

Altiris_OS_ACLs_Windows - STANDARD Class

Name Data Type Qualifiers
Name Value
Access string(256)  
Description This specifies the access rights of a resource.
Domain string(256)  
Key true
ResourceID string(256)  
Display Name Resource ID
Key true
ResourceType string(256)  
Description The computer this data relates to
Display Name Resource Type
Key true
User string(256)  
Description The user the associated data is about
Key true

Altiris_OS_ActiveTcpUdpPorts - STANDARD Class

Name Data Type Qualifiers
Name Value
LocalAddress string(255)  
   
Display Name Local Address
LocalPort string(25)  
   
Display Name Local Port
Key true
ProcessName string(256)  
   
Display Name Process Name
ProtocolName string(4)  
   
Display Name Protocol Name
RemoteAddress string(255)  
   
Display Name Remote Address
RemotePort string(25)  
   
Display Name Remote Port
State string(25)  
   

Altiris_OS_AdminGroupMembers - STANDARD Class

Name Data Type Qualifiers
Name Value
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.
MemberID string(256)  
Description Security identifier (SID) for the account.
Display Name Member ID

Altiris_OS_InventoryResults - STANDARD Class

Name Data Type Qualifiers
Name Value
ClassCount uint16  
Description The number of classes the inventory was collected for.
Display Name Class Count
CollectionTime datetime  
Description A datetime value that indicates when the inventory was collected.
Display Name Collection Time
Key true
Version string(256)  
Description Inventory agent version.

Altiris_OS_MDAC_Windows - STANDARD Class

Name Data Type Qualifiers
Name Value
FullInstallVer string  
   
Display Name FullInstallVer
Key true
IE5_Version string(256)  
   
Display Name IE5_Version
Version string(256)

Altiris_OS_NetworkProvider_Windows - STANDARD Class

Name Data Type Qualifiers
Name Value
Name string  
Description This gives the name of the network provider.
Key true
Maxlen 256

Altiris_OS_ODBC_Windows - STANDARD Class

Name Data Type Qualifiers
Name Value
APILevel string(256)  
   
Display Name API Level
DriverODBCVersion string(256)  
   
Display Name Driver ODBC Version
Key true
DriverPath string(256)  
   
Display Name Driver Path
DriverTitle string(256)  
   
Display Name Driver Title
Key true
FileExtensions string(256)  
   
Display Name File Extensions
SQLLevel string(256)  
   
Display Name SQL Level

Altiris_OS_Patches_Windows - STANDARD Class

Name Data Type Qualifiers
Name Value
Description string(256)  
Description Description of the object.
InstalledBy string(256)  
Description Person who installed the update. If this value is unknown, the property is empty.
Display Name Installed By
InstalledDate datetime  
Description Object was installed.
Display Name Installed Date
PatchID string  
Description Unique identifier associated with a particular update.
Display Name Patch ID
Key true
RegKey string(256)  
Description This specifies the unique registration key.
Display Name Reg Key
ServicePack string(256)  
Description Service pack in effect when the update was applied.
Display Name Service Pack
Type string(256)  
Description This specifies the type of services and hot-fixes installed on the computer.

Altiris_OS_Service_Windows - STANDARD Class

Name Data Type Qualifiers
Name Value
AcceptPause boolean  
Description The Service can be paused.
Display Name Accept Pause
AcceptStop boolean  
Description The Service can be stopped.
Display Name Accept Stop
DesktopInteract boolean  
Description Service can create or communicate with windows on the desktop.
Display Name Desktop Interact
ExitCode uint32  
Description Windows error code that defines errors encountered in starting or stopping the service.
Display Name Exit Code
InstallDate datetime  
Description Date object is installed.
Display Name Install Date
Name string(256)  
Description Unique identifier of the service that provides an indication of the functionality that is managed.
Key true
ServiceType string(256)  
Description Type of service provided to calling processes.
Display Name Service Type
Started boolean  
Description Service has been started.
Display Name Started
State string(256)  
Description Current state of the base service.
Display Name State

Altiris_OS_Shares_Windows - STANDARD Class

Name Data Type Qualifiers
Name Value
Description string(256)  
   
MaxConnections string(256)  
   
Display Name Max Connections
ShareName string(256)  
   
Display Name Share Name
Key true
SharePath string(256)  
   
Display Name Share Path
Type string(256)  
   

Altiris_OS_SystemDevices_Windows - STANDARD Class

Name Data Type Qualifiers
Name Value
className string(256)  
Description This gives the class type of the physical device.
Display Name Class
Description string(256)  
Description This gives a description of the physical device.
DeviceID uint32  
Description This specifies the unique index used to identify the physical devices.
Display Name Device ID
Key true
Enumeration string(256)  
Description This specifies the category of the physical device.
Manufacturer string(256)  
Description This specifies the manufacturer name of the physical device.
Type string(256)  
Description This specifies the type of physical device.

Altiris_OS_TaskScheduler_Windows - STANDARD Class

Name Data Type Qualifiers
Name Value
AccountName string(256)  
   
Display Name Account Name
Application string(256)  
Description This specifies the task application.
Comment string(256)  
Description This specifies the task comments.
Creator string(256)  
Description User that created the job.
LastRunTime datetime  
Description This specifies the last run time of the task.
Display Name Last Run Time
NextRunTime datetime  
Description This specifies the next run time of the task.
Display Name Next Run Time
Parameters string(256)  
   
Priority string(256)  
Description This specifies the priority of the tasks.
Schedule string(256)  
Description This specifies a schedule for the task.
Status string(256)  
Description This specifies the task status.
TaskIdName uint32  
Description Identifying number of the job.
Display Name Task Id Name
Key true
WorkingDirectory string(256)  
Description This specifies the working directory of the tasks.
Display Name Working Directory

Altiris_OS_Timezone - STANDARD Class

Name Data Type Qualifiers
Name Value
DaylightName string(256)  
Description Time zone being represented when daylight saving time is in effect.
Display Name Daylight Name
DaylightOffset sint16  
Description Bias value to be used during local time translations that occur during daylight saving time.
Display Name Daylight Offset(Minutes)
Units Minutes
StandardCaption string(256)  
Description Short description of the object.
Display Name Standard Caption
StandardName string(256)  
Description Name of the time zone being represented when standard time is in effect.
Display Name Standard Name
Key true
StandardOffset sint16  
Description Current bias for local time translation.
Display Name Standard Offset(Minutes)
Units Minutes

Conclusion

Hopefully this provides a guide that will allow you to upgrade or implement Inventory Solution 7.0 armed with the necessary data to manage your reports, filters, or anything else based off of Operating System data.

Inventory Solution 7.0 Database Schema - Index of Articles

Inventory Solution 7.0 Database Schema, Part 2: Hardware Inventory
 

Comments 2 CommentsJump to latest comment

Pascal KOTTE's picture

I would like Altiris automatically inventory also, drivers with file & version, and also the P&P enumeration string.

Please, see & vote this Idea:
https://www-secure.symantec.com/connect/idea/integrate-windows-device-enumeration-string-missing-drivers-drivers-file-name-version

~Pascal @ Kotte.net~ Do you speak French? Et utilisez Altiris: venez nous rejoindre sur le GUASF

+1
Login to vote
noodleNT's picture

Just a heads up, the "Last Boot Up Time" in 7.1 is wrong. It's getting collected with the local timezone on the box but then gets an additional timezone adjustment added to it when saved to the NS.

0
Login to vote