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

DataImportConfiguration

DataImportConfiguration

This table holds configuration and the current catalog name for the AntiMalware importer. It is updated when a new Anti-malware catalog is downloaded.

Column

Data Type

Description

CurrentAntiMalwarePackage

NVARCHAR(100)

Anti-malware package version

LastModifiedDate

DATETIME

Date/Time of action

DomainUsers

DomainUsers

This table contains a list of users that launch the manager and is used for Admin Activity reporting.

Column

Data Type

Description

UserSID

NVARCHAR(100)

System User SID

UserName

NVARCHAR(255)

System User Name

Domain

NVARCHAR(255)

Domain Name

MachineName

NVARCHAR(255)

Computer Name

LastAccessedDate

DATETIME

Date Last Accessed

LastModifiedDate

DATETIME

Date Last Modified

Hardware_Display

Hardware_Display

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

Column

Data Type

Description

DisplayID

INT

Display ID

ComputerIdentificationID

INT

Computer ID

Instance

INT

Display Instance

Manufacturer

NVARCHAR(255)

Display Manufacturer

InterfaceType

NVARCHAR(64)

Display Interface

Type

NVARCHAR(64)

Display Type

SerialNumber

NVARCHAR(64)

Serial Number

YearManufactured

NVARCHAR(10)

Year Manufactured

MaxResolution

NVARCHAR(10)

Maximum Resolution

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_Inventory

Hardware_Inventory

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

Column

Data Type

Description

ComputerIdentificationID

INT

Computer ID

ComputerName

NVARCHAR(255)

Computer Name

ComputerOU

NVARCHAR(2000)

Computer OU

Manufacturer

NVARCHAR(255)

Computer Manufacturer

Model

NVARCHAR(64)

Computer Model

ComputerType

NVARCHAR(25)

Computer Type

ComputerClass

NVARCHAR(25)

Class of Computer

SerialNumber

VNARCHAR(64)

Computer Serial Number

Motherboard

NVARCHAR(64)

Type of Motherboard

MotherboardManufacturer

NVARCHAR(255)

Motherboard Manufacturer

MotherboardName

NVARCHAR(255)

Motherboard Name

MotherboardSerialNumber

NVARCHAR(255)

Motherboard Serial Number

Memory

NVARCHAR(20)

Amount of Memory

BIOS

NVARCHAR(255)

Type of BIOS

BIOSManufacturer

NVARCHAR(255)

BIOS Manufacturer

BIOSName

NVARCHAR(255)

BIOS Name

BIOSSerialNumber

NVARCHAR(255)

BIOS Serial Number

OperatingSystem

NVARCHAR(64)

Installed Operating System

PatchLevel

NVARCHAR(64)

Patch Level of OS

Platform

NVARCHAR(64)

32/64 bit OS

IsVirtual

NVARCHAR(64)

Is Virtual Machine

LastUser

NVARCHAR(255)

Last User on Machine

VirtualEnvironment

NVARCHAR(255)

Virtual Environment Type

FirstDetectedLocal

DATETIME

First detected (Date)

FirstDetectedUTC

DATETIME

First detected Coordinated Universal Time (UTC)

ScanTimeLocal

DATETIME

Scan Time

ScanTimeUTC

DATETIME

Scan Time Coordinated Universal Time (UTC)

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating