ZenEvents.MySqlEventManager.MySqlEventManager

Class MySqlEventManager

Instance Methods

[hide private]

list

getEventSummary(self, where="", severity=1, state=1, prodState=None)
Return a list of tuples with the CSS class, acknowledged count, count...

source code

countEventsSince(self, since)
since is number of seconds since epoch, see documentation for python time.time()

source code

Inherited from MySqlSendEvent.MySqlSendEventMixin: applyDeviceContext, applyEventContext, buildClearUpdate, buildDetailInsert, buildInsert, buildStatusInsert, doSendEvent, escape, eventDataMaps, getNetworkRoot, sendEvent

Inherited from MySqlSendEvent.MySqlSendEventMixin (private): _findByIp, _sendHeartbeat

Inherited from EventManagerBase.EventManagerBase: __init__, convert, convertEventField, dateDB, dateString, defaultAvailabilityEnd, defaultAvailabilityStart, deleteEvents, eventControls, getAllComponentStatus, getAvailability, getAvgFieldLength, getBatchComponentInfo, getComponentStatus, getDeviceIssues, getDevicePingIssues, getDeviceStatus, getDeviceStatusIssues, getEventActions, getEventBatchME, getEventCssClass, getEventDetail, getEventDetailFromStatusOrHistory, getEventList, getEventListME, getEventOwnerList, getEventOwnerListME, getEventResultFields, getEventStates, getEventSummaryME, getFieldList, getGenericStatus, getHeartbeat, getHeartbeatObjects, getMaxSeverity, getOrganizerStatus, getOrganizerStatusIssues, getPriorities, getPriorityString, getSeverities, getSeverityString, getStatusCssClass, getStatusImgSrc, getStatusME, getWmiConnIssues, installIntoPortal, isDate, loadSchema, lookupManagedEntityField, lookupManagedEntityResultFields, lookupManagedEntityWhere, manage_ackEvents, manage_addCommand, manage_addEvent, manage_addLogMessage, manage_clearCache, manage_clearHeartbeats, manage_createEventMap, manage_deleteAllEvents, manage_deleteCommands, manage_deleteEvents, manage_deleteHeartbeat, manage_deleteHistoricalEvents, manage_editCache, manage_editEventManager, manage_refreshConversions, manage_setEventStates, manage_undeleteEvents, restrictedUserFilter, sendEvents, undeleteEvents, updateEvents, zmanage_editProperties

Inherited from EventManagerBase.EventManagerBase (private): _setupDateRange, _wand

Inherited from DbAccessBase.DbAccessBase: cleanstring, close, connect

Inherited from object: __delattr__, __getattribute__, __hash__, __new__, __reduce__, __reduce_ex__, __repr__, __setattr__, __str__

Class Variables

[hide private]

meta_type = 'MySqlEventManager'

portal_type = 'MySqlEventManager'

backend = "mysql"

security = ClassSecurityInfo()

Inherited from EventManagerBase.EventManagerBase: ComponentResultFields, ComponentWhere, DeviceClassWhere, DeviceGroupField, DeviceGroupWhere, DeviceResultFields, DeviceWhere, EventClassInstWhere, EventClassWhere, IpAddressWhere, LocationWhere, SystemField, SystemWhere, componentField, countField, defaultAvailabilityDays, defaultEventId, defaultFields, defaultPriority, defaultResultFields, detailTable, deviceField, eventActions, eventAgingHours, eventAgingSeverity, eventClassField, eventStateConversions, factory_type_information, firstTimeField, historyMaxAgeDays, lastTimeField, logTable, priorities, priorityConversions, prodStateField, refreshConversionsForm, requiredEventFields, severities, severityConversions, severityField, stateField, statusTable

Inherited from EventManagerBase.EventManagerBase (private): _properties, _relations

Inherited from DbAccessBase.DbAccessBase (private): _v_cpool

Properties

[hide private]

Inherited from object: __class__

getEventSummary(self, where="", severity=1, state=1, prodState=None)

source code


Return a list of tuples with the CSS class, acknowledged count, count

[['zenevents_5', 0, 3], ...]

select severity, count(*), group_concat(eventState), 
    from status where device="win2k.confmon.loc" 
    and eventState < 2 group by severity desc;

Returns: list: List of lists of the form [class, acked count, unacked count].
Overrides: EventManagerBase.EventManagerBase.getEventSummary