KACE Desktop Authority 11.3

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

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.

Column	Data Type	Description
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

Column	Data Type
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.

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.

Column	Data Type	Description
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)

Please select your product:

To serve you better, please complete the Purpose of your Chat:

Recommended Solutions for Your Problem

KACE Desktop Authority 11.3 - Data Dictionary

HardwareInventory

ItemIdentification

PatchApplication

PatchApplication_Item