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

Database Schema

 

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

For readability and ease of use, the DA Reporting Database Schema shown on the following pages is broken up into logical groupings, User Management Profile Data, Computer Management Profile Data, Hardware/Software Inventory, User/Computer Activity Data, Anti-malware and Anti-spyware.

The grouping of tables that make up the User Management Profile Data consists of all profile and configuration element data for User Management profile objects configured in the Manager.

The grouping of tables that make up the Computer Management Profile Data consists of all profile and configuration element data for Computer Management profile objects configured in the Manager.

The Hardware/Software Inventory grouping consists of data that is collected from and about hardware and software clients that log on to the network.

The grouping of tables that make up the User/Computer Activity Data consists of data collected as users/computers log on and off the network. This set makes up the data needed for User Activity reporting.

The Profile data is periodically updated from the DACONFIGURATION database to the DAREPORTING database. The period in which the database is updated is configured in the ETLProcessor plugin. This is found on the OpsMaster Service tab of Server Manager.

When viewing the following diagrams, zoom in for a more precise view. A full printable version of the diagrams can be downloaded from the Quest web site.

•
User Management Profile Data
•
Computer Management Profile Data
•
Hardware/Software Inventory Data
•
User/Computer Activity Data

User Management Profile Data

User Management Profile Data

UserMangement

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.

Computer Management Profile Data

Computer Management Profile Data

ComputerManagement
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.

Hardware/Software Inventory Data

Hardware/Software Inventory Data

HardwareSoftwareInv
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.
Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
RSS Feed
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating