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.
NOTE: The information in this document may change, though at the time of publication this is believed to be the accurate information for the release of Inventory Solution 7.0.
Database Schema
The following list reveals data classes and their structure. First, the name of the table is given, followed by a designation as a Base or Sub Class data class. The following label system is used:
- BASE Class - This is a data class that has no dependencies on other Inventory data classes
- SUB Class - This is a data class that has 1 dependency on a BASE data class
- STANDARD Class - This is a data class that contains no dependencies or sub classes
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:
- Altiris_UG_UserAccount
- Altiris_UG_UserAccount_UNIX
- Altiris_UG_UserAccount_Windows
User Inventory
The following data classes are for User-based data:
Altiris_UG_UserAccount - BASE Class
| Name |
Data Type |
Qualifiers |
| Name |
Value |
| Description |
string(256) |
|
| Description |
Description of the object. |
| Domain |
string(256) |
|
| Description |
User domain or computer hostname for local users. |
| Key |
true |
| FullName |
string(256) |
|
| Description |
Full name of the user belonging to the network login profile. |
| DisplayName |
Full Name |
| HomeDirectory |
string(256) |
|
| Description |
Path to the home directory of the user. |
| DisplayName |
Home Directory |
| PrimaryGroupID |
string(256) |
|
| Description |
The identifier verifies the primary group to which the user's profile belongs. |
| DisplayName |
Primary Group ID |
| UserID |
string(256) |
|
| Description |
User identifier. Win32_NetworkLoginProfile.UserID for Windows, UID for UNIX. |
| DisplayName |
User ID |
| UserName |
string(256) |
|
| Description |
User account on a particular domain or computer. |
| DisplayName |
User Name |
| Key |
true |
Altiris_UG_UserAccount_UNIX - SUB Class
| Name |
Data Type |
Qualifiers |
| Name |
Value |
| LoginShell |
string(256) |
|
| Description |
The user's initial shell. |
| DisplayName |
Login Shell |
Altiris_UG_UserAccount_Windows - SUB Class
| Name |
Data Type |
Qualifiers |
| Name |
Value |
| AccountExpires |
datetime |
|
| Description |
This gives when the Account will expire. |
| DisplayName |
Account Expires |
| CodePage |
uint32 |
|
| Description |
Code page for the user's language of choice. |
| DisplayName |
Code Page |
| CountryCode |
uint32 |
|
| Description |
Country/region code for the user's language of choice. |
| DisplayName |
Country Code |
| Flags |
uint32 |
|
| Description |
The properties available to this network profile.(e.g. 2-Account disabled, 512, Normal account, 8388608-Password expired) |
| valueMap |
1, 2, 8, 16, 32, 64, 128, 256, 512, 2048, 4096, 8192, 65536, 1131072, 262144, 524288, 1048576, 2097152, 4194304, 8388608 |
| values |
Script, Account Disabled, Home Directory Required, Lockout, Password Not Required, Password Cannot Change, Encrypted Test Password Allowed, Temp Duplicate Account, Normal Account, Interdomain Trust Account, Workstation Trust Account, Server Trust Account, Do Not Expire Password, MNS Logon Account, Smartcard Required, Trusted for Delegation, Not Delegated, Use DES Key Only, Do Not Require Preauthorization, Password Expired |
| LastLogin |
datetime |
|
| Description |
User last logged on to the system. |
| DisplayName |
Last Login |
| LogonHours |
string(256) |
|
| Description |
Times during the week when the user can log on.Each bit represents a unit of time specified by the UnitsPerWeek property. |
| DisplayName |
Logon Hours |
| LogonServer |
string(256) |
|
| Description |
Name of the server to which logon requests are sent. |
| DisplayName |
Logon Server |
| MaximumStorage |
uint64 |
|
| Description |
Maximum amount of disk space available to the user. |
| DisplayName |
Maximum Storage (Bytes) |
| NumberOfLogons |
uint32 |
|
| Description |
Number of successful times the user tried to log on to this account. |
| DisplayName |
Number Of Logons |
| PasswordExpires |
datetime |
|
| Description |
Date and time the password expires. |
| DisplayName |
Password Expires |
| Privileges |
uint32 |
|
| Description |
Level of privilege assigned (e.g. 0-Guest, 1-User, 2-Administrator) |
| ValueMap |
0, 1, 2 |
| Values |
Guest, User, Administrator |
| Profile |
string(256) |
|
| Description |
Path to the user's profile. |
Altiris_UG_AdminGroupMembers - STANDARD Class
| Name |
Data Type |
Qualifiers |
| Name |
Value |
| Domain |
string(256) |
|
| Description |
This specifies the domain name of the user from Admin group or the computer hostname for local users. |
| Key |
true |
| MemberName |
string(256) |
|
| Description |
This specifies the name of the user from Admin group. |
| DisplayName |
Member Name |
| Key |
true |
Altiris_UG_Group - STANDARD Class
| Name |
Data Type |
Qualifiers |
| Name |
Value |
| Description |
string(256) |
|
| Description |
Textual description of the object. |
| GroupID |
string(256) |
|
| Description |
The group identifier, SID for Windows, numerical group ID for UNIX. |
| DisplayName |
Group ID |
| Key |
true |
| Name |
string(256) |
|
| Description |
The name of the group. |
Altiris_UG_UserUsage_UNIX - STANDARD Class
| Name |
Data Type |
Qualifiers |
| Name |
Value |
| AccessPoint |
string(256) |
|
| Description |
Where the connection was made from. For remote connections this field will contain the remote host name or IP address, for local connections will be always "local" |
| DisplayName |
Access Point |
| ConnectionType |
string(256) |
|
| Description |
How the connection was made: console, terminal window and so on. |
| DisplayName |
Connection Type |
| Domain |
string(256) |
|
| Description |
User domain or the computer hostname for local users. |
| InstanceID |
string(256) |
|
| Description |
Unique identificator for class object |
| DisplayName |
Instance ID |
| Key |
true |
| LoginSessionEndTime |
datetime |
|
| Description |
The datetime value when the user logged out. |
| DisplayName |
Login Session End Time |
| LoginSessionStartTime |
datetime |
|
| Description |
The datetime value when the user logged in. |
| DisplayName |
Login Session Start Time |
| UserName |
string(256) |
|
| Description |
The login user name. |
| DisplayName |
User Name |
Software Inventory
The following data classes are for Software-based data:
Altiris_SW_Antivirus - STANDARD Class
| Name |
Data Type |
Qualifiers |
| Name |
Value |
| CentrallyManaged |
boolean |
|
| Description |
Value specifying a managed / unmanaged / standalone antivirus machine. |
| DisplayName |
Centrally Managed |
| DisplayName |
string(256) |
|
| Description |
Name of the antivirus. |
| DisplayName |
Name |
| Key |
true |
| DisplayVersion |
string(256) |
|
| Description |
Version of the antivirus. |
| DisplayName |
Version |
| LastScanTime |
datetime |
|
| Description |
The time when the last virus scan was performed scheduled or manual scan. |
| DisplayName |
Last Scan Time |
| LastVirusDefinitionCheck |
datetime |
|
| Description |
The time when the virus definitions on a machine were last updated. |
| DisplayName |
Last Virus Definition Check |
| Parent |
string(256) |
|
| Description |
This is the server name of the antivirus machine |
| DisplayName |
Server Name |
| PatternFileRevision |
string(256) |
|
| Description |
This is the revision number of the virus definition file |
| DisplayName |
Virus Definition File Version |
| RealTimeEnabled |
boolean |
|
| Description |
Value specifying if virus protection is enabled / disabled on a machine |
| DisplayName |
Real Time Enabled |
| VirusDefFileDate |
datetime |
|
| Description |
This is the date when the virus definition file was originally created |
| DisplayName |
Virus Definition File Date |
Altiris_SW_AuditResults - STANDARD Class
| Name |
Data Type |
Qualifiers |
| Name |
Value |
| FilesExamined |
uint32 |
|
| Description |
The total number of files examined. |
| DisplayName |
Files Examined |
| ScanDuration |
uint32 |
|
| Description |
The scan duration in minutes. |
| DisplayName |
Scan Duration (Minutes) |
| Units |
Minutes |
| ScanTime |
datetime |
|
| Description |
Datetime value indicates when the software scanning started. |
| DisplayName |
Scan Time |
| Key |
true |
| TotalProductsReported |
uint32 |
|
| Description |
The total number of software products reported. |
| DisplayName |
Total Products Reported |
Altiris_SW_AvailableUpdates_UNIX - STANDARD Class
| Name |
Data Type |
Qualifiers |
| Name |
Value |
| Name |
string(256) |
|
| Description |
The available software update name. |
| DisplayName |
Name |
| RequiresRestart |
boolean |
|
| Description |
True if the update requires computer restart after install. |
| DisplayName |
Requires Restart |
| Severity |
uint32 |
|
| Description |
Describes the severity of the available update. Example: "recommended", "optional". |
| DisplayName |
Severity |
| Size |
uint64 |
|
| Description |
Total size of the update in bytes. |
| DisplayName |
Size (Bytes) |
| Units |
Bytes |
| UpdateKey |
string(64) |
|
| Description |
An identifier for the update. |
| DisplayName |
Update Key |
| Key |
true |
| Version |
string(256) |
|
| Description |
The version of the update. |
| DisplayName |
Version |
Altiris_SW_BIOSElement - STANDARD Class
| Name |
Data Type |
Qualifiers |
| Name |
Value |
| BuildNumber |
string(64) |
|
| Description |
The internal identifier for this compilation of this software element. |
| DisplayName |
Build Number |
| IdentificationCode |
string(64) |
|
| Description |
Often this will be a stock keeping unit (SKU) or a part number. |
| DisplayName |
Identification Code |
| Manufacturer |
string(256) |
|
| Description |
Manufacturer of this BIOS. |
| Name |
string(256) |
|
| Description |
The name used to identify this SoftwareElement. |
| Key |
true |
| ReleaseDate |
datetime |
|
| Description |
Release date of the BIOS in the UTC format. |
| DisplayName |
Release Date |
| Version |
string(64) |
|
| Description |
Version of the BIOS. |
Altiris_SW_DeviceDriver_Windows - STANDARD Class
| Name |
Data Type |
Qualifiers |
| Name |
Value |
| DeviceID |
string(256) |
|
| Description |
Identifier (unique to the computer system) for different devices. |
| DisplayName |
Device ID |
| Key |
true |
| DriverProvider |
string(256) |
|
| Description |
Name of the Windows device driver. |
| DisplayName |
Driver Provider |
| DriverVersion |
string(64) |
|
| Description |
Version number of the device driver. |
| DisplayName |
Driver Version |
| InfFileName |
string(50) |
|
| Description |
Name of the .inf file for the Windows device. |
| DisplayName |
Inf File Name |
| InfSection |
string(50) |
|
| Description |
Section of the .inf file where the Windows information resides. |
| DisplayName |
Inf Section |
| Service |
string(255) |
|
| Description |
|
| DisplayName |
Service |
Altiris_SW_DiskUsageByFileType - STANDARD Class
| Name |
Data Type |
Qualifiers |
| Name |
Value |
| Drive |
string(1024) |
|
| Description |
Drive name. |
| DisplayName |
Drive |
| Key |
true |
| FileType |
string(40) |
|
| Description |
File type. |
| DisplayName |
File Type |
| Key |
true |
| TotalFileSizes |
uint64 |
|
| Description |
Total file sizes in kilobytes. |
| DisplayName |
Total File Sizes (KiloBytes) |
| Units |
KiloBytes |
| TotalFilesReported |
uint32 |
|
| Description |
Total files reported. |
| DisplayName |
Total Files Reported |
Altiris_SW_Fonts - STANDARD Class
| Name |
Data Type |
Qualifiers |
| Name |
Value |
| FileName |
string(256) |
|
| Description |
The name of file containing font. |
| DisplayName |
File Name |
| FontName |
string(256) |
|
| Description |
The font name. |
| DisplayName |
Font Name |
| FontType |
string(256) |
|
| Description |
The font type. Example: "Bitmap/vector", "TrueType", "OpenType PostScrip", "PostScript Type 1" |
| DisplayName |
Font Type |
| Path |
string(256) |
|
| Description |
The path to directory wrere the font file is located. |
| SoftwareElementID |
string(256) |
|
| Description |
An identifier for the font. |
| DisplayName |
Instance ID |
| Key |
true |
Altiris_SW_Patch_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. |
| DisplayName |
Installed By |
| InstalledDate |
datetime |
|
| Description |
Object was installed. |
| DisplayName |
Installed Date |
| PatchID |
string |
|
| Description |
Unique identifier associated with a particular update. |
| DisplayName |
Patch ID |
| Key |
true |
| RegKey |
string(256) |
|
| Description |
This specifies the unique registration key. |
| DisplayName |
Reg Key |
| ServicePack |
string(256) |
|
| Description |
Service pack in effect when the update was applied. |
| DisplayName |
Service Pack |
| Type |
string(256) |
|
| Description |
This specifies the type of services and hot-fixes installed on the computer. |
Altiris_SW_SMBIOSElement - STANDARD Class
| Name |
Data Type |
Qualifiers |
| Name |
Value |
| SMBIOSMajorVersion |
uint16 |
|
| Description |
Identifies the major version of SMBIOS specification implemented in the table structures, e.g. the value will be 0Ah for revision 10.22 and 02h for revision 2.1. This property corresponds to the value with offset 06h of SMBIOS Structure Table Entry Point. |
| DisplayName |
SMBIOS Major Version |
| Key |
true |
| SMBIOSMinorVersion |
uint16 |
|
| Description |
Identifies the minor version of this specification implemented in the table structures, e.g. the value will be 16h for revision 10.22 and 01h for revision 2.1.This property corresponds to the value with offset 07h of SMBIOS Structure Table Entry Point. |
| DisplayName |
SMBIOS Minor Version |
Altiris_SW_Virtual_Software_Packages_Windows - STANDARD Class
| Name |
Data Type |
Qualifiers |
| Name |
Value |
| ActivatedTime |
datetime |
|
| Description |
When the layer was last activated. Null if the layer has never been activated. The activated time will be reported in NS date time format, example: '2006-10-17T10:32:06'. |
| DisplayName |
Activated Time |
| Active |
boolean |
|
| Description |
1 if the layer is activated, 0 otherwise. |
| DisplayName |
Active |
| AutoActivate |
boolean |
|
| Description |
1 if the layer is auto activated 0 otherwise. |
| DisplayName |
Auto Activate |
| Key |
true |
| CreatedTime |
datetime |
|
| Description |
When the layer was created. |
| DisplayName |
Created Time |
| |
|
| Name |
string(260) |
|
| Description |
Layer Name. SVS has two layers for each package one read only, other writable. We will report only the writeable layers. |
| DisplayName |
Name |
| PackageId |
string(64) |
|
| Description |
This typically takes the form of a GUID |
| DisplayName |
Package Id |
| Key |
true |
| ResetTime |
datetime |
|
| Description |
When the layer was last reset. Null if the layer has never been reset. The reset time will be reported in NS date time format, example: '2006-10-17T10:32:06' |
| DisplayName |
Reset Time |
| Type |
uint32 |
|
| Description |
Type of the virtual software package. 0 = Application 1 = Data |
| DisplayName |
Type |
Altiris_SW_Virtual_Software_Sublayers_Windows - STANDARD Class
| Name |
Data Type |
Qualifiers |
| Name |
Value |
| FileRedirectPath |
string(1024) |
|
| Description |
File system path where the redirect area of the layer is located. |
| DisplayName |
File Redirect Path |
| LayerId |
string(64) |
|
| Description |
This typically takes the form of a GUID. |
| DisplayName |
Layer Id |
| Key |
true |
| PackageId |
string(64) |
|
| Description |
This typically takes the form of a GUID. |
| DisplayName |
Package Id |
| Key |
true |
| RegistryRedirectPath |
string(1024) |
|
| Description |
Registry path where the redirect area of the layer is located. |
| DisplayName |
Registry Redirect Path |
| Type |
uint32 |
|
| Description |
Type of the layer.0 = Normal 1 = Peer 2 = Data |
| DisplayName |
Type |
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 Detailed Software and User data. This also concludes the series and now all data classes as part of Inventory Solution 7.0 are included (this does not include Server Inventory data classes, which will be covered in a separate article).
Inventory Solution 7.0 Database Schema, Part 2: Hardware Inventory
Comments 8 Comments • Jump to latest comment
Hi Joel,
Where do i select a new language for the Software Updates? is it a Notification Server setting? is it a patch management setting?
I would like to incoprporate new users which have different softwares than English softwares.
thanks,
Dom
Dom
Dominique,
I'd recommend contacting the Patch Management Support team as I am unfamiliar with Patch at this time. They should be able to answer your question.
Thanks,
Joel
Joel Smith
Symantec Services Group (SSE)
Sr. Principal Support Engineer
Joel,
I found it under the All Settings > Software > Patch Management > Patch Management Core Solution
Thanks,
Dom
Dom
Joel, I appreciate this info, but I was pointed to this article because I was looking to pull certain core SW information out of Altiris v7 and into a CMDB.
Namely, just four (4) attributes:
- sw product Manufacturer
- sw product Name
- sw product Version
- sw product Filename
Can you tell me where these are in the v7 schema? I cannot find the location for these in v7 as compared to v6.
Thanks,
JC
What tables are needed to see what software is installed. I'm in the same boat as jclyde in trying to find the needed tables for this information. Kind of expected that to be documented under the User and SW schema section.
Hi Joel,
In NS 6 we have been using the table Inv_EU_Contact_Detail , which could be seen in the Resource manager under User folder.
We are using this table to run reports based on user's department and company amongst other fields.
In NS 7 I cannot see this table any more in the resource manager.
Where are the user department and company fields stored? Is the table Inv_EU_Contact_Detail still used?
Is this information collected during the default user inventory?
Thank you,
Peter
I am in the same boat as you....I haven't found the table that has this data.
I think a more robust list detailing the schema of the 7 platform is needed. Does Symantec plan on releasing a schema of the 7.1 platform when it releases? I know I will have quite a bit of re-writing reports and such to map to the new schema, so a diagram of the new schema is a neccesary piece of information. Would anyone else benefit from having a documented schema for 7.1?
Would you like to reply?
Login or Register to post your comment.