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:
- 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 or TERTIARY classes subsequently listed 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:
- Altiris_OS_OperatingSystem
- Altiris_OS_OperatingSystem_Windows
- Altiris_OS_FileShare
- 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 Comments • Jump to latest comment
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
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.
Would you like to reply?
Login or Register to post your comment.