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_IPAddress

Hardware_IPAddress

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

Column

Data Type

Description

IPAddressID

INT

IP Address ID

ComputerIdentificationID

INT

Computer ID

MAC

NVARCHAR(64)

MAC Address

Address

NVARCHAR(64)

IP Address

Subnet

NVARCHAR(64)

Subnet Address

DHCP

NVARCHAR(64)

DHCP Installed

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_LogicalDisk

Hardware_LogicalDisk

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

Column

Data Type

Description

LogicalDiskID

INT

Logical Disk ID

ComputerIdentificationID

INT

Computer ID

StorageID

INT

Storage ID

DriveLetter

NVARCHAR(5)

Drive Letter

FileSystem

NVARCHAR(20)

Type of File System

Size

NVARCHAR(20)

Size of Disk

SizeMB

DECIMAL(20,2)

Size of Disk in MB

FreeSpace

NVARCHAR(20)

Free space on Disk

FreeSpaceMB

DECIMAL(20,2)

Free Space on Disk in MB

VolumeName

NVARCHAR(255)

Disk Volume name

VolumeSerialNumber

NVARCHAR(64)

Volume serial number

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_Modem

Hardware_Modem

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

Column

Data Type

Description

ModemID

INT

Modem ID

ComputerIdentificationID

INT

Computer ID

Instance

INT

Modem instance

Manufacturer

NVARCHAR(255)

Modem Manufacturer

Model

NVARCHAR(64)

Modem Model

SerialNumber

NVARCHAR(64)

Modem Serial Number

BIOS

NVARCHAR(64)

Modem BIOS

Driver

NVARCHAR(64)

Modem Driver

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_NIC

Hardware_NIC

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

Column

Data Type

Description

NIC_ID

INT

NIC ID

ComputerIdentificationID

INT

Computer ID

Instance

INT

NIC Instance

NetworkConnectionName

NVARCHAR(255)

NIC Network Connection Name

Manufacturer

NVARCHAR(255)

NIC Manufacturer

Model

NVARCHAR(64)

NIC Model

MAC

NVARCHAR(64)

NIC MAC Address

Driver

NVARCHAR(64)

NIC Driver

BIOS

NVARCHAR(64)

NIC BIOS

AdapterType

NVARCHAR(64)

NIC Adapter type

InterfaceType

NVARCHAR(64)

NIC Interface type

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