class TbInstanceForVirusOutbreak(Base):
__tablename__ = 'tb_InstanceForVirusOutbreak'
CLF_EntityID = Column(CHAR(36), primary_key=True, nullable=False)
CLF_ProductType = Column(INTEGER, nullable=False)
VLF_VirusName = Column(VARCHAR(64))
IFVO_TotalInstances = Column(INTEGER, nullable=False)
IFVO_FoundTime = Column(DATETIME)
IFVO_YEAR = Column(INTEGER, nullable=False)
IFVO_MONTH = Column(INTEGER, nullable=False)
IFVO_DAY = Column(INTEGER, nullable=False)
class ENtbOfficeScan(Base):
__tablename__ = 'EN_tb_OfficeScan'
RID = Column(CHAR(36), primary_key=True, nullable=False)
CLF_LogGenerationTime = Column(DATETIME)
SLF_LogGenerationTimeZone = Column(INTEGER)
SLF_IsDayLightSaving = Column(INTEGER)
CLF_LogReceivedTime = Column(DATETIME)
CLF_LogReceivedTimeZone = Column(INTEGER)
EntityID = Column(CHAR(36), nullable=False)
HostName = Column(NVARCHAR(64))
OSName = Column(NVARCHAR(64))
IPAddress = Column(VARCHAR(256))
GroupName = Column(NVARCHAR(64))
PatternNumber = Column(VARCHAR(19))
InternalPatternNumber = Column(VARCHAR(19))
EngineVersion = Column(VARCHAR(19))
EngineType = Column(INTEGER)
ProgramVersion = Column(VARCHAR(19))
Status = Column(INTEGER)
class TbPersonalFirewallLog(Base):
__tablename__ = 'tb_PersonalFirewallLog'
id = Column(INTEGER, primary_key=True, nullable=False)
MsgLogID = Column(CHAR(36), nullable=False)
MsgLogType = Column(INTEGER)
ProductGUID = Column(CHAR(36))
ClientGUID = Column(CHAR(36))
ProductID = Column(INTEGER)
LogVersion = Column(INTEGER)
LogMinorVersion = Column(INTEGER)
ComputerName = Column(NVARCHAR(128))
LogGenUTCDatetime = Column(DATETIME)
LogGenLocalDatetime = Column(DATETIME)
TimeZoneInMins = Column(INTEGER)
DaylightSavingInMins = Column(INTEGER)
RedAlertID = Column(CHAR(36))
Direction = Column(INTEGER)
Protocol = Column(INTEGER)
SourceIP = Column(VARCHAR(256))
SourcePort = Column(INTEGER)
DestinationIP = Column(VARCHAR(256))
DestinationPort = Column(INTEGER)
EventType = Column(INTEGER)
SubType = Column(INTEGER)
RiskLevel = Column(INTEGER)
PolicyName = Column(NVARCHAR(256))
RuleID = Column(NVARCHAR(256))
Description = Column(NVARCHAR(1024))
ProcessName = Column(NVARCHAR(256))
ApplicationName = Column(NVARCHAR(256))
VirusName = Column(NVARCHAR(256))
ActionResult = Column(INTEGER)
LogReceivedTime = Column(DATETIME)
LogReceivedUTCTime = Column(DATETIME)
AggregatedUTCDatetime = Column(DATETIME)
AggregatedLocalDatetime = Column(DATETIME)
AggregatedCount = Column(INTEGER)
SLF_Is_CCCA_Detection = Column(INTEGER)
SLF_CCCA_DetectionSource = Column(INTEGER)
SLF_CCCA_RiskLevel = Column(INTEGER)
SLF_HostName = Column(VARCHAR(128))
CE_FilterID = Column(VARCHAR(35))
CLF_LogGenCMLocalTime = Column(DATETIME)
class TbTopTenVirus(Base):
__tablename__ = 'tb_TopTenVirus'
CLF_EntityID = Column(CHAR(36), primary_key=True, nullable=False)
CLF_ProductType = Column(INTEGER, nullable=False)
VLF_VirusName = Column(VARCHAR(64))
TTV_Total = Column(INTEGER, nullable=False)
TTV_SummaryTime = Column(DATETIME)
TTV_YEAR = Column(INTEGER, nullable=False)
TTV_MONTH = Column(INTEGER, nullable=False)
TTV_DAY = Column(INTEGER, nullable=False)
class TbsCloudPolicyTask(Base):
__tablename__ = 'tb_sCloudPolicyTask'
id = Column(INTEGER, primary_key=True, nullable=False)
PolicyTaskID = Column(UNIQUEIDENTIFIER, nullable=False)
PolicyID = Column(UNIQUEIDENTIFIER, nullable=False)
Context = Column(VARCHAR(1024))
CreationTime = Column(DATETIME, nullable=False)
LastUpdateTime = Column(DATETIME, nullable=False)
Result = Column(INTEGER, nullable=False)
ResultDescription = Column(NVARCHAR(2048))
class Tbstatuslogjournalengine(Base):
__tablename__ = 'tb_statuslogjournalengine'
id = Column(BIGINT, primary_key=True, nullable=False)
SLF_ProductGUID = Column(CHAR(36))
SLF_DaylightSavingInMins = Column(INTEGER)
SLF_Name = Column(INTEGER)
SLF_Version = Column(VARCHAR(19))
SLF_LastUpdateTime = Column(DATETIME)
SLF_IsInUse = Column(SMALLINT)
lutontmcm = Column(DATETIME)
class TbEntityIPAddress(Base):
__tablename__ = 'tb_EntityIPAddress'
EntityID = Column(CHAR(36), primary_key=True, nullable=False)
IPAddress = Column(VARCHAR(256), primary_key=True)
FirstOctet = Column(TINYINT)
SecondOctet = Column(TINYINT)
ThirdOctet = Column(TINYINT)
FourthOctet = Column(TINYINT)
IPv4INT = Column(BIGINT)
IPv6Bin = Column(BINARY(16))
class TbManualScanJobList(Base):
__tablename__ = 'tb_ManualScanJobList'
MS_JobID = Column(CHAR(36), primary_key=True, nullable=False)
MS_RcvDateTime = Column(DATETIME(32))
MS_EntityID = Column(CHAR(36))
MS_DstType = Column(INTEGER)
MS_WaitTime = Column(INTEGER)
MS_Status = Column(INTEGER)
MS_Token = Column(VARCHAR(255), nullable=False)
MS_ScanType = Column(INTEGER, nullable=False)
class TbEventNotificationFilter(Base):
__tablename__ = 'tb_EventNotificationFilter'
USER_ID = Column(VARCHAR(38), primary_key=True)
GROUP_ID = Column(VARCHAR(38))
Event_ID = Column(VARCHAR(64))
Enabled = Column(BIT)
Category = Column(VARCHAR(32))
FuncFilename = Column(VARCHAR(128))
EditFilename = Column(VARCHAR(128))
ComponentID = Column(VARCHAR(64))
Site = Column(VARCHAR(64))
Result = Column(INTEGER)
class TbBlacklistRESTRegisterProductList(Base):
__tablename__ = 'tb_BlacklistRESTRegisterProductList'
id = Column(BIGINT, primary_key=True, nullable=False)
EntityID = Column(CHAR(36), nullable=False)
ProductName = Column(NVARCHAR(256), nullable=False)
HostName = Column(NVARCHAR(256), nullable=False)
lutontmcm = Column(DATETIME, nullable=False)
LatestQueryID = Column(INTEGER)
LatestQueryUTCTime = Column(DATETIME)
SourceID = Column(VARCHAR(16))
class TbstatuslogjournalPLS(Base):
__tablename__ = 'tb_statuslogjournalPLS'
id = Column(BIGINT, primary_key=True, nullable=False)
SLF_ProductGUID = Column(CHAR(36))
SLF_ProductID = Column(INTEGER)
SLF_PropertyID = Column(INTEGER)
SLF_PluginServiceID = Column(INTEGER)
SLF_Version = Column(VARCHAR(19))
SLF_Status = Column(INTEGER)
SLF_LastUpdateTime = Column(DATETIME)
SLF_LastCompliantState = Column(BIGINT)
class TbDDM3rdPartyTagging(Base):
__tablename__ = 'tb_DDM_3rdPartyTagging'
SID = Column(BIGINT, primary_key=True, nullable=False)
Category = Column(SMALLINT, primary_key=True, nullable=False)
InterestedHost = Column(NVARCHAR(64))
HostOwner = Column(NVARCHAR(64))
Department = Column(NVARCHAR(64))
Service = Column(NVARCHAR(64))
DeviceType = Column(NVARCHAR(128))
MACAddress = Column(NVARCHAR(17))
ReverseDNS = Column(NVARCHAR(2048))
Destination = Column(NVARCHAR(128))
Registrar = Column(VARCHAR(128))
Registrant = Column(VARCHAR(128))
CreatedDate = Column(DATETIME)
OverallScore = Column(SMALLINT)
IPRating = Column(SMALLINT)
URLRating = Column(SMALLINT)
FileRating = Column(SMALLINT)
MailRating = Column(SMALLINT)
class TbFirstSuccessInstance(Base):
__tablename__ = 'tb_FirstSuccessInstance'
FSI_EntityID = Column(CHAR(36), primary_key=True)
FSI_ProductType = Column(INTEGER)
FSI_VirusName = Column(VARCHAR(64))
FSI_InfectionDestination = Column(NVARCHAR(254))
FSI_TotalInstances = Column(INTEGER)
FSI_FoundTime = Column(DATETIME)
FSI_YEAR = Column(INTEGER)
FSI_MONTH = Column(INTEGER)
FSI_DAY = Column(INTEGER)
class TbInstanceForVirusInfecDest(Base):
__tablename__ = 'tb_InstanceForVirusInfecDest'
CLF_EntityID = Column(CHAR(36), primary_key=True, nullable=False)
CLF_ProductType = Column(INTEGER, nullable=False)
VLF_VirusName = Column(VARCHAR(64))
VLF_InfectionDestination = Column(NVARCHAR(254))
IFVID_TotalInstances = Column(INTEGER, nullable=False)
IFVID_FoundTime = Column(DATETIME)
IFVID_YEAR = Column(INTEGER, nullable=False)
IFVID_MONTH = Column(INTEGER, nullable=False)
IFVID_DAY = Column(INTEGER, nullable=False)
class TbstatuslogjournalServiceLicense(Base):
__tablename__ = 'tb_statuslogjournalServiceLicense'
id = Column(BIGINT, primary_key=True, nullable=False)
SLF_ProductGUID = Column(CHAR(36), nullable=False)
SLF_SlotID = Column(INTEGER, nullable=False)
SLF_Status = Column(INTEGER, nullable=False)
SLF_ACKey = Column(VARCHAR(31), nullable=False)
SLF_ExpirationDate = Column(DATETIME, nullable=False)
SLF_SeatCount = Column(INTEGER, nullable=False)
SLF_Description = Column(NVARCHAR(1024))
lutontmcm = Column(DATETIME)
class TbOPSSummary(Base):
__tablename__ = 'tb_OPSSummary'
VLF_VirusName = Column(VARCHAR(64), primary_key=True)
VLF_GenerationTime = Column(DATETIME)
VLF_VirusLogType = Column(INTEGER)
VLF_Year = Column(INTEGER, nullable=False)
VLF_Month = Column(INTEGER, nullable=False)
VLF_Day = Column(INTEGER, nullable=False)
VLF_Hour = Column(INTEGER, nullable=False)
OPS_Count = Column(INTEGER, nullable=False)
RA_ID = Column(CHAR(36))
class TbScheduleTask(Base):
__tablename__ = 'tb_ScheduleTask'
id = Column(INTEGER, primary_key=True, nullable=False)
ScheduleName = Column(VARCHAR(1024))
ScheduleID = Column(UNIQUEIDENTIFIER, nullable=False)
Parameters = Column(NVARCHAR)
Context = Column(NVARCHAR)
FrequencyType = Column(SMALLINT, nullable=False)
FrequencyRange = Column(INTEGER, nullable=False)
RetryTimes = Column(INTEGER, nullable=False)
Target = Column(VARCHAR(1024))
Enable = Column(SMALLINT, nullable=False)
LastUpdateUTCTime = Column(DATETIME)
SpecificTime = Column(VARCHAR(32))
@classmethod
def update_schedule_time(cls, target, freq):
cm_session.query(cls).filter(cls.Target == target).update(
{cls.FrequencyRange: freq})
cm_session.commit()
class TbApplicationControlApplicationInventory(Base):
__tablename__ = 'tb_ApplicationControlApplicationInventory'
SLF_ProductID = Column(INTEGER, nullable=False)
SLF_CreateUTCDatetime = Column(DATETIME, nullable=False)
SLF_ApplicationFileHash = Column(VARCHAR(40),
primary_key=True,
nullable=False)
SLF_ApplicationFileType = Column(INTEGER)
SLF_ApplicationDisplayName = Column(NVARCHAR(256))
SLF_ApplicationOriginalFileName = Column(NVARCHAR(256))
SLF_ApplicationFileVersion = Column(NVARCHAR(128))
SLF_ApplicationFileSize = Column(BIGINT)
SLF_ApplicationFileDescription = Column(NVARCHAR(256))
SLF_ApplicationFileProductVersion = Column(NVARCHAR(128))
SLF_ApplicationFileProductName = Column(NVARCHAR(256))
SLF_ApplicationFileCopyright = Column(NVARCHAR(256))
SLF_ApplicationFileLanguage = Column(NVARCHAR(32))
SLF_ApplicationRequestedPriviledges = Column(VARCHAR(256))
SLF_ApplicationFileSignatureIssuer = Column(NVARCHAR(1024))
SLF_ApplicationFileSignatureSubject = Column(NVARCHAR(1024))
class TbInstanceForSpecialVirus(Base):
__tablename__ = 'tb_InstanceForSpecialVirus'
CLF_EntityID = Column(CHAR(36), primary_key=True, nullable=False)
CLF_ProductType = Column(INTEGER, nullable=False)
VLF_VirusName = Column(VARCHAR(64))
VLF_InfectionDestination = Column(NVARCHAR(254))
VIFSV_FoundTime = Column(DATETIME)
VIFSV_IsFirst = Column(BIT)
VIFSV_YEAR = Column(INTEGER, nullable=False)
VIFSV_MONTH = Column(INTEGER, nullable=False)
VIFSV_DAY = Column(INTEGER, nullable=False)
class TbCmdJobList(Base):
__tablename__ = 'tb_CmdJobList'
id = Column(INTEGER, primary_key=True, nullable=False)
JobID = Column(CHAR(36), nullable=False)
CmdType = Column(INTEGER, nullable=False)
UserID = Column(CHAR(36), nullable=False)
ParamJSON = Column(NVARCHAR)
ResultTbName = Column(VARCHAR(512))
Status = Column(INTEGER)
Progress = Column(INTEGER)
LastAccessTme = Column(DATETIME)
class TbsCloudPolicyJournal(Base):
__tablename__ = 'tb_sCloudPolicyJournal'
PolicyID = Column(UNIQUEIDENTIFIER, primary_key=True, nullable=False)
UTCDurationStart = Column(DATETIME, nullable=False)
UTCDurationEnd = Column(DATETIME)
DisplayName = Column(NVARCHAR(256))
PolicyType = Column(VARCHAR(32), nullable=False)
ProductType = Column(INTEGER, nullable=False)
Settings = Column(NVARCHAR, nullable=False)
ActivatedSettings = Column(NVARCHAR, nullable=False)
JournalDetailGUID = Column(UNIQUEIDENTIFIER)
class TbLogBehaviorMonitor(Base):
__tablename__ = 'tb_LogBehaviorMonitor'
id = Column(INTEGER, primary_key=True, nullable=False)
MsgLogGUID = Column(UNIQUEIDENTIFIER)
CMGuid = Column(CHAR(36))
ProductGUID = Column(CHAR(36), nullable=False)
LogMinorVersion = Column(SMALLINT)
LogVersion = Column(SMALLINT)
MsgType = Column(INTEGER, nullable=False)
ComputerName = Column(NVARCHAR(128))
DaylightSavingInMins = Column(INTEGER)
TimeZoneInMins = Column(SMALLINT)
CLF_LogReceivedTime = Column(DATETIME)
Endpoint = Column(NVARCHAR(128))
EndpointIP = Column(VARCHAR(256))
LogReferenceID = Column(INTEGER)
ClientGuid = Column(CHAR(36))
CE_FilterID = Column(VARCHAR(35))
SLF_Channel = Column(INTEGER)
SLF_CloudStorage = Column(INTEGER)
class TbDCSJob(Base):
__tablename__ = 'tb_DCSJob'
JobID = Column(INTEGER, primary_key=True, nullable=False)
TaskID = Column(INTEGER, nullable=False)
TaskName = Column(NVARCHAR(64))
StartTime = Column(DATETIME)
EndTime = Column(DATETIME)
IssuedBy = Column(NVARCHAR(32))
MA_MachineList = Column(IMAGE, nullable=False)
UnsupportMachineList = Column(IMAGE)
DamageCleanupEngine = Column(VARCHAR(19))
DamageCleanupPattern = Column(VARCHAR(19))
Properties = Column(INTEGER)
DeployMissed = Column(INTEGER)
DamageMachines = Column(INTEGER)
DamageFree = Column(INTEGER)
CleanMissed = Column(INTEGER)
InProgress = Column(INTEGER)
UnsupportMachines = Column(INTEGER)
Total = Column(INTEGER)
class TbTotalSecurityLogByAttachmentType(Base):
__tablename__ = 'tb_TotalSecurityLogByAttachmentType'
id = Column(BIGINT, primary_key=True, nullable=False)
EntityID = Column(CHAR(36), nullable=False)
AttachType = Column(VARCHAR(80))
HighSeverity = Column(INTEGER, nullable=False)
MediumSeverity = Column(INTEGER, nullable=False)
LowSeverity = Column(INTEGER, nullable=False)
TotalCount = Column(INTEGER, nullable=False)
LastDetectionTime = Column(DATETIME)
TSC_SummaryTime = Column(DATETIME)
class TbSecondFailureAccumulate(Base):
__tablename__ = 'tb_SecondFailureAccumulate'
SFA_VirusName = Column(VARCHAR(64), primary_key=True)
SFA_TotalForInstances = Column(INTEGER)
SFA_TotalForDestinations = Column(INTEGER)
SFA_RecordTime = Column(DATETIME)
SFA_StartOfperiod = Column(DATETIME)
SFA_EndOfperiod = Column(DATETIME)
SFA_YEAR = Column(INTEGER)
SFA_MONTH = Column(INTEGER)
SFA_DAY = Column(INTEGER)
class TbReportTaskQueue(Base):
__tablename__ = 'tb_ReportTaskQueue'
RPT_ID = Column(CHAR(36), primary_key=True)
RPT_GenDate = Column(DATETIME)
RPT_IssueUser = Column(NVARCHAR(256))
RPT_RetryCount = Column(INTEGER)
RPT_LoginToken = Column(VARCHAR(1024))
RPT_NodeInfo = Column(IMAGE)
RPT_ParameterTemplate = Column(IMAGE)
RPT_MailList = Column(IMAGE)
RPT_IsNeedAttacheInMail = Column(INTEGER)
class TbNetworkOutbreakInstance(Base):
__tablename__ = 'tb_NetworkOutbreakInstance'
CLF_EntityID = Column(CHAR(36), primary_key=True)
CLF_ProductType = Column(INTEGER)
VLF_VirusName = Column(VARCHAR(64))
VLF_InfectionDestination = Column(NVARCHAR(254))
IFVID_TotalInstances = Column(INTEGER)
IFVID_FoundTime = Column(DATETIME)
IFVID_YEAR = Column(INTEGER)
IFVID_MONTH = Column(INTEGER)
IFVID_DAY = Column(INTEGER)
class TbServerDetailStatusInfo(Base):
__tablename__ = 'tb_ServerDetailStatusInfo'
id = Column(INTEGER, primary_key=True, nullable=False)
ServerID = Column(VARCHAR(36), nullable=False)
DiskUsage = Column(VARCHAR(10))
DiskTotal = Column(VARCHAR(10))
DiskUnit = Column(VARCHAR(10))
DiskPercent = Column(VARCHAR(10))
DiskLevel = Column(INTEGER)
CPUPercent = Column(VARCHAR(10))
CPULevel = Column(INTEGER)
MemoryUsage = Column(VARCHAR(10))
MemoryTotal = Column(VARCHAR(10))
MemoryUnit = Column(VARCHAR(10))
MemoryPercent = Column(VARCHAR(10))
MemoryLevel = Column(INTEGER)
Samples = Column(INTEGER)
SamplesLevel = Column(INTEGER)
LastUpdateUTCTime = Column(DATETIME)
ServerStatus = Column(INTEGER)
class TbsCloudPolicySortingRule(Base):
__tablename__ = 'tb_sCloudPolicySortingRule'
id = Column(INTEGER, primary_key=True, nullable=False)
RuleID = Column(UNIQUEIDENTIFIER, nullable=False)
PolicyID = Column(CHAR(36), nullable=False)
SortingSequence = Column(SMALLINT)
RuleForUI = Column(NVARCHAR, nullable=False)
RuleForQuery = Column(NVARCHAR, nullable=False)
LastUpdateUTCTime = Column(DATETIME)
UserGuid = Column(CHAR(36), nullable=False)
PolicyType = Column(VARCHAR(32), nullable=False)
class TbSecondFailureInstance(Base):
__tablename__ = 'tb_SecondFailureInstance'
SFI_EntityID = Column(CHAR(36), primary_key=True)
SFI_ProductType = Column(INTEGER)
SFI_VirusName = Column(VARCHAR(64))
SFI_InfectionDestination = Column(NVARCHAR(254))
SFI_TotalInstances = Column(INTEGER)
SFI_FoundTime = Column(DATETIME)
SFI_YEAR = Column(INTEGER)
SFI_MONTH = Column(INTEGER)
SFI_DAY = Column(INTEGER)
