'reporting' Database

CA Spectrum Report Manager (SRM) uses a MySQL database named 'reporting' to store data. This database contains all the tables that are required to store the data that is used by SRM application to generate reports.
casp1031
CA Spectrum Report Manager (SRM) uses a MySQL database named '
reporting
' to store data. This database contains all the tables that are required to store the data that is used by SRM application to generate reports.
At startup, the CA Spectrum Report Manager retrieves the data from the primary Archive Manager for each SpectroSERVER through OneClick and stores the data in the SRM databases.
Following is the list of tables and views in the '
reporting
' database.
 
 
3
 
 
 The relations shown in the following diagrams merely indicate table relations. They do not indicate 1:1 or 1: many relations. 
 Interpret the column icons as indicated below:
  'reporting' database_Primary Key.png  - Represents a Primary Key
  'reporting' database_NOT NULL attribute.png  - Simple NOT NULL column
  'reporting' database_NULL attribute.png  - Simple column which can be NULL
Tables
alarm_user
 
Description
 
 This table lists the users who can manage the alarms in spectrum.
 
Columns
 
Field
Type
Null
Key
Default
Extra
Comment
alarm_user_name
char(255)
NO
UNI
Name of the spectrum user, who can manage the alarms.
alarm_user_key
int(10) unsigned
NO
PRI
auto_increment
Unique key for each user, who manages the alarm in spectrum
 
Relations
 
  imageanil.JPG  
alarmactivity
 
Description
 
The alarmactivity table stores all the alarm activity that is monitored by SRM. The activity field denotes the type of alarm event generated. This field can be one of the following:
  • Set alarm event
  • Acknowledge alarm event
  • Assign troubleshooter alarm event
  • Clear alarm event
  • User cleared alarm event
  • Assign trouble ticket alarm event
 
Columns
  
Field
Type
Null
Key
Default
Comment
user
char(50)
NO
MUL
Name of the user, handling the alarm
time
datetime
NO
MUL
0000-00-00 00:00:00
Time of the activity performed in the alarm.
data
char(255)
YES
alarm_key
int(11) unsigned
NO
MUL
Key value for specific type of Alarms.
activity
int(10) unsigned
NO
MUL
Activity that is performed by the user on the specific alarm.
 
Relations
 
  AlarmactivityNew.jpg  
alarmcondition
 
Description
 
This table represents the alarm criticality and condition.
 
Columns
   
Field
Type
Null
Key
Default
Comment
criticality
tinyint(2)
NO
UNI
Criticality of the alarm like Minor, Major, Critical
condition_name
varchar(11)
NO
Condition name of the alarm, which is mapped to the criticality.
condition_id
int(10) unsigned
NO
PRI
Unique ID for the alarm condition.
 
Relations
 
alarminfo
 
Description
 
This table contains all the alarm information including the assignee and trouble ticket IDs.
The alarminfo table stores relevant information for an alarm. There is one entry per unique alarm id, as opposed to the alarmactivity table which can have multiple entries for a single Alarm ID. An entry in this table is created when a “set alarm event” is received by SRM. The table is updated through the life of the alarm as each of the other alarm events are received by SRM.
 
Columns
    
Field
Type
Null
Key
Default
Comment
set_troubleticket_user_key
int(10) unsigned
YES
MUL
Trouble ticket user key for the specific alarm.
set_troubleticket_time
datetime
YES
Time of the trouble ticket assigned.
set_troubleticket_id
char(255)
YES
Trouble ticket ID of the alarm.
set_time
datetime
YES
MUL
Originated time of the alarm.
persistent
int(10) unsigned
YES
MUL
2
orig_event_type
int(10) unsigned
YES
Originating event type for the alarm.
orig_event_key
bigint(20) unsigned
YES
Originating event key for the Alarm.
model_key
int(10) unsigned
NO
MUL
0
Unique model key for each alarm.
model_h
int(10) unsigned
NO
MUL
Model handle of the device, which has the alarm on it.
last_assigning_user_key
int(10) unsigned
YES
MUL
last_assigned_user_key
int(10) unsigned
YES
MUL
last_assigned_time
datetime
YES
landscape_h
int(10) unsigned
NO
Landscape handle of the server, where the alarm present.
impact_severity
int(10) unsigned
NO
0
Severity of the alarm.
first_assigning_user_key
int(10) unsigned
YES
MUL
first_assigned_user_key
int(10) unsigned
YES
MUL
first_assigned_time
datetime
YES
First assigned time of the alarm to specific user.
condition_id
int(11)
YES
Condition of the alarm, which is mapped to the criticality.
clear_user_key
int(10) unsigned
YES
MUL
clear_user
char(50)
YES
User who acknowledge the alarm.
clear_time
datetime
YES
When the alarm is cleared from spectrum.
cause
int(10) unsigned
YES
MUL
Cause/Event ID of the specific alarm.
alarm_title_id
int(10) unsigned
NO
MUL
1
Unique ID for alarm title.
alarm_key
int(11) unsigned
NO
PRI
Unique ID for each alarm present in spectrum
alarm_id
char(36)
NO
UNI
Alarm ID for specific type of alarms.
ack_user_key
int(10) unsigned
YES
MUL
Specific key for the user who acknowledges the alarm.
ack_time
datetime
YES
When the user acknowledge the alarm.
 
 
 
Relations
 
  AlarmInfoNew.jpg  
alarmtitle
 
Description
 
This table represents the title information of spectrum alarms.
 
Columns
    
Field
Type
Null
Key
Default
Extra
Comment
title
varchar(255)
YES
Title of the Alarm.
cause_id
int(10) unsigned
NO
MUL
Cause or Event ID of specific type of alarm in spectrum
alarm_title_id
int(10) unsigned
NO
PRI
auto_increment
Unique ID for each alarm present in spectrum.
 
Relations
 
  AlarmTitileNew.jpg  
backups
 
Description
 
This table contains list of database backups.
bo_only_user
 
Description
 
This table includes the Business object user information. 
boxi_user_sync
 
Description
 
 This table includes the Business object user sync information.
bucketactivitylog
 
Description
 
This table includes the event information from the landscape to process in SRM database.
ca_reportstrings
 
Description
 
This table represents the information of localized string for the identifier.
configchangelog
 
Description
 
This table contains the information about NCM configuration file and logs.
 
Columns
     
Field
Type
Null
Key
Default
Extra
Comment
last_modified
bigint(20)
NO
Last_Modified time of the configuration file.
id
int(10) unsigned
NO
PRI
auto_increment
Unique ID of Configuration file.
filename
varchar(255)
NO
Name of the Configuration file.
content
blob
NO
Content of the configuration file
contentpkg
 
Description
 
This table represents the installation content package information. 
The contentpkg table associates content packages with Crystal Enterprise folder IDs. This table is not meant to be reported against, but instead is actually used by the Report Manager to help identify installation and security issues. A content package might only be installed once and this table helps identify if that is the case.
creator
 
Description
 
This table includes the model creator information. 
 
Relations
 
  CreatorNew.jpg  
data_retention_policy_changelog
 
Description
 
This table includes the information about the data retention policy. 
devicemodel 
 
Description
 
This table represents the complete device model information.
The devicemodel table is filled in initially as the Report Manager extracts model information from the respective SpectroSERVERs. New records are added by the Report Manager as it responds to model creation events for device models.
Certain attributes of this table can change and as such the Report Manager needs a way to keep up with these changes. To keep up with these changes, the Report Manager periodically requests current values for these attributes. These requests are made to the appropriate models through the OneClick architecture. Initially this period for updating device data is set to once every 24 hours.
The user-defined fields are to be left blank, but provide the administrator an opportunity to extend the Report Manager database to include data that is applicable to their assets.
 
Relations
 
  devicemodelNew.jpg  
devicemodel_uda
 
Description
  
The devicemodel_uda table contains user-defined polling attribute information.
devicemodule
 
Description
  
This table includes the chassis information like module name, serial number etc. 
This table captures the relationship between Chassis device models and the board modules contained within. This table is dynamically kept up to date.
 
Relations
 
  devicemoduleNew.jpg  
 
Columns 
(till CA Spectrum 10.2.1 release)
Field
Type
Null
Key
Default
Extra
module_id
int(10) unsigned
NO
 PRI
 NULL
 auto_increment
model_key
int(10) unsigned
YES
MUL
 NULL
module_index
int(10)
YES
 NULL
module_name
varchar(255)
YES
NULL
serial_nbr
varchar(255)
YES
NULL
software_rev
varchar(255)
YES
NULL
 
Columns 
(from CA Spectrum 10.2.2 release)
Field
Type
Null
Key
Default
Extra
module_id
int(10) unsigned
NO
 PRI
 NULL
 auto_increment
model_key
int(10) unsigned
YES
MUL
 NULL
physical_index
int(10)
YES
 NULL
physical_modelname
varchar(255)
YES
NULL
physical_name
varchar(255)
YES
NULL
physical_class
int(10)
YES
NULL
physical_contained_in
int(10)
YES
NULL
serial_nbr
varchar(255)
YES
NULL
software_rev
varchar(255)
YES
NULL
entity
 
 
Description
  
This table maintains distinct devices/interfaces across ALL landscapes. 
The entity table is used to identify all entities uniquely that can be reported on. As new unique entities are added to the database, new entity records are created. Entity table record creation is closely tied to devicemodel and interfacemodel table record creation. The current_model, create_time, and destroy_time columns always correspond to the most recently created model.
 
Relations
 
  entityNew.jpg  
entitygroup
 
Description
  
This table is about taking the device assets and grouping them into predefined groups that are based on Vendor, Model Class, Landscape. 
The EntityGroup table is initially filled in during the startup of the Report Manager application. Queries are made to the individual SpectroSERVERs to learn of the existing model collections (which are actually models themselves).
The EntityGroup table is then kept up to date by having the Report Manager watch for the creation (and destruction) events of the collection models. When a new event occurs indicating the creation of one of these collection models, the name for that collection model is immediately obtained. A search of the EntityGroup table for a record with that name is performed. If no such record exists, one is immediately added. If a record does exist, no further processing is necessary.
entitygroupentity
 
Description
  
The EntityGroupEntity table is initially filled in during the startup of the Report Manager application. As EntityGroups are added to the system, queries are made back to each of the servers to determine the membership of those groups. In determining membership, the SpectroSERVER identifies a set of models. Each model can then be referenced in either the devicemodel or interfacemodel table. From there, an entity ID can be obtained and an appropriate entry can be made into this table.
The EntityGroupEntity table can then be kept up to date by monitoring the relationship changes associated with those collection models.
entitygrouptype
 
Description
   
The EntityGroupType table is filled in at the time of table creation. EntityGroupTypes are pre-defined before any EntityGroups have been defined. Table records include: 
 
entity_group_type
 
 
eg_type_name
 
101
Vendor group
102
Model Class group
103
Landscape group
1000
User-Defined group
1001
User-Defined group
entitymodel
 
Description
   
The entitymodel is used to identify all model handles that an entity has had. This table gets filled in as part of the Entity table updating. When a record gets added to either the devicemodel or interfacemodel table, a process is kicked off to identify if this “new” model is either an existing/known entity, or a new (previously unknown/un-modeled) entity.
A new record gets added to the entitymodel table every time a “new” model record gets added to either the devicemodel or devicemodel table. When a record is added to the entitymodel table, the record is recorded with a timestamp. This timestamp enables the Report Manager to identify the most current model that represents an entity.
 
Columns
 
event
 
Description
   
This table described the complete event information like event ID, message, time etc. 
 
Relations
 
  eventNew.jpg  
eventactivitylog
 
Description
  
Contains number of events processed in each polling cycle for every landscape.
 
Columns
 
 
Field
Type
Null
Key
Default
Extra
Comment
log_id
int(10) unsigned
NO
PRI
auto_increment
Unique log id for each event processing polling cycle
landscape_h
int(10) unsigned
NO
MUL
landscape handle of SS
poll_start_time
datetime
NO
The time when polling cycle started
poll_end_time
datetime
YES
The time when polling cycle end
nbr_of_events
int(10) unsigned
YES
number of events processed in the current polling cycle
 
eventdesc
 
Description
 
Contains static list of events.
 
Columns
 
Field
Type
Null
Key
Default
Comment
type
int(10) unsigned
NO
PRI
0
Event Type
title
varchar(255)
YES
Event title
parsed
tinyint(1)
YES
0
 
Relations
 
  eventdescNew.jpg  
folderhierarchy
 
Description
 
Contains folder hierarchy present in OneClick explorer view.
 
Columns
 
 
 
folderidmap
 
Description
 
This table maps the SRM entitygroupid of the folder to the CsUniqueID that identifies the folder in One Click and Spectrum. This table is used for custom collection hierarchies.
 
Columns
 
Field
Type
Null
Key
Default
Comment
cs_unique_id
char(36)
NO
PRI
folder_id
int(10) unsigned
NO
MUL
 
 
gcmodel
 
Description
 
Contains mapping between global collections and models present in it.
Please note that this table does not include a flag like 'destroyed' or 'startdate/enddate' for the relation between the model and the global collection. It only represents the current assignment.
 
Columns
 
Field
Type
Null
Key
Default
Comment
gc_rec_ID
int(10) unsigned
NO
PRI
global collection record ID
model_key
int(10) unsigned
NO
PRI
model key of the model present in the global collection
 
Relations
 
  changed.jpg  
globalcollection
 
Description
 
Contains list of global collections.
 
Columns
 
Field
Type
Null
Key
Default
Extra
Comment
gc_rec_ID
int(10) unsigned
NO
PRI
auto_increment
unique record ID for each global collection
gc_name
varchar(255)
NO
Name of global collection
gc_unique_key
varchar(255)
NO
UNI
unique key for each global collection
 
Relations
 
  globalcollectionNew.jpg  
groupentitygroups
 
Description
 
This table stores mapping of group_id to entity _group_id .
Since entity groups of type 'folder’ can be made up of multiple entity groups (of type folder, collection or both), this table allows you to find all the entity groups that make up the specified entity group.
NOTE: When finding all entities of a specified entity group, use this table, not the entitygroup table.
 
 
 
Columns
 
Field
Type
Null
Key
Default
Comment
group_id
int(10) unsigned
NO
PRI
entity_group_id
int(10) unsigned
NO
PRI
handleractivitylog
 
Description
 
Containing the log of bucket processing done by all handlers for each landscape.
 
Columns
 
Field
Type
Null
Key
Default
Extra
Comment
log_id
int(10) unsigned
NO
PRI
auto_increment
Unique log id for each processing done by the handler
landscape_h
int(10) unsigned
NO
MUL
Landsacpe handle
staging_table
varchar(255)
NO
MUL
Name of the bucket which is getting processed
process_start_time
datetime
NO
Processing start time
process_end_time
datetime
YES
Processing end time
last_event_seq
int(10) unsigned
YES
event_log_id
int(10) unsigned
NO
MUL
handlerrollback
 
Description
 
This table stores model outage rollback data.
 
Columns
 
Field
Type
Null
Key
Default
Comment
landscape_h
int(10) unsigned
NO
PRI
model_outage_update_ongoing
int(10) unsigned
NO
0
last_model_outage_id
bigint(20) unsigned
YES
last_model_outage_event_key
bigint(20) unsigned
YES
dev_outage_update_ongoing
int(10) unsigned
NO
0
last_dev_outage_id
int(10) unsigned
YES
last_dev_event_time
datetime
YES
int_outage_update_ongoing
int(10) unsigned
NO
0
last_int_outage_id
int(10) unsigned
YES
last_int_event_time
datetime
YES
installedreports
 
Description
 
This table contains the file names of the reports that are loaded into the database by SRM. The report ID of the report that is stored in the database with its parent folder ID are also listed. This table is consulted when add or updating reports within SRM.
 
Columns
 
Field
Type
Null
Key
Default
Comment
report_ID
int(10) unsigned
NO
PRI
parent_folder_ID
int(10) unsigned
NO
file_name
varchar(255)
NO
interfacemodel
 
Description
 
Contains interface information for all device models.
The interfacemodel table is filled in initially as the Report Manager extracts model information from the respective SpectroSERVERs. New records are added by the Report Manager as it responds to model creation events for interface models. The models that are reported on within the interfacemodel table are initially limited to those models that represent physical interfaces. Logical interfaces are not recognized or reported on with this first phase.
 
Columns
 
Field
Type
Null
Key
Default
Comment
model_key
int(10) unsigned
NO
PRI
0
model key of the interface
model_h
int(10) unsigned
NO
MUL
model handle of interface
landscape_h
int(10) unsigned
NO
MUL
Landscape handle of SS where the model is present
model_name
varchar(4000)
YES
MUL
Model name of the interface
model_class
int(10) unsigned
NO
MUL
model class of the interface
create_time
datetime
NO
Interface model creation time
mtype_h
int(10) unsigned
NO
MUL
Model Type Handle of the interface
security_string
varchar(255)
NO
security string of interface
destroy_time
datetime
YES
Destroy time of the interface model
port_type
varchar(255)
NO
MUL
Interface / port type
port_desc
varchar(255)
YES
Interface or port description
if_speed
bigint(20) unsigned
YES
Speed of the interface
IP
varchar(255)
YES
IP address of the interface
MAC
varchar(32)
YES
MAC address of the interface
port_link_status
int(10) unsigned
YES
MUL
Port or Interface link status
ifLastChange
bigint(20) unsigned
YES
value of ifLastChange mib attribute
ifInOctets
bigint(20) unsigned
YES
Value of ifInOctets mib attribute
dateLastSignificantTraffic
datetime
YES
The time when the last traffic is seen on the interface or port
ifAlias
varchar(4000)
YES
Contains the value of ifAlias mib attribute
connected_dev
int(10) unsigned
YES
Contains the interface to which this is connected
component_OID
varchar(255)
YES
device_model_key
int(10) unsigned
YES
MUL
Model key of the device
port_duplex_id
tinyint(3) unsigned
YES
 
 
 
Relations
 
  interfacemodel.jpg  
ipls_names
 
Description
 
This table contains the different values for the port_link_status on an interface model found in the interfacemodel table. This table is filled when it is created with the following values:
 
Status
 
 
Name
 
0
Good
1
Bad
2
Unknown
3
Disabled
4
Unreachable
5
Init
6
L inked Port Bad
7
Linked Device Bad
8
Dormant
9
Port In Maintenance
10
Bad Suppressed
11
WA Link Bad
12
LL In Maintenance
13
Always Down
 
Columns
 
Field
Type
Null
Key
Default
Comment
status
int(10) unsigned
NO
PRI
Status number
name
varchar(32)
NO
Status name
 
 
 
Relations
 
  ipls_names.JPG  
 
 
landscape
 
Description
 
Contains the last poll /sync times for each landscape
The landscape table lists those landscapes that report manager has seen. The dev_sync_time is the time the last known device event was recorded for the given landscape. The int_sync_time time is the time the last known interface event was recorded.
 
Columns
 
Field
Type
Null
Key
Default
Comment
landscape_h
int(10) unsigned
NO
PRI
Landscape handle which is polled by report manager
domain_name
varchar(255)
YES
Domain name of the landscape
avail_sync_time
datetime
YES
The last sync time for availability
dev_sync_time
datetime
YES
The last sync time for device availability
int_sync_time
datetime
YES
The last sync time for interface information
process_if_app_events
int(10)
NO
0
 Indicates if it is ok to process application lost /react events for the interfaces
spm_sync_time
datetime
YES
The last sync time for SPM information
alarm_sync_time
datetime
YES
The last sync time for alarms information
event_sync_time
datetime
YES
The last sync time for events information
event_polling
tinyint(1)
NO
1
contains 1 if the event polling is enabled for this landscape else 0
device_polling
tinyint(1)
NO
1
Contains 1 if Asset polling is enabled else 0
 
Relations
 
  landscape.jpg  
managementoutage
 
Description
 
This table stores the management outages for the monitored landscapes.
 
Columns
 
Field
Type
Null
Key
Default
Extra
Comment
outage_ID
int(10) unsigned
NO
PRI
auto_increment
landscape_h
int(10) unsigned
NO
MUL
start_time
datetime
NO
end_time
datetime
YES
outage_type
int(10) unsigned
NO
MUL
managementoutagetype
 
Description
 
This table lists the different types of management outages. This table is filled at table creation time with the following values:
  • Expected
  • Unexpected
  • History
 
Columns
 
Field
Type
Null
Key
Default
Comment
outage_type
int(10) unsigned
NO
PRI
outage_desc
varchar(32)
NO
model
 
Description
 
Contains information of all the spectrum models. This table stores general model information.
 
Columns
 
Field
Type
Null
Key
Default
Extra
Comment
model_key
int(10) unsigned
NO
PRI
auto_increment
Unique Model Key for model
model_h
int(10) unsigned
NO
MUL
0
Model Handle of the model
model_name
varchar(4000)
YES
MUL
Name of the Model
mtype_h
int(10) unsigned
YES
MUL
Model Type Handle of the model
model_class
int(10) unsigned
YES
MUL
model class of the model
network_address
varchar(255)
YES
IP or Network address of the model
first_event_time
datetime
YES
2000-01-01 00:00:00
The time when first event got generated on the model
landscape_h
int(10) unsigned
YES
MUL
Landscape handle of SS where the model is present
destroy_time
datetime
YES
MUL
The time when model is destroyed
security_string
varchar(255)
YES
MUL
*UNKNOWN*
security string of the model
isClusterEntity
int(11)
NO
0
Flag that indicated if the model is cluster or not
 
Relations
 
  model.jpg  
model_state
 
Description
 
Contains information about model state.
 
Columns
 
Field
Type
Null
Key
Default
Extra
Comment
model_state_id
bigint(20) unsigned
NO
PRI
auto_increment
Unique ID for each model state
model_key
int(10) unsigned
NO
MUL
Model key of the model
model_state
varchar(64)
NO
MUL
Model state
start_time
datetime
NO
The time when the model is in this state
end_time
datetime
YES
The time when the model is no longer in this state
 
Relations
 
  model_state.jpg  
modelclass
 
Description
 
Contains static list containing list of all model class names.
 The modelclass table is filled in at the time of table creation.
 
Columns
 
Field
Type
Null
Key
Default
Extra
Comment
model_class
int(10) unsigned
NO
PRI
unique number for model class
mclass_name
varchar(32)
NO
MUL
Name of the model class
 
Relations
 
  modelclass.jpg  
modeloutage
 
Description
 
Contains all the outages for the model.
 
Columns
 
Field
Type
Null
Key
Default
Extra
Comment
model_outage_ID
bigint(20) unsigned
NO
PRI
auto_increment
Unique ID for each outage of the model
model_key
int(10) unsigned
NO
MUL
Model Key of the model
landscape_h
int(10) unsigned
NO
MUL
landscape handle of SS where the model is present
start_time
datetime
NO
MUL
The time when the outage started for the model
end_time
datetime
YES
MUL
The time when the outage got end for the model
outage_type
int(10) unsigned
NO
MUL
Type of outage on the model
zero_length_outage
tinyint(2)
NO
MUL
0
start_event_key
bigint(20) unsigned
YES
MUL
end_event_key
bigint(20) unsigned
YES
MUL
legacy_outage_id
int(10) unsigned
YES
legacy_outage_source
char(1)
YES
 
Relations
 
  modeloutage.jpg  
modeloutage_notes
 
Description
 
Contains notes for each outage for the model.
 
 
Columns
 
Field
Type
Null
Key
Default
Extra
Comment
modeloutage_note_ID
bigint(20) unsigned
NO
PRI
auto_increment
unique ID for each model outage note
model_outage_ID
bigint(20) unsigned
NO
MUL
Outage ID corresponding to the outage ID in model table
notes
char(250)
YES
model outage notes
 
Relations
 
  modeloutage_notes.jpg  
modeltype
 
Description
 
Contains Static list of all model type handles and their names.
The modeltype table is filled in as the Report Manager is starting up. The Report Manager contacts one of the SpectroSERVERs and sends a query requesting the handle and name for all device model types. Once this query is returned, the modeltype table is updated.
 
Columns
 
Field
Type
Null
Key
Default
Comment
mtype_h
int(10) unsigned
NO
PRI
Model type handle
mtype_name
varchar(128)
NO
Model Type Name
 
Relations
 
  modeltype.jpg  
ncm_config
 
Description
 
 
Columns
 
Field
Type
Null
Key
Default
Extra
Comment
config_id
int(10) unsigned
NO
PRI
auto_increment
config_text_id
int(10) unsigned
NO
MUL
device_model_key
int(10) unsigned
NO
change_time
datetime
YES
trap_from
varchar(255)
NO
trap_user
varchar(255)
NO
trap_on
varchar(128)
YES
lines_changed
int(11)
YES
rel_lines_changed
int(11)
YES
violated_policies
varchar(3000)
YES
compliant_policies
varchar(3000)
YES
spec_user_name
varchar(255)
YES
comm_mode
varchar(128)
YES
landscape
varchar(128)
YES
ncm_config_text
 
Description
 
 
Columns
 
Field
Type
Null
Key
Default
Extra
Comment
config_text_id
int(10) unsigned
NO
PRI
auto_increment
prev_config_text_id
int(10) unsigned
YES
MUL
config_model_key
int(10) unsigned
NO
MUL
prev_config_model_key
int(10) unsigned
YES
create_time
datetime
YES
diff_text
mediumtext
YES
config_text
mediumtext
YES
 
Relations
 
  nvm_config_text.jpg  
ncm_event_type
 
Description
 
Contains static list of all NCM event types
 
Columns
 
Field
Type
Null
Key
Default
Extra
Comment
type
int(10) unsigned
NO
PRI
NCM Event type
 
Relations
 
  nvm_event_type.jpg  
oc_user
 
Description
 
This table contains list of oneclick users
 
Columns
    
 
Field
 
 
Type
 
 
Null
 
 
Key
 
 
Default
 
 
Extra
 
 
Comment
 
oc_user_id
int(10) unsigned
NO
PRI
auto_increment
user_name
varchar(255)
YES
UNI
load_time
timestamp
NO
CURRENT_TIMESTAMP
last_evaluation_time
timestamp
NO
0000-00-00 00:00:00
 
 
 
Relations
 
  oc_user.jpg  
outagetype
 
Description
 
This table contains list outage types and descriptions
This table is filled in at the time of table creation. Outage types are pre-defined before any outages occur. Table records include:
 
outage_type
 
 
outage_desc
 
0
Initial
1
Unplanned
2
Planned
3
Exempt
 
Columns
    
 
Field
 
 
Type
 
 
Null
 
 
Key
 
 
Default
 
 
Extra
 
 
Comment
 
outage_type
int(10) unsigned
NO
PRI
outage_desc
varchar(32)
NO
 
 
 
Relations
 
  outagetype.jpg  
pcause
 
Description
 
This table provides a mapping of cause codes to their titles. It is populated as each new cause is encountered by the alarm handler.
 
Columns
    
 
Field
 
 
Type
 
 
Null
 
 
Key
 
 
Default
 
 
Extra
 
 
Comment
 
cause_id
int(10) unsigned
NO
PRI
title
varchar(100)
YES
performance
 
Description
 
This table contains MySQL configuration settings for SRM DB, mostly static data
 
Columns
    
 
Field
 
 
Type
 
 
Null
 
 
Key
 
 
Default
 
 
Extra
 
 
Comment
 
id
int(10) unsigned
NO
PRI
auto_increment
runcode
char(255)
YES
runtime
datetime
YES
memused
int(10) unsigned
NO
memfree
int(10) unsigned
NO
Aborted_clients
int(10) unsigned
NO
0
Aborted_connects
int(10) unsigned
NO
0
Binlog_cache_disk_use
int(10) unsigned
NO
0
Binlog_cache_use
int(10) unsigned
NO
0
Bytes_received
int(10) unsigned
NO
0
Bytes_sent
int(10) unsigned
NO
0
Com_admin_commands
int(10) unsigned
NO
0
Com_alter_db
int(10) unsigned
NO
0
Com_alter_table
int(10) unsigned
NO
0
Com_analyze
int(10) unsigned
NO
0
Com_backup_table
int(10) unsigned
NO
0
Com_begin
int(10) unsigned
NO
0
Com_change_db
int(10) unsigned
NO
0
Com_change_master
int(10) unsigned
NO
0
Com_check
int(10) unsigned
NO
0
Com_checksum
int(10) unsigned
NO
0
Com_commit
int(10) unsigned
NO
0
Com_create_db
int(10) unsigned
NO
0
Com_create_function
int(10) unsigned
NO
0
Com_create_index
int(10) unsigned
NO
0
Com_create_table
int(10) unsigned
NO
0
Com_dealloc_sql
int(10) unsigned
NO
0
Com_delete
int(10) unsigned
NO
0
Com_delete_multi
int(10) unsigned
NO
0
Com_do
int(10) unsigned
NO
0
Com_drop_db
int(10) unsigned
NO
0
Com_drop_function
int(10) unsigned
NO
0
Com_drop_index
int(10) unsigned
NO
0
Com_drop_table
int(10) unsigned
NO
0
Com_drop_user
int(10) unsigned
NO
0
Com_execute_sql
int(10) unsigned
NO
0
Com_flush
int(10) unsigned
NO
0
Com_grant
int(10) unsigned
NO
0
Com_ha_close
int(10) unsigned
NO
0
Com_ha_open
int(10) unsigned
NO
0
Com_ha_read
int(10) unsigned
NO
0
Com_help
int(10) unsigned
NO
0
Com_insert
int(10) unsigned
NO
0
Com_insert_select
int(10) unsigned
NO
0
Com_kill
int(10) unsigned
NO
0
Com_load
int(10) unsigned
NO
0
Com_load_master_data
int(10) unsigned
NO
0
Com_load_master_table
int(10) unsigned
NO
0
Com_lock_tables
int(10) unsigned
NO
0
Com_optimize
int(10) unsigned
NO
0
Com_preload_keys
int(10) unsigned
NO
0
Com_prepare_sql
int(10) unsigned
NO
0
Com_purge
int(10) unsigned
NO
0
Com_purge_before_date
int(10) unsigned
NO
0
Com_rename_table
int(10) unsigned
NO
0
Com_repair
int(10) unsigned
NO
0
Com_replace
int(10) unsigned
NO
0
Com_replace_select
int(10) unsigned
NO
0
Com_reset
int(10) unsigned
NO
0
Com_restore_table
int(10) unsigned
NO
0
Com_revoke
int(10) unsigned
NO
0
Com_revoke_all
int(10) unsigned
NO
0
Com_rollback
int(10) unsigned
NO
0
Com_savepoint
int(10) unsigned
NO
0
Com_select
int(10) unsigned
NO
0
Com_set_option
int(10) unsigned
NO
0
Com_show_binlog_events
int(10) unsigned
NO
0
Com_show_binlogs
int(10) unsigned
NO
0
Com_show_charsets
int(10) unsigned
NO
0
Com_show_collations
int(10) unsigned
NO
0
Com_show_column_types
int(10) unsigned
NO
0
Com_show_create_db
int(10) unsigned
NO
0
Com_show_create_table
int(10) unsigned
NO
0
Com_show_databases
int(10) unsigned
NO
0
Com_show_errors
int(10) unsigned
NO
0
Com_show_fields
int(10) unsigned
NO
0
Com_show_grants
int(10) unsigned
NO
0
Com_show_innodb_status
int(10) unsigned
NO
0
Com_show_keys
int(10) unsigned
NO
0
Com_show_logs
int(10) unsigned
NO
0
Com_show_master_status
int(10) unsigned
NO
0
Com_show_new_master
int(10) unsigned
NO
0
Com_show_open_tables
int(10) unsigned
NO
0
Com_show_privileges
int(10) unsigned
NO
0
Com_show_processlist
int(10) unsigned
NO
0
Com_show_slave_hosts
int(10) unsigned
NO
0
Com_show_slave_status
int(10) unsigned
NO
0
Com_show_status
int(10) unsigned
NO
0
Com_show_storage_engines
int(10) unsigned
NO
0
Com_show_tables
int(10) unsigned
NO
0
Com_show_variables
int(10) unsigned
NO
0
Com_show_warnings
int(10) unsigned
NO
0
Com_slave_start
int(10) unsigned
NO
0
Com_slave_stop
int(10) unsigned
NO
0
Com_truncate
int(10) unsigned
NO
0
Com_unlock_tables
int(10) unsigned
NO
0
Com_update
int(10) unsigned
NO
0
Com_update_multi
int(10) unsigned
NO
0
Connections
int(10) unsigned
NO
0
Created_tmp_disk_tables
int(10) unsigned
NO
0
Created_tmp_files
int(10) unsigned
NO
0
Created_tmp_tables
int(10) unsigned
NO
0
Delayed_errors
int(10) unsigned
NO
0
Delayed_insert_threads
int(10) unsigned
NO
0
Delayed_writes
int(10) unsigned
NO
0
Flush_commands
int(10) unsigned
NO
0
Handler_commit
int(10) unsigned
NO
0
Handler_delete
int(10) unsigned
NO
0
Handler_discover
int(10) unsigned
NO
0
Handler_read_first
int(10) unsigned
NO
0
Handler_read_key
int(10) unsigned
NO
0
Handler_read_next
int(10) unsigned
NO
0
Handler_read_prev
int(10) unsigned
NO
0
Handler_read_rnd
int(10) unsigned
NO
0
Handler_read_rnd_next
int(10) unsigned
NO
0
Handler_rollback
int(10) unsigned
NO
0
Handler_update
int(10) unsigned
NO
0
Handler_write
int(10) unsigned
NO
0
Key_blocks_not_flushed
int(10) unsigned
NO
0
Key_blocks_unused
int(10) unsigned
NO
0
Key_blocks_used
int(10) unsigned
NO
0
Key_read_requests
int(10) unsigned
NO
0
Key_reads
int(10) unsigned
NO
0
Key_write_requests
int(10) unsigned
NO
0
Key_writes
int(10) unsigned
NO
0
Max_used_connections
int(10) unsigned
NO
0
Not_flushed_delayed_rows
int(10) unsigned
NO
0
Open_files
int(10) unsigned
NO
0
Open_streams
int(10) unsigned
NO
0
Open_tables
int(10) unsigned
NO
0
Opened_tables
int(10) unsigned
NO
0
Qcache_free_blocks
int(10) unsigned
NO
0
Qcache_free_memory
int(10) unsigned
NO
0
Qcache_hits
int(10) unsigned
NO
0
Qcache_inserts
int(10) unsigned
NO
0
Qcache_lowmem_prunes
int(10) unsigned
NO
0
Qcache_not_cached
int(10) unsigned
NO
0
Qcache_queries_in_cache
int(10) unsigned
NO
0
Qcache_total_blocks
int(10) unsigned
NO
0
Questions
int(10) unsigned
NO
0
Select_full_join
int(10) unsigned
NO
0
Select_full_range_join
int(10) unsigned
NO
0
Select_range
int(10) unsigned
NO
0
Select_range_check
int(10) unsigned
NO
0
Select_scan
int(10) unsigned
NO
0
Slave_open_temp_tables
int(10) unsigned
NO
0
Slave_retried_transactions
int(10) unsigned
NO
0
Slow_launch_threads
int(10) unsigned
NO
0
Slow_queries
int(10) unsigned
NO
0
Sort_merge_passes
int(10) unsigned
NO
0
Sort_range
int(10) unsigned
NO
0
Sort_rows
int(10) unsigned
NO
0
Sort_scan
int(10) unsigned
NO
0
Table_locks_immediate
int(10) unsigned
NO
0
Table_locks_waited
int(10) unsigned
NO
0
Threads_cached
int(10) unsigned
NO
0
Threads_connected
int(10) unsigned
NO
0
Threads_created
int(10) unsigned
NO
0
Threads_running
int(10) unsigned
NO
0
Uptime
int(10) unsigned
NO
0
Com_show_ndb_status
int(10) unsigned
NO
0
Com_show_triggers
int(10) unsigned
NO
0
Com_stmt_close
int(10) unsigned
NO
0
Com_stmt_execute
int(10) unsigned
NO
0
Com_stmt_fetch
int(10) unsigned
NO
0
Com_stmt_prepare
int(10) unsigned
NO
0
Com_stmt_reset
int(10) unsigned
NO
0
Com_stmt_send_long_data
int(10) unsigned
NO
0
Com_xa_commit
int(10) unsigned
NO
0
Com_xa_end
int(10) unsigned
NO
0
Com_xa_prepare
int(10) unsigned
NO
0
Com_xa_recover
int(10) unsigned
NO
0
Com_xa_rollback
int(10) unsigned
NO
0
Com_xa_start
int(10) unsigned
NO
0
Handler_prepare
int(10) unsigned
NO
0
Handler_savepoint
int(10) unsigned
NO
0
Handler_savepoint_rollback
int(10) unsigned
NO
0
Innodb_buffer_pool_pages_data
int(10) unsigned
NO
0
Innodb_buffer_pool_pages_dirty
int(10) unsigned
NO
0
Innodb_buffer_pool_pages_flushed
int(10) unsigned
NO
0
Innodb_buffer_pool_pages_free
int(10) unsigned
NO
0
Innodb_buffer_pool_pages_latched
int(10) unsigned
NO
0
Innodb_buffer_pool_pages_misc
int(10) unsigned
NO
0
Innodb_buffer_pool_pages_total
int(10) unsigned
NO
0
Innodb_buffer_pool_read_ahead_rnd
int(10) unsigned
NO
0
Innodb_buffer_pool_read_ahead_seq
int(10) unsigned
NO
0
Innodb_buffer_pool_read_requests
int(10) unsigned
NO
0
Innodb_buffer_pool_reads
int(10) unsigned
NO
0
Innodb_buffer_pool_wait_free
int(10) unsigned
NO
0
Innodb_buffer_pool_write_requests
int(10) unsigned
NO
0
Innodb_data_fsyncs
int(10) unsigned
NO
0
Innodb_data_pending_fsyncs
int(10) unsigned
NO
0
Innodb_data_pending_reads
int(10) unsigned
NO
0
Innodb_data_pending_writes
int(10) unsigned
NO
0
Innodb_data_read
int(10) unsigned
NO
0
Innodb_data_reads
int(10) unsigned
NO
0
Innodb_data_writes
int(10) unsigned
NO
0
Innodb_data_written
int(10) unsigned
NO
0
Innodb_dblwr_pages_written
int(10) unsigned
NO
0
Innodb_dblwr_writes
int(10) unsigned
NO
0
Innodb_log_waits
int(10) unsigned
NO
0
Innodb_log_write_requests
int(10) unsigned
NO
0
Innodb_log_writes
int(10) unsigned
NO
0
Innodb_os_log_fsyncs
int(10) unsigned
NO
0
Innodb_os_log_pending_fsyncs
int(10) unsigned
NO
0
Innodb_os_log_pending_writes
int(10) unsigned
NO
0
Innodb_os_log_written
int(10) unsigned
NO
0
Innodb_page_size
int(10) unsigned
NO
0
Innodb_pages_created
int(10) unsigned
NO
0
Innodb_pages_read
int(10) unsigned
NO
0
Innodb_pages_written
int(10) unsigned
NO
0
Innodb_row_lock_current_waits
int(10) unsigned
NO
0
Innodb_row_lock_time
int(10) unsigned
NO
0
Innodb_row_lock_time_avg
int(10) unsigned
NO
0
Innodb_row_lock_time_max
int(10) unsigned
NO
0
Innodb_row_lock_waits
int(10) unsigned
NO
0
Innodb_rows_deleted
int(10) unsigned
NO
0
Innodb_rows_inserted
int(10) unsigned
NO
0
Innodb_rows_read
int(10) unsigned
NO
0
Innodb_rows_updated
int(10) unsigned
NO
0
Last_query_cost
int(10) unsigned
NO
0
Ssl_accept_renegotiates
int(10) unsigned
NO
0
Ssl_accepts
int(10) unsigned
NO
0
Ssl_callback_cache_hits
int(10) unsigned
NO
0
Ssl_client_connects
int(10) unsigned
NO
0
Ssl_connect_renegotiates
int(10) unsigned
NO
0
Ssl_ctx_verify_depth
int(10) unsigned
NO
0
Ssl_ctx_verify_mode
int(10) unsigned
NO
0
Ssl_default_timeout
int(10) unsigned
NO
0
Ssl_finished_accepts
int(10) unsigned
NO
0
Ssl_finished_connects
int(10) unsigned
NO
0
Ssl_session_cache_hits
int(10) unsigned
NO
0
Ssl_session_cache_misses
int(10) unsigned
NO
0
Ssl_session_cache_overflows
int(10) unsigned
NO
0
Ssl_session_cache_size
int(10) unsigned
NO
0
Ssl_session_cache_timeouts
int(10) unsigned
NO
0
Ssl_sessions_reused
int(10) unsigned
NO
0
Ssl_used_session_cache_entries
int(10) unsigned
NO
0
Ssl_verify_depth
int(10) unsigned
NO
0
Ssl_verify_mode
int(10) unsigned
NO
0
Tc_log_max_pages_used
int(10) unsigned
NO
0
Tc_log_page_size
int(10) unsigned
NO
0
Tc_log_page_waits
int(10) unsigned
NO
0
Com_call_procedure
int(10) unsigned
YES
Com_create_user
int(10) unsigned
YES
prepared_stmt_count
int(10) unsigned
YES
Com_assign_to_keycache
int(10) unsigned
NO
0
Com_alter_db_upgrade
int(10) unsigned
NO
0
Com_alter_event
int(10) unsigned
NO
0
Com_alter_function
int(10) unsigned
NO
0
Com_alter_procedure
int(10) unsigned
NO
0
Com_alter_server
int(10) unsigned
NO
0
Com_alter_tablespace
int(10) unsigned
NO
0
Com_binlog
int(10) unsigned
NO
0
Com_create_event
int(10) unsigned
NO
0
Com_create_procedure
int(10) unsigned
NO
0
Com_create_server
int(10) unsigned
NO
0
Com_create_trigger
int(10) unsigned
NO
0
Com_create_udf
int(10) unsigned
NO
0
Com_create_view
int(10) unsigned
NO
0
Com_drop_event
int(10) unsigned
NO
0
Com_drop_procedure
int(10) unsigned
NO
0
Com_drop_server
int(10) unsigned
NO
0
Com_drop_trigger
int(10) unsigned
NO
0
Com_drop_view
int(10) unsigned
NO
0
Com_empty_query
int(10) unsigned
NO
0
Com_install_plugin
int(10) unsigned
NO
0
Com_release_savepoint
int(10) unsigned
NO
0
Com_rename_user
int(10) unsigned
NO
0
Com_rollback_to_savepoint
int(10) unsigned
NO
0
Com_show_authors
int(10) unsigned
NO
0
Com_show_contributors
int(10) unsigned
NO
0
Com_show_create_event
int(10) unsigned
NO
0
Com_show_create_func
int(10) unsigned
NO
0
Com_show_create_proc
int(10) unsigned
NO
0
Com_show_create_trigger
int(10) unsigned
NO
0
Com_show_engine_logs
int(10) unsigned
NO
0
Com_show_engine_mutex
int(10) unsigned
NO
0
Com_show_engine_status
int(10) unsigned
NO
0
Com_show_events
int(10) unsigned
NO
0
Com_show_function_status
int(10) unsigned
NO
0
Com_show_plugins
int(10) unsigned
NO
0
Com_show_procedure_status
int(10) unsigned
NO
0
Com_show_profile
int(10) unsigned
NO
0
Com_show_profiles
int(10) unsigned
NO
0
Com_show_table_status
int(10) unsigned
NO
0
Com_stmt_reprepare
int(10) unsigned
NO
0
Com_uninstall_plugin
int(10) unsigned
NO
0
Open_table_definitions
int(10) unsigned
NO
0
Opened_files
int(10) unsigned
NO
0
Opened_table_definitions
int(10) unsigned
NO
0
Queries
int(10) unsigned
NO
0
Uptime_since_flush_status
int(10) unsigned
NO
0
portduplex
 
Description
 
This table contains port duplex IDs and corresponding values
 
Columns
    
 
Field
 
 
Type
 
 
Null
 
 
Key
 
 
Default
 
 
Extra
 
 
Comment
 
port_duplex_id
tinyint(3) unsigned
NO
PRI
port_duplex_value
varchar(255)
NO
 
 
 
Relations
 
  portduplex.jpg  
registry
 
Description
 
This table provides a storage area for SRM to maintain different properties and attributes of the SRM application. The table stores generic mappings using key/value pairs. Registry entries can have one of the following types: 
 
type id
 
 
type name
 
0
Boolean
1
String
2
Hidden
3
List
4
List Entry
 
Columns
    
 
Field
 
 
Type
 
 
Null
 
 
Key
 
 
Default
 
 
Extra
 
 
Comment
 
reg_user
varchar(255)
NO
PRI
OneClickServerEntry
varchar(255)
NO
SRMPollPeriod
tinyint(4)
NO
SRMPollStartTime
tinyint(4)
NO
SRMPollEndTime
tinyint(4)
NO
<