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

SoftwareInventory

SoftwareInventory

This table is related to the parent HardwareInventory table, many to 1, for each software title found in Install/Uninstall programs of a machine’s registry. A Computer Management Data Collection element must be configured to capture this.

Column

Data Type

Description

SoftwareID

INT

Software Application ID

ComputerIdentificationID

INT

Computer ID

Publisher

NVARCHAR(255)

Software Publisher

DisplayName

NVARCHAR(255)

Software Name

DisplayVersion

NVARCHAR(255)

Software Version

InstallDate

NVARCHAR(255)

Install Date

InstallLocation

NVARCHAR(500)

Install Location

InstallSource

NVARCHAR(500)

Install Source

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)

UserSession

UserSession

This table holds the data collected for User activity Logon and Log off. A User Management Data Collection element must be configured to capture this data.

Column

Data Type

Description

SessionID

INT

Unique Session ID

ComputerIdentificationID

INT

Computer ID

ComputerSessionID

INT

Computer Session ID

UserDomain

NVARCHAR(255)

User Domain

UserID

NVARCHAR(255)

User ID

UserSID

NVARCHAR(64)

User SID

ComputerDomain

NVARCHAR(255)

Computer Domain

ComputerName

NVARCHAR(255)

Computer Name

ConnectionType

NVARCHAR(64)

Connection Type

AuthenticatingServer

NVARCHAR(64)

Authenticating Server

LocalPrivilege

NVARCHAR(64)

Local Privileges

DomainPrivilege

NVARCHAR(64)

Domain Privileges

UTCOffset

INT

Coordinated Universal Time (UTC) offset

SessionStartTimeLocal

DATETIME

Session Start Time

SessionStartTimeUTC

DATETIME

Session Start Time Coordinated Universal Time (UTC)

UserSessionActivity

UserSessionActivity

This table holds User activity session data. A session starts at logon, then all locks, unlocks of the workstation get recorded here until the machine is logged off of or restarted. Then a new Usersession record will be created from this data. A User Management Data Collection element must be configured to capture this data.

Column

Data Type

Description

SessionActivityID

INT

Session Activity ID

ComputerIdentificationID

INT

Computer ID

SessionID

INT

Session ID

SessionEvent

NVARCHAR(64)

Session Event

UTCOffset

INT

Coordinated Universal Time (UTC) offset

ActivityTimeLocal

DATETIME

Activity Time

ActivityTimeUTC

DATETIME

Activity Time Coordinated Universal Time (UTC)

About us

About us

Quest creates software solutions that make the benefits of new technology real in an increasingly complex IT landscape. From database and systems management, to Active Directory and Office 365 management, and cyber security resilience, Quest helps customers solve their next IT challenge now. Around the globe, more than 130,000 companies and 95% of the Fortune 500 count on Quest to deliver proactive management and monitoring for the next enterprise initiative, find the next solution for complex Microsoft challenges and stay ahead of the next threat. Quest Software. Where next meets now. For more information, visit www.quest.com.

Technical support resources

Technical support is available to Quest customers with a valid maintenance contract and customers who have trial versions. You can access the Quest Support Portal at https://support.quest.com.

The Support Portal provides self-help tools you can use to solve problems quickly and independently, 24 hours a day, 365 days a year. The Support Portal enables you to:

•
Submit and manage a Service Request
•
View Knowledge Base articles
•
Sign up for product notifications
•
Download software and technical documentation
•
View how-to-videos
•
Engage in community discussions
•
Chat with support engineers online
•
View services to assist you with your product.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating