Chat now with support
Chat with Support

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_Printer

Hardware_Printer

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

Column

Data Type

Description

PrinterID

INT

Printer ID

ComputerIdentificationID

INT

Computer ID

Instance

INT

Printer Instance

Manufacturer

NVARCHAR(255)

Printer Manufacturer

Model

NVARCHAR(64)

Printer Model

Driver

NVARCHAR(255)

Printer Driver

PortName

NVARCHAR(64)

Porter Port name

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_Processor

Hardware_Processor

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

Column

Data Type

Description

ProcessorID

INT

Processor ID

ComputerIdentificationID

INT

Computer ID

Instance

INT

Processor Instance

Manufacturer

NVARCHAR(255)

Processor Manufacturer

Name

NVARCHAR(255)

Processor Name

ClockSpeed

NVARCHAR(20)

Processor Clock Speed

FrontSideBusSpeed

NVARCHAR(20)

Processor Front Bus Speed

Version

NVARCHAR(64)

Processor version

L1CacheSize

NVARCHAR(20)

L1 Cache size

L2CacheSize

NVARCHAR(20)

L2 Cache size

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_SIMM

Hardware_SIMM

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

Column

Data Type

Description

SIMM_ID

INT

SIMM ID

ComputerIdentificationID

INT

Computer ID

Instance

INT

SIMM Instance

RAMSize

NVARCHAR(20)

Ram Size

RAMSizeMB

DECIMAL(20,2)

Ram size in MB

BankSlot

NVARCHAR(20)

Bank Slot used

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_Storage

Hardware_Storage

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

Column

Data Type

Description

StorageID

INT

Storage ID

ComputerIdentificationID

INT

Computer ID

Instance

INT

Storage Instance ID

DeviceType

NVARCHAR(50)

Device Type

InterfaceType

NVARCHAR(50)

Interface Type

InterfaceChannel

NVARCHAR(10)

Interface Channel

Manufacturer

NVARCHAR(255)

Storage Manufacturer

Model

NVARCHAR(64)

Storage Model

SerialNumber

NVARCHAR(64)

Storage Serial Number

BIOS

NVARCHAR(64)

Storage BIOS

StorageFree

NVARCHAR(20)

Disk Space Free

StorageFreeMB

DECIMAL(20,2)

Disk Space Free in MB

StorageUsed

NVARCHAR(20)

Disk Space Used

StorageUsedMB

DECIMAL(20,2)

Disk Spage Used in MB

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

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating