Chat now with support
Chat with Support

KACE Desktop Authority 11.1 - Data Dictionary

Contents Database Schema
User Management Profile Data Computer Management Profile Data Hardware/Software Inventory Data User/Computer Activity Data ComputerIdentification ComputerSession DAConfigurationAuditLog DataImportConfiguration DomainUsers Hardware_Display Hardware_Inventory Hardware_IPAddress Hardware_LogicalDisk Hardware_Modem Hardware_NIC Hardware_Printer Hardware_Processor Hardware_SIMM Hardware_Storage Hardware_USB Hardware_VideoCard HardwareInventory ItemIdentification PatchApplication PatchApplication_Item PatchManagement_Severities Profile_Alerts Profile_ApplicationLauncher Profile_ApplicationLauncherCBM Profile_CommonFolderRedirection Profile_DataCollection Profile_DataCollectionCBM Profile_Display Profile_Drives Profile_Embargo Profile_Environment Profile_FileOperations Profile_FolderRedirection Profile_General Profile_GroupPolicyTemplates Profile_Inactivity Profile_INIFiles Profile_LegalNotice Profile_Logging Profile_MailProfile Profile_MessageBoxes Profile_MSOffice Profile_Outlook Profile_Outlook_BlockedSender Profile_Outlook_SafeRecipient Profile_Outlook_SafeSender Profile_PatchManagement Profile_PatchManagementCBM Profile_Path Profile_Permissions Profile_PostEngineScripts Profile_PowerManagement Profile_PreEngineScripts Profile_Printers Profile_Registry Profile_RegistryCBM Profile_RemoteManagement Profile_SecurityPolicies Profile_ServicePacks Profile_ServicePacksCBM Profile_Shortcuts Profile_SoftwareDeployment Profile_SoftwareDeploymentCBM Profile_TimeSync Profile_WakeOnLanBeaconCBM Profile_WebBrowser Profile_WebBrowser_ExceptionAddOn Profile_WebBrowser_ExceptionCookies Profile_WebBrowser_ExceptionPassword Profile_WebBrowser_ExceptionPopUp Profile_WebBrowser_IntranetSite Profile_WebBrowser_RestrictedSite Profile_WindowsFirewall Profiles SoftwareInventory UserSession UserSessionActivity
About us

HardwareInventory

This table is a 1-1 relation to the ComputerIdentification table. This table contains a summary of hardware data for machines on a customer’s network. A Computer Management Data Collection element must be configured to collect this information.

ComputerIdentificationID

INT

Computer ID

ComputerName

NVARCHAR(255)

Computer Name

ComputerOU

NVARCHAR(2000)

Computer OU

Manufacturer

NVARCHAR(255)

Manufacturer

Model

NVARCHAR(64)

Computer Model

ComputerType

NVARCHAR(25)

Computer Type

ComputerClass

NVARCHAR(25)

Computer Class

SerialNumber

NVARCHAR(64)

Serial Number

Motherboard

NVARCHAR(64)

Computer Motherboard

MotherboardManufacturer

NVARCHAR(255)

Computer Motherboard Manufacturer

MotherboardName

NVARCHAR(255)

Computer Motherboard Name

MOtherboardSerialNumber

NVARCHAR(255)

Computer Motherboard Serial Number

Memory

NVARCHAR(20)

Amount of Memory

TotalInstalledRamMD

DECIMAL(20,2)

Installed Memory in MB

BIOS

NVARCHAR(255)

System BIOS

BIOSManufacturer

NVARCHAR(255)

System BIOS Manufacturer

BIOSName

NVARCHAR(255)

System BIOS Name

BIOSSerialNumber

NVARCHAR(255)

System BIOS Serial Number

OperatingSystem

NVARCHAR(64)

Installed Operating System

PatchLevel

NVARCHAR(64)

Installed Patch Level

Platform

NVARCHAR(64)

System platform

IsVirtual

NVARCHAR(64)

Virtual machine flag

VirtualEnvironment

NVARCHAR(255)

Virtual environment flag

LastUser

NVARCHAR(255)

Last user to login

FirstDetectedLocal

DATETIME

First scanned (Date)

FirstDetectedUTC

DATETIME

First Scanned Coordinated Universal Time (UTC)

ScanTimeLocal

DATETIME

Scanned since (Date)

ScanTimeUTC

DATETIME

Scanned Since Coordinated Universal Time (UTC)

ItemIdentification

This table is used internally by the data collection system to generate primary key seed values for the hardware inventory sub-tables. For most reports

ItemIdentificationID

INT

ComputerIdentificationID

INT

PID

NVARCHAR(255)

PID2

NVARCHAR(255)

PatchApplication

This table maps a patch file to an application. For example, Microsoft Word 2003 SP3 Office2003SP3-KB923618-FullFile-ENU.exe to Microsoft Word 2003.

PatchApplicationID

INT

Patch Application Id

ComputerIdentificationID

INT

Computer ID

Product

NVARCHAR(255)

Patch Product

SP

NVARCHAR(255)

Patch Service Pack

FirstDetectedLocal

DATETIME

First detected (Date)

FirstDetectedUTC

DATETIME

First detected Coordinated Universal Time (UTC)

LastDetectedLocal

DATETIME

Last detected (Date)

LastDetectedUTC

DATETIME

Last detected Coordinated Universal Time (UTC)

PatchApplication_Item

This table holds the patch item that is being applied. It is related, many-1, to a record in the PatchApplication table. For example, one might be for the spell checker, the other for outlook integration, etc.

ComputerIdentificationID

INT

Computer ID

PatchItemID

INT

Patch Item ID

PatchApplicationID

INT

Patch Application ID

BulletinID

NVARCHAR(20)

Bulletin ID

BulletinTitle

NVARCHAR(255)

Bulletin Title

SQNumber

NVARCHAR(20)

MS KB article ID number

PatchName

NVARCHAR(255)

Patch Name

Severity

NVARCHAR(20)

Patch Severity

SeverityOrdinal

INT

Severity ID

Status

NVARCHAR(100)

Patch Status

FirstDetectedLocal

DATETIME

First detected (Date)

FirstDetectedUTC

DATETIME

First detected Coordinated Universal Time (UTC)

LastDetectedLocal

DATETIME

Last detected (Date)

LastDetectedUTC

DATETIME

Last detected Coordinated Universal Time (UTC)

Related Documents