Understanding the db_ControlManager Tables

To access all tables in the Control Manager database, use a Microsoft Access project (*.adp /*.ade).

Do not use any of the SQL tools to add, delete, or modify records without instructions from Trend Micro Technical Support.

The following tables make up the Control Manager database:

Directory Manager Tables	Description
CDSM_Entity	Stores the managed product information
CDSM_Agent	Stores Communicator information
CDSM_Registry	Stores registry information
CDSM_UserLog	Stores information as to who, which options, and what time a user accesses the management console; this is useful for auditing management console accesses
CDSM_SystemEventlog	Stores system logs generated by internal processes
Server Command Controller Tables	Description
tb_TVCSCommandList	Stores managed product commands
tb_TVCSCommandTaskQueue	Stores commands issued to managed products
tb_CommandTracking	Stores command status
tb_CommandItemTracking	Stores detailed command status
tb_ProcessInfo	Stores MsgReceiver.exe, CmdProcessor.exe, LogReceiver.exe, LogRetriever.exe, and UIProcessor.exe information
tb_LoginUserSessionData	Stores user log on session control
tb_ManualDownload	Stores manual download information
tb_ScheduleDownload	Stores scheduled download information
Managed Product Tables	Description
tb_EntityInfo	Stores the managed product information
tb_VirtualEntity	Stores TVCS1.x agent registration information
Log Tables	Description
tb_TempLog	Stores the raw data of product logs
tb_AV*Log	Stores product log * corresponds to Virus, Event, Status, PEInfo, WebSecurity. These tables stores the product status log as well as the pattern and engine version, update and deploy time, and the unhandled virus count.
tb_InValidLog	Stores unidentified log information
tb_TotalWebSecurityCount tb_TotalVirusCount tb_TotalSecurityCount tb_TopTenSource tb_TopTenDestination tb_TopTenVirus	Stores virus summary information for Status Summary and reports
tb_LogPurgePolicy	Stores purge log settings
tb_LogPurgeCounter	Stores purge log counter
tb_InstanceForVirusOutbreak tb_InstanceForSpecialVirus tb_InstanceForVirusOutbreak	Stores log instanced used in alert notifications
Notification Tables	Description
tb_Alert_NTF_JobList tb_Event_NTF_JobList	Stores notification queue list
tb_EventNotificationFilter	Stores Event Center configuration
tb_SendEMailNotification tb_SendPagerNotification tb_SendSNMPTrapNotification tb_SendWindowsNTEventLogNotification	Stores notification method settings
tb_VirusOutBreakPolicy	Stores rules used during virus outbreak
tb_SpecialVirusPolicy	Stores the user specified virus name
tb_VirusOutbreakAccumulate tb_SpecialVirusAccumulate	Stores virus counter information
tb_UGNtfRelation tb_NtfUserGROUP tb_GroupAndUserRelation	Stores user and group notification settings
Report Tables	Description
tb_ReportScheduleTask tb_ReportTaskQueue	Stores and handles report generation tasks
tb_ReportItemTracking	Stores report template file catalog
Pattern and Engine Deployment Tables	Description
tb_DeploymentPlans tb_DeploymentPlansTF	Stores deployment plan information
tb_DeploymentPlanTasks	Stores deployment task queue
tb_DeployNowJobList	Stores ongoing deployment plan status
tb_DeployCommandTracking	Stores deployment command tracking information
tb_DeploymentPlanTargets	Stores the managed product information that applied the deploy command