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

User/Computer Activity Data

User/Computer Activity Data

UserComputerActivity
NOTE: When viewing this diagram, zoom in for a more precise view. A full printable version of this diagram can be downloaded from the Quest web site.

ComputerIdentification

ComputerIdentification

This table identifies computers that Desktop Authority is installed on. The identification is made up of a GUID and Domain name and Machine name.

Column

Data Type

Description

ComputerIdentificationID

INT

Computer Identification ID

ComputerIdentification1

NVARCHAR(255)

Makes up part of the unique Computer ID

ComputerIdentification2

NVARCHAR(255)

Makes up part of the unique Computer ID

ComputerIdentification3

NVARCHAR(255)

Makes up part of the unique Computer ID

ComputerIdentification4

NVARCHAR(255)

Makes up part of the unique Computer ID

ComputerIdentification5

NVARCHAR(255)

Makes up part of the unique Computer ID

ComputerSession

ComputerSession

This table is used with data collection. The startup and shutdown activity is stored in this file.

Column

Data Type

Description

ComputerSessionID

INT

Computer Session ID

ComputerIdentificationID

INT

Computer ID

SessionEvent

NVARCHAR(64)

Type of computer event

ActivityTimeLocal

DATETIME

Time of computer event

ActivityTimeUTC

DATETIME

Time of computer event Coordinated Universal Time (UTC)

DAConfigurationAuditLog

DAConfigurationAuditLog

This is a copy of the Audits table from DAConfiguration. Activity performed by an admin thru DA is recorded here. This includes profile or element adds, updates and deletes.

Column

Data Type

Description

RBAAuditID

INT

Audit Entry ID

AuditName

NVARCHAR(255)

Audit Type

Operation

NVARCHAR(50)

Operation

ProfileID

INT

Profile ID

ProfileName

NVARCHAR(255)

Profile Name

RoleID

INT

Role ID

RoleName

NVARCHAR(255)

Role Name

ProfileElementID

INT

Profile Element ID

ProfileElementDescription

NVARCHAR(255)

Profile Element Description

ObjectName

NVARCHAR(100)

Object Name

SystemUserSID

NVARCHAR(100)

System User SID

SystemUserOrGroupName

NVARCHAR(255)

System User Group

AdministratorSID

NVARCHAR(100)

Admin SID

AdministratorName

NVARCHAR(255)

Admin Name

AdministratorDomain

NVARCHAR(255)

Admin Domain

ComputerName

NVARCHAR(255)

Computer Name

Description

NVARCHAR(255)

Description of action

LogTime

DATETIME

Date/Time of action

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating