立即与支持人员聊天
与支持团队交流

KACE Desktop Authority 11.2 - Data Dictionary

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

Hardware_USB

Hardware_USB

This table holds the data that the Computer Management Data Collection profile object collects with regard to client hardware information (usb ports).

Column

Data Type

Description

USB_ID

INT

USB ID

ComputerIdentificationID

INT

Computer ID

Instance

INT

USB Instance

DeviceType

NVARCHAR(64)

USB Type

DeviceName

NVARCHAR(255)

USB Device

COMPort

NVARCHAR(10)

USB Port

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)

Hardware_VideoCard

Hardware_VideoCard

This table holds the data that the Computer Management Data Collection profile object collects with regard to client hardware information (video cards).

Column

Data Type

Description

VideoCardID

INT

Video Card ID

ComputerIdentificationID

INT

Computer ID

Instance

INT

Video Card Instance

Manufacturer

NVARCHAR(255)

Video Card Manufacturer

ModelNumber

NVARCHAR(64)

Video Card Model

InterfaceType

NVARCHAR(64)

Video Card Interface type

SerialNumber

NVARCHAR(64)

Video Card Serial number

Driver

NVARCHAR(255)

Video Card driver

BIOS

NVARCHAR(64)

Video Card BIOS

Memory

NVARCHAR(20)

Video Card Memory amount

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)

HardwareInventory

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

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)

相关文档

The document was helpful.

选择评级

I easily found the information I needed.

选择评级