Anomalies


Things that might not be 'quite right' about your database and schema

Columns whose name and type imply a relationship to another table's primary key

Child Column Implied Parent Column
agentdeploymentreadinesscheck.[AgentDeploymentReadinessCheckStatusId] reference_agentdeploymentreadinesscheckstatus.[AgentDeploymentReadinessCheckStatusId]
agents.[AgentDefaultGUID] autogeneratedagents.[AgentDefaultGuid]
agents.[ContactID] contactsmultifactorsecurity.[ContactId]
agents.[GUID] workspaces.[GUID]
agents.[Name] plugin_lm_properties.[Name]
agentsversion.[Version] webextensionschemaversion.[Version]
alerttemplate.[GUID] workspaces.[GUID]
alerttemplates.[AlertActionID] alerttemplate.[AlertActionID]
alerttemplates.[ContactID] contactsmultifactorsecurity.[ContactId]
alerttemplates.[GUID] workspaces.[GUID]
antivirustemplatepolicy.[GUID] scripttime.[Guid]
antivirusthreats.[AvThreatId] antivirusthreatlookup.[AvThreatId]
autostartup.[AutoDefID] autostartupdefs.[AutoDefID]
autostartup.[Name] plugin_lm_properties.[Name]
autostartupdefs.[GUID] scripttime.[Guid]
autostartupdefs.[Name] plugin_lm_properties.[Name]
availableapps.[GUID] scripttime.[Guid]
backupdefinitionschedules.[JobTypeID] l_backupjobtype.[JobTypeId]
backupjobs.[DestinationID] backupdestinations.[DestinationID]
backuplogs.[BackupID] backupstatus.[BackupID]
backupstatus.[DestinationID] backupdestinations.[DestinationID]
backupstatus.[GroupJobID] groupbackupjobs.[GroupJobID]
backupstatus.[JobID] backupjobs.[JobID]
backupstatus.[LocationJobID] locationbackupjobs.[LocationJobID]
categoryfunctionmapping.[ScriptFunctionCategoryId] scriptfunctioncategories.[ScriptFunctionCategoryId]
categoryfunctionmapping.[ScriptFunctionId] scriptfunctions.[ScriptFunctionId]
certificatestore.[GUID] igniteguids.[GUID]
commandfolders.[GUID] scripttime.[Guid]
computermenus.[Name] plugin_lm_properties.[Name]
computers.[CommentPriorityId] commentpriority.[CommentPriorityId]
computers.[ContactID] contactsmultifactorsecurity.[ContactId]
contactpwtoken.[ContactID] contactsmultifactorsecurity.[ContactId]
contacts.[ContactID] contactsmultifactorsecurity.[ContactId]
custommenus.[GUID] scripttime.[Guid]
dataviewfolders.[GUID] scripttime.[Guid]
dataviewfolders.[Name] plugin_lm_properties.[Name]
dataviews.[GUID] scripttime.[Guid]
dataviews.[Name] plugin_lm_properties.[Name]
diskcleanup.[GUID] scripttime.[Guid]
eventblacklist.[EventType] labtechlogmessages.[EventType]
eventblacklist.[GUID] scripttime.[Guid]
eventlogs.[EventType] labtechlogmessages.[EventType]
extensionclaimtypes.[WebExtensionId] webextensions.[WebExtensionId]
extrafielddata.[ExtraFieldID] extrafield.[ID]
filelibrary.[GUID] workspaces.[GUID]
filteredhotfixcompliancedata.[HotfixID] hotfixscripts.[HotFixID]
groupagents.[ContactID] contactsmultifactorsecurity.[ContactId]
groupagents.[GUID] scripttime.[Guid]
groupbackupjobs.[DestinationID] backupdestinations.[DestinationID]
groupbackupjobs.[JobID] backupjobs.[JobID]
groupdagents.[ContactID] contactsmultifactorsecurity.[ContactId]
groupdagents.[GUID] workspaces.[GUID]
groupmonitorcontrol.[MonitorID] monitortemplates.[MonitorID]
groupmonitors.[MonitorTemplateID] monitortemplate.[MonitorTemplateID]
groupscripts.[Priority] ticketpriority.[Priority]
h_backupjobs.[JobTypeID] l_backupjobtype.[JobTypeId]
h_backupsolutionlogs.[LogTypeID] l_backuplogtype.[LogTypeId]
h_labtech.[EventType] labtechlogmessages.[EventType]
h_license.[LicenseId] licenseavailability.[LicenseId]
h_pendingscripts.[PendingScriptID] pendingscripts.[PendingScriptID]
h_pendingscripts.[ScheduledID] scheduledscripts.[scheduledID]
h_probecommands.[ProbeId] probeconfig.[ProbeID]
h_probehistory.[ProbeID] probeconfig.[ProbeID]
h_reports.[LTReportID] ltreports.[LTReportID]
h_scripts.[StepID] scriptsteps.[StepID]
hudmain.[GUID] scripttime.[Guid]
hvnetwork.[HVSwitchID] hvswitch.[HVSwitchID]
ignite_propertyinfo.[PropertyTypeId] ignite_propertytypes.[PropertyTypeId]
ind_data.[ConnectionID] ind_connection.[ConnectionID]
installertokens.[InstallerTypeId] installertypes.[InstallerTypeId]
inv_chassis.[ProductName] products.[ProductName]
inv_memoryslots.[FormFactor] cim_formfactor.[FormFactor]
inv_memoryslots.[MemoryType] cim_memorytype.[MemoryType]
inv_probefansensor.[DeviceType] cim_sensortype.[DeviceType]
languagepacks.[GUID] workspaces.[GUID]
licenseavailability.[LicenseType] licensetypelookup.[LicenseType]
licenseusage.[LicenseId] licenseavailability.[LicenseId]
licenseusage.[LicenseType] licensetypelookup.[LicenseType]
localizationresources.[GUID] workspaces.[GUID]
localizations.[GUID] workspaces.[GUID]
locationbackupjobs.[DestinationID] backupdestinations.[DestinationID]
locationbackupjobs.[JobID] backupjobs.[JobID]
locations.[ContactID] contactsmultifactorsecurity.[ContactId]
locations.[DestinationID] backupdestinations.[DestinationID]
locations.[MaintenanceID] maintenancewindow.[MaintenanceID]
locations.[PasswordID] passwords.[PasswordID]
locations.[ProbeID] probeconfig.[ProbeID]
lt_languages.[GUID] scripttime.[Guid]
lt_languages.[Version] webextensionschemaversion.[Version]
lt_servers_oopp.[ProcessID] processes.[ProcessID]
lt_wcc2_sessions.[UserName] userauthenticationlockoutstats.[UserName]
ltreports.[GUID] workspaces.[GUID]
maintenancewindows.[MaintenanceID] maintenancewindow.[MaintenanceID]
mastergroups.[GUID] scripttime.[Guid]
mastergroups.[MaintenanceID] maintenancewindow.[MaintenanceID]
mastergroups.[Priority] ticketpriority.[Priority]
mobileconfigclassexchange.[CertID] certificatestore.[CertId]
mobileconfigclassexchange.[PasswordID] passwords.[PasswordID]
mobiledeviceinfo.[NetworkID] network.[NetworkID]
mobiledevices.[ContactID] contactsmultifactorsecurity.[ContactId]
mobiledevices.[DeviceType] cim_sensortype.[DeviceType]
mobileiosinstalledprofiles.[Version] webextensionschemaversion.[Version]
mobileiosprofilecontent.[ProfileID] mobileiosinstalledprofiles.[ProfileID]
mobileiosprofilecontent.[Version] webextensionschemaversion.[Version]
mobileprocesses.[Priority] ticketpriority.[Priority]
mobileretiredassets.[DeviceType] cim_sensortype.[DeviceType]
monitortemplate.[GUID] scripttime.[Guid]
monitortemplates.[AlertActionID] alerttemplate.[AlertActionID]
monitortemplates.[MonitorTemplateID] monitortemplate.[MonitorTemplateID]
msg_messages.[Name] plugin_lm_properties.[Name]
msg_questions.[MessageID] msg_messages.[MessageID]
msg_questions.[Name] plugin_lm_properties.[Name]
msg_responses.[MessageID] msg_messages.[MessageID]
networkdevices.[ContactID] contactsmultifactorsecurity.[ContactId]
networkdevices.[DeviceType] cim_sensortype.[DeviceType]
outgoingsms.[ContactId] contactsmultifactorsecurity.[ContactId]
patchgrouppolicies.[Priority] ticketpriority.[Priority]
patchjobscripts.[PendingScriptId] pendingscripts.[PendingScriptID]
pendingscripts.[Priority] ticketpriority.[Priority]
pendingscripts.[ScheduledID] scheduledscripts.[scheduledID]
plugin_sap_activityresults.[ActivityID] plugin_sap_activities.[ActivityID]
plugin_sap_failedstandards.[Priority] ticketpriority.[Priority]
plugin_sap_failedstandards.[ProductId] vendorproducts.[ProductId]
plugin_sap_failedstandards.[StandardGuid] plugin_sap_standards.[StandardGuid]
plugin_sap_failedstandards.[VendorId] vendors.[VendorId]
plugin_sap_healthchecks.[CheckCategoryId] plugin_sap_lookupcategories.[CheckCategoryId]
plugin_sap_healthresults.[HealthCheckGuid] plugin_sap_healthchecks.[HealthCheckGuid]
plugin_sap_reportcategoryresults.[CheckCategoryID] plugin_sap_lookupcategories.[CheckCategoryId]
plugin_sap_reportcheckresults.[CheckCategoryID] plugin_sap_lookupcategories.[CheckCategoryId]
plugin_sap_reportcheckresults.[HealthCheckGUID] plugin_sap_healthchecks.[HealthCheckGuid]
plugin_sap_standards.[Priority] ticketpriority.[Priority]
plugin_sap_standards.[ProductId] vendorproducts.[ProductId]
plugin_sap_standards.[VendorId] vendors.[VendorId]
plugin_sap_summarydata.[Name] plugin_lm_properties.[Name]
plugin_screenconnect_connectionevents.[ConnectionID] plugin_screenconnect_connectionaudits.[ConnectionID]
plugin_screenconnect_connectionevents.[EventType] labtechlogmessages.[EventType]
plugin_screenconnect_serverinstallupdates.[StatusId] l_backupjobstatus.[StatusId]
pluginalerts.[ContactId] contactsmultifactorsecurity.[ContactId]
pluginalerts.[DeviceType] cim_sensortype.[DeviceType]
plugins.[GUID] scripttime.[Guid]
plugins.[Name] plugin_lm_properties.[Name]
possibilities.[ProductId] vendorproducts.[ProductId]
printers.[Name] plugin_lm_properties.[Name]
probe_events.[ProbeId] probeconfig.[ProbeID]
probe_receivedsnmptraps.[ProbeId] probeconfig.[ProbeID]
probealerts.[ProbeID] probeconfig.[ProbeID]
probecollectiontemplates.[GUID] workspaces.[GUID]
probecommands.[ProbeId] probeconfig.[ProbeID]
probeconfig.[ContactID] contactsmultifactorsecurity.[ContactId]
probeconfiguration.[StatusScanNetworkPortOptionId] statusscannetworkportoption.[StatusScanNetworkPortOptionId]
probeconfigurationcredentials.[ProbeConfigurationId] probeconfiguration.[ProbeConfigurationId]
probedefaultsetting.[StatusScanNetworkPortOptionId] statusscannetworkportoption.[StatusScanNetworkPortOptionId]
probediscoveryscanstatus.[ProbeId] probeconfig.[ProbeID]
probeexcludedipaddressrange.[ProbeSubnetId] probesubnet.[ProbeSubnetId]
probesnmpconfiguration.[ProbeConfigurationId] probeconfiguration.[ProbeConfigurationId]
probesubnet.[ProbeConfigurationId] probeconfiguration.[ProbeConfigurationId]
processes.[Priority] ticketpriority.[Priority]
productkeys.[LicenseType] licensetypelookup.[LicenseType]
projects.[TicketID] tickets.[TicketID]
quotes.[DocumentID] documents.[DocumentID]
redirectorports.[GUID] scripttime.[Guid]
redirectorports.[RedirectorID] redirectors.[RedirectorID]
redirectors.[GUID] scripttime.[Guid]
redirectors.[Name] plugin_lm_properties.[Name]
reportdeliveries.[LTReportID] ltreports.[LTReportID]
reportdeliveries.[ReportScheduleID] reportschedules.[ReportScheduleID]
reportdeliveries.[ReportScheduleRecipientID] reportschedulerecipients.[ReportScheduleRecipientID]
reportfavorites.[LTReportID] ltreports.[LTReportID]
reportfolders.[GUID] scripttime.[Guid]
reportscheduler.[ContactID] contactsmultifactorsecurity.[ContactId]
reportschedulerecipients.[ReportScheduleID] reportschedules.[ReportScheduleID]
reportschedules.[EmailTemplateID] emailtemplates.[EmailTemplateID]
reporttemplates.[ReportTemplateTypeID] reporttemplatetypes.[ReportTemplateTypeID]
routers.[GUID] scripttime.[Guid]
runningscripts.[PendingScriptID] pendingscripts.[PendingScriptID]
runningscripts.[Priority] ticketpriority.[Priority]
scanfrequencycategories.[ScanFrequencyCategoryId] scanfrequencycategory.[ScanFrequencyCategoryId]
scanfrequencycategories.[ScanFrequencyId] scanfrequency.[ScanFrequencyId]
scheduledscripts.[Priority] ticketpriority.[Priority]
scheduledtasks.[JobID] backupjobs.[JobID]
scriptfolders.[GUID] scripttime.[Guid]
scriptfunctiondynamicparameteroptions.[ScriptFunctionParameterId] scriptfunctionparameters.[ScriptFunctionParameterId]
scriptfunctionparameters.[ScriptFunctionId] scriptfunctions.[ScriptFunctionId]
scriptfunctionparameters.[ScriptFunctionParameterTypeId] scriptfunctionparametertypes.[ScriptFunctionParameterTypeId]
scriptfunctionstaticparameteroptions.[ScriptFunctionParameterId] scriptfunctionparameters.[ScriptFunctionParameterId]
scriptinstancecommands.[CommandID] mobilecommandslookup.[CommandID]
scriptlets.[FunctionID] functions.[FunctionID]
scripts.[GUID] scripttime.[Guid]
scripts.[Name] plugin_lm_properties.[Name]
scripts.[Version] webextensionschemaversion.[Version]
scriptsteps.[FunctionID] functions.[FunctionID]
searches.[ContactID] contactsmultifactorsecurity.[ContactId]
searchfolders.[GUID] scripttime.[Guid]
sensorchecks.[GUID] scripttime.[Guid]
sensorchecks.[Name] plugin_lm_properties.[Name]
snmpauthentication.[HashMethodId] hashmethod.[HashMethodId]
snmpauthentication.[ProbeSnmpConfigurationId] probesnmpconfiguration.[ProbeSnmpConfigurationId]
snmpchecks.[GUID] scripttime.[Guid]
snmpencryption.[EncryptionMethodId] encryptionmethod.[EncryptionMethodId]
snmpencryption.[ProbeSnmpConfigurationId] probesnmpconfiguration.[ProbeSnmpConfigurationId]
snmptraps.[AlertActionID] alerttemplate.[AlertActionID]
syslogtraps.[AlertActionID] alerttemplate.[AlertActionID]
systemworkflowprogress.[WorkflowStatusId] workflowstatus.[WorkflowStatusId]
systemworkflowprogress.[WorkflowStepId] workflowstep.[WorkflowStepId]
systemworkflowprogressmetadata.[SystemWorkflowProgressId] systemworkflowprogress.[SystemWorkflowProgressId]
templates.[GUID] scripttime.[Guid]
tempsearches-2021.09.14.20.57.35.[ContactID] contactsmultifactorsecurity.[ContactId]
ticketdata.[TicketID] tickets.[TicketID]
tickets.[MonitorId] monitortemplates.[MonitorID]
tickets.[Priority] ticketpriority.[Priority]
tickets.[ProjectID] projects.[ProjectID]
timers.[TicketID] tickets.[TicketID]
timeslips.[ProjectID] projects.[ProjectID]
timeslips.[TicketID] tickets.[TicketID]
userclassassignedextensionclaims.[ExtensionClaimTypeId] extensionclaimtypes.[ExtensionClaimTypeId]
vendorproducts.[VendorId] vendors.[VendorId]
virusscanners.[GUID] scripttime.[Guid]
webdashboards.[Name] plugin_lm_properties.[Name]
webextensionareacontroltypes.[WebExtensionAreaId] webextensionareas.[WebExtensionAreaId]
webextensionareacontroltypes.[WebExtensionControlTypeId] webextensioncontroltypes.[WebExtensionControlTypeId]
webextensionareas.[WebExtensionScreenId] webextensionscreens.[WebExtensionScreenId]
webextensionbuttons.[WebExtensionButtonTypeId] webextensionbuttontypes.[WebExtensionButtonTypeId]
webextensionbuttons.[WebExtensionClickActionId] webextensionclickactions.[WebExtensionClickActionId]
webextensionbuttons.[WebExtensionControlId] webextensioncontrols.[WebExtensionControlId]
webextensionclickactions.[WebExtensionUrlOpenTypeId] webextensionurlopentypes.[WebExtensionUrlOpenTypeId]
webextensioncontrolareas.[WebExtensionAreaControlTypeId] webextensionareacontroltypes.[WebExtensionAreaControlTypeId]
webextensioncontrolareas.[WebExtensionControlId] webextensioncontrols.[WebExtensionControlId]
webextensioncontrols.[ExtensionClaimTypeId] extensionclaimtypes.[ExtensionClaimTypeId]
webextensioncontrols.[WebExtensionId] webextensions.[WebExtensionId]
webextensionhelpercommands.[WebExtensionGuid] webextensionusers.[WebExtensionGuid]
webextensioninlineframes.[WebExtensionControlId] webextensioncontrols.[WebExtensionControlId]
webextensionmenuitems.[WebExtensionControlId] webextensioncontrols.[WebExtensionControlId]
webextensionredirects.[WebExtensionControlId] webextensioncontrols.[WebExtensionControlId]
webextensions.[ExtensionSolutionId] extensionsolutions.[ExtensionSolutionId]
webextensions.[ExtensionStatusId] extensionstatuses.[ExtensionStatusId]
webextensions.[WebExtensionGuid] webextensionusers.[WebExtensionGuid]
webextensiontiles.[WebExtensionControlId] webextensioncontrols.[WebExtensionControlId]
workflowstep.[ApplicationWorkflowId] applicationworkflow.[ApplicationWorkflowId]

Tables without indexes

Table Rows
agentconfig 1
configbackup 1
contactpwtoken 0
controlcenterconfig 1
h_probeinternal_systeminfo 0
lt_patchinformation 1
managementreport 1
managementscore 1
plugin_databasetuner_general 1
plugin_databasetunerlite_general 1
signupdata 0
util_ints 10

Tables that contain a single column

Table Column
agentconfig
asp_connectionpool
errmsgs
serverfiles
util_ints

Tables with incrementing column names, potentially indicating denormalization

Table
agentcommands
clients
computerconfig
config
contacts
controlcenterconfig
h_extrastats
h_extrastatsdaily
h_extrastatsmonthly
h_extrastatsweekly
h_extrastatsyearly
h_labtech
hudmain
huduser
hvnetwork
hvswitch
locations
managementreport
mobiledeviceinfo
msg_responses
plugincalls
probecollectionrules
probedetectionrules
reports
retiredcomputerconfig
scriptlets
scriptsteps
templates
timecategory
v_extradatacomputers

Columns whose default value is the word 'NULL' or 'null'

Table
Anomaly not detected