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)