CI Class MySQL Database

Inheritance diagram for MySQL Database

Summary

Display Name	MySQL Database
Name	mysql_db
Description	SQL Data Base from MySQL

Attributes

Attributes defined for MySQL Database
Name	Display Name	Type	Default Value	Description	Factory	Key	Hidden
BODY_ICON		string	sqldatabase		true	false	true
FAMILY_ICON		string	db		true	false	true
Attributes defined for Database Schema
Name	Display Name	Type	Default Value	Description	Factory	Key	Hidden
created_at	CreatedAt	date		The creation date of the database	true	false	false
~~createdate~~	~~Creation Date~~	string[100]		The creation date of the database	true	false	false
Attributes defined for Database Resource
Name	Display Name	Type	Default Value	Description	Factory	Key	Hidden
BODY_ICON		string	databaseresource		true	false	true
FAMILY_ICON		string	db		true	false	true
Attributes defined for Application Resource
Name	Display Name	Type	Default Value	Description	Factory	Key	Hidden
applicationresource_type	Application Resource Type	string[100]		Application Resource Type	true	false	false
BODY_ICON		string	general		true	false	true
FAMILY_ICON		string	hostresource		true	false	true
layer		layer_enum	software		true	false	false
resource_path	Resource Path	string[512]		Resource Path	true	false	false
Attributes defined for InfrastructureElement
Name	Display Name	Type	Default Value	Description	Factory	Key	Hidden
BODY_ICON		string	system		true	false	true
codepage	CodePage	string[50]		System suported CodePage	true	false	true
credentials_id	Reference to the credentials dictionary entry	string		Reference to the credentials dictinary entry	true	false	true
language	Language	string[50]		System suported language	true	false	true
zone_list	Zone List	string_list[256]		List of management zones in which the CI is discovered	true	false	false
Attributes defined for ConfigurationItem
Name	Display Name	Type	Default Value	Description	Factory	Key	Hidden
ack_cleared_time		long			true	false	true
ack_id		string[80]			true	false	true
bit_position	Bit Position	integer			true	false	true
bitmap_id	Bitmap ID	integer			true	false	true
BODY_ICON		string	it_world		true	false	true
~~city~~	~~City~~	string[50]		City location	true	false	true
classification		classification_enum			true	false	false
contextmenu	Context Menu	string_list[100]		Context menu	true	false	true
~~country~~	~~Country or Province~~	string[50]		Country or province location	true	false	true
data_tags	Tags	json[4000]		A tag is a label assigned to a resource.Each tag consists of a key and a value.	true	false	false
is_save_persistency	Store KPI History For Over Time Reports	boolean	false	Store KPI history for over time reports	true	false	true
layer		layer_enum			true	false	false
sd_type	SD Type	string[32]			true	false	false
~~state~~	~~State~~	string[50]		State location	true	false	true
track_changes	Track Configuration Changes	boolean	false	Track configuration changes	true	false	true
Attributes defined for Managed Object
Name	Display Name	Type	Default Value	Description	Factory	Key	Hidden
TenantOwner	Owner Tenant	string[32]		The Tenant Owner ID	true	false	false
TenantsUses	Consumer Tenants	string_list		The IDs of the Tenants who are associated with the CI	true	false	false
Attributes defined for Object
Name	Display Name	Type	Default Value	Description	Factory	Key	Hidden
document_list	Documents	string		Documents	true	false	true
MENU		xml			true	false	true
Attributes defined for Data
Name	Display Name	Type	Default Value	Description	Factory	Key	Hidden
~~data_adminstate~~	~~Admin State~~	adminstates_enum	0	Admin State	true	false	true
data_allow_auto_discovery	Allow CI Update	boolean[250]	true		true	false	false
~~data_changecorrstate~~	~~Change Corr State~~	changestates_enum	0	Change State	true	false	true
~~data_changeisnew~~	~~Change Is New~~	boolean	false	Change State	true	false	true
~~data_changestate~~	~~Change State~~	changestates_enum	0	Change State	true	false	true
data_externalid	External ID	string[50]		external source id: snmp index, data sources index etc.	true	false	true
data_note	Note	string[250]			true	false	false
~~data_operationcorrstate~~	~~Operation Corr State~~	operationstates_enum	0	Operation State	true	false	true
~~data_operationisnew~~	~~Operation Is New~~	boolean	false	Operation State	true	false	true
~~data_operationstate~~	~~Operation State~~	operationstates_enum	0	Operation State	true	false	true
data_origin	Origin	string[100]			true	false	false
data_source	Created By	string[512]			true	false	false
~~data_testcorrstate~~	~~Test Corr State~~	teststates_enum	0	Test State	true	false	true
~~data_testisnew~~	~~Test Is New~~	boolean	false	Test State	true	false	true
~~data_teststate~~	~~Test State~~	teststates_enum	0	Test State	true	false	true
data_updated_by	LastModifiedBy	string[512]			true	false	false
description	Description	string[1000]		Description	true	false	false
digest	Digest	string[40]			true	false	true
display_label	Display Label	string[900]		Used as calc attribute for display	true	false	false
MENU		xml			true	false	true
name	Name	string[900]			true	false	false
user_label	User Label	string[900]		Used as user label	true	false	false
Attributes defined for Root
Name	Display Name	Type	Default Value	Description	Factory	Key	Hidden
BODY_ICON		string	general		true	false	true
calculated_id	Calculated ID	bytes[16]		Calculated ID	true	false	true
create_time	Created Time	date		When was this CI created	true	false	false
FAMILY_ICON		string			true	false	true
global_id	Global Id	string[32]		A globally unique identifier for the entity represented by the object	true	false	false
global_id_scope		string	Default		true	false	true
last_discovered_by	LastDiscoveredBy	string[512]		Who discovered this CI	true	false	false
last_discovered_by_probe	LastDiscoveredByProbe	string		Which probe discovered this CI	true	false	false
last_discovered_time	LastDiscoveredTime	date		When was this CI discovered	true	false	false
last_modified_time	LastModifiedTime	date		When was this CI last updated	true	false	false
root_actualdeletetime	Actual Delete Time	date		When will this CI be deleted	true	false	true
root_actualdeletionperiod	Actual Deletion Period	integer	40	What is the period after the CI will be deleted	true	false	false
root_candidatefordeletetime	Candidate For Deletion Time	date		When will this CI be warned about deleting	true	false	true
root_class	CI Type	string[100]		Class name of the CI	true	false	true
root_container	Container	string[32]		Container CI of this CI	true	false	false
root_deletioncandidateperiod	Deletion Candidate Period	integer	20	What is the period after the CI will be candidate for delete	true	false	false
root_enableageing	Enable Aging	boolean	false	Is aging enabled	true	false	false
root_iconproperties		string[100]			true	false	true
root_iscandidatefordeletion	Is Candidate For Deletion	boolean	false	Is candidate for deletion	true	false	false
root_lastaccesstime	Last Access Time	date		When was this CI last accessed	true	false	false
~~root_system~~	~~System~~	string[2]			true	false	true

Valid Relations

Valid direct incoming and outgoing relations defined on MySQL Database

Relations defined for MySQL Database
From	To	Type	Description
MySQL Database	DB Table	Composition	Represents a relation between 2 objects where one is contained within the other, and the included object can not exist without its container. Therefore, when the container is deleted, all its contained object will be automatically removed
Relations defined for Database Schema
From	To	Type	Description
DB User	Database Schema	Ownership
HanaDatabase	Database Schema	Composition	Represents a relation between 2 objects where one is contained within the other, and the included object can not exist without its container. Therefore, when the container is deleted, all its contained object will be automatically removed
JdbcDataSource	Database Schema	Dependency	represents a dependency between 2 objects
Relations defined for Database Resource
From	To	Type	Description
Database	Database Resource	Composition	Represents a relation between 2 objects where one is contained within the other, and the included object can not exist without its container. Therefore, when the container is deleted, all its contained object will be automatically removed
Relations defined for Application Resource
From	To	Type	Description
RunningSoftware	Application Resource	Composition	Represents a relation between 2 objects where one is contained within the other, and the included object can not exist without its container. Therefore, when the container is deleted, all its contained object will be automatically removed
Relations defined for InfrastructureElement
From	To	Type	Description
BusinessActivity	InfrastructureElement	Usage	Monitor system Relationships
BusinessApplication	InfrastructureElement	Containment
BusinessApplication	InfrastructureElement	Usage	Monitor system Relationships
BusinessElement	InfrastructureElement	Usage	Monitor system Relationships
BusinessTransaction	InfrastructureElement	Usage	Monitor system Relationships
CiCollection	InfrastructureElement	Usage	Monitor system Relationships
ClusterResourceConfig	InfrastructureElement	Dependency	represents a dependency between 2 objects
Service	InfrastructureElement	Containment
Service	InfrastructureElement	Usage	Monitor system Relationships
Relations defined for ConfigurationItem
From	To	Type	Description
ConfigurationItem	ConfigurationItem	ConsumerProvider
ConfigurationItem	Kpi	Composition	Represents a relation between 2 objects where one is contained within the other, and the included object can not exist without its container. Therefore, when the container is deleted, all its contained object will be automatically removed
ConfigurationItem	Outage	Composition	Represents a relation between 2 objects where one is contained within the other, and the included object can not exist without its container. Therefore, when the container is deleted, all its contained object will be automatically removed
ConfigurationItem	PolicyResult	Aggregation
ConfigurationItem	ScheduledDowntime	Connection
ConfigurationItem	ServiceConnectionPoint	Composition	Represents a relation between 2 objects where one is contained within the other, and the included object can not exist without its container. Therefore, when the container is deleted, all its contained object will be automatically removed
ConfigurationItem	ServiceConnectionPoint	Ownership
DefectsFilter	ConfigurationItem	Containment
ApplicationSystem	ConfigurationItem	Aggregation
Asset	ConfigurationItem	Connection
CiCollection	ConfigurationItem	Containment
CiCollection	ConfigurationItem	Membership
ItProcessRecord	ConfigurationItem	Connection
ItProcessRecord	ConfigurationItem	Membership
Location	ConfigurationItem	Membership
Tenant	ConfigurationItem	Connection
Relations defined for Managed Object
From	To	Type	Description
Managed Object	History Change	History Link
Tenant	Managed Object	Connection

Combined inheritance and relation diagram for MySQL Database

Potential Data Providers

Adapters providing CIs of type MySQL Database
Adapter Name	Description	Adapter Type
MySQL Topology by SQL	Discovers MySQL instances and replication topology by SQL	Discovery
MySQL Topology by SQL - Cloud Service	Discovers MySQL Service instances and replication topology by SQL	Discovery
Adapters providing CIs of type Database Schema
Adapter Name	Description	Adapter Type
HanaDb Topology by SQL	Discovers HanaDB instances and topology using SQL Connections	Discovery
HanaDb by shell	Discover HanaDb instances	Discovery
J2EE Inactive WebSphere Topology Discovery by Shell	This adapter discovers WebSphere J2EE environment and components by shell only when the WebSphere Application Server is inactive.	Discovery
MaxDb Topology by SQL	Discovers MaxDB instances and topology using SQL Connections	Discovery
MaxDb by Shell	Discovers MaxDB instances and topology	Discovery
Weblogic J2EE Topology Discovery by Shell	Discovers WebLogic J2EE environment and components by shell. Supported versions: 8.1, 9.0, 9.1, 9.2, 10	Discovery
Websphere J2EE Topology Discovery by Shell	This adapter discovers WebSphere J2EE environment and components by shell.	Discovery
hp_nonstop_topology_by_shell	HPE NonStop topology discovery.	Discovery
Adapters providing CIs of type Database Resource
Adapter Name	Description	Adapter Type
IIS Applications by NTCMD or UDA or PowerCmd	This adapter discovers Microsoft Internet Information Services (IIS).	Discovery
Adapters providing CIs of type ConfigurationItem
Adapter Name	Description	Adapter Type
Import from CSV	Imports data from a CSV file into CMDB using mapping of the CSV file columns to CIT attributes. Mapping is defined by the following parameters: ciType: to define the CIT name which you want to create, mappingString: to define the mapping of the CIT attributes to the CSV file columns. Mapping file is used for more complex mapping definitions. Mapping file name is specified by 'mappingFile' parameter.	Integration
Import from DB	Imports data from an external database into CMDB using mapping of table columns to CIT attributes. Mapping is defined by the following parameters: ciType: to define the CIT name which you want to create, mappingString: to define the mapping of the CIT attributes to the table columns Mapping file is used for more complex mapping definitions. Mapping file name is specified by 'mappingFile' parameter. A SQL 'select' query is generated automatically and selects all columns in specified table, which defined by parameter: tableName In advanced cases you can specify custom SQL query.	Integration
Import from properties file	Imports data from a Properties file into CMDB, using mapping of the CSV file columns to CIT attributes This mapping is usually defined by the setting adapter parameters: ciType: to define the CIT name which you want to create, mappingString: to define the mapping of the Properties attributes to the CSV file columns In cases you need more complex mapping abilities, such as conversion of the strings contained in Properties file to the appropriate type of CMDB object's attribute, you should use the mapping XML configuration file specified by the mappingFile parameter.	Integration
SCCM Installed Software Integration	This adapter queries the records from SCCM database and recognizes it as install software by UD SAI	Integration
Import from Excel Workbook	Imports data from Excel Workbooks. Parses through multiple worksheet XLS files. Uses 'CIImports.xls' (default) file to import data.	Integration
Adapters providing CIs of type Object
Adapter Name	Description	Adapter Type
ALMAdapter	Federate defects from ALM	Integration
AMGenericAdapter	This adapter pushes/populates data between UCMDB and Asset Manager. Follow the Quick Start guide supplied with the AM Generic Adapter documentation before creating this integration point.	Integration
Application Portfolio Management Push Adapter	This adapter pushes data from UCMDB to HP Application Portfolio Management. Follow the APM Push Adapter documentation included in the HP UCMDB Discovery and Integration Content Guide before creating this integration point.	Integration
UCMDB API Population	Allows defining Reconciliation Priority for API Data In flows	Integration
Data Push into Atrium	Pushes CIs and relationships to BMC Atrium	Integration
CA CMDB	Pushes CIs and relationships to CA CMDB	Integration
UCMDB 10.x and later	Used for Populating and Federating data from a remote UCMDB 10.x(or later) and for Pushing to a remote UCMDB 10.x(or later)	Integration
UCMDB 9.x	Used for Populating and Federating data from a remote UCMDB 9.x server and for Pushing to a remote UCMDB 9.x	Integration
UCMDB History Adapter [local instance only]	Used to federated data from the UCMDB's History	Integration
Push Adapter DB Example	Push data into Oracle \ MSSQL database	Integration
GenericDBAdapter	An example Adapter that uses the GDB-Framework	Integration
IAM UI Push Adapter	Push IAM Universal Inventory data into MSSQL database on-premises or on cloud-based Azure.	Integration
Java_Adapter_Template	Adapter Description	Integration
Kafka Push Adapter 2019.05	Push function for Kafka Push Adapter	Integration
Local State Push Adapter	Used for populating data between the states of the same UCMDB Server	Integration
Pulsar Push Adapter	Push function for Pulsar Push Adapter	Integration
Push Adapter	Push Adapter	Integration
Remedyforce Push Integration	Remedyforce Push Integration	Integration
SMA-X Push Adapter	This adapter pushes data from UCMDB to Service Anywhere.	Integration
System Center Configuration Manager	Uses the GDB-Framework to Populate and Federate data from a System Center Configuration Manager. The adapter is also backward compatible with the SMS DB	Integration
Service Manager 9.41	Discovery Pattern Description	Integration
Service Manager 9.xx	Discovery Pattern Description	Integration
Service Manager Enhanced Generic Adapter	Push and Populate CI data between UCMDB and Service Manager	Integration
ServiceNow Enhanced Generic Adapter	Push, Populate and Federation of CI data between UCMDB and ServiceNow	Integration
UCMDB to XML	Export data into XML from UCMDB	Integration