Chat now with support
Chat with Support

KACE Desktop Authority 11.3 - Data Dictionary

Contents 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

Contents

Contents

 

Database Schema

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

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