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.
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.
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:
Note the following when reviewing the grids:
For help in navigating dependent data classes, use the following guide:
Name
Data Type
Qualifiers
Value
_id
bigint
Description
Column ID for entries in the table
Key
true
_ResourceGuid
uniqueidentifier
The reporting system’s GUID
Boot Device
string(256)
Name of the disk drive from which the Windows operating system starts. Example: "\Device\Harddisk0".
Display Name
Country Code
string(6)
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)
Install Date
datetime
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
Last Boot Up Time
Time when the Operating System was last booted.
Max Process Memory Size
uint64
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.
Max Process Memory Size (KiloBytes)
Units
KiloBytes
Name serves as key of an Operating System instance within a Computer System.
Number Of Licensed Users
uint32
Number of user licenses for the Operating System. If unlimited, 0 will be used.
Number Of Processors
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.
OS Architecture
string(64)
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
Registered User
Name of the registered user of the operating system. Example: "Ben Smith"
Serial Number
Operating system product serial identification number.
Total Swap Space Size
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.
Total Swap Space Size (KiloBytes)
Total Visible Memory Size
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.
Total Visible Memory Size (KiloBytes)
Dependent on Inv_OS_Operating_System
Encryption Level
Encryption level for secure transactions: 40-bit, 128-bit, or n-bit.
Encryption Level (Bits)
Bits
Locale
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
BitValues
Possible values: Small Business, Enterprise, BackOffice, Communication Server, Terminal Server, Small Business(Restricted), Embedded NT, Data Center
The OSProductSuite property identifies installed and licensed system product additions to the operating system.
System Directory
The SystemDirectory property indicates the system directory of the operating system. Example: C:\WINDOWS\SYSTEM32
System Drive
The SystemDrive property contains the letter of the disk drive that the operating system resides on. Example: C:
Windows Directory
The WindowsDirectory property indicates the Windows directory of the operating system. Example: C:\WINDOWS
string
A textual description of the share.
File Sharing Protocol
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
Instance ID
Uniquely identifies an instance of this class. The combination of share protocol and name will used. Example: SMB:share
Defines the shared name (alias) by which the shared object is exported. For NFS shares this will be the same as Path.
Path
The local path of the share.
Protocol Versions
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".
Dependent on Inv_OS_File_Share
Type
Nvarchar(256)
The Type of drive the file share represents
False
Max Connections
Nvarchar(1024)
How many connections are allowed to connect to the share
The share identification, including its Name
Command
nvarchar(256)
Name of the command and command line arguments that the scheduled service uses to invoke the job.
Job ID
Uniquely identifies this Job instance.
nvarchar(1024)
The Name property defines the label by which the object is known.
Owner
The User that submitted the Job, or the Service or method name that caused the job to be created.
Dependent on Inv_OS_Job
Run Day Of Month
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).
Run Day Of Week
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).
Run Hour
The hour (0-23) when the Job should be processed. May have values: number, asterisk (*), lists (1,2), ranges of numbers (5-9).
Run Minute
The minute (0-59) when the Job should be processed. May have values: number, asterisk (*), lists (1,2), ranges of numbers (5-9).
Run Month
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).
The identifier for the Job instance
Dependent on Inv_OS_Jobs
Interact With Desktop
boolean
Specified job is interactive, which means that a user can give input to a scheduled job while it is executing.
The following data classes are considered Stand-alone.
Share Permission
This specifies the access rights of a resource.
Domain
Resource ID
Share Name
The name of the designated share
Resource Type
The computer this data relates to
User
The user the associated data is about
Local Address
nvarchar(255)
Local Port
nvarchar (25)
Process Name
nvarchar (256)
Protocol Name
nvarchar (4)
Remote Address
nvarchar (255)
Remote Port
State
This specifies the domain name of the Admin group.
This specifies the name of the Admin group.
Class Count
int
The number of classes the inventory was collected for.
Collection Time
A datetime value that indicates when the inventory was collected.
Version
Inventory agent version.
Agent
What Inventory plug-in is being used, i.e. Server Inventory versus standard Inventory
Full Install Version
Full Install version
This gives the name of the network provider.
Maxlen
256
API Level
Driver ODBC Version
Driver Path
Driver Title
File Extensions
SQL Level
ODBC Driver
nvarchar (10)
Description of the object.
Installed By
Person who installed the update. If this value is unknown, the property is empty.
Installed Date
Object was installed.
Patch ID
Unique identifier associated with a particular update.
Registry Key
This specifies the unique registration key.
Reg Key
Service Pack
Service pack in effect when the update was applied.
This specifies the type of services and hot-fixes installed on the computer.
Accept Pause
bit
The Service can be paused.
Accept Stop
The Service can be stopped.
Desktop Interact
Service can create or communicate with windows on the desktop.
Exit Code
Windows error code that defines errors encountered in starting or stopping the service.
Date object is installed.
Unique identifier of the service that provides an indication of the functionality that is managed.
Service Type
Type of service provided to calling processes.
Started
Service has been started.
Current state of the base service.
Class
This gives the class type of the physical device.
This gives a description of the physical device.
Device ID
This specifies the unique index used to identify the physical devices.
Enumeration
This specifies the category of the physical device.
Manufacturer
This specifies the manufacturer name of the physical device.
This specifies the type of physical device.
Account Name
Application
This specifies the task application.
Comment
This specifies the task comments.
Creator
User that created the job.
Last Run Time
This specifies the last run time of the task.
Next Run Time
This specifies the next run time of the task.
Parameters
Priority
This specifies the priority of the tasks.
Schedule
This specifies a schedule for the task.
Status
This specifies the task status.
Task Id Name
Identifying number of the job.
Working Directory
This specifies the working directory of the tasks.
Daylight Name
Time zone being represented when daylight saving time is in effect.
Daylight Offset (Minutes)
Bias value to be used during local time translations that occur during daylight saving time.
Daylight Offset(Minutes)
Minutes
Standard Caption
Short description of the object.
Daylight Caption
Standard Name
Name of the time zone being represented when standard time is in effect.
Standard Offset (Minutes)
Current bias for local time translation.
Standard Offset(Minutes)
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.